Learn database concepts, RDBMS principles, and SQL basics.
- What are databases
- Relational database concepts
- RDBMS vs NoSQL
- Database terminology
- ACID properties
- Database design principles
- SQL introduction
- Popular database systems
Create tables and understand SQL data types and constraints.
- CREATE TABLE syntax
- Common data types
- Primary keys
- Foreign keys
- Constraints (NOT NULL, UNIQUE)
- Auto-increment fields
- Default values
- Table modification (ALTER)
Master fundamental SQL query operations and data retrieval.
- SELECT statements
- WHERE clauses
- Comparison operators
- Logical operators (AND, OR, NOT)
- LIKE and wildcards
- IN and BETWEEN
- NULL handling
- ORDER BY and LIMIT
Insert, update, and delete data with DML operations.
- INSERT statements
- INSERT multiple rows
- UPDATE operations
- Conditional updates
- DELETE operations
- TRUNCATE vs DELETE
- Batch operations
- Data validation
Connect tables with joins and understand table relationships.
- Table relationships
- INNER JOIN
- LEFT/RIGHT JOIN
- FULL OUTER JOIN
- CROSS JOIN
- Self joins
- Multiple table joins
- Join performance
Use aggregate functions and GROUP BY for data analysis.
- COUNT function
- SUM and AVG
- MIN and MAX
- GROUP BY clauses
- HAVING clauses
- Multiple grouping
- Aggregate with joins
- Window functions intro
Write complex queries with subqueries and advanced techniques.
- Subqueries
- Correlated subqueries
- EXISTS operator
- UNION operations
- Common Table Expressions (CTE)
- Window functions
- CASE statements
- Query optimization
Optimize database performance with indexes and query tuning.