Learn Mysql in Depth

1
Learn Mysql in Depth

• With Continued Learning

2
What is MYSQL?

• MySQL is the world's most popular open source
  database. Whether you are a fast growing web
  property, technology ISV or large enterprise,
  MySQL can cost-effectively help you deliver high
  performance, scalable database applications.
  MySQL Community Edition is the freely
  downloadable version of the world's most popular
  open source database.

3

• Continued Learning realized the potential and
  need for a specialized course in MySQL and came
  out with a MySQL training program. There are many
  out there who claim to know MySQL however are
  fundamentally very weak. Our MySQL Training will
  empower those who year to be extremely good with
  MySQL Database and go on to write complex stored
  procedures to simplify their database management
  jobs.

4
Syllabus

• INTRODUCTION
• INSTALLATION
• ADMINISTRATION.
• PHP SYNTAX
• CONNECTION
• CREATE DATABASE
• DROP DATABASE
• SELECT DATABASE
• DATA TYPES

5
Syllabus

• CREATE TABLES
• DROP TABLES
• INSERT QUERY
• SELECT QUERY
• WHERE CLAUSE
• UPDATE QUERY
• DELETE QUERY
• LIKE CLAUSE
• SORTING RESULTS
• USING JOIN

6
Syllabus

• NULL VALUES
• REGEXPS
• TRANSACTIONS
• ALTER COMMAND
• INDEXES
• TEMPORARY TABLES
• CLONE TABLES
• DATABASE INFO
• USING SEQUENCES
• HANDLING DUPLICATES

7
Pre-requisites

• Practically anyone who wants to make a career
  in computing can learn MySQL databases. It would
  be an added plus if you have
• Good command over English language
• Basic Computing knowledge

8
Benefits

• Today knowing MySql is of essence for any Web
  developer. Especially there is a tremendous need
  for developers with good database understanding.
  This MySQL training is for those who want to lift
  up their career and make their applications run
  smoothly by effective usage of advanced MySQL
  tips and tricks.

9
Contact Us

• Address 9, Ketki Building, Sadashiv Peth, L B
  Shastri Road, Behind Alka Talkies, Sadashiv Peth,
  Pune, Maharashtra 411030
• Phone [phone]
• Email info_at_continued-learning.com
• www.continued-learning.com