OneSource Professional Training Solutions, Inc. presents
 

Querying Microsoft SQL Server 2012 On-Site Training

Querying Microsoft SQL Server 2012

Course Description/Agenda

In this course, you will develop the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 using the prerelease version of the software in the virtual machines for the labs. This course is the foundation for the all SQL Server-related disciplines, including database administration, database development, and business intelligence. Many of the labs are SQL Azure enabled.

What You'll Learn

• Write SELECT Queries
• Query Multiple Tables
• Use Built-In Functions and Subqueries
• Execute Stored Procedures
• Use Set Operators
• Implement Error-Handling and Transactions
• Use Table Expressions, Windows Ranking, Offset, and Aggregate Functions
• Sort and Filter Data
• Query SQL Server Metadata and Improve Query Performance
• Program with T-SQL

Who Should Attend

Database administrators, database developers, BI professionals, and SQL power-users such as report writers, business analysts, and client application developers

Course Prerequisites

• Working knowledge of relational databases
• Basic knowledge of Microsoft Windows operation system and its core functionality

Course Outline

1. Microsoft SQL Server 2012

• SQL Server 2012 Architecture
• Working with SQL Server 2012 Tools
• Working with SQL Server Databases

2. Transact-SQL Querying

• Transact-SQL
• Sets
• Predicate Logic
• Logical Order of Operations in SELECT Statements

3. Writing SELECT Queries

• Writing Simple SELECT Statements
• Eliminating Duplicates with DISTINCT
• Using Column and Table Aliases
• Writing Simple CASE Expressions

4. Querying Multiple Tables

• Joins
• Querying with Inner Joins
• Querying with Outer Joins
• Querying Using Self and Cross Joins

5. Sorting and Filtering Data

• Sorting Data
• Filtering Data
• Filtering with the TOP and OFFSET-FETCH Options
• Working with Unknown Values

6. Working with SQL Server 2012 Data Types

• SQL Server 2012 Data Types
• Working with Character Data
• Working with Date and Time Data

7. Using Built-In Functions

• Writing Queries with Built-In Functions
• Conversion Functions
• Logical Functions
• Using Functions to Test for Nullability

8. Grouping and Aggregating Data

• Using Aggregate Functions
• Using the GROUP BY Clause
• Filtering Groups with the HAVING Clause

9. Using Subqueries

• Writing Self-Contained Subqueries
• Writing Correlated Subqueries
• Using the EXISTS Predicate with Subqueries

10. Using Table Expressions

• Views
• Table Expressions

11. Use Set Operators

12. Using Window Ranking, Offset, and Aggregate Functions

13. Pivoting and Grouping Sets

14. Querying SQL Server Metadata

15. Executing Stored Procedures

16. Programming with T-SQL

17. Implementing Error Handling

18. Implementing Transactions

19. Improving Query Performance

Labs

Lab 1: SQL Server 2012 Tools

Lab 2: Transact-SQL Querying

Lab 3: Write Basic SELECT statements

Lab 4: Query Multiple Tables

Lab 5: Filter and Sort Data

Lab 6: Work with SQL Server 2012 Data Types

Lab 7: Use Built-In Functions

Lab 8: Group and Aggregate Data

Lab 9: Use Subqueries

Lab 10: Use Table Expressions

Lab 11: Use Set Operators

Lab 12: Use Window Ranking, Offset, and Aggregate Functions

Lab 13: Pivot and Group Sets

Lab 14: Query SQL Server Metadata

Lab 15: Execute Stored Procedures

Lab 16: Program with T-SQL

Lab 17: Implement Error Handling

Lab 18: Implement Transactions

Lab 19: Improve Query Performance

More Seminar Information

OneSource Professional Training Solutions, Inc. Delivery Method  On-Site Training Also Available As  Seminar