MYSQL

• Introduction to Databases & SQL
• Limitations of Excel
• Creation of Database and Tables
• MySQL installation
• Datatypes in SQL
• SQL Commands/Sub Languages
• DDL
• DML
• DCL
• TCL
• DQL
• Integrity Constraints
   
• Introduction and Explanation of Live Project - Movies Database / OTT Platform NETFLIX Database
   
• WHERE Clause
• Order by Clause
• SQL Basic operators -
• OR
• AND
• NOT
• Range operator - Between
• Membership operator - IN
• DISTINCT clause
• LIMIT Clause
• LIKE Operator
• Wildcards in Like Operator
   
• Functions:
• Numerical Functions
• Character Functions
• Date Functions
• Aggregate Functions
   
• JOINS:
• Inner
• Left, Right
• Outer
• Self-join
• Cross Join
• Natural joins
   
• Assignment Questions on Joins
   
• Regular Expressions
• Anchors in Regexp
• GROUP BY Clause
• HAVING Clause
• Aggregation – Group By
   
• Subqueries
• Correlated
• Non correlated
   
• Normalizations
• Denormalization
• Normal Forms (1NF, 2NF, 3NF)
• ER Diagrams
• Views
• Index
• Temporary Tables
• CTE
• Stored Procedure
• Window Functions – Rank, Dense Rank, Row Number
• Interview Questions