Description:
GIS data types, cloud integration, and low level access for database performance give MySQL the power necessary to handle many data storage tasks. Explore these features in MySQL.
Target Audience:
Duration: 00:57
Description:
Indexing and understanding the configuration of MySQL can be key to performance. Explore index types and configuration options that can be set to fine-tune the performance of your MySQL databases to optimal levels
Target Audience:
Duration: 01:28
Description:
Stored programs (procedures) and routines (functions) in MySQL are used to create reusable, executable code. Explore the syntax and use of stored procedures and functions in MySQL
Target Audience:
Duration: 00:48
Description:
Funtions in MySQL are used to produce values from other values, or to determine values that may be unknown. Explore the syntax and use of the most common MySQL functions, including aggregate, date/time and string functions.
Target Audience:
Duration: 01:06
Description:
SELECT statements are used to retrieve data from MySQL tables or views. Explore the syntax and use of the most common SELECT statement elements, including SELECT, FROM, WHERE, and ORDER BY, as well as unions and joins.
Target Audience:
Duration: 01:04
Description:
Data Manipulation Language (DML) statements are used to manipulate the actual data in MySQL databases. Explore the syntax and use of the most common DML statements, including INSERT, UPDATE, and DELETE.
Target Audience:
Duration: 00:53
Description:
Data Definition Language (DDL) statements are used to manipulate MySQL database schema objects. Examine the use of the CREATE, ALTER, and DROP statements to create, modify, and maintain MySQL databases, tables, and views.
Target Audience:
Duration: 00:53
Description:
A database is only as good as its initial design. Explores RDBMS design fundamentals, such as table design, normalization, and relationships. Full Stack Development and how MySQL fits into the FDS landscape is also covered.
Target Audience:
Duration: 01:06
Description:
MySQL is fast, reliable, easy to use, free to download, and supports standard SQL. Explore MySQL, including how to download and configure MySQL, and how to use the MySQL Workbench.
Target Audience:
Duration: 00:58