Course in MySQL
Course
In Pune
Description
-
Type
Course
-
Location
Pune
-
Class hours
70h
Facilities
Location
Start date
Start date
Reviews
Course programme
This program demands fundamental knowledge of Database. After this course, students may opt for Microsoft Structured Query Language Server, Oracle 9i/10g, Hypertext Preprocessor
Course Syllabus:
* Conceptions and Structural Design of Client and Server
* MySQL Customer Program in interactive & batch mode
* Connector/J, Connector/Open Database Connectivity and Connector/NET
* Highly Developed Types of Data comprising Bit & Binary
* Database Management
* Tables Management and Usage
* Indexes Management and Usage
* Data Retrieval and Aggregation
* Complex Structured Query Language Expressions & Functions
* Further Operations Inserting, Updating, Deletion, Replacing and Truncating
* Import and Export of Data by using SQL
* Import & Export from Command Lines
* Complex Joins & Sub-queries
* Views Management and Usage
* User Variable Syntax & Properties
* Statements Preparation
* Defining Stored Routines
* Procedures & Functions
* Creation, Dropping & Alteration of Stored Routine
* Stored Routines Invoking
* Trigger Conceptions
* Triggers Creation and Usage
* Opportunities for Stored Routines & Triggers
* Acquiring Database Metadata
Course in MySQL