This course provides students with the technical skills required to be prepared for the 70-461 Querying SQL Server 2012 exam. Students will acquire the skills to write basic Transact-SQL queries for Microsoft SQL Server 2012, which is the foundation for all SQL Server-related disciplines; namely Database Administration, Database Development and Business Intelligence.

0
Course Videos
0
Duration (hrs)
0
Test Questions
0
Course Completion Certificate

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