CA10 - Microsoft SQL Server Introduction to Querying - 2 Days

Course Description


Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.


Course Details

Introduction to SQL Server Databases
Objects in a SQL Server Database
Database Diagrams
Components of a SQL Server Database Table
Native SQL Server Data Types
Categories of SQL Statements
Adding Comments to SQL Code

Using the SELECT Statement to Retrieve Data
Examine the Basic Syntax of the SELECT Statement
Retrieving Columns of Data from a Table
Using Aliases for Column Names
Using Aliases for Table Names

Retrieving Specific Rows of Data Using the WHERE Clause
How to Use the WHERE Clause
Overview of Operators
Filter Data by Using Comparison Operators
Filter Data by Using String Comparisons
Filter Data by Using Logical Operators
Filter Data Using a Range of Values
Filter Data Using a List of Values
Working with NULL Values
Introducing Native SQL Server Functions
Functions Relating to NULL Values

Formatting and Sorting Result Sets
Sorting Data Using the ORDER BY Clause
Eliminating Duplicate Rows
Using String Literals
Using Expressions

Querying Data from Multiple Tables by Using Joins
Introduction to Joins
Using Inner Joins
Using Outer Joins
Using Cross Joins
Joining More than Two Tables
Joining a Table to Itself

Summarizing Data Using Aggregate Functions
Using Aggregate Functions Native to SQL Server
Using Aggregate Functions with NULL Values
Grouping Summarized Data with GROUP BY
Filtering Grouped Data
Using the HAVING Clause

Combining and Limiting Result Sets
Combining Result Sets
Using the UNION Operator
Limiting Result Sets
Using the TOP Operator

Working with Subqueries
Introduction to Subqueries
Using Subqueries as Expressions and Derived Tables
Scalar versus Tabular Subqueries
Using Correlated Subqueries
Using the EXISTS Clause with Correlated Subqueries

Inserting Data into Tables
Inserting a Single Row into a Table
Inserting Multiple Rows into a Table
Differentiating Various INSERT Statements

Deleting Data from Tables
Deleting Rows from a Table
Truncating a Table
Deleting Rows Based on Data in Other Tables

Updating Data in Tables
Updating Rows in a Table
Updating Rows Based on Data in Other Tables

Appendix 1. Ranking Grouped Data
Ranking Data
Using Ranking Functions
Using ROW_NUMBER
Using RANK
Using DENSE_RANK
Using NTILE
Summary of Ranking Functions Based on Their Functionality

Appendix 2. Working with SQL Server Date and Time Data
Data Type Precedence
Implicit Data Type Conversions
Querying and Modifying Date and Time Data
Using the New SQL Server Date and Time Data Types


Course Enquiry