Querying Microsoft SQL Server 2012
- Vendor:
- Microsoft Corporation
- Course:
- 6294
- Start Date:
- Monday, March 19, 2012
- Length:
- 5 Days
- Location:
- Expired Class Date
- Tuition:
- $2,995
- Expired:
- This class has expired. Current Class
March
19
Expired Class Date
Course Description
In this course, you will develop the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 using the beta version of pre-released 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.
Skills Gained
- 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 Can Benefit
Database administrators, database developers, BI professionals, and SQL power-users such as report writers, business analysts, and client application developers
Prerequisites
- Working knowledge of relational databases
- Basic knowledge of Microsoft Windows operation system and its core functionality
Syllabus
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
