Home Sql Online-mysql-tutorial Online Mysql Training

Related Tutorials


 
 

Share on Google+Share on Google+

Online Mysql Training

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

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.
Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 19, 2009

Related Tutorials

Discuss: Online Mysql Training   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:3
sekhar
February 27, 2012
oracle sql online training

Hi, Could you please let me know the course fee details. Regards, Sekhar
khushbu
June 16, 2012
mysqltraining

hello
Jsg
June 28, 2013
online training my SQL

Please let me know the cost and training method and course details. Thanks Jsg
DMCA.com