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 and engineering or data science.
Teachers/Faculties: All computer science and engineering teachers/faculties.
Professionals: All working professionals from computer science / IT / Data Science 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 Databases. 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
1. During the program, the participants will have to take all the assignments given to them for better learning.
2. At the end of the program, a final assessment will be conducted.
1. All successful participants will be provided with a certificate of completion (except for demo courses).
2. Students who do not complete the course / leave it midway will not be awarded any certificate.
Topics to be covered
- What is a Database
This chapter we will talk about what a database actually is. When people talk about a database, they mean many things. So we will define what a database really is.
- MySQL overview
Learning Objectives: This chapter we re going to focus on the features of MySQL.
This is only a demo course. The full course can be bought here
- Using MySQL Queries
You can download the source code files by clicking on the button "Download Source"
- Datatypes in MySQL
This chapter we will talk about datatypes in MySQL. Any data that is added to the database table has to have a certain datatype.
- Designing Databases Using MySQL
This chapter covers the introduction to MySQL. MySQL is a very popular and robust relational database management system. This database is most widely used in big and small businesses. MySQL was developed by a Swedish company named MYSQL AB. You’ll also learn about the concepts of the database, a database is an organized collection of data and information which can be easily accessed and maintained. The chapter also covers the details of datatypes in MySQL. A datatype is defined as the type of data in which a variable can hold. In MySQL, the datatypes can be numeric, strings, date and time, bit, Boolean and enumeration. Apart from this the chapter also attempts to cover the installation instructions of MySQL including XAMPP configuring and setting up of MySQL workbench, PHPMYADMIN, normalization and principles.
- Principles and Normalization
- Creating Database
This chapter we will cover Setting up XAMPP, Introduction to phpmyadmin, Setting up MySQL Workbench.
- Setting up XAMPP
- Introduction to phpmyadmin
- SQL Queries
This chapter covers the details of SQL Joins. A SQL Join clause combines the columns from two or more tables in a relational database. This creates a set which can be used as a table or as it is. There are various types of joins in MySQL, such as Inner Join, Left Join, Right Join, Full Join, Self-Join etc. The chapter also includes the aggregate functions which are there in MySQL.
- Show Use and Describe
- Importing data in MySQL database
- Select Single Column
- Select Multiple Column
- DISTINCT and LIMIT
- ORDER BY
- WHERE and BETWEEN
- AND and OR
- IN, NOT IN and LIKE
- AND (&&) and OR (||) again
- Regular Expressions
- String Functions
- Aggregate Functions
- GROUP BY
- SUB Queries
- Full Text
- INSERT INTO
- UPDATE and DELETE
- ALTER, RENAME and DROP
- Concat and Count
- Using the IN clause
- Math and SubQueries
- Using Group By
- Database Structure
The chapter covers the details of the database structure which includes some important terms such as Applications, End user, Data Definition Language, DDL compiler, DML Compiler, Query Optimizer, Stored data manager, Data files, Compiled DML and Data Dictionary.
- Managing Users and Privileges
This chapter covers the details of how to create and manage users in MySQL database, understanding users and privileges.
- MySQL Performance Management
This Chapter we will learn about the performance related issues in MySQL. We will learn about monitoring the server and the system variables and viewing the logs. Then we will learn about performance tuning and denormalization.
- Backing up and Restoring Database
This chapter covers the details of creating a backup and restoring the data from the database with the help of SQL queries.
- MySQL-Final Quiz