Open / Close contact form

Aptech Computer Training Dubai & Sharjah
X

Enquire Now

MySQL

MySQL is an open-source relational database management system. Many of the world’s largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business critical systems and packaged software. MySQL is an open-source relational database management system. Many of the world’s largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, businesscritical systems and packaged software.

Learn Adobe Photoshop
MySQL Course Overview

Overview

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

Other related courses