Introduction to MySQL

By the end of the course, delegates will be able to: * Outline the structure of a MySQL database * Use the MySQL Client Program and other interfaces * Create a MySQL database * Write SQL statements to select data from a MySQL database * Use joins, subqueries, grouping and aggregate functions * Use SQL expressions and basic functions * Insert, update, delete and replace data * Create and alter tables, indexes and views * Use various data types and constraints * Understand how privileges are controlled * Understand the principles of transactions * Export and Import data Course content

• Client/Server Concepts
• Relational Database Principles
• The MySQL Client Program
• Other MySQL Interfaces
• Data Types * Creating Databases
• The BasicSELECTStatement
• Selecting Data from Multiple Tables usingJOIN
• Grouping and Sorting Output
• Sub-queries
• String, Temporal and Numeric Functions
• Creating, Altering and Dropping Tables
• Creating, Altering and Dropping Views
• Primary and Foreign Key Constraints
• Creating and Dropping Indexes
• Inserting, Updating and Deleting Data
• Transactions
• Controlling Access
• Exporting and Importing Data