Infoschool

Introduction to MySql Training

MySql Training Overview

The MySQL training course targets new or existing users of MySQL with some experience with relational database management systems. The MySQL course covers several essential elements of MySQL and general database theories.

MySql Training Class Goals

Understand the basics of Relational Databases.
Use various Data types and database design.
Learn the features and benefits of MySQL.
Discover a database design structure/content.
Retrieve database information using the SELECT statements.
Troubleshoot typical warnings and errors.
Delete or modify database and its objects.
Be able to delete or modify table row data
Use of Simple Functions (String, Date, Numerical).
Understand the primary methods for exporting and importing data.
Understand various MySQL storage engines and their features.
Extensive coverage of MySQL Functions and expressions.
Use expressions in SQL statements for more functional and flexible retrieval.
Learn bulk data import and export operations.
Understand MySQL storage engines, transactions and features of the common engines.
Create views to reuse SELECT statements

MySQL Courseware

MySQL Programs and Executables
- MySQL Programs and Executables
- Common Options to Commands
- Specifying Options
- Options on the Command Line
- my_print_defaults: Display options from files
- perror: Explain Error Codes
User Interfaces MySQL
- Overview of User Interfaces
- Establishing a Connection
- MySQL Query Browser
- MySQL Administrator
- MySQL Migration Toolkit
- phpMyAdmin
MySQL Monitor
- Using MySQL Monitor (SQL Command Interpreter)
- Some Useful Options
- Formatting and Output Options
- Commands for Interactive Mode
- Executing a Script from the Monitor
- Using the mysql Command to run a Script
- See Database Status
Designing Databases
- Relational Database Concepts
- Tables and Rows
- Datatypes
- Primary Keys
- Foreign Keys
- Valid Object References
- SQL Statements
- Database Normalization
- Relationships
Creating Databases and Components
- Creating Databases
- Creating Tables
- Altering Existing Table Structures
- Deleting Databases
- Dropping Tables
- Add a column
- Creating Column Definitions
- Data Types in MySQL
- Constraints
- UNIQUE Constraint
- Defining Default Values
- Managing Indexes
- CREATE INDEX Statement
- Full-Text Indexes
Identifiers in MySQL
- Identifiers in MySQL
- Schema Object Names
- Some Restrictions
- Identifier Qualifierss
- Mapping of Identifiers to Filenames
- Identifier Case Sensitivity
- Some Restrictions
- Some Restrictions
Show Database Information
- SHOW and DESCRIBE Statements
- INFORMATION_SCHEMA Tables
- Example
MySQL Table Types
- MySQL Table Types (Storage Engines)
- Setting/Changing Engine
- MyISAM Tables
- InnoDB Tables
- FOREIGN KEY Constraints in InnoDB
- Choosing - MyISAM or InnoDB?
- HEAP or MEMORY Tables
- Temporary Tables
- MERGE Tables

Email:

Join this course now

E-Mail:*	Enter correct e-post adress Enter e-post adress
Password:*	Enter Password
	register

Contact counselors

Training @ infoschool

Success stories

I got the opportunity of getting a practical experience on SAS couse from InfoSchool. It helped me in learning new analytical tools and their applications, today I am in my dream job. Thanks to InfoSchool for giving this opportunity.

By Vidya,
SAS Developer, PowerSoft Technologies,