Mastering SQL: From Basics to Professional Level at just ₹1499
Trained by working IT professionals from leading companies
15 HOUR Mastering SQL COURSE SYLLABUS
SQL (Structured Query Language) is the universal language for managing and interacting with relational databases such as MySQL, MariaDB, MsSQL, Oracle, PostgreSQL, etc. Whether you're a beginner or looking to sharpen your advanced SQL skills, this course takes you on a journey from foundational knowledge to mastering professional-grade database management and analytics. By the end of this course, you’ll be proficient in creating, managing, and querying databases, as well as optimizing performance.
Fee: ₹1499
Training Mode: Instructor-led live class
Duration: 15hrs
Next Batch: Loading...
What you will learn from this course?
- What is SQL?
- History and importance of relational databases
- Introduction to Popular SQL databases
- MySQL Installation
- SQL Operators
- Data Types
- SQL Constraints
- NULL
- NOT NULL
- UNIQUE
- CHECK
- DEFAULT
- PRIMARY KEY
- AUTO_INCREMENT
- FOREIGN KEY
- Introduction to DBMS
- DDL (Data Definition Language)
- DML (Data Manipulation Language)
- DCL (Data Control Language)
- TCL (Transaction Control Language)
- DDL
- CREATE
- ALTER
- TRUNCATE
- RENAME
- DML
- INSERT
- UPDATE
- DELETE
- SELECT
- DCL
- TCL
- SET TRANSACTION ON|OFF or START TRANSACTION
- COMMIT
- ROLLBACK
- SELECT Queries
- Basic Query
- Select All Columns
- LIMIT (Filter Limited Records)
- WHERE Clause (Conditional Search)
- LIKE (String Search)
- BETWEEN AND (Range Search)
- IN() (Array of Values Search)
- ORDER BY (Sorting Search Result)
- GROUP BY (Creating Row Groups)
- SQL Functions
- Aggregate Functions
- HAVING (Conditions on Aggregate Functions)
- Sub Queries
- DISTINCT (Remove Duplicate Rows)
- IF Statement
- CASE Statement
- Join Queries
- Simple Join
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- CROSS JOIN
- UNION
- Data Backup and Restoration
- Minimum 3 Projects
