SkillGild
MySQL
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Enroll course

Course sections

Section 1
Background Concepts
1
MySQL - Introducing databases
2
MySQL - Introducing databases
3
MySQL - Exploring MySQL
4
MySQL - Exploring MySQL
5
MySQL - Organizing data in a relational format
6
MySQL - Organizing data in a relational format
7
MySQL - Exploring MySQL architecture
8
MySQL - Exploring MySQL architecture
9
MySQL - Storage engines (InnoDB and MyRocks)
10
MySQL - Storage engines (InnoDB and MyRocks)
11
MySQL - Data modeling
12
MySQL - Normalization
13
MySQL - Creating an optimized table for an employee project
Section 2
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 - Aggregating data
6
MySQL - Case statements
7
MySQL - Case statements
Section 3
Creating a Database
1
MySQL - The MySQL Workbench GUI
2
MySQL - The MySQL Workbench GUI
3
MySQL - Accessing MySQL through the command-line interface
4
MySQL - Accessing MySQL through the command-line interface
5
MySQL - Creating a database
6
MySQL - Creating a database
7
MySQL - Using Workbench to add a table
8
MySQL - Using Workbench to add a table
9
MySQL - MySQL table indexes and foreign keys
10
MySQL - MySQL table indexes and foreign keys
11
MySQL - Reverse engineering a database
12
MySQL - Reverse engineering a database
13
MySQL - Modifying the EER diagram, the model, and the database
14
MySQL - Modifying the EER diagram, the model, and the database
Section 4
Correlating Data across Tables
1
MySQL - Joining two tables
2
MySQL - Joining two tables
3
MySQL - Analyzing subqueries
4
MySQL - Analyzing subqueries
5
MySQL - Common table expressions
6
MySQL - Common table expressions
7
MySQL - Analyzing query performance with EXPLAIN
8
MySQL - The Sakila video store (Activity)
9
MySQL - Generating a list of years (Activity)
Section 5
Using SQL to Work with a Database
1
MySQL - Working with data
2
MySQL - Working with data
3
MySQL - Backing up databases
4
MySQL - Backing up databases
5
MySQL - Restoring databases
6
MySQL - Restoring databases
7
MySQL - Working with SQL code to maintain a database
8
MySQL - Creating a new database
9
MySQL - Creating a new database
10
MySQL - Creating and modifying tables
11
MySQL - Creating and modifying tables
12
MySQL - SQL queries to create indexes and foreign keys
13
MySQL - SQL queries to create indexes and foreign keys
14
MySQL - Creating a table with indexes and foreign keys
15
MySQL - Creating a table with indexes and foreign keys
16
MySQL - Altering table queries
17
MySQL - Altering table queries
18
MySQL - Updating data in a record
19
MySQL - Adding data to a table
20
MySQL - Blobs, files, and file paths
21
MySQL - Deleting data from tables
22
MySQL - Adding image file paths to the database
23
MySQL - Adding image file paths to the database
Section 6
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
Section 7
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
Section 8
Working with Data Using Node.js
1
MySQL - Inserting records in Node.js
2
MySQL - Inserting records in Node.js
3
MySQL - Updating the records of a table
4
MySQL - Multiple updates (Activity)
5
MySQL - Multiple updates (Activity)
6
MySQL - Displaying data in browsers
7
MySQL - Displaying data in browsers
8
MySQL - ODBC connections
9
MySQL - Designing a customer database (Activity)
Section 9
Creating Database Clients in Node.js
1
MySQL - Best practices for SQL client development
2
MySQL - Best practices for SQL client development
3
MySQL - JavaScript using Node.js
4
MySQL - JavaScript using Node.js
5
MySQL - Connecting to MySQL
6
MySQL - Connecting to MySQL
7
MySQL - Building a database application with Node.js (Activity)
8
MySQL - Building a database application with Node.js (Activity)
Section 10
Microsoft Access – Part 1
1
MySQL - MS Access database application configurations
2
MySQL - MS Access database application configurations
3
MySQL - Upsizing an MS Access database to MySQL
4
MySQL - Upsizing an MS Access database to MySQL
5
MySQL - Manually exporting MS Access tables
6
MySQL - Manually exporting MS Access tables
7
MySQL - Adjusting field properties
8
MySQL - Adjusting field properties
9
MySQL - Migrating with wizards
10
MySQL - Migrating with wizards
11
MySQL - Linking to your tables and views
12
MySQL - Linking to your tables and views
13
MySQL - Refreshing linked MySQL tables
14
MySQL - Refreshing linked MySQL tables
15
MySQL - Linking the remaining MySQL tables to your MS Access database (Activity)
16
MySQL - Linking the remaining MySQL tables to your MS Access database (Activity)
Section 11
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
Section 12
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
Section 13
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 - Connecting to the MySQL database using VBA
7
MySQL - Reading data from MySQL using VBA
8
MySQL - Reading data from MySQL using VBA
9
MySQL - Populating charts
10
MySQL - Populating charts
11
MySQL - Creating a chart (artist track sales) (Actiity)
12
MySQL - Creating a chart (artist track sales) (Actiity)
Section 14
Manipulating User Permissions
1
MySQL - Exploring users and accounts
2
MySQL - Exploring users and accounts
3
MySQL - Creating users and granting permissions (Exercise)
4
MySQL - Creating users and granting permissions (Exercise)
5
MySQL - Changing users
6
MySQL - Changing users
7
MySQL - Flush privileges
8
MySQL - Flush privileges
9
MySQL - Changing permissions
10
MySQL - Changing permissions
11
MySQL - Using roles
12
MySQL - Using roles
13
MySQL - Troubleshooting access problems
14
MySQL - Troubleshooting access problems
15
MySQL - Creating users for managing the world schema (Activity)
16
MySQL - Creating users for managing the world schema (Activity)
Section 15
Working With Microsoft Excel VBA – Part 2
1
MySQL - Connecting to the MySQL database using ODBC
2
MySQL - Connecting to the MySQL database using ODBC
3
MySQL - Exploring generic data read functions
4
MySQL - Exploring generic data read functions
5
MySQL - Creating connections to MySQL in Excel
6
MySQL - Inserting data using MySQL for Excel
7
MySQL - Updating data using MySQL for Excel
8
MySQL - Pushing data from Excel
9
MySQL - Pivot tables
10
MySQL - Pivot tables
11
MySQL - Building a MySQL-based Excel document (Activity)
12
MySQL - Building a MySQL-based Excel document (Activity)
Section 16
Logical Backups
1
MySQL - Understanding the basics of backups
2
MySQL - Understanding the basics of backups
3
MySQL - Logical and physical backup
4
MySQL - Logical and physical backup
5
MySQL - Types of restore
6
MySQL - Types of restore
7
MySQL - Scheduling backups
8
MySQL - Scheduling backups
9
MySQL - Using point-in-time recovery with binlog files
10
MySQL - Using point-in-time recovery with binlog files
11
MySQL - Backing up and restoring a single schema (Acivity)
12
MySQL - Backing up and restoring a single schema (Acivity)
13
MySQL - Performing a point-in-time restore (Activity)
14
MySQL - Performing a point-in-time restore (Activity)
Section 17
Getting Data into MySQL
1
MySQL - Working with the X DevAPI
2
MySQL - Working with the X DevAPI
3
MySQL - Inserting documents
4
MySQL - Inserting documents
5
MySQL - Loading data from a SQL file
6
MySQL - Loading data from a SQL file
7
MySQL - Loading data from a CSV file
8
MySQL - Loading data from a CSV file
9
MySQL - Loading data from a JSON file
10
MySQL - Loading data from a JSON file
11
MySQL - Using the CSV storage engine to export data
12
MySQL - Using the CSV storage engine to export data
13
MySQL - Using the CSV storage engine to import data
14
MySQL - Using the CSV storage engine to import data
15
MySQL - Searching and filtering JSON documents
16
MySQL - Searching and filtering JSON documents
17
MySQL - Using JSON functions and operators to query JSON columns
18
MySQL - Using JSON functions and operators to query JSON columns
19
MySQL - Using generated columns to query and index JSON data
20
MySQL - Using generated columns to query and index JSON data
21
MySQL - Exporting report data to CSV for Excel (Activity)
22
MySQL - Exporting report data to CSV for Excel (Activity)

C Program to list all files and sub-directories in a directory

Lesson is locked. Please Buy course to proceed.