DATABASE CONCEPTS & SQL COURSE CONTENT
1. Database Concepts
- Entities, Relationships & Attributes
- Keys and Functional Dependencies
- Database Design: Methods & Lifecycle
- Normalization – 1NF to 3NF
- ER Diagrams & Real-world Examples
2. Getting Started with SQL
- What is SQL and RDBMS?
- Installing MySQL or SQL Server
- Basic SQL architecture
- Data types & Constraints
- DDL vs DML vs TCL vs DQL
3. Interactive SQL
- CREATE TABLE, SELECT, INSERT, UPDATE, DELETE
- WHERE, ORDER BY, GROUP BY, HAVING
- Alias and Multi-table operations
- LIKE, BETWEEN, IN, IS NULL
4. SQL Joins & Subqueries
- INNER, LEFT, RIGHT, FULL Outer Joins
- Self Join and Cross Join
- Nested and Correlated Subqueries
- Set Operators: UNION, INTERSECT, MINUS
5. Indexes, Views & Transactions
- Creating & Dropping Indexes
- Views: Create, Update, Delete
- Sequences and Cloning Tables
- Transactions: BEGIN, COMMIT, ROLLBACK
6. User Access & Permissions
- GRANT and REVOKE
- Creating Roles
- User Security Best Practices
