+91 9879558787 info@itsahmedabad.com

SQL Server Training

Live classroom and Online training options :
Apart from live classroom, ITS offers MS Sql server online course with instructor led training

Querying SQL Server 2012

Part – 1 – (20 hours) Part – 2 – (20 hours)

SQL Server MCSA / MCSE

Certification Path

SQL Server 2012 DBA

Part – 1 – (40 hours) Part – 2 – (20 hours)
Microsoft SQL server has global presence, good market share and considered as leading database on windows platform. Lots of new features have been introduced from version 2012 and onward. DBA career prospects are seen good among leading databases and SQL server database is one of them.

Querying SQL Server 2012 - 40 hours

Introduction to Microsoft SQL Server 2012
Getting Started with SQL Azure
Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server 2012 Data Types
Using Built-In Functions
Grouping and Aggregating Data
Using Subqueries
Using Table Expressions
Using Set Operators
Using Window Ranking
Offset and Aggregate Functions
Pivoting and Grouping Sets
Querying SQL Server Metadata
Executing Stored Procedures
Programming with T-SQL
Implementing Error Handling
Implementing Transactions
Improving Query Performance

Download Brochure

Querying SQL Server 2012 Part - 1 - 20 hours

Understanding the Foundation of T-SQL
Understanding Logical Query Processing
Using the FROM and SELECT Clauses
Working with Data Types and Built-in Functions
Working with CASE Expression
Filtering Data with Predicates and TOP
OFFSET-FETCH
Sorting Data
Combining Sets – Using Joins
Using Subqueries
Table Expressions and the APPLY Operator Using Set Operatiors
Grouping and Windowing – Grouped Queries
Pivoting and Unpivoting Data
Using Window Functions
Creating and Altering Tables
Enforcing Data Integrity
Designing and Creating Views and Inline Functions
Using Synonyms
Inserting Data
Updating Data
Deleting Data
Using the Sequence Object and IDENTITY Column Property
Merging Data Using the OUTPUT Option
Introduction to Indexes and Statistics

Download Brochure

Querying SQL Server 2012 Part - 2 - 20 hours

Understanding and Type of Transactions
Basic Locking and Transaction Isolation Levels
Implementing Error Handling Using Dynamic SQL
Designing and Implementing Store Procedures
Implementing User-Defined Functions
Implementing Triggers
Query Optimization problems and Query Optimizer
Using SET Session Options, Using Dynamic Management Objects
Implementing Indexes
Using Search Arguments
Understanding and Maintaining Statistics
Cursors vs Set-Based Solutions
Using Temporary Tables and Table Variables
Understanding Plan Iterators
Using Parameterised Queries and Batch Operations
Using Optimizer Hints and Plan Guides
Creating Full-Text Catalog and Indexes
Querying Full-Text Data
Introduction to XML
Producing from and Shredding to Relational tables
Querying XML Data

Download Brochure

SQL Server 2012 DBA - 60 hours

Install and Configure
Plan installation
Install SQL Server and related services
Implement a migration strategy
Configure additional SQL Server components
Manage SQL Server Agent
Maintain Instances and Databases
Manage and configure databases
Configure SQL Server instances
Implement a SQL Server clustered instance
Manage SQL Server instances
Optimize and Troubleshoot
Identify and resolve concurrency problems
Collect and analyze troubleshooting data
Audit SQL Server instances
Manage Data
Configure and maintain a back up strategy
Restore databases
Implement and maintain indexes
Import and export data
Implement Security
Manage logins and server roles
Manage database permissions
Manage users and database roles
Troubleshoot security
Implement High Availability
Implement AlwaysOn
Implement database mirroring
Implement replication

Download Brochure

SQL Server 2012 DBA Part - 1 - 40 hours

Planning and Installing SQL Server 2012
Configuring and Managing SQL Server Instances
Configuring SQL Server 2012 Components
Migrating, Importing
and Exporting
SQL Server Logins
Roles and Users
Securing SQL Server 2012
Managing Permissions by using Database Roles
SQL Server Backup and Restore
Managing SQL Server Agent
Implementing and Maintaining Indexes
Identifying and Resolving Concurrency Problem

Download Brochure

SQL Server 2012 DBA Part - 2 - 20 hours

Troubleshooting SQL Server 2012
Monitoring SQL Server
Identifying Bottlenecks
Diagnosing Database and Service Failures
Configuring Log Shipping
Configuring Database Mirroring
Configuring Replication
Clustering SQL Server 2012
AlwaysOn Availability Groups

Download Brochure

Implementing Datawarehouse with SQL Server 2012 - 40 hours

Data Warehouse Logical Design
Implementing a Data Warehouse
Creating SSIS Packages
Designing and Implementing Control Flow
Designing and Implementing Data Flow
Enhancing Control Flow
Enhancing Data Flow
Creating a Robust and Restartable Package
Implementing Dynamic Packages
Installing SSIS and Deploying Packages
Executing and Securing Package
Troubleshooting and Performance Tuning
Installing and Maintaining Data Quality Services
Implementing Master Data Services
Managing Master Data
Creating a Data Quality Project to Clean Data
SSIS and Data Mining
Implementing Custom Code in SSIS Packages
Identity Mapping and De-Duplicating

Download Brochure

SQL Server 2012 Reporting Services (SSRS) - 12 hours

Introduction to Reporting Services and SQL Server 2012
Installing Reporting Services
Reporting Services Internals and Post Installation Setup
Basic Report Building with Reporting Tools
Working with Report Builder and Report formatting
Working with Data Sources to Access data
Advance Report design considerations
Working with Chart Reports
Administrating SSRS and Managing Report projects
SQL Server Administration related to SSRS database

Download Brochure

Trainers profile

Years real time experience

Supporting live database servers

Students and professionals trained

SQL Server Certification Exams Chart

 

Subject Name Exam Code Questions Exam Duration Passing at
TS: Microsoft SQL Server 2008, Installation and Maintenance 70-432 50 180 Minutes 70.00%
Database Fundamentals 98-364 50 50 Minutes 70.00%
Querying Microsoft SQL Server 2012 70-461 55 120 Minutes 70.00%
Administering Microsoft SQL Server 2012 Databases 70-462 55 120 Minutes 70.00%
Implementing a Data Warehouse with Microsoft SQL Server 2012 70-463 55 120 Minutes 70.00%
Developing Microsoft SQL Server 2012 Databases 70-464 55 120 Minutes 70.00%
Designing Database Solutions for SQL Server 2012 70-465 55 120 Minutes 70.00%

 

No. of exam questions, passing percentage and duration may be changed without prior notice by Microsoft.

MCTS = Passing one exam 70-432

MTA = Passing one exam 98-364

MCSA = Passing three exams 70-461, 70-462 and 70-463

MCSE = Passing five exams 70-461, 70-462, 70-463, 70-464 and 70-465

 

Exam Preparation Support ITS offers extensive exam preparation support to all students to secure MCTS, MTA, MCSA, MCSE or respective certifications. There is more than 90% passing ratio in Microsoft exams at ITS

Corporate Training Customers

Student Testimonials