Share Description
In this course, you will learn how to:
- Create a well structured database
- Handle a database with pretty good efficiency
- Create a database that can handle itself on most conditions
- Create MySQL queries that are efficient and clear
- Understand the errors as they occur and rectify them
- Administrate the database with ease
- Create SQL queries for database driven applications
- Spot abnormality in database table
- Database structure as needed for good design
- Index tables for better performance
Syllabus :
1. Getting the Development Environment Ready
- Installation of MySQL Database Server in WIndows
- Installation of MySQL Database Server in Ubuntu [Linux]
- Installation MySQL Database Server in MAC OSX
- Introduction to MySQL Console in WIndows
- Introduction to MySQL Console in Ubuntu [Linux]
- Introduction to MySQL Console in MAC OSX
2. Beginning with MySQL Basics
- Creating a Database - CREATE DATABASE
- Creating a Table - CREATE TABLE
- Inserting Values into Table - INSERT INTO
- Retrieving Values from Table - SELECT
- Selecting Distinct Values from Column - DISTINCT
- Selecting a Specific Data using WHERE Clause
- Selecting with Multiple Identifiers Using AND
- Selecting with One of Many Identifiers Using OR
- Sorting the Data Using ORDER BY
- Limiting the Data Retrieved Using LIMIT
- Updating or Modifying Data in a Table Using UPDATE
- Deleting a Data from a Table Using DELETE
- Deleting a Table - DROP TABLE
- Deleting all values in Table - TRUNCATE TABLE
- DESCRIBE TABLE
- Altering Table Structure - ALTER TABLE
3. Time to Jump in for More
- Selecting Data with a Range - BETWEEN
- Creating Alias Name for a Column - AS
- Selecting Data which has one of Multitple Values - IN
- Using LIKE and WILDCARDS
- Copy Table with INSERT INTO SELECT
- Copy a Table Struture - CREATE TABLE LIKE
- Copy Table with Certain Columns - INSERT INTO SELECT
- Combine the Tables - UNION
4. Few things that Keeps the Database in Shape
- Keeping Database in Shape
- PRIMARY KEY
- UNIQUE KEY
- FOREIGN KEY
- NOT NULL
- AUTO_INCREMENT
- DEFAULT
- Sectional Wrap-up
5. Using Joins to Combine Tables
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
