Complete SQL and Databases Bootcamp
-
By
Krishna Kumar
- 03/Jul/2024
- 1 Students
Course Description
Chapter 1: Introduction to SQL
- What is SQL?
- Database vs. DBMS
- Types of Databases (Relational & Non-Relational)
- SQL vs NoSQL
- Installing MySQL / PostgreSQL
Chapter 2: SQL Database & Table Management
- Creating Databases
- Creating & Modifying Tables
- Data Types in SQL
- Primary Key, Foreign Key & Constraints
Chapter 3: SQL Data Manipulation (DML)
- INSERT, UPDATE, DELETE Commands
- Bulk Insert & Transactions
- Handling NULL Values
Chapter 4: SQL Data Querying (DQL - SELECT)
- Basic SELECT Queries
- WHERE Clause & Filtering Data
- ORDER BY, GROUP BY & HAVING Clauses
- DISTINCT & LIMIT
Chapter 5: SQL Joins & Relationships
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- Self Join & Cross Join
- Subqueries & Nested Queries
Chapter 6: SQL Functions & Aggregations
- COUNT, SUM, AVG, MIN, MAX
- String Functions (UPPER, LOWER, CONCAT, SUBSTRING)
- Date & Time Functions
Chapter 7: Advanced SQL Concepts
- Views & Indexing
- Stored Procedures & Functions
- Triggers & Events
- CTEs & Window Functions
Chapter 8: SQL Performance Optimization
- Query Optimization Techniques
- Indexing Strategies
- Normalization & Denormalization
Chapter 9: SQL Security & Transactions
- ACID Properties
- Transactions & Rollback
- User Privileges & Security
Chapter 10: Real-World Applications & SQL in BI
- SQL for Data Analytics
- SQL in Power BI & Tableau
- Case Studies & Project Work
Course Curriculum
Krishna Kumar
Founder, AICT PVT LTD, IoT & Embedded System Academic Trainer, Data ScientistI am a web developer with a vast array of knowledge in many different front end and back end languages, responsive frameworks, databases, and best code practices
This Course Fee:
₹8500
₹8500
₹10500
Course includes:
-
Level
-
Expert
-
Duration
50h
-
Lessons
0
-
Quizzes
0
-
Certifications
Yes
-
Language
-
English
English