MySQL Fundamentals Ed2
The MySQL Fundamentals training is the first step in mastering MySQL, the world’s most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.In this course, you will be introduced to the MySQL Cloud Service.
STUDENTS WILL LEARN TO
- Explain the relational database model.
- Describe the features and benefits of MySQL.
- Install and configure the MySQL server and clients.
- Design efficient databases.
- Use Structured Query Language (SQL) to build your database and query data.
- Employ appropriate MySQL tools.
- Gain an understanding on the MySQL Cloud Service.

Phone
|
Phone
|
---|---|
Product
|
Oracle
|
Code
|
D90871GC20
|
Duration
|
4 Days
|
Price (baht)
|
49,000
|
About the course
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
Register for Training
Schedule
Start Date | End Date | Duration (days) | Price | Register | Course | Code | Product |
---|