M20761 Quering Data with Transact-SQL -
Seminar / Kurs
von brainymotion AG
The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
1 - Introduction to Microsoft SQL Server 2016The Basic Architecture of SQL ServerSQL Server Editions and VersionsGetting Started with SQL Server Management Studio2 - Introduction to T-SQL QueryingIntroducing T-SQLUnderstanding SetsUnderstanding Predicate LogicUnderstanding the Logical Order of Operations in SELECT statements3 - Writing SELECT QueriesWriting Simple SELECT StatementsEliminating Duplicates with DISTINCTUsing Column and Table AliasesWriting Simple CASE Expressions4 - Querying Multiple TablesUnderstanding JoinsQuerying with Inner JoinsQuerying with Outer JoinsQuerying with Cross Joins and Self Joins5 - Sorting and Filtering DataSorting DataFiltering Data with PredicatesFiltering with the TOP and OFFSET-FETCH OptionsWorking with Unknown Values6 - Working with SQL Server 2016 Data TypesIntroducing SQL Server 2016 Data TypesWorking with Character DataWorking with Date and Time Data7 - Using DML to Modify DataInserting DataModifying and Deleting Data8 - Using Built-In FunctionsWriting Queries with Built-In FunctionsUsing Conversion FunctionsUsing Logical FunctionsUsing Functions to Work with NULL9 - Grouping and Aggregating DataUsing Aggregate FunctionsUsing the GROUP BY ClauseFiltering Groups with HAVING10 - Using SubqueriesWriting Self-Contained SubqueriesWriting Correlated SubqueriesUsing the EXISTS Predicate with Subqueries11 - Using Set OperatorsWriting Queries with the UNION OperatorUsing EXCEPT and INTERSECTUsing APPLY