Course Details Location: PST, Application Classroom Length: 5 days Times: 9:00 AM – 4:30 PM Price: $2,195 Lessons: 20 view details Course Content 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 Registration Fill in the fields below to register for courseChoose the option that best describes the student: *selectCorporate ParticipantFederal/MilitaryWIOAState and Local Government Employees RSFHAdditional RegistrantName *FirstLastCompany *Email *Phone *NameRegister