Brochure
Enquire
- Introduction
- The dataset that you will need for the Assignments/Excercises
- Installation/Uploading instructions (please read carefully)
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 2,499
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction to the Course
Base Knowledge of SQL
- SQL Snytax
- Where CLAUSE
- SELECT statement and Columns (Variables,Calculated Value,Formatted Value)
- CASE Logic
- Summary Functions
- Base Knowledge Quiz
- Assignment 1
- Solution Assignment 1
JOINING
- Inner Join
- Joining Three Tables
- Left/Right Join
- Full Join (using coalesce function)
- Joining Quiz
- Assignment 2
- Solution Assignment 2
Working With Tables
- Creating A Table
- Altering Columns (add, modify, delete + adding values to column)
- Inserting Rows with a Query and SET statement + Deleting Rows
- Working with Tables Quiz
- Assignment 3
- Solution for Assignment 3
Practical Application of SQL in SAS programming
- Comparing Tables
- Finding Duplicate Records
- Only Displaying Unique records/rows
- Customize The Way You Sort
- Updating A Table Under Certain Conditions
- Practical Application Quiz
- Assignment 4
- Solution for Assignment 4
Bonus
- Bonus Lecture
Articles
Popular Articles
prev
next
