MySQL is an open-source relational database management system. MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often MySQL is used with other programs to implement applications that need relational database capability.
Introduction to MySQL as an open source Database
- List the advantages of MySQL over other RDBMA
- Differentiate MySQL with other RDBMS.
- List the advantage of PHP in MySQL.
Installing and Configuring MySQL
- Evaluate various distributing options to MySQL.
- Install MySQL on Windows Platform
- Install MySQL on Linux platform
- Configuring MySQL using scripts
- Initializing MySQL at the startup
- Install MySQL
- Configure MySQL using customization scripts
Using MySQL
- Create a database
- Explain a data type
- Identify the different types of data
- Create a table
- Explain the use of Normalization
- Identify the different forms of Normalization
- Explain the concepts of Indexes and Referential Integrity
Implementing the SQL queries using MySQL-1
- View and alter the database
- Retrieve data from a table
- Modify the table definitions
- Delete table definitions
- Modify the database
- Use Select command
- Use Select command with WHERE clause
- Modify the table structure
- Drop the table
Implementing the SQL queries using MySQL-II
- Work with Keys
- Work with Indexes
- Manipulate tables
- Manipulate tables with INSERT, MANIPULATE, UPDATE and DELETE
- Using Order BY
- Using the Group By Command
Using Joins
- Know the basic concepts and reason behind joining tables
- Use Equi-join
- Use Outer- join
- Use self-join
- Use multiple Select queries in a single Select query
- Use UNION with the query
Using Basic Functions in MySQL
- Use GROUP BY and HAVING clause in MySQL queries
- Use the Mathematical functions
- Use the date functions
- Use String information function
- Use the system information functions
Controlling and Managing MySQL database
- Create User Account
- Allocate appropriate privileges to users
- Alter privileges
- Using GRANT command to assign privileges to user
- Using REVOKE command to alter privileges granted to users
