Course Outline:
DURATION: 2 Days
1. Introduction to RDBMS.
2. Introduction to MySQL.
3. Data Types.
4. Operators.
5. Built-in Functions.
6. Introduction to SQL – DDL, DML and DCL.
7. DDL.
- CREATE SCHEMA.
- CREATE TABLE.
- ALTER TABLE.
- DROP TABLE.
- CONSTRAINTS – PRIMARY & FOREIGN KEY.
8. DML
- SELECT.
9. WHERE
10. GROUP BY
11. HAVING
12. ORDER BY
13. JOIN
- INSERT.
- UPDATE.
- DELETE.
- TRUNCATE.
14. DCL
- GRANT
- REVOKE.
15. Joins.
16. Sub queries.
17. Aggregations.
18. Grouping.
19. Indexing.
20. Database CRUD operations (INSERT, UPDAT, DELETE and SELECT).