• Educate
  • Inspire
  • Transform
080 - 41226000 / 01 / 02 / 03
Feedback
Home > Courses >Advanced PHP
Skeleton of the Advanced PHP Course Share/Bookmark

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.
  • • Learn the features and benefits of MySQL.
  • • Use various Data types and database design.
  • • Discover a database design structure/content.
  • • Retrieve database information using the SELECT statements.
  • • Delete or modify database and its objects.
  • • Troubleshoot typical warnings and errors.
  • • 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.
  • • Create views to reuse SELECT statements
MySQL Courseware
  • 1. MySQL Programs and Executables
    • 1. MySQL Programs and Executables
    • 2. Common Options to Commands
    • 3. Specifying Options
    • 4. Options on the Command Line
    • 5. my_print_defaults: Display options from files
    • 6. perror: Explain Error Codes
  • 2. User Interfaces MySQL
    • 1. Overview of User Interfaces
    • 2. Establishing a Connection
    • 3. MySQL Query Browser
    • 4. MySQL Administrator
    • 5. MySQL Migration Toolkit
    • 6. phpMyAdmin
  • 3. MySQL Monitor
    • 1. Using MySQL Monitor (SQL Command Interpreter)
    • 2. Some Useful Options
    • 3. Formatting and Output Options
    • 4. Commands for Interactive Mode
    • 5. Executing a Script from the Monitor
    • 6. Using the mysql Command to run a Script
    • 7. See Database Status
  • XML RPC
    • XML-RPC Implementations
    • Installing and Configuring PHPXMLRPC
    • XML RPC Data-Types
    • XML RPC Server
    • XML RPC Client
    • XML RPC Request and Response
    • Exploring the XML RPC API
  • 4. Designing Databases
    • 1. Relational Database Concepts
    • 2. Database Design Principles
    • 3. Film Rentals - sakila
    • 4. Basic Modeling Process: Creating a Data Model
    • 5. Database Normalization
  • 5. Creating Databases and Components
    • 1. Creating Databases
    • 2. Creating Tables
    • 3. Creating Column Definitions
    • 4. Data Types in MySQL
    • 5. Constraints
    • 6. Managing Indexes
  • 6. Identifiers in MySQL
    • 1. Identifiers in MySQL
    • 2. Schema Object Names
    • 3. Some Restrictions
    • 4. Identifier Qualifiers
    • 5. Mapping of Identifiers to Filenames
    • 6. Identifier Case Sensitivity
  • 7. MySQL Table Types
    • 1. MySQL Table Types (Storage Engines)
    • 2. Setting/Changing Engine
    • 3. MyISAM Tables
  • 4. InnoDB Tables
    • 5. FOREIGN KEY Constraints in InnoDB
    • 6. Choosing - MyISAM or InnoDB?
    • 7. HEAP or MEMORY Tables
    • 8. Temporary Tables
    • 9. MERGE Tables
    • 10. Other Table Types
    • 11. Table Files Storage
    Ph: +91- 080 - 41226000 / 01 / 02 / 03
    Email:
    Login
    E-Mail:*
    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,
    Copyright 2009 infoschool.in © All right reserved
    Disclaimer | Sitemap | Contact Us