+The Basic Architecture of SQL Server
+SQL Server Editions and Versions
+Getting Started with SQL Server Management Studio
+Lab : Working with SQL Server 2016 Tools
Close
SQL Server 2019 ile Temel Veritabanı Sorgulama
SQL SERVER EĞİTİMLERİ
Her Yönüyle SQL Server 2019 ile Temel Veritabanı Sorgulama
-
Module 1: Introduction to Microsoft SQL Server 2016
-
Module 2: Introduction to T-SQL Querying
+Introducing T-SQL
+Understanding Sets
+Understanding Predicate Logic
+Understanding the Logical Order of Operations in SELECT statements
+Lab : Introduction to Transact-SQL Querying
-
Module 3: Writing SELECT Queries
+Writing Simple SELECT Statements
+Eliminating Duplicates with DISTINCT
+Using Column and Table Aliases
+Writing Simple CASE Expressions
+Lab : Writing Basic SELECT Statements
-
Module 4: Querying Multiple Tables
+Understanding Joins
+Querying with Inner Joins
+Querying with Outer Joins
+Querying with Cross Joins and Self Joins
+Lab : Querying Multiple Tables
-
Module 5: Sorting and Filtering Data
+Sorting Data
+Filtering Data with a WHERE Clause
+Filtering with the TOP and OFFSET-FETCH Options
+Working with Unknown and Missing Values
+Lab : Sorting and Filtering Data
-
Module 6: Working with SQL Server 2016 Data Types
+Introducing SQL Server 2016 Data Types
+Working with Character Data
+Working with Date and Time Data
+Lab : Working with SQL Server 2016 Data Types
-
Module 7: Using DML to Modify Data
+Inserting Data
+Modifying and Deleting Data
+Lab : Using DML to Modify Data
-
Module 8: Using Built-In Functions
+Writing Queries with Built-In Functions
+Using Conversion Functions
+Using Logical Functions
+Using Functions to Work with NULL
+Lab : Using Built-In Functions
-
Module 9: Grouping and Aggregating Data
+Using Aggregate Functions
+Using the GROUP BY Clause
+Filtering Groups with HAVING
+Lab : Grouping and Aggregating Data
-
Module 10: Using Subqueries
+Writing Self-Contained Subqueries
+Writing Correlated Subqueries
+Using the EXISTS Predicate with Subqueries
+Lab : Using Subqueries
-
Module 11: Using Table Expressions
+Using Derived Tables
+Using Common Table Expressions
+Using Views
+Using Inline Table-Valued Functions
+Lab : Using Table Expressions
-
Module 12: Using Set Operators
+Writing Queries with the UNION Operator
+Using EXCEPT and INTERSECT
+Using CROSS APPLY and OUTER APPLY
+Lab : Using Set Operators
-
Module 13: Using Window Ranking, ffset, aOnd Aggregate Functions
+Creating Windows with OVER
+Exploring Window Functions
+Lab : Using Window Ranking, Offset and Aggregate Functions
-
Module 14: Executing Stored Procedures
+Querying Data with Stored Procedures
+Passing Parameters to Stored Procedures
+Creating Simple Stored Procedures
+Working with Dynamic SQL
+Lab : Executing Stored Procedures
-
Module 15: Improving Query Performance
+Factors in Query Performance
+Displaying Query Performance Data
+Lab : Improving Query Performance
-
SQL Server Database Certification Path
+Introduction to SQL Server Database Certification
+Choosing the Right SQL Server Database Certification Path
+Preparing for SQL Server Certification Exams
+Sample Tips,Questions and Answers from Certification Exams