SQL Training in Portharcourt Nigeria - Data Analysis Training in Port Harcourt Nigeria

Data science, data analysis, data analytics

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?