For More Udemy Free Courses >>> https://ftuforum.com/
For more Lynda and other Courses >>> https://www.freecoursesonline.me/
Forum for discussion >>> https://1hack.us/



By: Victor Deras
Publisher: Technics Publications
Release Date: July 2019
ISBN: 9781634625944
Torrent Contains: 18 Files, 1 Folders
Course Source: https://www.oreilly.com/library/view/database-series-the/9781634625944/

Description

Follow along with MySQL expert Victor Deras and master relational database constructs and MySQL (and MariaDB). Build powerful and robust relational databases after watching these 12 topics within the MySQL video series:

• Introducing MySQL. This first topic in the MySQL (and MariaDB) video series introduces you to this powerful open source relational database. Install both client and server, on Windows or Linux. MariaDB can also be used as an alternative to MySQL, and almost everything in this course also applies to MariaDB.
• Creating and modifying tables in MySQL. This second topic in the MySQL (and MariaDB) video series focuses on tables. Tables are comprised of columns and rows, and both are illustrated in this session first in Microsoft Excel and then in MySQL. Follow along with Victor in this hands-on session to create and modify tables in MySQL. Ensure tables have data integrity using nullability, and primary and foreign keys.
• Data Types in MySQL. This third topic in the MySQL (and MariaDB) video series focuses on data types in MySQL. Follow along with Victor in this hands-on session to create numeric, date and time, and string data types in MySQL.
• Inserting Data in MySQL. This fourth topic in the MySQL (and MariaDB) video series focuses on inserting data in MySQL using the INSERT INTO statement and through a GUI. Follow along with Victor in this hands-on session to insert data using these two approaches in MySQL. Also experience some of the restrictions that exist in MySQL for inserting data.
• Querying Data in MySQL. This fifth topic in the MySQL (and MariaDB) video series focuses on querying data in MySQL. Learn about queries and subqueries. Follow along with Victor in this hands-on session using the SELECT, FROM, and WHERE statements to retrieve data from tables in MySQL.
• Performing Joins in MySQL. This sixth topic in the MySQL (and MariaDB) video series focuses on performing joins in MySQL. Learn about inner joins, left joins, right joins, and full outer joins. Follow along with Victor in this hands-on session to retrieve data from multiple tables in the same query using MySQL.
• Creating Views in MySQL. This seventh topic in the MySQL (and MariaDB) video series focuses on creating views in MySQL. Learn when views should be used. Follow along with Victor in this hands-on session to create and access data from virtual tables in MySQL.
• Leveraging Functions in MySQL. This eighth topic in the MySQL (and MariaDB) video series focuses on aggregate, string, control flow, date and time, and math functions in MySQL. Follow along with Victor in this hands-on session to apply functions in MySQL.
• Creating Stored Procedures in MySQL. This ninth topic in the MySQL (and MariaDB) video series focuses on stored procedures in MySQL. Learn what stored procedures are, how to use them, and when to use them (for reusability or security) in MySQL. Follow along with Victor in this hands-on session to create and run stored procedures in MySQL.
• Creating Triggers in MySQL. This tenth topic in the MySQL (and MariaDB) video series focuses on triggers in MySQL. Learn what triggers are, how they differentiate from stored procedures, how to build them, and when to use them. Follow along with Victor in this hands-on session to create and run triggers in MySQL.
• Optimizing MySQL. This 11th topic in the MySQL (and MariaDB) video series focuses on optimizing MySQL. Learn why optimization is so important and the different ways to optimize your database. Follow along with Victor in this hands-on session to optimize your database in MySQL.
• Performing Maintenance in MySQL. This 12th topic in the MySQL (and MariaDB) video series focuses on performing database backup and maintenance in MySQL. Learn why backups are so important and hear some valuable backup tips. Follow along with Victor in this hands-on session to backup your database and apply techniques to maintain your database in MySQL.

Table of Contents

• Introducing MySQL (and MariaDB) 00:15:43
• Creating and modifying tables in MySQL (and MariaDB) 00:14:01
• Data Types in MySQL (and MariaDB) 00:12:06
• Inserting Data in MySQL (and MariaDB) 00:07:08
• Querying Data in MySQL (and MariaDB) 00:11:18
• Performing Joins in MySQL (and MariaDB) 00:09:54
• Creating Views in MySQL (and MariaDB) 00:07:21
• Leveraging Functions in MySQL (and MariaDB) 00:13:36
• Creating Stored Procedures in MySQL (and MariaDB) 00:20:38
• Creating Triggers in MySQL (and MariaDB) 00:21:56
• Optimizing MySQL (and MariaDB) 00:32:17
• Performing Maintenance in MySQL (and MariaDB) 00:22:11