MySQL for Beginners

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

Show more