Microsoft MCSA SQL Server 2012 Training

  • Overview
  • Course Content
  • Drop us a Query

Microsoft MCSA SQL Server 2012 Training delivers the technical skills to handle Microsoft database. It covers the installation, administration, maintenance and troubleshooting of the database. The candidates will learn about data warehousing in detail in this training. The comprehensive knowledge and practical exposure of the database concept builds the proficiency of the professionals to serve the organizations of any size.

This training is a complete database solution offering studies on three different courses mentioned as following:

  • Querying Microsoft SQL Server 2012
  • Administering Microsoft SQL Server 2012 Databases
  • Implementing a Data Warehouse with Microsoft SQL Server 2012

At the completion of this training the participants will exhibit the following skills:

  • Introduce Microsoft SQL Server platform, architecture and tools.
  • Explore SQL Azure.
  • Execute T-SQL queries - write SELECT queries, query multiple tables, sort and filter data, use built-in functions, group and aggregate data, subqueries, views, derived tables
  • Learn SQL Server 2012 data types
  • Practice indexes, stored procedures, error handling, transactions, query performance
  • Programming with T-SQL
  • Install SQL server and describe physical structure of database
  • Create SQL server backup and restore databases
  • Define permissions and conduct SQL server audit
  • Design and implement data warehouse.
  • Integrate cloud data into data warehouse infrastructure, implement data cleansing, and enforce data integrity.
Target audience
  • Database Administrators
  • Database Developers
  • Client application developers
  • Business analysts
Prerequisites

The candidates with the following skillsets are the ideal candidates for this training:

  • Microsoft Windows operating system and its functionality
  • Relational database along normalization
  • T-SQL
Exams

After being trained on above skills, you can attempt following exams to get MCSA SQL server 2012 certification from Microsoft:

Course Name Course No. Exam No. Certification Achieved
Querying Microsoft SQL Server 2012 10774A 70-461 MCSA SQL Server 2012
Administering Microsoft SQL Server 2012 Databases 10775A 70-462
Implementing a Data Warehouse with Microsoft SQL Server 2012 10777A 70-463

Course 10774A: Querying Microsoft SQL Server 2012

  • 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
  • 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

Course 10775A: Administering Microsoft SQL Server 2012 Databases

  • Introduction to SQL Server 2012 and  its Toolset
  • Preparing Systems for SQL Server 2012
  • Installing and Configuring SQL Server 2012
  • Working with Databases
  • Understanding SQL Server 2012 Recovery Models
  • Backup of SQL Server 2012 Databases
  • Restoring SQL Server 2012 Databases-
  • Importing and Exporting Data
  • Authenticating and Authorizing Users
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Auditing SQL Server Environments
  • Automating SQL Server 2012 Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server 2012 with Alerts and Notifications
  • Performing Ongoing Database Maintenance
  • Tracing Access to SQL Server 2012
  • Monitoring SQL Server 2012
  • Managing Multiple Servers
  • Troubleshooting Common SQL Server 2012 Administrative Issues

Course 10777A: Implementing a Data Warehouse with Microsoft SQL Server 2012

  • Introduction to Data Warehousing
  • Data Warehouse Hardware
  • Designing and Implementing a Data Warehouse
  • Creating an ETL Solution with SSIS
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Incorporating Data from the Cloud into a Data Warehouse
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SQL Server Integration Services
  •  Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse

Partners

A Few Things You'll Love!

What our Students Speak

+