Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Nov 25th @9:00PM

Faculty: Mrs. Divya (7+ Yrs of Exp,..)

Duration : 35 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

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