This 40-hour workout provides the tools and technical knowledge needed to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all disciplines related to SQL Server: database management, database development and business intelligence. The main purpose of the course is to prepare people for the exam, “70-461: Write Microsoft SQL Server 2014 Transact-SQL Queries.” The main target audience for this course are: Database administrators, database developers and BI professionals.
Audience(s): | IT Professionals |
Technology: | SQL Server 2014 |
Duration: | 40 hours |
Module 1: Introduction to Microsoft SQL Server 2014
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Module 6: Working with SQL Server 2014 Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying data with Stored Procedures
Module 16: Programming with T-SQL
Module 17: Implementing Error Handling
Module 18: Implementing Transactions
Module 19: Improving Query Performance
Module 20: Querying SQL Server Metadata
Session 1 | ||||
Start Date: | May 15 | |||
End Date: | June 14 | |||
Day(s): | Mon, Tue | |||
Hours: | 6:00pm a 10:00pm |