Course

In Pune

Price on request

Description

  • Type

    Course

  • Location

    Pune

  • Class hours

    70h

Facilities

Location

Start date

Pune (Mahārāshtra)
See map
D66, 6th Floor, Rahul Complex, Near Krishna Hospital Paud Road, Kothrud, 411029

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

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

Price on request