Course in MySQL

SpymekTech Solutions Pvt. Ltd.
In Pune

Price on request
Compare this course with other similar courses
See all

Important information

  • Course
  • Pune
  • 70 hours of class

Important information

Where and when

Starts Location
On request
D66, 6th Floor, Rahul Complex, Near Krishna Hospital Paud Road, Kothrud, 411029, Maharashtra, India
See map

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

Compare this course with other similar courses
See all