ARIEL TECHNOLOGIES INDIA PVT LTD

IT TRAINING & DEVELOPMENT

mysql server training content

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

Backup, Restore, Recovery

  • Differences between logical and physical backups
  • Key figures of Backup/Restore and derived Backup strategies
  • Export and import of data
  • Logical backup with mysqldump

 

Database Performance

  • Performance, what does it mean?
  • Critical resources
  • Measure
  • Influence on performance

Application

  • Schema Tuning
  • Indexing
  • SQL Query Tuning
  • Tools: Slow Query Log, MySQL Profile, General Query Log, etc.
  • Parallelizing

Architecture

  • What is Database Scaling & Sharding.