Online Mysql Training

SQL is Structured Query Language plays an important role in date manipulation language.

Online Mysql Training

Online Mysql Training

     

Introduction to Mysql

SQL is Structured Query Language plays an important role in date manipulation language. The Online training on Mysql provides the course for the students who want to learn and use SQL to retrieve, store or update date etc in Mysql. The Mysql Online Training provide practical examples, illustration images and detailed explainations. This Online Training will help students by providing weekly assignment and go beyond what they have learned in the class .

Introduction to Mysql Databases

  • Understand the basics of Relational Databases.
  • Mysql Feature and benefits of Mysql.
  • Use Data types and Mysql Database design.
  • Discover a database structure.
  • Retrieve information from database using SELECT statement.
  • Delete or modify the table or row data.
  • Simple Functions (String, Date, Numerical)
  • Understanding the Primary Methods for exporting and importing data.
  • Mysql Troubleshoot on typical warning and errors.
  • Learn bulk import and export data operation.
  • Create Views to reuse SELECT statements.
  • Mysql storage engines, transaction and feature in common engines.

Prerequisite of Mysql Training Online

The Experience in the following areas is required

  • Basic Knowledge of Database concepts.
  • Knowledge of data retrieval using basic SQL queries.
  • Basic experience with command-line programs

Mysql Programs and Execution

  • Command Options to Commands.
  • Specifying Option in Commands
  • Option on the Command Line
  • Display options from file.
  • Explanation to Error Codes
  • Overview on User Interface
  • Connection built in Mysql.

Mysql Query Browser

  • Main Query Windows
  • Keyboard Shortcuts
  • Query Toolbar
  • Advanced Toolbar
  • Result Area
  • SQL Commands using Mouse Clicks
  • Bookmarks and History for SQL Commands
  • Object Browser
  • Script Editor
  • Modify Date in SELECT Results
  • Stored Procedures
  • Information Browser on Mysql

MySQL Monitor

  • SQL Command Interpreter
  • Commands for Interactive Mode
  • Execute a Script from the Mysql Monitor
  • Mysql Command to run a Script
  • Database Status

Mysql Database Design

  • RDBMS
  • Tables
  • Columns
  • Rows
  • Relationship
  • Datatypes
  • Primary Keys
  • Foreign Keys
  • SQL Keywords

Databases Queries

  • Databases and Components create

    • Database Create
    • Database Delete
    • Table Create
    • Table Drop
    • Table Defining
    • Altering Existing Table Structure
    • Add Column Table
    • Rename Tables
       
  • Constraints in Database

    • Not NULL Constraint: Column's Nullability
    • Unique Constraint
    • Primary Key Constraint: Master Key
    • Referential Integrity Constraint: Foreign Key
    • Auto-Increment Columns
    • Defining Default Values
    • Constraint Check on Transaction: Rollback
       
  • Indexes Manage

    • Define Indexes
    • Index Statement Create
    • Delete Indexes
    • Types of Indexes
    • Clustered Index
    • Non-Clustered Index

Database Information

  • a) Show and Describe Statements

    • Table-Related Show Statements
    • Describe Statements
  • b) Schema Tables Information

    • Showing Databases

Mysql Identifier

  • a) Identifier Mysql

    • Identifier Names
    • Double Quotes
    • Quotes within Names
    • Digits
    • Lower_Case_Table_Name Setting
    • Upper_Case_Table_Name Setting.