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