Course Title                 : -    My SQL for Beginners

 

Course Duration       :-     4 Day

 

 

Objective                          :-    This course aims to provide basic knowledge of

                                            MySQL and trains to work with MySQL

Course Content         :-      

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                                                    

 

 

 

 

 

 

 

 

 

Expectations            :-   On completion of this course the participants will be

  able to install MySQL on a computer and create and

                                        use databases in MySQL         

 

 

Mode of Training          Theoretical sessions followed by hands on training

 

 

CETTM

MTNL

(A Govt. of India Enterprise)

Centre for Excellence in Telecom Technology and Management

[A Govt. of India Enterprise]

[An ISO 9001:2000 Certified Institution]

Introduction to My SQL

Installation: In Windows (OS)  and Linux

Designing Database,

Data Type

Create Database,

Create Table

Inserting Data

Indexing

Altering existing Table

Modifying existing fields,

deleting fields, deleting records

with filter condition,

 deleting tables with records,

 updating fields,

Data Loading etc

Query; Select with where clause, group by clause,

             In clause, Lpad functions, soundex function,

             substring functions, Numerical functions

             Managing user privileges and Lab sessions