SQL - Live Online
About
Learn how to write queries from scratch; Master uptil Advanced Joins, Sub Queries & more
Prerequisites
Basic knowledge of computers. Any exposure to Microsoft Excel would be an added plus.
Faculty Profile
Vibhor Gupta.
Founder & Director of Weekendr & Mobiquel. B.E (IT) from NSIT with over 12+ years of Industry Experience in delivering software solutions globally. Has taught close to 3000+ students & professionals on Software Development in Android, Java, SQL & Python.
Curriculum
- Why SQL, RDBMS Concepts, ACID Properties
- Basic SQL Queries, CRUD in SQL
- How to create a Simple Database, Creating and Running SQL Queries
- Select Query and multiple variants
- SQL Functions and How to apply
- Group By, SQL Joins, Subqueries
- Stored Procedures
- Case Statements, Window Functions
- Using SQL in MS Excel
- Connecting Python with SQL & Plotting Data
