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

Batch Date: Sept 25th @7: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
• SQL Commands
• DDL
• DML
• DCL
• TCL
• DQL
• Integrity Constraints
• SELECT
• WHERE Clause
  
  
• Introduction and Explanation of Live Project - Movies Database
  
  
• Order by Clause
• SQL basic operators
• Range operator
• Membership operator
• DISTINCT
• LIMIT
• Wildcards
  
  
• Functions :
• Numerical Functions
• Character Functions
• Date Functions
  
  
• JOINS :
• Inner
• Left, Right
• Outer
• Self-join
• Cross Join
• Natural joins
  
  
• Regular Expression
• GROUP BY
• HAVING
• Aggregation
  
  
• Sub Queries:
• Correlated
• Non correlated
  
  
• Normalizations
• Normal Forms (1NF, 2NF, 3NF)
• ER Diagrams
• Denormalization
  
  
• Views
• Index
• Temporary Tables
• Stored Procedure
• Interview Questions