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 DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save