3 arrows

Winter-Ready Savings Up To $500 Off Training 

closeClose

MySQL for Beginners

The MySQL for Beginners course helps you learn about the world's most popular open source database. Expert Oracle University instructors will teach you how to use the MySQL Server and tools, while...

Read More
$3,200 USD
Course Code D61918GC30
Duration 4 days
Available Formats Classroom
5254 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

The MySQL for Beginners course helps you learn about the world's most popular open source database. Expert Oracle University instructors will teach you how to use the MySQL Server and tools, while helping you develop deeper knowledge of using relational databases.

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.

Benefits to You

This course will teach you everything you need to know to start using the incredibly popular MySQL database in your Web, Cloud and embedded applications. In learning about MySQL, you will develop an understanding of relational databases and how to design a robust and efficient database. You will harness that power by learning SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.

Manage Your MySQL Database

This course also introduces you to more advanced tools and techniques to help you manage your MySQL database and data. At the end of the course, you will be confident in your abilities to use the MySQL database and put your new skills to work.

Skills Gained

  • Explain MySQL storage engines
  • Explain database transactions
  • Obtain database metadata
  • Describe MySQL GUI tools
  • Monitor database performance
  • Perform database backup and recovery
  • Export and import database data
  • Describe the features and benefits of MySQL
  • Explain the basics of relational databases
  • Design an effective database
  • Build a database and tables by using SQL Modify or delete database entities
  • Query data with the SELECT command
  • Join data from multiple tables
  • Perform nested subqueries
  • Use built-in MySQL functions

Who Can Benefit

  • Administrator
  • Architect
  • Database Administrator
  • Developer

Course Details

Topics

  • Introduction
    • Features and Benefits of MySQL
    • MySQL Products and Service
    • Community vs. Enterprise
    • MySQL Certification Program
    • MySQL Certification Program
    • MySQL Website
    • MySQL Architecture
    • Install and Start MySQL
  • Database Basics
    • SQL Language and MySQL
    • Database Design
    • Database Modeling
    • Keys
    • Normalization
    • Data Types
    • What is NULL?
    • Viewing Database Structure
  • Database Creation
    • Create a New Database Structure
    • Creating a Database
    • Creating a Table
  • Basic Queries
    • The SELECT Command
    • MySQL Query Browser
    • Troubleshooting
  • Database Maintenance
    • Delete an Entire Database
    • Maintaining Tables
    • Maintaining Columns
    • Indexes and Constraints
    • Data Manipulation
  • Delete/Modify Table row Data
    • The INSERT Command
    • The REPLACE Command
    • The UPDATE Statement
    • The DELETE Command
  • Functions
    • Simple Functions
    • Grouping With Functions
  • Joining Tables
    • Combining Multiple Tables
    • Inner Joins
    • Outer Joins
  • Exporting/Importing Data
    • Exporting Data
    • Importing Data
  • Sub queries
    • What is a Sub query?
    • Categories of Sub queries
    • Sub query Types
    • Placing Sub queries
    • Other Sub query Uses
    • Other Sub query Uses
  • Supplementary Information
    • Creating VIEWs
    • Transactions
    • Storage Engines
    • Retrieving Metadata
  • Conclusion
    • Course Review
    • Training and Certification Website
    • Course Evaluation
    • Thank You!
    • QA Session
  • Course Goals
  • Course Lesson Map
  • MySQL Overview
  • MySQL Database Server Editions
  • MySQL Products
  • MySQL Services and Support
  • MySQL Resources
  • Example Databases

MySQL Server and Client

  • MySQL Client/Server Model
  • Communication protocols
  • MySQL Connectors
  • The LAMP Stack
  • Installation of the MySQL server
  • MySQL Server and Client Startup
  • Keyboard Editing
  • Session Logging With the tee File

Database Basics

  • Basics of Relational Databases
  • Spreadsheet Versus Database
  • Entities and Relationships
  • Relationship Categories
  • SQL Language and MySQL
  • SQL data definition language
  • SQL data manipulation language

Database Design

  • Database Modeling
  • Structure and Cardinality Diagram (ERD)
  • Keys
  • Normalization
  • Database Design
  • Viewing and Evaluating a Database

Table Data Types

  • Data Types as Part of Database Design
  • Numeric Data Types
  • Temporal Data Types
  • Character String Data Types
  • Character Set and Collation Support
  • Binary String Data Types
  • Data Type Considerations
  • The Meaning of NULL

Database and Table Creation

  • Creating a Database
  • Creating a Table
  • Showing How a Table Was Created
  • Column Options
  • Table Options
  • Table Indexing
  • Table Constraints

Basic Queries

  • The SELECT Statement
  • Troubleshooting
  • SQL Modes for Syntax Checking
  • Common SQL Modes
  • MySQL Workbench for SQL Development

Database and Table Maintenance

  • Deleting databases and tables
  • Creating a new table using an existing table
  • Confirming the creation of a new table
  • Copying an existing table structure
  • Creating a temporary table
  • Adding, removing and modifying table columns
  • Adding, removing and modifying indexes and constraints

Table Data Manipulation

  • Manipulating Table Row Data
  • The INSERT Statement
  • The REPLACE Statement
  • The UPDATE Statement
  • The DELETE Statement

Functions

  • Functions in MySQL Expressions
  • Using Functions
  • String Functions
  • Temporal Functions
  • Numeric Functions
  • Control Flow Functions
  • Aggregate Functions
  • Spaces in Function Names

Exporting and Importing Data

  • Exporting with a Query
  • Exporting with a MySQL Utility
  • Importing from a Data File
  • Importing with a MySQL Utility

Joining Tables

  • Combining Multiple Tables
  • Joining Tables with SELECT
  • Comma-Separated Joins
  • Inner Joins
  • Outer Joins
  • Table Name Aliases

Table Subqueries

  • Advantages of Using a Subquery
  • Placement of Subqueries
  • Subquery Categories
  • Subquery Result Table Types
  • Subquery Type/Placement
  • Finding Mismatches
  • Modifying Tables using Subqueries
  • Converting Joins to Subqueries

MySQL Graphical User Interface Tools

  • MySQL Workbench
  • MySQL Enterprise Monitor

Supplementary Information

  • Storage Engines
  • Creating Views
  • Transactions
  • Retrieving Metadata
  • Performance Schema
  • MySQL Enterprise Backup

Conclusion

  • Course Goals
  • MySQL Curriculum Path
  • MySQL Resources
  • Evaluation
  • Final QA
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward