Introduction to SQL Server Query Writing

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

Data Platform Training

Introduction to Query Writing

Timezone - AEST
Thursday March 22, 2018
AUD$550 + GST


The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available