
This course includes our updated coding exercises so you can practice your skills as you learn.
See a demo
Explore data manipulation language basics, including select, insert, delete, and update, and learn transaction control with commit, rollback, and save points, plus data control statements like grant and revoke.
Learn how to apply constraints in SQL tables, including unique constraints on roll numbers to prevent duplicates, not null to require values, and check constraints to enforce age ranges.
Master the update statement to modify specific rows using set and where with a condition, and avoid updating all rows in a table.
Learn how to use the having clause to apply aggregate functions in SQL queries, unlike where which disallows aggregates, as illustrated by selecting students with the maximum score.
Explore right join in SQL, which includes all rows from the right table and the matching rows from the left table, with nulls shown where there is no match.
Learn how window functions in SQL use partition by and over to compute per-employee totals from a sales table, applying sum and other aggregates.
Demonstrates SQL window functions with sum and max over partitions to compute item totals, using orders, and shows how partition by order_id avoids duplicates.
Welcome to my course on SQL For Beginners. It is very essential to know and understand the importance and implementation of database systems in the real world. To interact with a lot of DBMS Softwares available out there, SQL becomes the most wanted language. SQL stands for Structured Query Language which interprets the data in forms of tabular structures. This short term course will give you a good understanding on
1. Fundamentals of Relational Database Management Systems.
2. Procedure to write SQL Statements for any given case study.
After completing this course, you'll be able to perform case studies, form the database and write SQL Queries for the same.
The topics that will be covered in this course are:
1. DDL Statements
2. DML Statements
3. Types of Constraints in SQL
4. Datatypes in Oracle SQL
5. Primary, Foreign Keys
6. Select Statement
7. Select Distinct
8. Where clause
9. Group By clause
10. Order By clause
11. Having clause
12. Aggregate functions
13. Different types of joins in SQL - Inner, Left, Right, Full
14. Sub Queries
And so on.
I will follow a step by step procedure in my pedagogy which will greatly gain you the momentum which accelerates your pace to complete this course at the earliest. Furthermore, None of the Technical Interviews will go without SQL. So, The concepts you learn will gain not only the knowledge but also boosts your confidence levels.
[UPDATE - 13th of July, 2025] - Added the Window Functions
[UPDATE - 13th of July, 2025] - Added one query exercise (Interview Question)