MySQL Fundamentals

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Nov 14, 202211:0007:00ESTToronto - In Class or by Video Conference4$3,200 USDPurchase


MYSQLFUND

MySQL Fundamentals

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.

Duration: 4 days

Audience

  • Architects
  • Database Administrators
  • Developers
  • End Users

Learning Objectives

  • Describe the features and benefits of MySQL
  • Explain the basics of relational databases
  • Issue MySQL statements from the mysql command-line client
  • Perform database operations by using MySQL Workbench
  • Select appropriate data types for your database
  • Build a database and tables by using SQL
  • Modify the structure of your database
  • Create indexes and keys
  • Add or update database data
  • Query data with SELECT statements
  • Join data from multiple tables
  • Use built-in MySQL functions
  • Retrieve JSON data
  • Backup and restore database data
  • Explain database transactions

Topics

  • MySQL Client and Server
  • Querying Table Data
  • Data Types
  • Functions
  • Joins and Unions
  • Subqueries
  • Creating and Modifying Databases and Tables
  • Modifying Table Data
  • Securing Your Database
  • Backing Up Your Database
  • JSON Data
Right Menu IconMENU