Data Analysis using SQL

Lecturer
fitimanager
0 Reviews

Course Description

Course Fee – ₦80,000

DATA ANALYSIS USING SQL

WEEK 1:       SQL BASICS

  • Understanding SQL and its importance in data analysis
  • Overview of relational databases and their components
  • Installing and setting up SQL tools (MySQL Workbench)
  • Understanding, SELECT, FROM, WHERE, GROUP BY, HAVING etc
  • Working with tables, views and indexes
  • Manipulating data using INSERT, UPDATE, and DELETE statements.

WEEK 2:       QUERYING AND FILTERING DATA

  • Writing complex queries
  • Logical Operators (AND or OR) and comparison operators
  • Aggregate functions (SUM, AVG, COUNT, MIN, MAX)
  • Links

WEEK 3:       JOINS AND RELATIONAL DATABASES

  • Understanding table relationships: one-to-one, one-to-many, many-to-many
  • Inner Join, left Join, Right Join, Full Join
  • Primary key, foreign keys and establishing relationships
  • Normalization Concepts

WEEK 4:       SUBQURIES AND DERIVED TABLES

  • Nesting Queries
  • Derived Tables

WEEK 5:       DATA MANIPULATION AND TRANSFORMATION

  • Pivoting and unpivoting
  • Sorting and ordering
  • CASE Statements

WEEK 6:       AGGREGATION AND GROUPING

  • Grouping Data using GROUP BY Clause
  • Having Clause

WEEK 7:       ANALYTICAL FUNCTIONS

  • Rank, row_number, lag, lead
  • Partitioning Data

WEEK 8:       VIEWS AND STIRED PROCEDURES

  • Creating Views
  • Writing Stored Procedures

WEEK 9:       PERFORMANCE OPTIMIZATION

  • Indexing strategies
  • Query execution plans

WEEK 10:     DATA MANIPULATION LANGUAGE (DML)

  • DML statements
  • Transactions and Data Consistency
  • Examination