fbpx

Upcoming Events

No Events on The List at This Time

 

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.
1

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!

qodef-fullwidth-slider

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.

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

     

     

     


    ×
    X
    \