MySQL: Become a Certified Database Engineer

$99.00 $49.99

In this MySQL: Become a Certified Database Engineer course, you will be introduced to database design and create your first database. Then you will learn all about MySQL variables, operators, security, replication, and so much more. By the time you've completed this course, you will be on your way to becoming a certified database engineer!

Length: 5 hrs

This title is available in the
Total Training All-Access library.

Subscribe Now

Description

MySQL is one of the most well-known systems for managing databases, and with this MySQL: Become a Certified Database Engineer course, you will get acquainted with with the basic concepts of databases and gain the knowledge needed to practically use MySQL servers.

Through the lessons, you’ll get an overview of SQL language syntaxes as well as the advanced functionalities of servers. This is an open code system, which means it’s available to everyone that wishes to use it and modify it according to their own specific needs. Apart from the fact this system enables you to manage your daily tasks quickly and efficiently, gaining skills and experience in MySQL will also provide you with a chance at building a successful and lucratively rewarding IT career. This course also prepares you for ORACLE certification, which can only further improve your chance at landing a great job.

What are the requirements?

  • No prior SQL Development experience required
  • Knowing some programming language would be helpful

What am I going to get from this course?

  • Gain the qualifications needed to apply for MySQL Development jobs
  • Gain the knowledge needed to prepare to take the ORACLE exam: Oracle Certified Professional, MySQL 5.6 Database Administrator

Sample clip

 

MySql: Become a Certified Database Engineer
 
Section 1
 Introduction to databases (download)
 Installation (17:27)
 Database design (download)
 MySql Workbench (16:59)
 
Section 2
 Creating the first database (10:47)
 MySQL – Data Types (download)
 Primary and foreign keys (29:50)
 
Section 3
 Introduction to SQL (download)
 Variables & Operators in MySQL (download)
 Definition commands-DDL (14:54)
 SELECT (16:51)
 Connecting data (10:18)
 INSERT, UPDATE, DELETE (18:32)
 
Section 4
 Indexes (download)
 Views (6:39)
 Stored routines (25:43)
 Built-in functions (24:28)
 Cursors and triggers (25:20)
 Transactions (9:07)
 Users and access (11:50)
 MySql Security (6:11)
 Connections (6:42)
 Replication (19:19)
 Backup and Migration (10:40)

You may also like…