MY SQL

Syllabus

Environment 

  • My sql 8.0

MYSQL – INTRODUCTION

  • What is a Database?
  • RDBMS Terminology
  • MySQL Database

 

MYSQL – INSTALLATION

  • Installing MySQL on Windows
  • Post-installation Steps

 

MYSQL – ADMINISTRATION

  • Running and Shutting down MySQL Server
  • Setting Up a MySQL User Account
  • Administrative MySQL Command

 

MYSQL – CONNECTION

MYSQL – CREATE DATABASE

  • Create Database Using mysqladmin

 

MYSQL – DROP DATABASE

  • Drop a Database using mysqladmin

 

MYSQL – SELECT DATABASE

  • Selecting MySQL Database from the Command Prompt

 

MYSQL – DATATYPES

  • Numeric Data Types
  • Date and Time Types
  • String Types

 

MYSQL – CREATE TABLES

  • Creating Tables from Command Prompt

 

MYSQL – DROP TABLES

  • Dropping Tables from the Command Prompt

 

MYSQL – INSERT QUERY

  • Inserting Data from the Command Prompt

 

MYSQL – SELECT QUERY

  • Fetching Data from a Command Prompt
  • Releasing Memory

 

MYSQL – WHERE CLAUSE

  • Fetching Data from the Command Prompt

 

MYSQL – UPDATE QUERY

  • Updating Data from the Command Prompt

 

MYSQL – DELETE QUERY

  • Deleting Data from the Command Prompt

 

MYSQL – LIKE CLAUSE

  • Using the LIKE clause at the Command Prompt

 

MYSQL – SORTING RESULTS

  • Using ORDER BY clause at the Command Prompt

 

MYSQL – USING JOIN

  • Using Joins at the Command Prompt
  • MySQL LEFT JOIN

 

MYSQL – NULL VALUES

  • Using NULL values at the Command Prompt

 

MYSQL – REGEXPS

MYSQL – TRANSACTIONS

  • Properties of Transactions
  • COMMIT and ROLLBACK
  • Transaction-Safe Table Types in MySQL

 

MYSQL – ALTER COMMAND

  • Dropping, Adding or Repositioning a Column
  • Altering (Changing) a Column Definition or a Name
  • Altering (Changing) a Column’s Default Value
  • Altering (Changing) a Table Type
  • Renaming (Altering) a Table

 

MYSQL – INDEXES

  • Simple and Unique Index
  • ALTER command to add and drop INDEX
  • ALTER Command to add and drop the PRIMARY KEY

 

MYSQL – TEMPORARY TABLES

  • What are Temporary Tables?
  • Dropping Temporary Tables

 

MYSQL – CLONE TABLES

MYSQL – DATABASE INFO

  • Obtaining and Using MySQL Metadata
  • Obtaining the Number of Rows Affected by a Query
  • Listing Tables and Databases

 

MYSQL – USING SEQUENCES

  • Using AUTO_INCREMENT Column
  • Renumbering an Existing Sequence

 

MYSQL – HANDLING DUPLICATES

  • Preventing Duplicates from Occurg in a Table
  • Counting and Identifying Duplicates
  • Eliminating Duplicates from a Query Result
  • Removing Duplicates Using Table Replacement

 

MYSQL – SQL INJECTION

  • Preventing SQL Injection
  • The LIKE Quandary

 

MYSQL – DATABASE EXPORTS

  • Exporting Data with the SELECT … INTO OUTFILE Statement
  • Exporting Tables as Raw Data
  • Copying Tables or Databases to Another Host

 

MYSQL – DATABASE IMPORT

  • Importing Data with LOAD DATA
  • Importing Data with mysqlimport
  • Handling Quotes and Special Characters