Description

In this course, you will learn how to use Structured Query Language (SQL) to extract and analyze data stored in databases.

Course Content

Module 1 -SQL and Relational Databases 101

  • Introduction to SQL and Relational Databases
  • Information and Data Models
  • Types of Relationships
  • Mapping Entities to Tables
  • Relational Model Concepts

Module 2 - Relational Model Constraints and Data Objects

  • Relational Model Constraints Introduction
  • Relational Model Constraints Advanced

Module 3 - Data Definition Language (DDL) and Data Manipulation Language (DML)

  • CREATE TABLE statement
  • INSERT statement
  • SELECT statement
  • UPDATE and DELETE statements

Module 4 - Advanced SQL

  • String Patterns, Ranges, and Sets
  • Sorting Result Sets
  • Grouping Result Sets

Module 5 - Working with multiple tables

  • Join Overview
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Join

Duration: 2 – 4 weeks

Hi, How Can We Help You?
Welcome To
Portharcourt Data School

Physical & Virtual  Programmes are available !

Enroll Now!

Thank You
100% secure website.