PRO
Earn a certificate & get recognized
Practical SQL Training
Kickstart your journey into data with this SQL course. Learn how to manage and query databases using SQL, the most in-demand language for data analysis and database management.
Earn a certificate with an Academy Pro subscription
Stand out to recruiters
Share on professional channels
Globally recognised
Land your dream job
Course outline
Industry focussed curriculum designed by experts
Introduction to DBMS and SQL
10 items
1.02 hr
- Introduction to DBMS
- Advantages of DBMS
- DBMS Operations
- Introduction to RDMS
- Intro to DB and SQL Introduction
- Intro to DB and SQL Data Understanding
- Intro to DB and SQL Problem Definition
- Getting setup with MySQL MacOS
- Getting setup with MySQL Windows
- Importing File into MySQL Workbench
Basic SQL Queries
9 items
1.01 hr
- Creating Database Structures
- Creating Table Constraints
- Order of Execution in SQL
- Fetching Data Concepts
- Fetching Data Hands on
- Fetching Data in SQL
- Filtering Data Concepts
- Filtering Data Hands on
- Fetching Data in SQL
2 Coding Exercises
- Coding Exercises Filtering and Operators Quiz - Beginner
- Coding Exercises Operators and Pattern Matching Quiz - Beginner
Intermediate SQL Concepts
14 items
2 hr
- Aggregating Data Concepts
- Aggregating Data Hands on
- Joining Data Concepts
- Joining Data Hands on
- Joins in SQL - Handson
- Sub queries
- Subqueries in SQL
- Subqueries in SQL - Hands on
- String Functions in SQL
- Data Functions in SQL
- Numeric Functions in SQL
- Constraints and Alter command in detail
- Basic rules for Foreign Key Constraint
- Foreign Key Constraint
4 Coding Exercises
- Coding Exercises Aggregate Functions Quiz - Beginner
- Coding Exercises Joins SQL Quiz - Beginner
- Coding Exercises Advance SQL Quiz - Beginner
- Coding Exercises Advance SQL Quiz - Advance
Database Design
3 items
0.26 hr
- Types of Data Models
- Normalization
- Types of Normalization
Advanced SQL Concepts
6 items
0.47 hr
- Self Joins
- Multiple table Joins
- Transactions and Concurrency
- Window Functions Concepts
- Window Functions in SQL
- Window Functions Hands-on
2 Coding Exercises
- Coding Exercises Window Functions - Beginner
- Coding Exercises Window Functions - Intermediate
Triggers, Views and Stored Procedures
5 items
0.43 hr
- Triggers
- Introduction to View
- Views - Hands on
- With cascaded and with local check option
- Stored Procedures
Practical Applications of SQL
1 item
0.53 hr
- DBMS and SQL - Case Study
Get access to the complete curriculum with your free trial
Start 7-Day Free TrialGuided Projects
Solve real-world projects with a step-by-step guide, starter code templates, and access to model solutions to boost your skills and build a standout resume.
- GUIDED PROJECT 1
- Library Management system
- In this project, you will design a Library Management System to manage books, authors, library members and book loans. The system will allow you to perform operations like adding new books, managing member details, tracking loans and generating reports. You will work with a relational database to efficiently organize and retrieve information about books, authors, members and their loan transactions.
- GUIDED PROJECT 2
- Advanced Reporting System
- In this project, you will develop an Advanced Reporting System that generates complex reports for a company. The system will utilize advanced SQL techniques such as views, window functions, advanced joins, and triggers to provide insights into employee performance, department-wise reports and automatic updates based on data changes. The goal is to create dynamic, real-time reports that improve business decision-making.
Gain skills & build your resume with complete access to guided projects in your free trial
Start 7-Day Free TrialCourse Instructors
Mr. Udit Mehrotra
Data Scientist, Stripe
Vidhya K
Consulting Specialist
Gain work-ready skills with an Academy Pro subscription
Get unlimited access to in-demand courses that get you noticed at work
Subscribe To Pro • $25/MonthShare your certificate online
Share your professional certificate & updated resume on LinkedIn
Learn from the best
Taught by top faculty & industry experts
Learn by doing
Apply skills with guided projects and interactive coding exercises
AI Mock Interviews
30+ Guided Projects
200+ Coding Exercises
Learn with AI
Get AI-powered coding hints & instant doubt resolution
24x7 Doubt resolution
Coding Hints
Application-driven learning to
Become a Skilled Professional with Pro Courses
Gain work-ready skills with guided projects, top faculty and AI tools, all at an affordable price.
 (1).png)
.png)
.jpg)
 (1).jpg)
.png)
.png)
.png)
.png)
.png)
Advance your career with
Top University programs
Gain industry-relevant skills through learning from top faculty, guidance from industry mentors, and hands-on projects.
UNIVERSITY
UNIVERSITY
MIT Professional Education
12 Weeks • Online
UNIVERSITY
UNIVERSITY
UNIVERSITY
McCombs School of Business at The University of Texas at Austin
7 months • Online
UNIVERSITY
McCombs School of Business at The University of Texas at Austin
7 months • Online
UNIVERSITY
McCombs School of Business at The University of Texas at Austin
6 months • Online
UNIVERSITY
