Note : This would be LIVE Instructor Led Session which would be conducted in "English" language. Duration - 4 hrs.
1. Why you should learn SQL: Basics to Intermediate?
- One of the easier languages to pick up
- Highly sought-after tech skill
- Good job prospects across the world
- Opens up many data job roles like data analyst, data scientist + data engineer
2. Are there any pre-requisites?
- Nope, anyone willing to learn can join.
3. Who would be conducting this training?
- Industry experienced professional would be conducting this session.
4. Would this be instructor led?
- Yes, it would be LIVE instructor led session which would be spread across 4hrs.
5. What would be syllabus which would be covered?
SQL Overview
Database overview
Basic Datatypes
Retrieval of Data
(Select, From, Where ,
Distinct, order By)
Working with Operators
BODMAS Rule (working
with multiple operators)
Basic SQL functions
Wildcard
Concept of Null
Practice examples
Group By
Having vs Where
Aggregate Functions
DDL vs DML
Create, Insert, Update,
Delete, Drop, Alter,
Truncate
Joins – Understanding
and working with Joins
Subqueries
Practice examples and
QUIZ
Introduction to Advanced
SQL