MySQL Path

2.72 GB | MP4 | 16 Hours | English | Elearning | 174 kb/s | 1280×720 | aac, 44100 Hz, stereo

Pre-requisites
This path targets beginners who may have no programming experience, or some experience with programming outside of databases and SQL.

What you will learn

Basics of SQL
MySQL server administration
Backup and recovery of MySQL database
InnoDB and MyISAM Storage Engines
Security
Performance monitoring
MySQL Enterprise
MySQL Workbench

Beginner

These courses will show you how to install MySQL software and perform basic setup of MySQL DBMS. You will also be introduced to basic queries in SQL/MySQL.

Introduction to SQL

Structured Query Language (SQL) is a special purpose language for interacting with relational databases. In this course, Introduction to SQL (Update), you will learn the basics of Structured Query Language. First, you will learn how to query data and shape results. Next, you will focus on creating and modifying data in your tables. Finally, you will touch on how actually modify the tables themselves. By the end of this course, you’ll understand the basics of how to create and use a relational database.

MySQL Fundamentals

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as write basic data retrieval and data modification queries.

Intermediate

This section will take you through more complex queries in MySQL and cover some of your backup/recovery options. You’ll finish of with a brief overview of MySQL Workbench installation and navigation.

MySQL Fundamentals Part 2

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. In this course, which is part 2 of the Fundamentals of MySQL series, we explore more advanced topics such as stored procedures & user-defined functions, subqueries & joins, views and events & triggers.

MySQL Workbench Guided Tour

A detailed exploration of MySQL Workbench, a unified visual tool for data modeling, SQL development, and comprehensive administration tools for MySQL. This course will guide you through maximizing the power of MySQL Workbench and getting productive quickly with MySQL.

MySQL Backup and Recovery Fundamentals

Data is very important to any application and business. It is very important that every business plan for data safety. Database backup strategies are often discussed after the disaster has already happened. In this introductory course we will explore a few of the basic backup strategies every business should implement for data safely. We will explore how we can recover our server quickly after any unfriendly incident to our MySQL database.

Advanced

The advanced courses you see here will solidify your confidence in MySQL database administration by showing you how to optimize performance and queries for your databases.

MySQL Indexing for Performance

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. Indexes are the silver bullets for Performance. In this course we will gain an understanding of the basics of Indexes and further explore practical tips and tricks for performance tuning.

MySQL Query Optimization and Performance Tuning

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.

phpMyAdmin Fundamentals

phpMyAdmin is a free and open source tool written in PHP for the administration of MySQL via a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields, and rows as well as executing SQL statements or managing users and permissions. This course will guide you through maximizing the power of phpMyAdmin to get productive quickly with MySQL.

Password/解压密码-0daydown

Download rapidgator
https://rg.to/file/28d3bbdebec9628e8d2d291c02c6cd92/MySQL_Path.part1.rar.html
https://rg.to/file/71dc0b1f2880eb665450f96a897f111f/MySQL_Path.part2.rar.html
https://rg.to/file/69083045438fcd0a10ceca5620f61d0c/MySQL_Path.part3.rar.html
https://rg.to/file/c7584d333cf99dceeb9a860f532750fb/MySQL_Path.part4.rar.html
https://rg.to/file/80b7a0b76c8315ad2101f1c0a2c904cf/MySQL_Path.part5.rar.html
https://rg.to/file/91ff9b7aaca7996f9b278e0c2be09eab/MySQL_Path.part6.rar.html

Download nitroflare
http://nitroflare.com/view/6F02ECD32705E71/MySQL_Path.part1.rar
http://nitroflare.com/view/C169F27153FC859/MySQL_Path.part2.rar
http://nitroflare.com/view/4BC19FE51DF5509/MySQL_Path.part3.rar
http://nitroflare.com/view/0C1114246270898/MySQL_Path.part4.rar
http://nitroflare.com/view/0E0AAF265A217C5/MySQL_Path.part5.rar
http://nitroflare.com/view/C2F6D4784C3A26F/MySQL_Path.part6.rar

Download 百度云

你是VIP 1个月(1 month)赞助会员，