MySQL Fundamentals Ed2

COURSE TOPICS

Module 1 : Installing MySQL

• Objectives
• Introduction to MySQL
• Practice 1-1: Accessing MySQL Resources Online
• Practice 1-2: Accessing the Course Environment
• MySQL Server and Client
• Practice 2-1: Installing and Starting the MySQL Server
• Practice 2-2: Using the Keyboard Editing and tee Commands
• Practice 2-3: Creating a Server Connection by Using MySQL Workbench
• Practice 2-4: Creating the world Database
• Database Basics
• Practice 3-1: Quiz on Database Basics
• Practice 3-2: Identifying the Structure of a Table
• Installing MySQL

Module 2 : Designing and Creating MySQL Databases

• Designing Your Database
• Practice 4-1: Quiz on Database Design
• Practice 4-2: Evaluating an Existing Database
• Practice 4-3: Creating a Structure Diagram of an Existing Database
• Practice 4-4 Optional: Creating a Data Model from an Existing Database by Using MySQL Workbench
• Practice 4-5: Granting Permissions to an Application User
• Practice 4-6: Designing a New Database
• Practice 4-7: Optional: Creating a Model for a New Database by Using MySQL Workbench
• Data Types
• Practice 5-1: Quiz on Data Types
• Practice 5-2: Explaining the Use of Data Types
• Practice 5-3: Selecting Data Types for a New Database
• Practice 5-4: Optional: Modifying the Data Types in a Database Model by Using MySQL Workbench
• Creating Databases and Tables
• Practice 6-1: Displaying Table Creation Information
• Practice 6-2: Creating a Database
• Modifying Databases and Tables
• Practice 7-1: Removing a Database
• Practice 7-2: Creating a New Table and Removing a Table
• Practice 7-3: Altering Table Columns
• Practice 7-4: Creating, Modifying, and Removing a Table
• Designing and Creating MySQL Databases

Module 3 : Querying and Modifying Data

• Querying Using SELECT Statement
• Querying Using CREATE Statement
• Practice 8-1: Performing Basic Queries
• Practice 8-2: Importing a Delimited File
• Practice 8-3: Performing Basic Queries on Imported Data
• Practice 8-4: Performing Basic Queries from an Application
• Practice 8-5: Exporting Table Data
• Modifying Table Data
• Exporting and Importing Data
• Practice 9-1: Inserting and Replacing Data
• Practice 9-2: Modifying and Deleting Data
• Practice 9-3: Adding and Modifying Data
• Practice 9-4: Modifying Data in an Application
• Practice 9-5: Exporting a Script
• Functions
• Numeric and Aggregate Functions
• Practice 10-1: Quiz on Functions
• Practice 10-2: Using Built-In, String, and Date and Time Functions
• Practice 10-3: Using Numeric Functions
• Practice 10-4: Using Aggregate Functions
• Joining Tables
• Practice 11-1: Joins in Queries for Cities, Countries, and Languages
• Practice 11-2: Joins in Queries for Pets, Owners, and Types
• Practice 11-3: Querying by Using Unions
• Conclusion
• Querying and Modifying Data