Relational DataBase Management Boot camp

150 Lessons Online Classes

The React JS Learning Roadmap

CONTENT

1. 1. DBMS Introduction
   2. MySQL Introduction
   3. MySQL Workbench Installation
   4. Data Modeling – ER Model Concept
   5. MySQL SQL Introduction
   6. MySQL Create DB
   7. MySQL Drop DB
   8. MySQL Create Table
   9. MySQL Drop Table
   10. MySQL Alter Table
   11. MySQL Constraints
   12. MySQL Not Null
   13. MySQL Unique
   14. MySQL Primary Key
   15. MySQL Foreign Key
   16. MySQL Check
   17. MySQL Default
   18. MySQL Create Index
   19. MySQL Auto Increment
   20. MySQL Dates
   21. MySQL SELECT
   22. MySQL WHERE
   23. MySQL AND, OR, NOT
   24. MySQL ORDER BY
   25. MySQL INSERT INTO
   26. MySQL NULL Values
   27. MySQL UPDATE
   28. MySQL DELETE
   29. MySQL LIMIT
   30. MySQL MIN and MAX
   31. MySQL COUNT, AVG, SUM
   32. MySQL LIKE
   33. MySQL Wildcards
   34. MySQL IN
   35. MySQL BETWEEN
   36. MySQL Aliases
   37. MySQL Joins
   38. MySQL INNER JOIN
   39. MySQL LEFT JOIN
   40. MySQL RIGHT JOIN
   41. MySQL CROSS JOIN
   42. MySQL Self Join
   43. MySQL UNION
   44. MySQL GROUP BY
   45. MySQL HAVING
   46. MySQL EXISTS
   47. MySQL ANY, ALL
   48. MySQL INSERT SELECT
   49. MySQL CASE
   50. MySQL Comments
   51. MySQL Operators
   52. MySQL Data Types
   53. MySQL Functions
   54. Normalization in DBMS
   55. 1NF (First Normal Form)
   56. 2NF (Second Normal Form)
   57. 3NF (Third Normal Form)
   58. Boyce Codd Normal Form (BCNF)
   59. SQL Injection
   60. Final Activities