Structured QueRy Language
 
Course Outline

The breakdown below provides an outline of the course content & learning path.

Structured Query Language (SQL) is a programming language designed for interacting with relational Database Management systems (DBMS).

In this course, you will be learning the basics of Relational databases, how to create a database and tables, querying and Modifying data in a DBMS.

After completing this course, the participants you will be able to:

  • Understand Relational databases and how data is structured in a Relational Database Management System.
  • Understand the concept of Primary and foreign keys.
  • Use CREATE Statements to create tables using SQL.
  • Insert, Update, and Delete data from a database using SQL.
  • Use Filters to extract data that matches specific criteria using SQL.
  • Manipulate data using various operators.
  • Summarise data using SQL.
  • Sort and Group data using SQL.
  • Retrieve and Merge data from multiple tables.
  • Use Common Table Expressions (CTE) to create temporary result sets to use for another query.

Beginner to Intermediate

4 Days

  • i. Database Fundamentals
  • Basic Databases Concepts
  • Introduction to SQL
  • Exploring Database Objects
  • Exploring Database Objects: Schema, Tables, Fields, Records
  • Concept of Primary Keys
  • Concept of Referential Integrity
  • ii. Building Database Schema
  • Creating database with SQL
  • Creating tables with SQL
  • Modifying table structure with ALTER TABLE
  • Data types
  • Relationships
  • Creating Primary Keys
  • Creating Foreign Keys
  • Removing tables with DROP TABLE
  • iii. Data Manipulation Commands
  • Inserting new rows into tables with INSERT
  • Modifying the content of tables with UPDATE
  • Deleting records from tables using DELETE
  • Truncating tables
  • iv. Querying Data with the SELECT Statement
  • Retrieve all data from a table
  • Retrieve specific data from Table with SQL SELECT
  • Filtering Data using SQL WHERE Clause
  • Ordering data using SQL ORDER BY Clause
  • Using Alias to rename data output column.
  • v. SQL Operators:
  • Comparison Operators (=, <, >, <=, >=)
  • Logical operators (AND, OR and NOT)
  • Special operators (BETWEEN, IN, LIKE)
  • IS NULL operator
  • Operator precedence
  • vi. Performing Analysis with Aggregate Functions
  • Summarizing data using SUM, AVG and COUNT
  • Finding the highest/lowest values with MAX and MIN
  • Defining the summary level with GROUP BY
  • Applying filter conditions with HAVING
  • vii. Merging Data From Multiple Tables
  • Creating Complex queries using JOIN: INNER JOIN, OUTER JOIN, CROSS JOIN
  • Defining Table Alias
  • Combining results Set Operators (UNION, INTERSECT, EXCEPT)
  • viii. Sub-Queries and Common Table Expressions
  • Creating Complex queries with sub-queries: Sub-query returning single value, Sub-query returning multiple values
  • Common Table Expressions (CTEs)
Enlist For This Course / Submit An Enquiry