SQL Fundamentals

Preference Dates Timing Location
Evening Course 02 - 06 December 2018 07:00PM- 10:00PM Dubai Knowledge Park

Course Description

This course will teach you how how to use SQL quickly and effectively. You’ll learn how to read and write complex queries to a database using one of the most in demand skills – PostgreSQL. These skills are also applicable to any other major SQL database including MySQL, Microsoft SQL Server and Oracle.

Moreover, you will learn how to query database tables, aggregate data using group by functions, write sub-queries and understand how to use some of the advanced features including date-time functions and regular expressions.

Unit 1 – Course Introduction

  • Course Curriculum Overview
  • Overview of Databases
  • Setup and Installation of PgAdmin and PostgreSQL

Unit 2 -Databases and Tables

  • Creating and Restoring a Database
  • Restoring a Table Schema

Unit 3 – SQL Statement Fundamentals

  • SELECT Statement
  • SELECT DISTINCT
  • SELECT WHERE
  • COUNT
  • LIMIT
  • ORDER BY
  • BETWEEN
  • IN
  • LIKE

Unit 4 – GROUP BY Statements

  • MIN MAX SUM and AVG
  • GROUP BY
  • HAVING

Unit 5 – JOINS

  • Overview of JOINS
  • AS Statement
  • Overview of Inner Join
  • Examples of Inner Joins
  • Overview of Join types
  • Example of Outer Joins
  • Union

Unit 6 -Advanced SQL Commands

  • Timestamps and Extract
  • Mathematical Functions
  • String Function and Operators
  • Sub-Queries
  • Self-Join

Unit 7 – Creating Database Tables

  • Data Types
  • Primary Keys and Foreign Keys
  • Create Table
  • Insert
  • Update
  • Delete
  • Alter Table
  • Drop Table
  • CHECK Constraint
  • NOT NULL Constraint
  • UNIQUE Constraint

Unit 8 – Views

  • Working with Views
  • Professionals or students who are interested in learning about how to extract data from relational databases.
  • Future Data Analysts, Data Science Professionals or Engineers.
  • No prior technical experience is required to benefit from this course.

The participants who have successfully completed this course are encouraged to take Big Data and Hadoop. 

Testimonials