Course Details
Course Outline
1 - Introduction to Microsoft SQL Server 2014
The Basic Architecture of SQL ServerSQL Server Editions and VersionsGetting Started with SQL Server Management StudioLab : Working with SQL Server 2014 Tools
2 - Introduction to T-SQL Querying
Introducing T-SQLUnderstanding SetsUnderstanding Predicate LogicUnderstanding the Logical Order of Operations in SELECT statementsLab : Introduction to Transact-SQL Querying
3 - Writing SELECT Queries
Writing Simple SELECT StatementsEliminating Duplicates with DISTINCTUsing Column and Table AliasesWriting Simple CASE ExpressionsLab : Writing Basic SELECT Statements
4 - Querying Multiple Tables
Understanding JoinsQuerying with Inner JoinsQuerying with Outer JoinsQuerying with Cross Joins and Self JoinsLab : Querying Multiple Tables
5 - Sorting and Filtering Data
Sorting DataFiltering Data with a WHERE ClauseFiltering with the TOP and OFFSET-FETCH OptionsWorking with Unknown and Missing ValuesLab : Sorting and Filtering Data
6 - Working with SQL Server 2014 Data Types
Introducing SQL Server 2014 Data TypesWorking with Character DataWorking with Date and Time DataLab : Working with SQL Server 2014 Data Types
7 - Using DML to Modify Data
Inserting DataModifying and Deleting DataLab : Using DML to Modify Data
8 - Using Built-In Functions
Writing Queries with Built-In FunctionsUsing Conversion FunctionsUsing Logical FunctionsUsing Functions to Work with NULLLab : Using Built-In Functions
9 - Grouping and Aggregating Data
Using Aggregate FunctionsUsing the GROUP BY ClauseFiltering Groups with HAVINGLab : Grouping and Aggregating Data
10 - Using Subqueries
Writing Self-Contained SubqueriesWriting Correlated SubqueriesUsing the EXISTS Predicate with SubqueriesLab : Using Subqueries
11 - Using Table Expressions
Using Derived TablesUsing Common Table ExpressionsUsing ViewsUsing Inline Table-Valued FunctionsLab : Using Table Expressions
12 - Using Set Operators
Writing Queries with the UNION OperatorUsing EXCEPT and INTERSECTUsing APPLYLab : Using Set Operators
13 - Using Window Ranking, Offset, and Aggregate Functions
Creating Windows with OVERExploring Window FunctionsLab : Using Window Ranking, Offset and Aggregate Functions
14 - Pivoting and Grouping Sets
Writing Queries with PIVOT and UNPIVOTWorking with Grouping SetsLab : Pivoting and Grouping Sets
15 - Executing Stored Procedures
Querying Data with Stored ProceduresPassing Parameters to Stored ProceduresCreating Simple Stored ProceduresWorking with Dynamic SQLLab : Executing Stored Procedures
16 - Programming with T-SQL
T-SQL Programming ElementsControlling Program FlowLab : Programming with T-SQL
17 - Implementing Error Handling
Using TRY / CATCH BlocksWorking with Error InformationLab : Implementing Error Handling
18 - Implementing Transactions
Transactions and the Database EngineControlling TransactionsIsolation LevelsLab : Implementing Transactions
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.
Other Prerequisites
This course requires that you meet the following prerequisites:
Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.