I-PAD logo

MySql Course Structure

Theory, Terminology and Concepts

  • Client/Server Concepts
  • Database and Database Objects

    • Data Definition using SQL

  • Databases
  • Data Types
  • Tables
  • Constraints and Indexes
  • Views

    • Basic Data Manipulation using SQL

  • Recurring SQL Constructs
  • Adding data
  • Modifying data
  • Removing data
  • Searching data

    • Advanced Data Manipulation using SQL

  • Expressions
  • Grouping and Aggregate Functions
  • Joining Tables

    • Transactions

  • Transaction Concepts
  • SQL for working with Transaction

    • Import/Export

  • Tools for Import/Export
  • SQL for Import/Export