SKU: mcsa-sql-certification-365 Categories: ,

MCSA: SQL 2012 Certification

$999.00

Microsoft SQL Server is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.

Mission Critical Confidence – Enable mission critical performance and availability at low TCO.
Breakthrough Insight – Unlock new insights with rapid data exploration and visualization across the organization.

Cloud on Your Terms – Create and scale business solutions fast, on your terms from server to private or public cloud.

Course Outline

Lesson 1: Getting Started with SQL Server 2012
  •  Course Introduction
Lesson 2: Working with T-SQL
  •  Creating Queries-Part 1
  •  Creating Queries-Part 2
  •  Creating Queries-Part 3
  •  Creating Queries-Part 4
  •  Creating Queries-Part 5
  •  Constraints-Part 1
  •  Constraints-Part 2
  •  Constraints-Part 3
  •  Constraints-Part 4
  •  Constraints-Part 5
Lesson 3: Writing SELECT Queries
  •  Select Statement-Part 1
  •  Select Statement-Part 2
  •  Select Statement-Part 3
  •  Select Statement-Part 4
Lesson 4: Working with SQL Data Types
  •  Data Types-Part 1
  •  Data Types-Part 2
  •  Data Types-Part 3
  •  Data Types-Part 4
  •  Data Types-Part 5
  •  Data Types-Part 6
  •  Data Types-Part 7
  •  Data Types-Part 8
  •  Data Types-Part 9
  •  Data Types-Part 10
Lesson 5: Sorting and Filtering Data
  •  Sorting Results-Part 1
  •  Sorting Results-Part 2
  •  Sorting Results-Part 3
  •  Sorting Results-Part 4
  •  Sorting Results-Part 5
  •  Sorting Results-Part 6
Lesson 6: Querying Data from Multiple Tables
  •  Tables Part 1
  •  Tables Part 2
  •  Tables Part 3
  •  Tables Part 4
  •  Tables Part 5
  •  Tables Part 6
Lesson 7: Modifying Data
  •  Inserting Data-Part 1
  •  Inserting Data-Part 2
  •  Inserting Data-Part 3
  •  Inserting Data-Part 4
  •  Inserting Data-Part 5
  •  Inserting Data-Part 6
Lesson 8: Working with SQL Server Built-in Functions
  •  Functions
  •  Parse
  •  Logical Functions
  •  Group By
Lesson 9: Programming in T-SQL
  •  Programming-Part 1
  •  Programming-Part 2
  •  Programming-Part 3
  •  Programming-Part 4
  •  Programming-Part 5
  •  Programming-Part 6
Lesson 10: Implementing Stored Procedures
  •  Storage Procedures-Part 1
  •  Storage Procedures-Part 2
  •  Dynamic SQL-Part 1
  •  Dynamic SQL-Part 2
Lesson 11: Working with Subqueries and Table Expressions
  •  Sub-Queries And Table Expressions-Part 1
  •  Sub-Queries And Table Expressions-Part 2
  •  Sub-Queries And Table Expressions-Part 3
  •  Sub-Queries And Table Expressions-Part 4
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
  •  Set Operators-Part 1
  •  Set Operators-Part 2
  •  Window Functions-Part 1
  •  Window Functions-Part 2
  •  User Defined Functions-Part 1
  •  User Defined Functions-Part 2
  •  Advanced Analytical Functions
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
  •  Pivot
  •  Grouping Sets
Lesson 14: Managing Error Handling and Transactions
  •  Error Handling-Part 1
  •  Error Handling-Part 2
  •  Manage Transactions-Part 1
  •  Manage Transactions-Part 2
  •  Manage Transactions-Part 3
Lesson 15: Querying SQL Server System
  •  System Databases-Part 1
  •  System Databases-Part 2
  •  System Databases-Part 3
  •  System Databases-Part 4
Lesson 16: Optimizing Query Performance
  •  Query Planning-Part 1
  •  Query Planning-Part 2
  •  Index-Part 1
  •  Index-Part 2
  •  Index-Part 3
MCSA: SQL 2012 Certification

Save For Later
Add to Wishlist