M20761 Quering Data with Transact-SQL - Seminar / Kurs von brainymotion AG

Inhalte

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.

Lernziele

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

SG-Seminar-Nr.: 5150571

Anbieter-Seminar-Nr.: 855707762

Preis jetzt anfragen

Seminar merken ›

Sie buchen immer automatisch den besten Preis für jeden Termin. Semigator berücksichtigt

  • Frühbucher-Preise
  • Last-Minute-Preise
  • Gruppenkonditionen

und verfügt über Sonderkonditionen mit einigen Anbietern.

Der Anbieter ist für den Inhalt verantwortlich.

Über Semigator mehr erfahren

  • Anbietervergleich von über 1.500 Seminaranbietern
  • Vollständige Veranstaltungsinformationen
  • Schnellbuchung
  • Persönlicher Service