Advance SQL Workshop

Master SQL in Data Warehousing

About SQL Workshop

A 2 week extensive workshop on “SQL” programming on industry data set! During this workshop, you will be able to learn SQL starting from basics and moving to advance level. Also, you will be covering SQL’s Analytical and Aggregate functions. In the hands-on, you will be using the technologies learned throughout the workshop under the supervision of trainers. Furthermore, you will also be offered preparation on 200 Plus Interviews Questions.

By the end of the workshop, you will be awarded completion certificate from Dice Analytics.

View workshop Agenda Reserve Your Seat

Our Approach for Live Workshop

After establishing a reputable Physical Training Model, based on our stellar records and customer earned trust we gradually progressed to establish the same reputation in the Live Training Model. We are committed to empower you by making our trainings accessible, interactive, and well curated specifically to your objective.

Schedule

Starting

15th April 2020

Duration

2 weeks (Monday – Friday)

Charges

8,000 PKR

Timing

07:00PM to 09:00PM

Meet the Trainer

Meet the trainer of this workshop who is highly experienced!

Mr. Abbas Rizvi

Data Engineer at Teradata | Trainer

Mr. Abbas Rizvi is a data enthusiast with extensive experience. He’s a Teradata 14 Certified Professional, a Certified Professional Scrum Master & a Talend Data Integration Certified Developer currently working with Teradata Global Delivery Center in the role of Data Integration Consultant. Having a great working experience of Data Warehouse design & development and good grasp on multiple ETL Tools and Techniques like Talend, Informatica, DataStage etc. Skilled in working with Open Source Technologies for Data Ingestion, Streaming, Transformation and Analysis like Hadoop, Hive, Spark, Kafka, NiFi and Amazon Web Services etc.

View Profile

Workshop Agenda

Week 1

Database conceptual rudiments
Understanding usage & importance of Primary, foreign, composite & surrogate keys
RDBMS & SQL synopsis
SQL components: DDL, DML & DCL
Understanding datatypes & operators
Database creation
Table construction
Data insertions & understanding Insert clause
Usage of Select clause & performing data retrieval
Unique records retrieval: Distinct
Data insertion from another table: SELECT INSERT
Table deletion: DROP Table
Table modification: ALTER Table
Data filtration
Understanding usage of WHERE clause
Data list filtration: IN operator
SQL Logical Operators
Data sorting using ORDER BY clause
Handling NULL values
SQL Update statement
Delete/Truncate & understanding the difference
Top statement
SQL aggregation: Count, Average, Sum, Min & Max
Wildcard search using SQL LIKE clause
Renaming attributes & Aliasing
Understanding SQL Joins
Data retrieval from multiple tables
Usage & applications of Inner, Left, Right, Full and Self Join

Week 2

Cartesian Product & its applications
Joining tables through UNION/UNION ALL clause & understanding their difference
Data Aggregation using SQL Group By
Filtration on aggregated data by HAVING clause
SQL Data Casting
Volatile Tables & its applications
Volatile Tables – Advanced
SQL COALESCE statement
SQL CASE
SQL Advanced Cases
String manipulation using SUBSTR
SQL TRIM
SQL If Else
Ordered Analytical Functions
Performing filtration on analytical functions using QUALIFY
Data ranking using ROW_NUMBER, RANK, DENSE_RANK & understanding practical applications
ROWs operations
Intro to Subquery & its importance
Query Optimization
OLTP vs OLAP
Data warehousing
DWH solutions
DWH Soft architecture
Data Quality
ETL techniques
Introduction to Teradata & its MPP architecture

Reserve your Seat

You can reserve your seat by filling the form below

Are you a:
StudentWorking Professional