Discover

Filter events and get the results you need

SQL For Data Analysis

By UrBizEdge
Thu, Feb 8. 8AM - Sat 4PM
URBIZEDGE LIMITED, Lagos
past 5 months
SQL For Data Analysis

Below are the details of our next training to take place in Lagos. Thanks for your interest!


This is a special opportunity for you to be trained at a specially discounted cost by professionals who have done Microsoft Excel training and consulting for MTN Nigeria, Airtel Nigeria, Vodacom, Globacom, Guinness, Nigerian Breweries, Total E&P, and many other local and international companies.


You will learn all you need to boost your productivity at work and career/entrepreneurial prospects. So this is an opportunity you shouldn't miss.

The training details are as follows:


Venue: UrBizEdge, 11 Oseni Street, adjacent GTBank, Anthony Village, Lagos.

Cost: N150,000


The cost covers your training materials, after-training support, video learning materials, certificate, and lunch. Try to pay early to secure your spot and send us your name as you would like it to appear on your certificate.

Payment Details

Account Name: URBIZEDGE LIMITED

Bank: FCMB

Account No: 2888666014

Branch: Onipanu



Title: SQL for Data Analysis

Training Outline

1. INTRODUCTION & SETUP

a.Understanding SQL and databases
b. Key concepts of schema, tables, columns, primary keys, and
foreign keys

c. Installation of SQL Server

d. Installation of SQL Server Management Studio (SSMS)
e. Sample company-wide DB setup (Adventure Works Cycle

2. INTRODUCTION TO RELATIONAL AND NON-RELATIONAL DATABASES

a. Relational databases like MS SQL, MySQL, and PostgreSQL
b. Non-relational databases
c. SQL is useful across all, including big data platforms


3. BUILDING A RELATIONAL SQL DB TABLE FROM SCRATCH

a. CREATE TABLE to build from scratch

b. ALTER TABLE to modify table structure

c. DROP TABLE to delete table

d. INSERT INTO statement to add new rows of records

e. UPDATE statement modify existing rows of records
f. DELETE statement to remove rows of records


4. SELECT STATEMENT FOR DATA ANALYSIS

a. Basic SELECT statement

b. SELECT DISTINCT

c. SELECT TOPWHERE clause
d. Multiple WHERE conditions

e. ORDER BY

f. GROUP BY

g. HAVING

h. Understanding when to use WHERE vs. HAVING


5. LOGICAL OPERATORS

a. AND

b. OR

c. NOT
d. IN
e. BETWEEN

f. LIKE

g. CASE


6. ADVANCED DATA MANIPULATION

a. Carrying out mathematical operations
b. Using alias
c. JOIN and the different types

d. UNION, INTERSECT, and EXCEPT
e. LIKE wildcardsSubqueries
f. Common Table Expressions

g. (CTE)String functions
h. Numbers formatting

i. Date formatting


7. VIEWS AND STORED PROCEDURES

a. Use of views
b. How to create views

c. Use of stored procedures

d. How to create stored procedures

e. Exporting tables as stored procedures

8. UNDERSTANDING SQL AND DATABASE PERFORMANCE



Google Map

Other Interesting Events

On Going 5 months
Feb 10
On Going 5 months

Free Car Maintenance Check

Tronics Ville Auto
upcoming in 13 days
Aug 02
upcoming in 13 days

WojEShOn Street Arts Festival 2024🇬🇭

Flamingo Traffic Light To Banku Junction
upcoming in 6 days
Jul 27
upcoming in 6 days

Learn Boxing with Wisdom Boxing Gym

Decathlon Ghana - Kawukudi
₵200
upcoming in 6 days
Jul 27
upcoming in 6 days

Decathlon & Rota Skates Class

Decathlon Ghana - Kawukudi
₵200
upcoming in 6 days
Jul 26
upcoming in 6 days

Soccer showdown

Accra ridge church school
₵20+
upcoming in about 1 month
Aug 30
upcoming in about 1 month

Underrated soccer tournament

AstroTurf Madina
₵35+
upcoming in 10 days
Jul 30
upcoming in 10 days

Learn Table Tennis

Decathlon Ghana - Kawukudi
₵380
upcoming in 3 months
Oct 12
upcoming in 3 months

First National Bank Accra Marathon

Regional Maritime University
₵20+
On Going 4 months
Mar 11
On Going 4 months

POTS - PLANTS - PAINT

Indulge Accra, Dade Street, Accra, Ghana
On Going 5 months
Feb 21
    Top Locations
    Locations & Categories
    All Event Categories

    Sign In

    Discover great experiences with eGotickets


    Sign Up     Lost Password     Confirmation