SQL Server 2019 ile Temel Veritabanı Sorgulama

Awesome Image


Her Yönüyle SQL Server 2019 ile Temel Veritabanı Sorgulama

  • Module 1: Introduction to Microsoft SQL Server 2016

    +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

  • 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



    +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