MYSQL

  • Theory, Terminology and Concepts
  • Client/Server Concepts
  • Database and Database Objects
  • Data Definition using SQL
  • Databases
  • Data Type
  • 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
  • SQL for Import/Export
  • Tools for Import/Export