Lessons

1. What is a Database

   6 mins

   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.
2. MySQL overview

   4 mins

   Learning Objectives: This chapter we re going to focus on the features of MySQL.
3. Using MySQL Queries

   You can download the source code files by clicking on the button "Download Source"
4. Datatypes in MySQL

   5 mins

   This chapter we will talk about datatypes in MySQL. Any data that is added to the database table has to have a certain datatype.
5. 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 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 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.
   1. Principles and Normalization

      18 mins
   2. Creating Database

      29 mins
6. Installation

   This chapter we will cover Setting up XAMPP, Introduction to phpmyadmin, Setting up MySQL Workbench.
   1. Setting up XAMPP

      6 mins
   2. Introduction to phpmyadmin

      8 mins
7. 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.
   1. Importing data in MySQL database

      2 mins
   2. Show Use and Describe

      3 mins
   3. Select Single Column

      3 mins
   4. Select Multiple Column

      2 mins
   5. DISTINCT and LIMIT

      2 mins
   6. ORDER BY

      4 mins
   7. WHERE and BETWEEN

      2 mins
   8. AND and OR

      3 mins
   9. IN, NOT IN and LIKE

      4 mins
   10. AND (&&) and OR (||) again

       3 mins
   11. Regular Expressions

       6 mins
   12. String Functions

       3 mins
   13. Aggregate Functions

       4 mins
   14. GROUP BY

       4 mins
   15. SUB Queries

       4 mins
   16. JOINS

       10 mins
   17. Full Text

       2 mins
   18. INSERT INTO

       5 mins
   19. UPDATE and DELETE

       1 mins
   20. ALTER, RENAME and DROP

       2 mins
   21. VIEWS

       5 mins
   22. Concat and Count

       2 mins
   23. Using the IN clause

       2 mins
   24. Math and SubQueries

       3 mins
   25. Using Group By

       2 mins
8. Database Structure

   5 mins

   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.
9. Managing Users and Privileges

   38 mins

   This chapter covers the details of how to create and manage users in MySQL database, understanding users and privileges.
10. MySQL Performance Management

    33 mins

    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.
11. Backing up and Restoring Database

    44 mins

    This chapter covers the details of creating a backup and restoring the data from the database with the help of SQL queries.