My SQL Online Training

MY SQL is one of the most popular RDBMS i.e. Relational Database Management System and is also an integral part of Linux, Apache, MySQL, PHP. More than 5000 companies across the globe has adopt the MySQL to reap the advantages of an open source RDBMS independent platform. My SQL online training offered by RH Soft Tech enables the students to explore the fundamentals and concepts of MySQL features. Aspirants will also learn the basics of MySQL, utility and programming of stored triggers and routines. Students will also learn the methods to perform administrative functions, exploring various API’s exploring the methods to optimization and performance tuning and methods to participate in database design discussions.

Who can learn this course?

Our MySQL online training program is the right fit for the following:

  1. Application and web developers
  2. Software Engineers
  3. Programmers and System Administrators

Course Outline

Section 1 An introduction to MySQL
Chapter 1     An introduction to relational databases and SQL
Chapter 2     How to use MySQL Workbench and other development tools

Section 2 The essential SQL skills
Chapter 3     How to retrieve data from a single table
Chapter 4     How to retrieve data from two or more tables
Chapter 5     How to code summary queries
Chapter 6     How to code subqueries
Chapter 7     How to insert, update, and delete data
Chapter 8     How to work with data types
Chapter 9     How to use functions

Section 3 Database design and implementation
Chapter 10     How to design a database
Chapter 11     How to create databases, tables, and indexes
Chapter 12     How to create views

Section 4 Stored program development
Chapter 13     Language skills for writing stored programs
Chapter 14     How to use transactions and locking
Chapter 15     How to create stored procedures and functions
Chapter 16     How to create triggers and events

Section 5 Database administration
Chapter 17     An introduction to database administration
Chapter 18     How to secure a database
Chapter 19     How to back up and restore a database

 

 

 

Course Duration: 35 – 40 hrs
Timing Week Days: 1 hrs per day (OR) 3 Times a week or Weekends: 3 hrs per day
Method: Instructor led, with exercises.
Breaks: As Required, but limited to 2 of 10 min. In weekend batch
Email ID Info@rhsofttech.com
Study Material  My SQL  Online Training
Phone +91 9356913849
Fees Structure 50% After introduction lectures balance  After 50% Lecture
Server access Throughout the course 24/7
Timings Flexible