MySQL for Beginners Ed 3

Rel 9.2 Ed 4

Cost $3,200

Course Code
D61918GC30

Duration
4 days

Format
Live Virtual Class

What you will learn

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 dataAudience

  • Administrator
  • Architect
  • Database Administrator
  • Developer

Audience

  • Administrator
  • Architect
  • Database Administrator
  • Developer

Objectives

    • 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 base and put your new skills to work.

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

Enroll for MySQL for Beginners Ed 3

MySQL for Beginners Ed 3

$3,200.00

Clear
SKU: D61918GC30 Categories: ,

Additional information

Schedules

May 9 2022 – May 12 2022 (4 days) 9:00 AM – 5:00 PM US-Eastern, Oct 31 2022 – Nov 3 2022 (4 days) 9:00 AM – 5:00 PM US-Pacific

Format

Live Virtual Class

Reviews

There are no reviews yet.

Be the first to review “MySQL for Beginners Ed 3”

Your email address will not be published. Required fields are marked *

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0