About the course
This course helps you in learning MySQL, which is one of the most widely used databases in the industry. In this course, you will learn to deal with databases that are the backbone of any personal or commercial software. This course covers the fundamental concepts of a relational database management system along with the steps to create database and database tables. Then it introduces queries to insert data, update, delete, and fetch the data from the tables. Merging of tables, using aggregate functions, clauses to filter and sort the data, has been covered in detail. The course mainly focuses on the practical approach and expects you to try hands-on with the exercises to get completely proficient in working with.
After completing this course, you will be able to:
- Understand the basic concepts of how a database stores information via tables.
- Understand SQL syntax used with MySQL.
- Learn how to retrieve and manipulate data from one or more tables.
- Learn how to filter data based on multiple conditions.
- Update and insert data into the existing tables.
- Understand how the relationships between tables will affect the SQL.
- Understand the advantages of stored procedures along with storing data using variables and functions.
- Boost your hireability through innovative and independent learning.
- Get a certificate on successful completion of the course.
The course can be taken by:
Students: All students who are pursuing professional graduate/post-graduate courses related to computer science or Information Technology.
Teachers/Faculties: All computer science and engineering teachers/faculties.
Professionals: All IT professionals in the application development domain.
Why learn MySQL?
MySQL provides an implementation of a SQL database very well suited for small to medium web pages. The database is free and open-source with a commercial license available (MySQL is now owned by Oracle after they bought Sun). Common applications for MySQL include PHP and Java-based web applications that require a DB storage backend, e.g. Dokuwiki, Joomla, XWiki, etc. Many applications that use MySQL are geared towards the LAMP stack (Linux, Apache, MySQL, PHP).
MySQL DBA skills are highly sought after in the marketplace. Prospects are bright for candidates with knowledge of Database. A survey of IT managers conducted by Information Week in December 2000 showed that the top two database management execution issues faced by companies are: ease of administration and availability of qualified administrators. So, there is a huge demand for database managers and administrators in the industry. So, it’s worth learning MySQL, if you are looking for a bright career in Database management/database administration.
- 24X7 Access: You can view lectures as per your own convenience.
- Online lectures: 6 hours of online lectures with high-quality videos.
- Hands-on practice: Includes source code files for hands-on practice.
- Updated Quality content: Content is the latest and gets updated regularly to meet the current industry demands.
Test & Evaluation
Each lecture will have a quiz containing a set of multiple-choice questions. Apart from that, there will be a final test based on multiple-choice questions.
Your evaluation will include the overall scores achieved in each lecture quiz and the final test.