MySQL

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.

• List the advantages of MySQL over other RDBMA
• Differentiate MySQL with other RDBMS.
• List the advantage of PHP in 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

• 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

• 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

• Work with Keys
• Work with Indexes
• Manipulate tables
• Manipulate tables with INSERT, MANIPULATE, UPDATE and DELETE
• Using Order BY
• Using the Group By Command

• 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

• 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

• 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