NewEra Technology Facebook
10774 Querying Microsoft SQL Server 2012 - Virtual Led Training - Course Information
PRINT
SEND TO A FRIEND
Name: 10774 Querying Microsoft SQL Server 2012 - Virtual Led Training
Category: Microsoft Official Curriculum Courses
Length (Days): 5
Course Price (CAD): 2750
Description:
Students will learn technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This
course is the foundation for all SQL Server-related disciplines:Database Administration, Database Development and Business Intelligence
Prerequisites:
Not Applicable
Outline:
Lesson 1 - Introduction to Microsoft SQL Server 2012
◦Introducing Microsoft SQL Server 2012
◦Getting Started with SQL Server Management Studio
◦Lab : Working with SQL Server 2012 Tools

Lesson 2 - Getting Started with SQL Azure
◦Overview of SQL Azure
◦Working with SQL Azure

Lesson 3 - Introduction to T-SQL Querying
◦Introducing T-SQL
◦Understanding Sets
◦Understanding Predicate Logic
◦Understanding the Logical Order of Operations in SELECT statements
◦Lab : Introduction to Transact-SQL Querying

Lesson 4 - Writing SELECT Queries
◦Writing Simple SELECT Statements
◦Eliminating Duplicates with DISTINCT
◦Using Column and Table Aliases
◦Writing Simple CASE Expressions
◦Lab : Writing Basic SELECT Statements

Lesson 5 - Querying Multiple Tables
◦Understanding Joins
◦Querying with Inner Joins
◦Querying with Outer Joins
◦Querying with Cross Joins and Self Joins
◦Lab : Querying Multiple Tables

Lesson 6 - Sorting and Filtering Data
◦Sorting Data
◦Filtering Data with a WHERE Clause
◦Filtering with the TOP and OFFSET-FETCH Options
◦Working with Unknown and Missing Values
◦Lab : Sorting and Filtering Data

Lesson 7 - Working with SQL Server 2012 Data Types
◦Introducing SQL Server 2012 Data Types
◦Working with Character Data
◦Working with Date and Time Data
◦Lab : Working with SQL Server 2012 Data Types

Lesson 8 - Using Built-In Functions
◦Writing Queries with Built-In Functions
◦Using Conversion Functions
◦Using Logical Functions
◦Using Functions to Work with NULL
◦Lab : Using Built-In Functions

Lesson 9 - Grouping and Aggregating Data
◦Using Aggregate Functions
◦Using the GROUP BY Clause
◦Filtering Groups with HAVING
◦Lab : Grouping and Aggregating Data

Lesson 10 - Using Subqueries
◦Writing Self-Contained Subqueries
◦Writing Correlated Subqueries
◦Using the EXISTS Predicate with Subqueries
◦Lab : Using Subqueries

Lesson 11 - Using Table Expressions
◦Using Derived Tables
◦Using Common Table Expressions
◦Using Views
◦Using Inline Table-Valued Functions
◦Lab : Using Table Expressions

Lesson 12 - Using Set Operators
◦Writing Queries with the UNION Operator
◦Using EXCEPT and INTERSECT
◦Using APPLY
◦Lab : Using Set Operators

Lesson 13 - Using Window Ranking, Offset and Aggregate Functions
◦Creating Windows with OVER
◦Exploring Window Functions
◦Lab : Using Window Ranking, Offset and Aggregate Functions

Lesson 14 - Pivoting and Grouping Sets
◦Writing Queries with PIVOT and UNPIVOT
◦Working with Grouping Sets
◦Lab : Pivoting and Grouping Sets

Lesson 15 - Querying SQL Server Metadata
◦Querying System Catalog Views and Functions
◦Executing System Stored Procedures
◦Querying Dynamic Management Objects
◦Lab : Querying SQL Server Metadata

Lesson 16 - Executing Stored Procedures
◦Querying Data with Stored Procedures
◦Passing Parameters to Stored Procedures
◦Creating Simple Stored Procedures
◦Working with Dynamic SQL
◦Lab : Executing Stored Procedures

Lesson 17 - Programming with T-SQL
◦T-SQL Programming Elements
◦Controlling Program Flow
◦Lab : Programming with T-SQL

Lesson 18 - Implementing Error Handling
◦Using TRY / CATCH Blocks
◦Working with Error Information
◦Lab : Implementing Error Handling

Lesson 19 - Implementing Transactions
◦Transactions and the Database Engine
◦Controlling Transactions
◦Lab : Implementing Transactions

Lesson 20 - Improving Query Performance
◦Factors in Query Performance
◦Displaying Query Performance Data
◦Lab : Improving Query Performance
Guaranteed to run courses