MySQL: MySQL 8.0 Intermediate

https://www.skillsoft.com/channel/mysql-0d795f10-e19a-11e6-93f3-0242c0a80605?technologyandversion=63815&expertiselevel=63816 https://www.skillsoft.com/channel/mysql-0d795f10-e19a-11e6-93f3-0242c0a80605?technologyandversion=63815&expertiselevel=63817
  • 6 Courses | 5h 59m 44s
  • 8 Books | 55h 48m
  • 11 Courses | 12h 45m 41s
  • 8 Books | 55h 15m
Likes 182
 
Discover everything you need to know about MySQL, the open-source relational database management system (RDBMS).

GETTING STARTED

MySQL 8.0: Introduction

  • Playable
    1. 
    Introduction to MySQL
    3m 21s
    NOW PLAYING
  • Playable
    2. 
    Select and Download MySQL
    3m 28s
    UP NEXT

GETTING STARTED

Stored Routines, Triggers, & the InnoDB memcached Plugin

  • Playable
    1. 
    Working with Stored Programs
    7m 58s
    NOW PLAYING
  • Playable
    2. 
    Working with Stored Routines
    8m 29s
    UP NEXT

COURSES INCLUDED

MySQL 8.0: Introduction
MySQL is fast, reliable, easy to use, free to download, and supports standard SQL. Discover how to download and configure MySQL, how to use the MySQL Workbench, and learn abow MySQL connection navigator, status and system vatiables, new user creations, and users and privileges management.
12 videos | 58m has Assessment available Badge
Database Design Fundamentals
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.
12 videos | 1h 5m has Assessment available Badge
DDL Statements
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.
10 videos | 52m has Assessment available Badge
Manipulating Data
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.
12 videos | 53m has Assessment available Badge
SELECT Statement & Operators
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.
10 videos | 1h 4m has Assessment available Badge
Working with Functions
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.
11 videos | 1h 6m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Stored Routines, Triggers, & the InnoDB memcached Plugin
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
8 videos | 47m has Assessment available Badge
Query & Performance Optimization
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
14 videos | 1h has Assessment available Badge
GIS, Cloud, & Connectors
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.
10 videos | 56m has Assessment available Badge
MySQL: Getting Started
Explore how database systems allow data to be stored and updated in a robust manner, and queried conveniently by using SQL language, and learn how MySQL can be installed and used from different operating environments. Key concepts covered in this 11-video course include requirements that a database management system needs to satisfy and the importance that consistency of the data in a system always be maintained; how to install MySQL on different platforms; and how to connect to a MySQL server by using a command-line interface. You will learn how to create a database and view a list of databases on a MySQL server; learn how to install MySQL workbench and connect to a MySQL server; and learn model entities in a real-world scenario for use in a database system. Next, explore how to execute commands from the MySQL Workbench environment; learn perform basic database operations such as inserting and querying data; and learn how to view table metadata and delete data from tables.
11 videos | 1h 9m has Assessment available Badge
MySQL: Creating & Updating Tables
In this 10-video course, learners can explore how tables in MySQL can be created to match entities and relationships as modeled in an E-R diagram and how MySQL allows the specification of different types of columns and column constraints. Key concepts covered in this course include attributes of keys, super keys, and candidate keys; learning how to model relationships in a real-world scenario for use in a database system; and learning how to specify non-null constraints while creating tables. You will learn how to run simple queries by using wildcards and where clauses; learn about the need for SQL and its important characteristics, SQL-based technologies also known as relational databases; and learn how to designate columns as unique while creating tables. Continue by learning how to perform update operations on data updating the structure of tables as well as the data contained within them in a MySQL relation; and learning how to perform DDL operations, including altering tables to add primary key constraints and dropping tables and databases.
10 videos | 1h 10m has Assessment available Badge
MySQL: Querying Data
Explore how MySQL continue to play an important role in complementing both data warehouses and programming language based frameworks, in this 10-video course. Learners will observe how MySQL tables can be queried by using classic SQL syntax and how common types of queries tie closely to common patterns in table design. Key concepts covered here include how to write queries to explore entity and relationship data, including foreign keys; how to translate entity-relationship models into actual database table schemas; and learning about correct data types and constraints for specific columns in a table schema. You will learn how to use relational and logical operators in WHERE clause of MySQL queries; how to use LIKE and IN operators, as well as pattern matching with wildcards in queries; and how to use subqueries to perform complex logical operations. Next, learn to implement referential integrity checks by using foreign key constraints. Finally, you will learn how to perform filtering operations on date columns; and how to use LIMIT and ORDER BY clauses in MySQL queries.
10 videos | 1h 2m has Assessment available Badge
MySQL: Understanding & Implementing Joins
This 10-video course explores how to use joins to combine data from different relations in meaningful ways. Learners will examine why joins are such a powerful and ubiquitous concept in data analysis. Begin by observing how SQL features several types of joins, and how these can be understood, and will examine each type of join in depth. You will examine the cross join, which is the simplest kind of join, and is also known as a Cartesian join. Then examine inner joins, which can be expressed as a combination of the cross join operator along with a filter. This course continues by examining the three types of outer joins, the left, the full, and the right outer join. You will explore natural joins, which could be an inner or an outer join where two additional conditions are satisfied. You will examine several features of the join keyword. Finally, this course demonstrates how to use MySQL platform to support several varieties of different joins types.
10 videos | 1h has Assessment available Badge
MySQL: Grouping & Aggregation Operations
Learners can explore how to use grouping and aggregation operators to analyze groups of rows rather than just individual rows, in this 8-video course. In it you will learn how to perform filtering operations on groups of rows. Then examine the GROUP BY clause, one of the most important syntactic constructs in SQL. You will learn how to use the GROUP BY clause to analyze groups of rows aggregated by common attribute values. Next, learn about aggregate functions such as SUM, COUNT, MIN, and MAX, and how they are used with GROUP BY clauses. You will learn how subqueries can be leveraged by using the ANY, SOME, and ALL keywords. You will learn how to implement multi-way joins in MySQL, and how the HAVING clause adds to the effectiveness of the GROUP BY construct by allowing groups of rows to be filtered based on specific conditions. Finally, this course explains the differences between the WHERE clause and the HAVING clause, which applies conditional filters to groups of rows rather than to individual rows.
8 videos | 57m has Assessment available Badge
MySQL: Views, Indices, & Normal Forms
This 13-video course explores how indexes work to speed up query execution, and how views can be used to abstract complex queries in a convenient fashion. Learners will explore advanced abstractions in MySQL, including a view, which is a virtual table, and indices. Then you will learn how to use views to build abstractions for complex and common query operations in your use case. You will examine indices, which are auxiliary data structures which are maintained by a DBMS (database management system). Next, learn how to use an index on a database to make queries fast and easy. You will examine normal forms in database design, a standard set of rules to test the design of a table. This course demonstrates how to apply the analysis of normal forms to optimize the structure of your relations, and then to use appropriate indices to speed up query execution on them. Finally, this course demonstrates first, second, and third normal forms, and how to fix violations.
13 videos | 1h 20m has Assessment available Badge
MySQL: Triggers & Stored Procedures
Learners can explore how triggers can be used to react to specific conditions in your database, and how stored procedures can be used to achieve code reuse and code composition of SQL commands, in this 12-video course. You will examine how triggers, which are described as actions or groups of logic, and special stored procedures, that are executed by the MySQL database when certain specific events occur. This course demonstrates how to use several types of triggers, and the use of foreign keys. You will learn how to use the ON DELETE and ON UPDATE cascade functionality. Then learn how to create stored procedures, which are bits of SQL code, queries, or other operations, which can be saved, given a name, and then invoked at will. Observe how to invoke stored procedures, to redefine stored procedures, and then examine advance and intricate stored procedures. Finally, this course demonstrates how to construct an elaborate stored procedure.
12 videos | 1h 24m has Assessment available Badge
MySQL: Transactions, Savepoints, & Locks
This 14-video course explores how to execute groups of commands in an all-or-nothing fashion. Learners will examine how locks are used to regulate table access when multiple clients are accessing the database simultaneously. First, you will explore the ACID properties (atomicity, consistency, isolation, and durability) of database management systems. Next, you will learn how transactions, a unit of work which needs to be executed in an all or nothing fashion, work in MySQL. Next, learners you will examine the start transaction keyword, how transactions are defined as committed or rolled back. You will examine implicit commits, operations which create, alter, or drop database entities, such as databases or tables, and how these operations are affected by transaction commits and rollbacks. Learners will observe DDL (data definition language) operations in MySQL. Continue by exploring savepoints, specific checkpoints where the copy of a system state is created, and release savepoints when they are no longer needed. Finally, the course examines the precise semantics of read and write locks in MySQL.
14 videos | 1h 28m has Assessment available Badge
SHOW MORE
FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

