Introduction to SQL Server Query Writing is an introductory level course designed to provide the core skills required to be able to use and understand Microsoft’s T-SQL language to be able to query your SQL Server databases.
This 1-day course is instructor led with hands on lab sessions taking you through following modules:
Course Outline
MODULE 1: Introduction to SQL Server
This module will provide an introduction to Microsoft SQL Server giving you an overview of:
- Where SQL Server has come from
- The different tools available to assist in managing your SQL Server environments,
- How you can connect to your SQL Server environments
- The different types of statements available for you to use
- Where you can get help from
MODULE 2: SQL Server Management Studio
This module introduces you to SQL Server Management Studio, the primary tool that will be used to connect, update and manage your SQL Server databases. In this module we will look at features such as:
- SSMS Components
- SSMS Configurations
- Statements Vs Scripts
- Result Sets
- Statement Readability
- Statement Execution
MODULE 3: Retrieving Data
This module introduces us to the components that make up a database and how we can utilise those to retrieve and manage the data in our SQL Server database. We start to look at how we are able to retrieve and manipulate the data out of our SQL Server databases looking at the following:
- Query Sources
- Selecting Data
- Filtering Results
- Ordering Results
- Statement Functions
- Query Readability
- Dealing with Nulls
MODULE 4: Summarizing Retrieved Data
This module takes the Retrieving data a little further by introducing concepts to allow us to make the data returned work for us to provide more relevant informationby being able to summarize the results.
MODULE 5: Retrieving Data from Multiple Tables
Now we are feeling more confident with being able to retrieve data from our SQL Server databases and make the results set much more meaningful we are now going to look at further expanding this by looking at how we can retrieve data from multiple locations from within our SQL Server database. We will look at concepts like:
- Inner Joins
- Outer Joins
- Cross Joins
- Joining 2 or more tables
- Joining a table to itself