MySQL Training and Certification

MySQL course is offered by Technogeeks. Technogeeks is your gateway to IT excellence in Pune. It is a leading Software & IT training institute offering live interactive sessions and hands-on experience.

Anyone looking forward to practical training and real-time projects can join the institute and unleash their IT potential. There are many more courses in Technogeeks.

Course Benefits​:

• No prerequisite
• Course designed for non-IT as well as IT professionals
• Flexible batch switch is available
• Placement assistance in MNC
• Classroom & Online Training – Can switch from online training to classroom training with nominal fee
• Working professional as instructor
• Proof of concept (POC) to demonstrate or self-evaluate the concept or theory taught by the instructor
• 100% placement calls guaranteed till you get placed
• Interview Preparation Support
• Resume Building & Mock Interview
• Evaluation after each Topic completion
• Hands-on Experience with Real-Time Projects

Syllabus:

• Module 01 - Retrieving Data Using the MySQL SELECT Statement
• Module 02 - Restricting and Sorting Data
• Module 03 - Using Single-Row Functions to Customize Output
• Module 04 - Reporting Aggregated Data Using the Group Functions
• Module 05 - Displaying Data from Multiple Tables
• Module 06 - Using Subqueries to Solve Queries
• Module 07 - Using the Set Operators
• Module 08 - Manipulating Data
• Module 09 - Using DDL Statements to Create and Manage Tables
• Module 10 - Creating Other Schema Objects
• Module 11 - Declaring MySQL Variables
• Module 12 - Writing Control Structures – Procedure
• Module 13 - Using Cursors – Procedure
• Module 14 - Handling Exceptions
• Module 15 - Creating Stored Functions
• Module 16 - Creating Stored Procedures
• Module 17 - Creating Triggers