QUERYING MICROSOFT SQL SERVER® 2014
Modular Course (Select your Modules)
In this course students will provided by 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.
Basic (2 days)
• Introduction to Microsoft SQL Server 2014
• Introduction to T-SQL Querying
• Writing SELECT Queries
• Querying Multiple Tables
• Sorting and Filtering Data
• Grouping and Aggregating Data
• Using Subqueries
Intermediate (2 days)
• Working with SQL Server 2014 Data Types
• Using DML to Modify Data
• Using Built-In Functions
• Using Table Expressions
• Using Set Operators
• Using Window Ranking, Offset, and Aggregate Functions
• Pivoting and Grouping Sets
• Querying data with Stored Procedures
• Programming with T-SQL
• Implementing Error Handling
• Implementing Transactions
• Improving Query Performance (Optional)
• Querying SQL Server Metadata (Optional)
Advanced (2 days)
