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

Batch Date: Sept 16th @6:00AM

Faculty: Mr. Suresh

Duration : 35 Days

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202, IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.

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

Syllabus:

MYSQL

DBMS:

• Concepts of DBMS

• Introduction
• Importance and Need

Introduction to RDBMS:

• Concepts of RDBMS

• Introduction
• Comparison with DBMS

Introduction to MySQL

Structured Query Language

• Introduction to SQL
• Predefined Data Types
• Introduction to database Objects
• Table

Commands in SQL

• Data definition language (DDL)
• Data manipulation language (DML)
• Transaction control language (TCL)

Working with DRL

• Operators

• Arithmetical
• Logical
• Assignment
• SQL Operators
• Set Operators

• Functions

• Date
• Number
• Character
• Group by ,Having clause
• Aggregate Functions
• Order By

• Integrity Constraint

• Different Types of Integrity Constraint
• Use of Integrity constraint in table

• Joins

• Usage of joins
• Different Types of joins
  • Inner join, left ,right and cross join
  • Outer join

• Sub queries

• Need of sub queries
• Simple sub queries
• Co-related sub quires

• Views

• Importance of views
• Creating, Drop views

• Working with database objects

• Index

• Distinct
• Ifnull (Convert null to Zero)
• Limit
• Coalesce
• Derived Table
• Locks
• Using Temp Tables
• CTE

Programs:

• Introduction to Programs
• Advantages of Programs
• Variable and constants
• Conditional statements
• Cursors
• Introduction to Triggers
• Before and after, instead of triggers
• Stored Procedures
• User Defined Functions
• Dropping triggers, procedures, functions