Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

MYSQL Course Details
 

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