Course Detail

SQL for Data Analysis

Introduction to SQL for Data Analysis

SQL stands for Structured Query Language. This language has become the de facto language by developers and data professionals to access and interactively query data from various sources as well as define data structures in relational databases. It is also used by large organizations to solve incredibly challenging problems. Thus, learning SQL is very relevant for developers and data professionals.

UrBizEdge Limited, Nigeria’s leading business data analysis company is putting together this special training for proactive business professionals who are interested in learning SQL for data analysis.

This course is meant to be an introductory course to the world of SQL. The language is also relatively easy to learn because its syntaxes are very similar to English phrases.
The course will require students to have an understanding of Excel or any spreadsheet application. No coding experience is required.

We will provide you all the software and resources needed.

Training Outline

Introduction to Database
Introduction to DBMS
Introduction to and applications of SQL
SQL Tables: Data Types
Creating an SQL Tables
Create, use and Drop Databases in SQL
Insert Query Syntax in SQL
Select Statement Syntax in SQL
Select Distinct Syntax in SQL
Operators in SQL; +, -, *, /
Condition: numeric comparison
SQL Aggregate Functions: COUNT, SUM, MIN/MAX, AVG, CASE
Functions in SQL: LEN, LOWER, CONCAT, LEFT, REPLACE, RIGHT, UPPER
Clauses in SQL: GROUP BY, ORDER BY, WHERE, LIMIT, IN, LIKE, AND, OR, IS NULL, NOT
Joins in SQL: INNER, OUTER, LEFT, RIGHT, using WHERE or ON
IF() Function in SQL
Case Study: SQL Island
Case Study: Murder Mystery