Course Outline - Microsoft Teams for End Users

    SQL Introduction

    Course Duration: Two Day

    Target Audience:

    This course is designed for participants new to writing SQL queries, who wish to use SQL to query and update data in SQL Server, MS Access and Oracle databases.

    Course Objectives:

    Understand how Database Servers work Learn to use SQL to output reports, Learn to modify data with SQL, Learn to create a simple database, Learn to create simple work with Views, Learn to create tables with SQL, Learn to program through SQL Stored procedures, triggers, functions,

    Course Outline:

    Relational Database Basics

    • Overview of Relational Database
    • Management Systems
    • Normalisation
    • Tables, Rows and Columns
    • Datatypes
    • Relationships
    • Primary Keys / Foreign Keys
    • SQL Statements
    • Data Control Language (DCL)
    • Data Manipulation Language (DML)
    • Data Definition Language (DDL)

    Overview of Database Types

    • Oracle
    • MySQL
    • MS Access
    • MS SQL Server
    • Similarities and Differences between different database types

    Simple SELECTs

    • Use SELECT to Select Columns in All Rows
    • Use SELECT to select Specific Columns
    • Comments
    • Exploring the Tables
    • Sorting Records
    • Sorting By a Single or Multiple Column
    • Sorting By Column Position
    • Ascending and Descending Sorts
    • Sorting Results
    • The WHERE Clause and Operator
    • Symbols / Words
    • Checking for NULL
    • Using WHERE and ORDER BY
    • Together
    • The BETWEEN, IN, LIKE, NOT, AND & OR Operators
    • Writing SELECTs with Multiple Conditions

    Views

    • Benefits of Views
    • Creating Views
    • Dropping Views

    Advanced SELECTs

    • Calculated Fields
    • Concatenation
    • Mathematical Calculations
    • Aliases
    • Calculating Fields
    • Aggregate Functions and Grouping
    • Grouping Data
    • Selecting Distinct Records
    • Working with Aggregate Functions
    • Built-In Data Manipulation Functions
    • Common Math Functions
    • Common String Functions
    • Common Date Functions
    • Data Manipulation Functions
    • Other Analytical Functions

    Subqueries, Joins and Unions

    • Table Aliases
    • Subqueries
    • Using Joins – Outer Joins / Inner Joins
    • Multi-Table Joins
    • Working with Unions
    • UNION ALL
    • UNION Rules

    Conditional Processing with CASE

    • Working with CASE
    • Using IIF in SQL Server

    Inserting, Updating and Deleting Records

    • INSERT – To Inserting Records
    • UPDATE – To Change Record Values
    • DELETE – To Delete Records

    Creating and Modifying Tables

    • Creating Tables
    • NULL Values
    • Primary Keys / Foreign Keys
    • Adding and Dropping Columns
    • Renaming Tables
    • Dropping Tables

    User Management (Oracle) Overview

    • Users / Roles
    • Privileges

    Using Other Software with Databases

    • ODBC and Creating DSNs
    • Using Access to Work with MS SQL and Oracle Databases
    • Using Excel to Work with MS SQL

    Discussion and Question Time

    View Schedule
    Contact Us