MySQL for the Internet of Things
Introducing the problems facing Internet of Things developers, this book explores current technologies and techniques to help you manage, mine, and make sense of the data being collected through the use of the world’s most popular database on the Internet - MySQL.
Book Duration 6h 47m Book Authors By Charles Bell

Book

Introducing the MySQL 8 Document Store
Presenting new tools and features that make creating a hybrid database solution far easier than ever before, this book gives insight into how features work and how to apply them to get the most out of your MySQL experience.
Book Duration 7h 4m Book Authors By Charles Bell

Book

PHP, MYSQL and Apache Server
Beginning with an introduction to PHP, then moving to more advanced features such as language basics, arrays and functions, web forms, connecting to databases, and much more, this book is ideal for beginner graphic designers, bloggers, and other web crafters who want a thorough but non-intimidating way to understand the code that makes websites dynamic.
Book Duration 16h 1m Book Authors By Shashi Banzal

Book

MySQL Workbench: Data Modeling & Development
With clear examples, instructions, and explanations, this Oracle Press guide helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements.
Book Duration 4h 14m Book Authors By Michael McLaughlin

Book

Expert MySQL, Second Edition
The leading reference for learning, understanding, and extending the MySQL server, this practical, detailed guide unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and much more.
Book Duration 11h 41m Book Authors By Charles Bell

Book

Effective MySQL: Replication Techniques in Depth
Providing an evaluation of various new replication features and additional third-party product implementations, this Oracle Press guide helps to ensure your MySQL environment can support the various high-availability needs of your business.
Book Duration 3h 38m Book Authors By Chris Schneider, Ronald Bradford

Book

Effective MySQL: Backup & Recovery
Featuring a side-by-side evaluation of the various backup strategies and complementary recovery implementations, this Oracle Press book helps you to protect your MySQL data from a wide range of disaster situations.
Book Duration 3h 33m