Course Outline - Microsoft Teams for End Users

    SQL Advanced

    Course Duration: One Day

    Target Audience:

    This course is designed for participants who have completed the SQL introduction course or who are familiar with writing simple SQL queries to query and maintain a relational database.

    Course Objectives:

    Build advanced SQL queries, Learn to create tables with SQL, Learn to create views, Learn to modify data with SQL using insert, update and delete, Learn how to use stored procedures, triggers and built-in functions

    Course Outline:

    Course Introduction

    SQL Select Main Clauses

    • Review of Joins Types
    • Review of Unions
    • Review of Views in SQL

    Advanced Querying

    • Self-Join
    • Sub-Query
    • Correlated Sub-Query
    • The LIKE Operator

    Conditional Processing Using CASE

    Modified Comparison Operators

    • Some
    • Any
    • All

    Modified Comparison Operators

    Restricting Records Using TOP

    Table Expressions

    • Derived Tables
    • Common Table Expressions (CTEs)

    Ranking SQL Query Results

    • The RANK Function
    • The PARTITION BY Clause
    • The DENSE_RANK Function

    DML Triggers

    • Deleted and Inserted Tables

    The OUTPUT Clause

    Temporary Tables

    • Local Temporary Tables
    • Global Temporary Tables

    The TRUNCATE TABLE Statement

    The MERGE Statement

    Creating and Modifying Tables

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

    Inserting, Updating and Deleting Records

    • INSERT – To Insert Records
    • Inserting Records
    • UPDATE – To Change Record Values
    • Multi-Table Joins
    • DELETE – To Delete Records
    • Updating and Deleting Records

    Programming Overview in SQL

    • SQL Server Transact SQL (T-SQL)
    • Oracle PL/SQL
    • Stored Procedures
    • Functions
    • Triggers
    • Cursors

    Monitoring and Troubleshooting

    Performance Tuning and Viewing System Logs

    • Turning on Statistics
    • Indexing
    • Finding a Bottleneck
    • Viewing System Logs
    • Setting Up Test Data

    Printing Schema Diagrams

    Discussion and Question Time

    View Schedule
    Contact Us