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 which 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 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 upon 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 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 a 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 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.
Certification requires you to complete all the lectures, quizzes, and the final test. Your certificate will be generated online after successful completion of course.
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.
- 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