MySQL

Background Concepts

1
MySQL – Introducing databases
2
MySQL – Exploring MySQL
3
MySQL – Organizing data in a relational format
4
MySQL – Exploring MySQL architecture
5
MySQL – Storage engines (InnoDB and MyRocks)
6
MySQL – Data modeling
7
MySQL – Normalization
8
MySQL – Creating an optimized table for an employee project

Creating a Database

1
MySQL – The MySQL Workbench GUI
2
MySQL – Accessing MySQL through the command-line interface
3
MySQL – Creating a database
4
MySQL – Using Workbench to add a table
5
MySQL – MySQL table indexes and foreign keys
6
MySQL – Reverse engineering a database
7
MySQL – Modifying the EER diagram, the model, and the database

Using SQL to Work with a Database

1
MySQL – Working with data
2
MySQL – Backing up databases
3
MySQL – Restoring databases
4
MySQL – Working with SQL code to maintain a database
5
MySQL – Creating a new database
6
MySQL – Creating and modifying tables
7
MySQL – SQL queries to create indexes and foreign keys
8
MySQL – Creating a table with indexes and foreign keys
9
MySQL – Altering table queries
10
MySQL – Adding data to a table
11
MySQL – Updating data in a record
12
MySQL – Deleting data from tables
13
MySQL – Blobs, files, and file paths
14
MySQL – Adding image file paths to the database

Selecting | Aggregating and Applying Functions

1
MySQL – Querying tables in MySQL
2
MySQL – Filtering results
3
MySQL – Using functions on data
4
MySQL – Aggregating data
5
MySQL – Case statements

Correlating Data across Tables

1
MySQL – Joining two tables
2
MySQL – Analyzing subqueries
3
MySQL – Common table expressions
4
MySQL – Analyzing query performance with EXPLAIN
5
MySQL – The Sakila video store (Activity)
6
MySQL – Generating a list of years (Activity)

Stored Procedures and Other Objects

1
MySQL – Exploring various database objects
2
MySQL – Working with views
3
MySQL – Updating the data in a view (Activity)
4
MySQL – Working with user-defined functions
5
MySQL – Working with stored procedures
6
MySQL – Working with IN, OUT, and INOUT
7
MySQL – Exploring triggers
8
MySQL – Using transactions

Creating Database Clients in Node.js

1
MySQL – Best practices for SQL client development
2
MySQL – JavaScript using Node.js
3
MySQL – Connecting to MySQL
4
MySQL – Building a database application with Node.js (Activity)

Working with Data Using Node.js

1
MySQL – Inserting records in Node.js
2
MySQL – Updating the records of a table
3
MySQL – Multiple updates (Activity)
4
MySQL – Displaying data in browsers
5
MySQL – ODBC connections
6
MySQL – Designing a customer database (Activity)

Microsoft Access – Part 1

1
MySQL – MS Access database application configurations
2
MySQL – Upsizing an MS Access database to MySQL
3
MySQL – Manually exporting MS Access tables
4
MySQL – Adjusting field properties
5
MySQL – Migrating with wizards
6
MySQL – Linking to your tables and views
7
MySQL – Refreshing linked MySQL tables
8
MySQL – Linking the remaining MySQL tables to your MS Access database (Activity)

Microsoft Access – Part 2

1
MySQL – Migrating an MS Access application to MySQL
2
MySQL – Converting gender and job statistics (Activity)
3
MySQL – Calling MySQL functions
4
MySQL – Creating a function and calling it (Activity)
5
MySQL – Calling MySQL stored procedures
6
MySQL – Creating MySQL stored procedures and using them in VBA (Activity)
7
MySQL – Using parameters
8
MySQL – Parameterized stored procedure (series list) – Activity
9
MySQL – Multiple parameters stored procedure (date list) – Activity
10
MySQL – The Bad Bits form

MS Excel VBA and MySQL – Part 1

1
MySQL – Introduction to Excel
2
MySQL – Exploring the ODBC connection
3
MySQL – Exploring the Excel VBA structure
4
MySQL – Learning about VBA libraries
5
MySQL – Connecting to the MySQL database using VBA
6
MySQL – Reading data from MySQL using VBA
7
MySQL – Populating charts
8
MySQL – Creating a chart (artist track sales) (Actiity)

Working With Microsoft Excel VBA – Part 2

1
MySQL – Connecting to the MySQL database using ODBC
2
MySQL – Exploring generic data read functions
3
MySQL – Creating connections to MySQL in Excel
4
MySQL – Inserting data using MySQL for Excel
5
MySQL – Updating data using MySQL for Excel
6
MySQL – Pushing data from Excel
7
MySQL – Pivot tables
8
MySQL – Building a MySQL-based Excel document (Activity)

Getting Data into MySQL

1
MySQL – Working with the X DevAPI
2
MySQL – Inserting documents
3
MySQL – Loading data from a SQL file
4
MySQL – Loading data from a CSV file
5
MySQL – Loading data from a JSON file
6
MySQL – Using the CSV storage engine to export data
7
MySQL – Using the CSV storage engine to import data
8
MySQL – Searching and filtering JSON documents
9
MySQL – Using JSON functions and operators to query JSON columns
10
MySQL – Using generated columns to query and index JSON data
11
MySQL – Exporting report data to CSV for Excel (Activity)

Manipulating User Permissions

1
MySQL – Exploring users and accounts
2
MySQL – Creating users and granting permissions (Exercise)
3
MySQL – Changing users
4
MySQL – Flush privileges
5
MySQL – Changing permissions
6
MySQL – Using roles
7
MySQL – Troubleshooting access problems
8
MySQL – Creating users for managing the world schema (Activity)

Logical Backups

1
MySQL – Understanding the basics of backups
2
MySQL – Logical and physical backup
3
MySQL – Types of restore
4
MySQL – Scheduling backups
5
MySQL – Using point-in-time recovery with binlog files
6
MySQL – Backing up and restoring a single schema (Acivity)
7
MySQL – Performing a point-in-time restore (Activity)

Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Enrolled: 0 students
Lectures: 118

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
Price:
Free