MCSA -SQL Server 2016 Database Development Training

This Lecture introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.

·         Lessons

·         The Basic Architecture of SQL Server

·         SQL Server Editions and Versions

·         Getting Started with SQL Server Management Studio

·         Lab : Working with SQL Server Tools

·         Working with SQL Server Management Studio

·         Creating and Organizing T-SQL Scripts

·         Using Books Online

·         After completing this Lecture, you will be able to:

·         Describe relational databases and Transact-SQL queries.

·         Describe the on-premise & cloud-based editions & versions of

       SQL Server.

·         Describe how to use SQL Server Management Studio (SSMS) to

       connect to an instance of SQL Server.

·         Explore the databases contained in the instance.

·         Work with script files that contain T-SQL queries.

This Lecture describes the elements of T-SQL and their role in writing queries. Describe the use of sets in SQL Server. Describe the use of predicate logic in SQL Server. Describe the logical order of operations in SELECT statements.

·         Lessons

·         Introducing T-SQL

·         Understanding Sets

·         Understanding Predicate Logic

·         Understanding the Logical Order of Operations in SELECT

       statements

·         Lab : Introduction to T-SQL Querying

·         Executing Basic SELECT Statements

·         Executing Queries that Filter Data using Predicates

·         Executing Queries That Sort Data Using ORDER BY

·         After completing this Lecture, you will be able to:

·         Describe the role of T-SQL in writing SELECT statements.

·         Describe the elements of the T-SQL language

·         Describe Which elements will be useful in writing queries.

·         Describe the concepts of the set theory, one of the mathematical

       underpinnings of relational databases, and to help you apply it to

       how you think about querying SQL Server.

·         Describe predicate logic and examine its application to querying

       SQL Server.

·         Explain the elements of a SELECT statement, delineate the order in

       which the elements are evaluated, and then apply this

            understanding to a practical approach to writing queries.

This Lecture introduces the fundamentals of the SELECT statement, focusing on queries against a single table.

·         Lessons

·         Writing Simple SELECT Statements

·         Eliminating Duplicates with DISTINCT

·         Using Column and Table Aliases

·         Writing Simple CASE Expressions

·         Lab : Writing Basic SELECT Statements

·         Writing Simple SELECT Statements

·         Eliminating Duplicates Using DISTINCT

·         Using Column and Table Aliases

·         Using a Simple CASE Expression

·         After completing this Lecture, you will be able to:

·         Describe the structure and format of the SELECT statement

·         Describe the enhancements that will add functionality 

·         Describe the readability to your queries

·         Describe how to eliminate duplicates using the DISTINCT clause

·         Describe the use of column and table aliases

·         Understand and use CASE expressions