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:
- Application and web developers
- Software Engineers
- 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 |