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