My SQL

MySQL Introduction
- What is Database?
- RDBMS Terminology
  - Database
  - Table
  - Column
  - Row
  - Redundancy
  - Primary Key
  - Foreign Key
  - Compound Key
  - Index
  - Referential Integrity
- MySQL Database
MySQL Installation
- Installing MySQL on Linux/Unix
- Installing MySQL on Windows
- Verifying MySQL Installation
- Post-Installation Steps
- Running MySQL at Boot Time
MySQL Administration
- Running and Shutting down MySQL Server
- Setting Up a MySQL User Account
- Administrative MySQL Command
  - Use Databasename
  - Show Databases
  - Show Tables
  - Show Columns from tablename
  - Show Index from tablename
  - Show Table Status Like tablename\G
MySQL PHP Syntax
MySQL Connection
- MySQL Connection Using MySQL Binary
- MySQL Using PHP Script
  - mysql_connect()
    - server
    - user
    - passwd
    - new_link
    - client_flags
  - mysql_close()

MySQL Create Database
- Create Database Using mysqladmin
- Create Database Using PHP Script
  - mysql_query()
    - sql
    - connection
Drop MySQL Database
- Drop a Database using mysqladmin
- Drop a Database using PHP
  - mysql_query()
    - sql
    - connection
Selecting MySQL Database
- Selecting MySQL Database from the Command Prompt
- Selecting MySQL Database Using PHP Script
  - mysql_select_db
    - db_name
    - connection
MySQL Data Types
- Numeric Data Types
  - INT
  - TINYINT
  - SMALLINT
  - MEDIUMINT
  - BIGINT
  - FLOAT(M,D)
  - DOUBLE(M,D)
  - DECIMAL(M,D)
- Date and Time Types
  - DATE
  - DATETIME
  - TIMESTAMP
  - TIME
  - YEAR(M)
- String Types
  - CHAR(M)
  - VARCHAR(M)
  - BLOB or TEXT
  - TINYBLOB or TINYTEXT
  - MEDIUMBLOB or MEDIUMTEXT
  - LONGBLOB or LONGTEXT
  - ENUM
Use of Commands in MySQL
- SELECT
- INSERT
- DELETE
- UPDATE
- GROUP BY
How to Query Data Using Where Clause in MySQL
How Sorting is Done by using
- ORDER BY
- DESC
- ASC
How to use the following in MySQL
- Wildcards
- Regular Expressions & Wildcards
- Aggregate Function
- Auto Increment
- Alter, Drop & Rename function
- Limit Keyword
- Sub-Queries
- Join
- Union
- Views
- Index
- Null value & Keyword
Creating an Application using MySQL

This course includes

- With MySQL Database Administration Certifications, you can prove your ability to deliver reliability and performance to current and future employers. Gain in demand skills to scale database applications and integrate your business.

This course includes

- Earning MySQL Developer Certifications allows you to develop query writing techniques for creating reports that support end users. By learning how to create and utilize trees and hierarchical data structures, you'll develop a highly coveted set of skills that will expand your career opportunities.