- SQL/ MySQL (Database )
- DATABASE MGMT. SYSTEM (DBMS)
- DBMS TERMINOLOGIES
- RELATIONAL DATABASE
- Introduction to SQL/MySQL
- SQL DATA TYPES
- INTEGRITY CONSTRAINTS
- CREATING TABLES BASED ON INTEGRITY CONSTRAINTS
- INSERT, UPDATE, DELETE
- SELECT COMMAND
- WHERE (RETRIEVAL OF SELECTED ROWS)
- WORKING WITH EXPRESSIONS
- CHECKING MULTIPLE CONDITIONS (AND, OR, NOT OPERATOR)
- EXISTS, NOT EXISTS
- BETWEEN, NOT BETWEEN
- ARRANGING RECORD (ORDER BY)
- DISTINCT CLAUSE
- WORKING WITH NULL VALUES
- SQL FUNCTIONS
- AGGREGATE FUNCTIONS
- ARITHMETIC FUNCTIONS
- CHARACTER/STRING FUNCTIONS
- DATE FUNCTIONS
- GROUPING RESULTS (GROUP BY)
- PLACING CONDITIONS ON GROUPS (HAVING CLAUSE)
- TABLE ALIASES
- JOINS
- MULTI-TABLE JOINS
- EQUI JOIN
- CARTESIAN JOIN
- OUTER JOINS
- UNIONS IN SQL
- INDEXES IN SQL