SQL
SQL
Course Overview
This course introduces Structured Query Language (SQL) for managing and manipulating relational databases. It covers key concepts like data retrieval, insertion, updating, deletion, and table relationships, enabling learners to interact efficiently with databases.
Objectives
- Understand database concepts and SQL syntax
- Create and manage tables in a relational database
- Retrieve data using SELECT statements with filters and sorting
- Perform data manipulation using INSERT, UPDATE, and DELETE
- Use functions, joins, and subqueries for advanced data operations
- Ensure data integrity using constraints and keys
Trainer Names
- Pavan
- Akhilesh
Course Duration
1-2 months
Course Mode
Online & Offline
Curriculum
1. Introduction to SQL
2. SQL Environment Setup
3. Data Definition Language (DDL)
- 3.1 CREATE Statement
- 3.2 ALTER Statement
- 3.3 DROP Statement
- 3.4 TRUNCATE Statement
- 3.5 Data Types in SQL
4. Data Manipulation Language (DML)
- 4.1 SELECT Statement
- 4.2 INSERT Statement
- 4.3 UPDATE Statement
- 4.4 DELETE Statement
5. Data Querying and Filtering
- 5.1 WHERE Clause
- 5.2 Logical Operators (AND, OR, NOT)
- 5.3 Comparison Operators (=, <>, >, <, etc.)
- 5.4 BETWEEN, IN, LIKE, IS NULL
- 5.5 ORDER BY Clause
- 5.6 LIMIT / TOP Clause
6. Functions in SQL
- 6.1 Aggregate Functions (SUM, COUNT, AVG, MIN, MAX)
- 6.2 Scalar Functions (UCASE, LCASE, LEN, ROUND, NOW)
- 6.3 Date and Time Functions
- 6.4 String Functions
- 6.5 Mathematical Functions
7. Grouping and Aggregation
- 7.1 GROUP BY Clause
- 7.2 HAVING Clause
- 7.3 Combining GROUP BY with Aggregates
8. Joins and Relationships
- 8.1 Introduction to Joins
- 8.2 INNER JOIN
- 8.3 LEFT (OUTER) JOIN
- 8.4 RIGHT (OUTER) JOIN
- 8.5 FULL (OUTER) JOIN
- 8.6 CROSS JOIN
- 8.7 Self Join
- 8.8 Using Aliases with Joins
9. Subqueries and Nested Queries
- 9.1 Subqueries in SELECT
- 9.2 Subqueries in WHERE
- 9.3 Correlated Subqueries
- 9.4 EXISTS and NOT EXISTS
10. Set Operations
- 10.1 UNION and UNION ALL
- 10.2 INTERSECT
- 10.3 EXCEPT / MINUS
11. Views and Indexes
- 11.1 Creating and Using Views
- 11.2 Updating Views
- 11.3 Indexes – Purpose and Types
- 11.4 Creating and Dropping Indexes
12. Transactions and Concurrency
- 12.1 What is a Transaction?
- 12.2 COMMIT and ROLLBACK
- 12.3 SAVEPOINT
- 12.4 ACID Properties
- 12.5 Isolation Levels and Concurrency Control
13. Constraints and Keys
- 13.1 Primary Key
- 13.2 Foreign Key
- 13.3 Unique, Not Null, and Default Constraints
- 13.4 CHECK Constraint
Share This Course
Loved this course? Share it with your friends and network on social media!
