Querying Microsoft SQL Server Home / Courses / Querying MS SQL Server PST, Application Classroom Length: 5 days Times: 9:00 AM – 4:30 PM View Course Outline Lesson 1 The Basic Architecture of SQL Server SQL Server Editions and Versions Getting Started with SQL Server Management Studio Lesson 2 Introducing T-SQL Understanding Sets Understanding Predicate Logic Understanding the Logical Order of Operations in SELECT statements Lesson 3 Writing Simple SELECT Statements Eliminate Duplicates with DISTINCT Using Column and Table Aliases Write Simple CASE Expressions Lesson 4 Understanding Joins Querying with Inner Joins Querying with Outer Joins Querying with Cross Joins and Self Joins Lesson 5 Sorting Data Filtering Data with Predicates Filtering with the TOP and OFFSET-FETCH Working with Unknown Values Lesson 6 Introducing SQL Server 2014 Data Types Working with Character Data Working with Date and Time Data Lesson 7 Inserting Data Modifying and Deleting Data Lesson 8 Writing Queries with Built-In Functions Using Conversion Functions Using Logical Functions Using Functions to Work with NULL Lesson 9 Using Aggregate Functions Using the GROUP BY Clause Filtering Groups with HAVING Lesson 10 Writing Self-Contained Subqueries Writing Correlated Subqueries Using the EXISTS Predicate with Subqueries Lesson 11 Using Views Using Inline Table-Valued Functions Using Derived Tables Using Common Table Expressions Lesson 12 Writing Queries with the UNION Operator Using EXCEPT and INTERSECT Using APPLY Lesson 13 Creating Windows with OVER Exploring Window Functions Lesson 14 Writing Queries with PIVOT and UNPIVOT Working with Grouping Sets Lesson 15 Writing Queries with PIVOT and UNPIVOT Passing Parameters to Stored Procedures Creating Simple Stored Procedures Working with Dynamic SQL Lesson 16 T-SQL Programming Elements Controlling Program Flow Lesson 17 Using TRY / CATCH Blocks Working with Error Information Lesson 18 Transactions and the Database Engine Controlling Transactions Lesson 19 Factors in Query Performance Displaying Query Performance Data Lesson 20 Querying System Catalog Views and Functions Executing System Stored Procedures Querying Dynamic Management Objects COURSE DESCRIPTION This is the foundational course for all SQL server related disciplines including database administration, database development, and business intelligence. In this course, participants will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server. Tools and skills you will learn include: SQL Server Management Studio, T-SQL, SELECT statements in querying multiple tables, data types, data sorting and filtering, data manipulation language (DML), grouping and aggregating data, table expressions, set operators, window functions, T-SQL programming, error handlers, and transaction management in SQL Server. IDEAL CANDIDATES: This beginner-level course is designed for anyone interested in learning SQL RELATED COURSES: Crystal Reports Level 1, Crystal Reports Level 2, Developing SQL Server Databases, Administering SQL Server, Implementing Data Models and Reports with SQL Server, SharePoint Site Owner, SharePoint, Site User, SharePoint Site Administrator, Office 365, Enabling and Managing Office 365