ProgramGuru

DS DSA Python Java MongoDB SQL NumPy UML

SQL Course

Basics of SQL

Basics of SQL8

❯

1Introduction to SQL
2Installing SQL and SQL Tools
3SQL Syntax and Statements
4SQL Data Types
5SQL CREATE TABLE Statement
6SQL INSERT INTO Statement
7SQL UPDATE Statement
8SQL DELETE Statement

Querying Data10

❯

1SQL SELECT Statement
2SQL WHERE Clause
3SQL ORDER BY Clause
4SQL GROUP BY Clause
5SQL HAVING Clause
6SQL LIMIT / TOP Clause
7SQL DISTINCT Keyword
8SQL Operators
9SQL Aliases
10SQL CASE Statement

SQL Joins

SQL Joins6

❯

1SQL INNER JOIN
2SQL LEFT JOIN
3SQL RIGHT JOIN
4SQL FULL OUTER JOIN
5SQL SELF JOIN
6SQL CROSS JOIN

Intermediate SQL

Intermediate SQL6

❯

1SQL Subqueries
2SQL Views
3SQL Indexes
4SQL Constraints
5SQL Functions
6SQL NULL Handling – IS NULL, COALESCE, IFNULL

Advanced SQL

Advanced SQL7

❯

1SQL Stored Procedures
2SQL User Defined Functions (UDF)
3SQL Triggers
4SQL Transactions
5SQL Cursors
6SQL Error Handling
7Dynamic SQL

Database Design

Database Design5

❯

1SQL Database Normalization
2SQL Denormalization
3ER Diagrams and Schema Design
4SQL Primary Key vs Unique Key
5SQL Foreign Keys and Relationships

Optimization

Optimization3

❯

1SQL Performance Tuning
2SQL Execution Plans
3Index Optimization in SQL

Security

Security2

❯

1SQL Injection and Security
2SQL User Management and Permissions

Advanced Querying

Advanced Querying4

❯

1SQL Common Table Expressions
2SQL Window Functions
3SQL Pivot and Unpivot
4SQL Recursive Queries

Integrations

Integrations4

❯

1SQL with Python
2SQL with Java
3SQL with Excel
4Connecting to SQL Databases via JDBC/ODBC

My Bookmarks
❯

Follow Our YouTube Channel

Explore beginner-friendly tutorials on DSA, Programming, Linux, Java, and more.

Subscribe on YouTube

Welcome to ProgramGuru

Sign up to start your journey with us

Sign in with Google

Interviews

DSA Mock Interviews Java Interview QA

Courses

Linux Machine Learning - I Apache Spark System Design

Web

Databases

Languages

Programming Basics Java JavaScript Python

Python Libraries

Resources

Sitemap Privacy Policy Terms and Conditions

© copyright 2025 - programguru.org

Player Settings

Speed: 2sShow Pseudocode Show Output