Course Detail

SQL for Data Analysis

SQL FOR DATA ANALYSIS

₦150,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 for data analysts and prospective data engineers. The language is 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 & Setup
    1. Understanding SQL and databases
    2. Key concepts of schema, tables, columns, primary keys, and foreign keys
    3. Installation of SQL Server
    4. Installation of SQL Server Management Studio (SSMS)
    5. Sample company-wide DB setup (Adventure Works Cycle)
  1. Introduction to relational and non-relational databases
    1. Relational databases like MS SQL, MySQL, and PostgreSQL
    2. Non-relational databases
    3. SQL is useful across all,  including big data platforms
  2. Building a relational SQL DB Table from scratch
    1. CREATE TABLE to build from scratch
    2. ALTER TABLE to modify table structure
    3. DROP TABLE to delete table
    4. INSERT INTO statement to add new rows of records
    5. UPDATE statement modify existing rows of records
    6. DELETE statement to remove rows of records
  3. SELECT statement for data analysis
    1. Basic SELECT statement
    2. SELECT DISTINCT
    3. SELECT TOP
    4. WHERE clause
    5. Multiple WHERE conditions
    6. ORDER BY
    7. GROUP BY
    8. HAVING
    9. Understanding when to use WHERE vs. HAVING
  4. Logical Operators
    1. AND
    2. OR
    3. NOT
    4. IN
    5. BETWEEN
    6. LIKE
    7. CASE
  5. Advanced data manipulation
    1. Carrying out mathematical operations
    2. Using alias
    3. JOIN and the different types
    4. UNION, INTERSECT and EXCEPT
    5. LIKE wildcards
    6. Subqueries
    7. Common Table Expressions (CTE)
    8. String functions
    9. Numbers formatting
    10. Date formatting
  6. Views and stored procedures
    1. Use of views
    2. How to create views
    3. Use of stored procedures
    4. How to create stored procedures
    5. Exporting tables as stored procedures
  7. Understanding SQL and database performance
  8. Extensive practical tasks

 

Related Courses



₦120,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

₦150,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