Microsoft SQL Server – Introduction

Content

SQL Server Overview

• SQL Server Overview
• Versions of SQL Server
• SQL Server Management Studio

Microsoft Query Tools

• Using Microsoft Excel (Query)
• Using Microsoft Access
• Using Power BI
• Learning SQL Directly

SQL Overview

• ANSI SQL and Transact-SQL
•  Structured Query Language
•  Data Definition Language
•  Data Manipulation Language
•  Data Control Language

The Basic SELECT Statement

•  The SELECT Statement
•  Selecting Fields and Expressions
•  Restricting Duplicates
•  Specifying Criteria
•  Logical Operators
•  Wild Cards
•  Considering the Query Optimiser
•  Combining Conditions
•  Sorting

Joining Tables

• Join Syntax
• Outer Joins
• Self Joins
• Union Queries

Summary Queries

• Grouping Data
• The HAVING Clause
• Sub-Queries
• Correlated Sub

Inserting and Copying Records

• Inserting Records
• Copying Data to an Existing Table
• Copying Data to a New Table
• Using Temporary Tables

Changing and Deleting Records

• Changing Records
• Updating one table based on values in another
• Deleting Records

Programmable Objects

• Server-Side Coding
• Stored Procedures
• Triggers