Course Detail

SQL for Data Analysis

Introduction to SQL for Data Analysis

₦120,000.00 Add to basket

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

  1. Introduction to Database

  2. Introduction to DBMS

  3. Introduction to and applications of SQL

  4. SQL Tables: Data Types

  5. Creating an SQL Tables

  6. Create, use and Drop Databases in SQL

  7. Insert Query Syntax in SQL

  8. Select Statement Syntax in SQL

  9. Select Distinct Syntax in SQL

  10. Operators in SQL; +, -, *, / 

  11. Condition: numeric comparison

  12. SQL Aggregate Functions: COUNT, SUM, MIN/MAX, AVG, CASE

  13. Functions in SQL: LEN, LOWER, CONCAT, LEFT, REPLACE, RIGHT, UPPER

  14. Clauses in SQL: GROUP BY, ORDER BY, WHERE, LIMIT, IN, LIKE, AND, OR, IS NULL, NOT

  15. Joins in SQL: INNER, OUTER, LEFT, RIGHT, using WHERE or ON

  16. IF() Function in SQL

  17. Case Study: SQL Island

  18. Case Study: Murder Mystery

 

Related Courses



₦100,000

In-depth Excel Training, Executive Dashboards & Business Data Analysis



₦120,000

Big Data Analysis, Power Query, Power Pivot and VBA in Excel

finance-model

₦120,000

Finance and Financial Statements for non-Finance Managers & Entrepreneurs

Increase your Productivity

Get the special edge you need. Register for our premium online classes.


Enroll Now