English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 4.5 Hours | 706 MB
Learn MySql and prepare yourself for: Oracle Certified Professional, MySQL 5.6 Database Administrator-Developer
MySQL is one of the most famous systems whose primary role is managing databases. The main goal of this course is the acquaintance with the basic concepts of databases. The acquired knowledge will enable you to practically use MySQL servers. Through the lessons, you’ll get a general picture regarding 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 You Will Learn
- Apply for jobs as MySQL developers
- After this course, students will be ready for ORACLE exam: Oracle Certified Professional, MySQL 5.6 Database Administrator
Table of Contents
Installation
MySQL Workbench
Creating Your First Database
Primary and Foreign Keys
Definition Commands – DDL
SELECT
Connecting Data
INSERT, UPDATE and DELETE
Views
Stored Routines
Built-In Functions
Cursors and Triggers
Transactions
Users and Access
MySQL Security
Connections
Replication
Backup and Migration
Resolve the captcha to access the links!