Introduction to SQL Server 2022 for Query Writers

Introduction to Relational Databases and SQL

• An introduction to client/server systems
• An introduction to the relational database model
• An introduction to SQL and SQL-based systems
• The Transact-SQL statements

Using Management Studio

• An introduction to SQL Server 2022
• An introduction to Management Studio
• How to view and modify the database
• How to work with queries
• How to view the documentation for SQL Server

Retrieving Data from a Single Table

• An introduction to the SELECT statement
• How to code the SELECT clause
• How to code the WHERE clause
• How to code the ORDER BY clause

Retrieving Data from Two or More Tables

• How to work with inner joins
• How to work with outer joins
• Other skills for working with joins
• How to work with unions

Coding Summary Queries

• How to work with aggregate functions
• How to group and summarize data
• How to summarize data using SQL Server extensions

Coding Subqueries

• An introduction to subqueries
• How to code subqueries in search conditions
• Other ways to use subqueries
• Guidelines for working with complex queries
• How to work with common table expressions

Inserting, Updating, and Deleting Data

• How to create test tables
• How to insert new rows
• How to modify existing rows
• How to delete existing rows
• How to merge rows

Working with Data Types

• A review of the SQL data types
• How to convert data

Using Functions

• How to work with string data
• How to work with numeric data
• How to work with date/time data
• Other functions you should know about