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

Batch Date: Dec 19th @8:00PM

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

Duration : 30 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

• Index of SQL w/r Data Analysis
  
  
• Introduction to Databases, SQL
• Creation of simple Databases & Tables
• Data Types
• INSERT
• UPDATE
• DELETE
• DROP
• Truncate, Keys
• SELECT
• WHERE
• Constraints
• ALTER
• Range & Membership operators
• DISTINCT & LIMIT
• Wildcards
  
  
• Functions :
• String Functions
• Numeric Functions
• Temporal Functions
• Date Functions
  
  
• JOINS :
• Inner
• Left, Right
• Outer
• Self join
• cross join
• Natural Joins
  
  
• Regular Expression
• GROUP BY
• Aggregation
• Generating Groups
  
  
• Sub Queries:
  
  
• Non correlated
• Correlated
  
  
• Normalizations
• Normal Forms (1NF,2NF,3NF)
• ER Diagrams
• Denormalization
  
  
• Conditional Logic
• Common Table Expressions(CTE)
  
  
• Recursive CTE
• Views
• Temporary Tables
• Indexing
• Stored Procedures
  
  
• Live project on Instagram Database