My SQL for Beginners Ed 3

Duration : 4 Days

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

Audience

Administrator

Database Administrators

Database Designers Developer

Related Training

Required Prerequisites

Basic computer literacy is required

Suggested Prerequisites

Knowledge of database concepts.

Previous experience with any command-line program.

Course 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 

Course Outline :

Popular Courses

Related Courses

Testimonials

Thank you EZY Intellect and Trainer for your support to become an Oracle Certified Professional

thumb Mr. Tint Aung Shwe
Assistant Manager (IT Department)-AYA Bank,August 29, 2017

This training helped me identify clear and do-able next steps toward my goal. Thank you EZY Intellect and Mr.Kushantha ( EC-Council Certified Trainer) for very valuable training.

thumb Mr. Kyaw Htet
CEH V10,21,22,23,29,30 Sep 2018