Call Us Today! +91 99907 48956 | info@analyticstraininghub.com
Menu
MySQL Certification Training
Structured Query Language (SQL) is a grade level computer language for related database management and data manipulation. SQL is mainly used to insert, query, update and modify data. The most related database supports SQL for management and manipulation of data. SQL adds to as a benefit for database administrators, as they support databases across several different platforms.
(6.5K+ Satisfied Learners)
4.6/5
With this skill, you will be able to connect with the humongous amounts of data and will be able to extract, update, create new data on the server.
Most of the companies store their database on the server, they give preference to those candidates who have the knowledge of My SQL.
“My SQL” is the 2nd top application required by the recruiters as per “naukri.com” with high annual salary package.
Instructor-Led Online & Physical Classes
| Batch Start Date | Class Type | Upcoming Slots | Timings | Location |
|---|---|---|---|---|
| 21st Nov 2020 | Classroom | Sold Out SAT & SUN (2.5 WEEKS) | 2:00 PM to 4:00 PM | Faridabad |
| 29th Nov 2020 | Classroom | Filling Fast⚡ SAT & SUN (2.5 WEEKS) weekend batch | 10:30 AM to 12:30 PM | Faridabad |
| 1st Dec 2020 | Online | TUE, WED & THU (1.5 WEEKS) weekday batch | 7:00 AM to 9:00 AM | |
| 27th Dec 2020 | Classroom | SAT & SUN (2.5 WEEKS) weekend batch | 1:00 PM to 3:00 PM | Faridabad |
| 16th Jan 2021 | Classroom | SAT & SUN (2.5 WEEKS) weekend batch | TBD | Faridabad |
| 17th Jan 2021 | Classroom | SAT & SUN (2.5 WEEKS) weekend batch | TBD | Delhi |
Can’t find a batch you were looking for?
COURSE DETAILS
MySQL
- An Introduction and Overview of MySQL
- Installation and GUI Tools
- An Overview
- Introducing SELECT statement
- Introducing WHERE clause
- Sort result with ORDER BY
- Using FROM to specify the source tables
- Importance of Clause Orders
- Data Modification tricks
- Creating a database
- Creating a table
- Creating Indexes
- Controlling column behavior with constraints
- Using foreign key constraints
- Creating an ID column
- Changing a schema with ALTER
- Introducing NULL and NOT_NULL
- Introduction to MySQL Data Types
- Setting up default values
- MySQL Warnings
- Alerting a table
- Introduction to MySQL Functions
- String Functions – CONCAT, SUBSTRING, REPLACE, REVERSE, LENGTH, UPPER, LCASE etc.
- Aggregate Functions – COUNT, MIN, MAX, SUM, AVG, ROUND etc
- Date/Time Functions – CURDATE, CURTIME, CURRENT_DATE, LOCALTIME etc.
- Control Flow Functions – IF, IFNULL, NULLIF etc.
- Introduction to JOINS
- Different types of JOINS
- JOINS and Aliases
- Multiple Table Joins
- Creating a simple Subselect
- Understanding of Primary keys and Foreign keys
- Transactions & Stored Routines
- Triggers
- Creating a New User Login
- Granting access to new users
- Backup and Restore databases
- Important Keyboard Shortcuts Guide
- Session Study Material
- Situational Case Studies for Best Practice and Getting Ready for Corporate World
- 6 Months Live Support via Phone/Email/Messages
Features
Instructor-led Sessions
10 Hours / 5 Sessions / 2.5 Weeks
Per Session for 2 Hours
20 Hours for Assignments
Real-life Case Studies
We have included unlimited real life examples and case studies in our course
Assignments
After completing every session you will get assignments, study material & real life based case studies
100% Job Assistance
You will get 100% Job Assistance from us
Expert Support
We have support team to resolve all your technical queries
Certification
After completing your course, we will provide you certificate of completion.
Student Reviews
Assistant Manager at ITC Limited Read More
"It was exactly what I was looking for. I was looking for a trainer who can help me in understanding the concepts rather than mugging them up. The course structure is good and Anil is always there to clear your doubts. Read More....
Chartered Accountant Read More
"The teaching methodology is very good.The class timings are also flexible. The exercises and case studies given after every session are very helpful in understanding the concepts and using them in real life scenarios. Read More....
Regional Account Manager at Expeditors International Read More
"Excellent stuff. I was amazed to learn the such important techniques which would definitely going to help in my managerial role and the way it was delivered by the trainer, Mr. Anil Dhawan made it more simpler and easy. Read More....
Read More
If you are looking for the best, surely you were seeking for this place. Anil Dhawan Sir is one of the best mentors you would want to be associated with. His experience and relevance with industry is remarkable. Read More....
Read More
Analytics training hub is the best place to learn the excel,VBA SQL etc, Mr. Anil explain every concepts and easy to understand all the concept. In this institute provide the every class case study to learn the concept very good manner. Read More....
Read More
I have enrolled in Excel to Power Bi Course. It is very good experience in here. Brilliant method, case studies and classes to get trained on course. I would highly recommend Analytics training hub. Read More....
Read More
The best Excel and Analytics training centre in town. The practical approach followed by the trainer gives immense clarity on the concepts taught. Read More....
Read More
I have opt for the Excel to Power BI course. I have completed the excel course and learned lot of new features of excel and now I am jumping on VBA. The way Anil Sir teach excel is very helpful in understanding the concepts. Read More....
Read More
Excellent learning experience . I have gone through the excel training and currently in between of VBA training. Session were interactive and based on realtime scenario. Flexible timings which is one of the biggest advantage. Read More....
Read More
Would like to say the best place to learn excel. Anil sir have complete knowledge and he teaches in a very simple and interesting way. The modules are well designed and study material is very helpful. Read More....
Read More
Nice place to nice excel and become expert for the same. Good practice classes they are providing along with good material which is very helpful for the students to grow. Sir and mam both are supportive. Read More....
Read More
Amazing experience. He is an awesome teacher as well as a great personality.He has really helped me catch up well with the basic & understand the concepts properly. Always available to help. Thankx alot!!
I would like to recommend others. Read More....
Read More
Mr.Anil is an amazing teacher. As a fresher, and very new to MS Excel, he has really helped me catch up well with the basics and understand the concepts properly. His patience and understanding is something which is making me more confident. Read More....
Read More
Anil Sir is very patient and humble teacher. He has sound knowledge in the subject he teaches. I have done Ms-Excel course and had a great learning experience from him. Read More....
Read More
It was a great learning experience. Although I am experienced professional but the advance excel course helped me and I learnt many new functions and formulas. Thanks to sir. Read More....
Read More
An excellent place to learn analytics in professional way under the guidance of respectable Mr Anil Dhawan along with Mrs Nisha. They are very supportive and their case studies of every session are very helpful. Read More....
Read More
Anil Sir is a patient and vastly knowledge person. I can’t thank him enough for all the help that he give me, with he’s help I was able to take my work to a next level. Read More....
Read More
Anil Dhawan sir is really experienced and knowledgeable and focuses on each students weakness. A very good learning environment. Analytics Training Hub is highly recommended. Read More....
General Manager at Urban Company Read More
Anil have been a great teacher. His basics are very strong, which is very necessary to understand any concept. Best part are the tutorials and examples which tests the concepts thoroughly and helps apply the learnings well. Read More....
Previous
Next
FAQ's
Structured Query Language (SQL) is a grade level computer language for related database management and data manipulation.
No, prior experience required.
As part of the course, learners will get weekly assignments and module-wise case studies. Once they successfully complete all their assignments, we’d evaluate them, and then the certificate shall be awarded.
We provide 100% job assistance with you in the driving seat!
