MCSA: SQL Server 2012

The globally recognized standard for IT professionals The MCSA: SQL Server 2012 demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. Earning an MCSA: SQL Server certification will qualify you for a position as a database developer or database analyst.

The Microsoft Certified Solutions Associate (MCSA): Windows Server 2012 certification shows that you have the primary set of Windows Server skills that are relevant across multiple solution areas in a business environment. The MCSA: Windows Server 2012 certification is a prerequisite for earning the MCSE: Server Infrastructure certification, the MCSE: Desktop Infrastructure certification, or the MCSE: Private Cloud certification.

Topic Covered:

• Module 01:    Introduction to Microsoft SQL Server 2012
• Module 02:    Getting Started with SQL Azure
• Module 03:    Introduction to T-SQL Querying
• Module 04:    Writing SELECT Queries
• Module 05:    Querying Multiple Tables
• Module 06:    Sorting and Filtering Data
• Module 07:    Working with SQL Server 2012 Data Types
• Module 08:    Using Built-In Functions
• Module 09:    Grouping and Aggregating Data
• Module 10:    Using Subqueries
• Module 11:    Using Table Expressions
• Module 12:    Using Set Operators
• Module 13:    Using Window Ranking, Offset and Aggregate Functions
• Module 14:    Pivoting and Grouping Sets
• Module 15:    Querying SQL Server Metadata
• Module 16:    Executing Stored Procedures
• Module 17:    Programming with T-SQL
• Module 18:    Implementing Error Handling
• Module 19:    Implementing Transactions
• Module 20:    Improving Query Performance