MySQL Database

MySQL Server Programming

Course Duration: 30 hours

MySQL is an open source RDBMS that relies on SQL for processing the data in the database. MySQL provides APIs for the languages C, C++, Eiffel, Java, Perl, PHP and Python.

Installing MySQl

  • General Installation Steps
  • Installing MySQL on Windows
  • Configuring MySQL on Windows
  • Installing MySQL on Macintosh
  • Installing MySQL on Linux
  • Basic Configuration Options
  • Upgrading MySQL

Running MySQl

  • Running MySQL on Linux and Unix
  • Using Mysqladmin
  • Setting the Root User Password
  • Using the Mysql Client
  • Users and Privileges

MySQL administration

  • The MySQL Administrator
  • Backing Up Databases
  • Importing Data
  • MySQL Logging
  • Database Maintenance
  • Improving Performance

MySQL 5 features

  • Stored Routines
  • Using OUT Parameters
  • Triggers
  • Views

Basic SQL

  • Using Values in Queries
  • Inserting Data
  • Selecting Data
  • Using Conditionals
  • Using LIKE and NOT LIKE
  • Performing Joins
  • Sorting Query Results
  • Limiting Query Results
  • Updating Data
  • Deleting Data

Database design

  • Normalization
  • Understanding Keys
  • Understanding Relationships
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Creating a MySQl database

  • MySQL Data Types
  • Extra Column Characteristics
  • Introduction to Indexes
  • Finalizing a Table's Design
  • Choosing a Storage Engine
  • Character Sets and Collations
  • Creating Databases
  • Creating Tables
  • Modifying Tables