Overview:
This 5-day instructor-led course provides participants with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
This course is designed for people who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
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.
Pre-Requisites:
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.
Course Curriculum
Introduction to Microsoft SQL Server 2014 | |||
The Basic Architecture of SQL Server Details | 00:00:00 | ||
SQL Server Editions and Versions Details | 00:00:00 | ||
Getting Started with SQL Server Management Studio Details | 00:00:00 | ||
Lab : Working with SQL Server 2014 Tools | |||
Working with SQL Server Management Studio Details | 00:00:00 | ||
Creating and Organizing T-SQL scripts Details | 00:00:00 | ||
Using Books Online Details | 00:00:00 | ||
Introduction to T-SQL Querying | |||
Introducing T-SQL Details | 00:00:00 | ||
Understanding Sets Details | 00:00:00 | ||
Understanding Predicate Logic Details | 00:00:00 | ||
Understanding the Logical Order of Operations in SELECT statements Details | 00:00:00 | ||
Lab : Introduction to Transact-SQL Querying | |||
Executing Basic SELECT Statements Details | 00:00:00 | ||
Executing queries which filter data using predicates Details | 00:00:00 | ||
Executing queries which sort data using ORDER BY Details | 00:00:00 | ||
Writing SELECT Queries | |||
Writing Simple SELECT Statements Details | 00:00:00 | ||
Eliminating Duplicates with DISTINCT Details | 00:00:00 | ||
Using Column and Table Aliases Details | 00:00:00 | ||
Writing Simple CASE Expressions Details | 00:00:00 | ||
Lab : Writing Basic SELECT Statements | |||
Write simple SELECT Statements Details | 00:00:00 | ||
Eliminate Duplicates Using Distinct Details | 00:00:00 | ||
Use Table and Column Aliases Details | 00:00:00 | ||
Use a Simple CASE Expression Details | 00:00:00 | ||
Querying Multiple Tables | |||
Understanding Joins Details | 00:00:00 | ||
Querying with Inner Joins Details | 00:00:00 | ||
Querying with Outer Joins Details | 00:00:00 | ||
Querying with Cross Joins and Self Joins Details | 00:00:00 | ||
Lab : Querying Multiple Tables | |||
Writing Queries That Use Inner Joins Details | 00:00:00 | ||
Writing Queries That Use Multiple-Table Inner Join Details | 00:00:00 | ||
Writing Queries That Use Self Joins Details | 00:00:00 | ||
Writing Queries That Use Outer Joins Details | 00:00:00 | ||
Writing Queries That Use Cross Joins Details | 00:00:00 | ||
Sorting and Filtering Data | |||
Sorting Data Details | 00:00:00 | ||
Filtering Data with a WHERE Clause Details | 00:00:00 | ||
Filtering with the TOP and OFFSET-FETCH Options Details | 00:00:00 | ||
Working with Unknown and Missing Values Details | 00:00:00 | ||
Lab : Sorting and Filtering Data | |||
Writing Queries That Filter Data Using a WHERE Clause Details | 00:00:00 | ||
Writing Queries That Filter Data Using an ORDER BY Clause Details | 00:00:00 | ||
Writing Queries That Filter Data Using the TOP Option Details | 00:00:00 | ||
Writing Queries That Filter Data Using the OFFSET-FETCH Clause Details | 00:00:00 | ||
Working with SQL Server 2014 Data Types | |||
Introducing SQL Server 2014 Data Types Details | 00:00:00 | ||
Working with Character Data Details | 00:00:00 | ||
Working with Date and Time Data Details | 00:00:00 | ||
Lab : Working with SQL Server 2014 Data Types | |||
Writing Queries That Return Date and Time Data Details | 00:00:00 | ||
Writing Queries That Use Date and Time Functions Details | 00:00:00 | ||
Writing Queries That Return Character Data Details | 00:00:00 | ||
Writing Queries That Use Character Functions Details | 00:00:00 | ||
Using DML to Modify Data | |||
Inserting Data Details | 00:00:00 | ||
Modifying and Deleting Data Details | 00:00:00 | ||
Lab : Using DML to Modify Data | |||
Inserting Data Details | 00:00:00 | ||
Updating and Deleting Data Details | 00:00:00 | ||
Using Built-In Functions | |||
Writing Queries with Built-In Functions Details | 00:00:00 | ||
Using Conversion Functions Details | 00:00:00 | ||
Using Logical Functions Details | 00:00:00 | ||
Using Functions to Work with NULL Details | 00:00:00 | ||
Lab : Using Built-In Functions | |||
Write queries which use conversion functions Details | 00:00:00 | ||
Write queries which use logical functions Details | 00:00:00 | ||
Write queries which test for nullability Details | 00:00:00 | ||
Grouping and Aggregating Data | |||
Using Aggregate Functions Details | 00:00:00 | ||
Using the GROUP BY Clause Details | 00:00:00 | ||
Filtering Groups with HAVING Details | 00:00:00 | ||
Lab : Grouping and Aggregating Data | |||
Write queries which use the GROUP BY clause Details | 00:00:00 | ||
Write queries which use aggregate functions Details | 00:00:00 | ||
Write queries which use distinct aggregate functions Details | 00:00:00 | ||
Write queries which filter groups with the HAVING clause Details | 00:00:00 | ||
Using Subqueries | |||
Writing Self-Contained Subqueries Details | 00:00:00 | ||
Writing Correlated Subqueries Details | 00:00:00 | ||
Using the EXISTS Predicate with Subqueries Details | 00:00:00 | ||
Lab : Using Subqueries | |||
Write queries which use self-contained subqueries Details | 00:00:00 | ||
Write queries which use scalar and multi-result subqueries Details | 00:00:00 | ||
Write queries which use correlated subqueries and EXISTS predicate Details | 00:00:00 | ||
Using Table Expressions | |||
Using Derived Tables Details | 00:00:00 | ||
Using Common Table Expressions Details | 00:00:00 | ||
Using Views Details | 00:00:00 | ||
Using Inline Table-Valued Functions Details | 00:00:00 | ||
Lab : Using Table Expressions | |||
Write Queries Which Use Views Details | 00:00:00 | ||
Write Queries Which Use Derived Tables Details | 00:00:00 | ||
Write Queries Which Use Common Table Expressions Details | 00:00:00 | ||
Write Queries Which Use Inline Table-Valued Functions Details | 00:00:00 | ||
Using Set Operators | |||
Writing Queries with the UNION Operator Details | 00:00:00 | ||
Using EXCEPT and INTERSECT Details | 00:00:00 | ||
Using APPLY Details | 00:00:00 | ||
Lab : Using Set Operators | |||
Write queries which use UNION set operators and UNION ALL multi-set operators Details | 00:00:00 | ||
Write queries which use CROSS APPLY and OUTER APPLY operators Details | 00:00:00 | ||
Write queries which use EXCEPT and INTERSECT operators Details | 00:00:00 | ||
Using Window Ranking, Offset, and Aggregate Functions | |||
Creating Windows with OVER Details | 00:00:00 | ||
Exploring Window Functions Details | 00:00:00 | ||
Lab : Using Window Ranking, Offset and Aggregate Functions | |||
Write queries which use ranking functions Details | 00:00:00 | ||
Write queries which use offset functions Details | 00:00:00 | ||
Write queries which use window aggregate functions Details | 00:00:00 | ||
Pivoting and Grouping Sets | |||
Writing Queries with PIVOT and UNPIVOT Details | 00:00:00 | ||
Working with Grouping Sets Details | 00:00:00 | ||
Lab : Pivoting and Grouping Sets | |||
Write queries which use the PIVOT operator Details | 00:00:00 | ||
Write queries which use the UNPIVOT operator Details | 00:00:00 | ||
Write queries which use the GROUPING SETS subclause Details | 00:00:00 | ||
Executing Stored Procedures | |||
Querying Data with Stored Procedures Details | 00:00:00 | ||
Passing Parameters to Stored Procedures Details | 00:00:00 | ||
Creating Simple Stored Procedures Details | 00:00:00 | ||
Working with Dynamic SQL Details | 00:00:00 | ||
Lab : Executing Stored Procedures | |||
Use the EXECUTE statement to invoke stored procedures Details | 00:00:00 | ||
Pass parameters to stored procedures Details | 00:00:00 | ||
Execute system stored procedures Details | 00:00:00 | ||
Programming with T-SQL | |||
T-SQL Programming Elements Details | 00:00:00 | ||
Controlling Program Flow Details | 00:00:00 | ||
Lab : Programming with T-SQL | |||
Declaring Variables and Delimiting Batches Details | 00:00:00 | ||
Using Control-of-Flow Elements Details | 00:00:00 | ||
Generating Dynamic SQL Details | 00:00:00 | ||
Using Synonyms Details | 00:00:00 | ||
Implementing Error Handling | |||
Using TRY / CATCH Blocks Details | 00:00:00 | ||
Working with Error Information Details | 00:00:00 | ||
Lab : Implementing Error Handling | |||
Redirecting Errors with TRY / CATCH Details | 00:00:00 | ||
Using THROW to Pass an Error Message Back to a Client Details | 00:00:00 | ||
Implementing Transactions | |||
Transactions and the Database Engine Details | 00:00:00 | ||
Controlling Transactions Details | 00:00:00 | ||
Isolation Levels Details | 00:00:00 | ||
Lab : Implementing Transactions | |||
Controlling transactions with BEGIN, COMMIT, and ROLLBACK Details | 00:00:00 | ||
Adding error handling to a CATCH block Details | 00:00:00 |
Course Reviews
No Reviews found for this course.