MySQL 8 from Zero to Expert, Practical and Complete

U1: Introduction to MySQL

– Introduction to the course
– Introduction to databases
– Relational databases

U2: First steps

– Installing MariaDB - MySQL Tools
– How to display Database Information
– Creating a database
– Delete a database
– Creating Tables in our Database
– Deleting tables from our database
– The different types of data for our columns

U3: Databases and tables

– Creating databases in MySQL
– Creating Tables in MySQL
– Practice - Creating tables
– Using schemas in databases

U4: Interaction with databases

– Inserting data into tables
– Practice - Inserting Data into Tables
– Database queries
– Practice - Database queries
– Modify data in a table
– Delete or remove records from a table
– Consult data in a non-exact manner

U5: Functions and operators in MySQL

– Comparison Functions and Operators
– Comparison and Operators part 2
– Logical Operators
– Flow Control Functions

U6: Functions with strings in MySQL

– Introduction to functions with AC strings
– Functions with CI strings
– Functions with LM chains
– Functions with MR strings
– Functions with RU strings
– Functions with UZ strings

U7: Mathematical Functions in MySQL

– AC Mathematical Functions
– DL Mathematical Functions
– MR Mathematical Functions
– SZ Mathematical Functions

U8: Date and Time Functions in MySQL

– Date and Time Functions AC
– Date and Time Functions D
– Date and Time Functions D (part 2)
– MQ Date and Time Functions
– Date and Time Functions S
– Date and Time Functions T
– UV Date and Time Functions

U9: Encryption and compression functions

– Information security functions

U10: Information Functions

– Functions to obtain information from MySQL
– More Functions to get information from MySQL

U11: Statements for defining data in MySQL

– Introduction to Data Definition Statements in MySQL
– Alter Database, Alter Event, Alter Function
– Alter Instant, Alter Logfile Group, Alter Procedure
– Alter Server, Alter Table
– Alter Tablespace, Alter View
– Create Database, Create Event, Create Function, Create Logfile Group
– Create Index, Create Procedure, Create Function
– Reading 52:Create Index, Create Procedure, Create Function
– Create Tablespace, Create Trigger, Create View
– Drop Database, Drop Event, Drop Index, Drop Logfile Group
– Drop Procedure, Drop Function, Drop Server
– Drop Table, Drop Tablespace, Drop Trigger, Drop View
– Rename Table, Truncate Table

U12: Data manipulation statements in MySQL

– Call, Delete, DO
– Handler, Import Table, Insert
– Load Data, Load XML, Replace
– Select, Table, Update, Values

U13: Transaction and Lock Statements

– Start Transaction, Commit, Rollback Transaction
– No Rollback Instructions and Instructions with Implicit Commit
– Savepoint, Lock Instance, Lock Table
– Set Transaction, XA Transactions

U14: Master Server Control

– Purge Binary Logs
– Reset Master
– SET sql_log_bin

U15: Prepared statements

– Prepare
– Execute, Deallocate Prepare

U16: Syntax of compound statements

– Begin End, Labels, Declare
– Cursors
– Case, If, Iterate
– Repeat, Return, While
– Handling Data Cursors
– Get Diagnostics, Resignal, Signal
– Rules and Restrictions

U17: Database Administration

– User creation and definition of access keys
– Updating user accounts
– Creating and Updating User Roles
– Updating user permissions
– Table analysis, optimization and repair
– Installing Components and Plugins
– Clone, Set variables, Set Character set and Set names
– Show Binary Logs, Show Character Set, Show Collation, Show Columns
– Show Create Database, Event, Function, Procedure, Table, Trigger, User, View
– Show Databases, Engine, Engines, Errors, Events, Function Code, Function Status
– Show Grants, Index, Master Status, Open Tables, Plugins
– Show Privileges, Procedure Code, Procedure Status
– Show processlist, Profile, Profiles
– Show Relaylog Events, Hosts, Status
– Show Table Status, Tables, Triggers, Variables, Warnings

U18: Utility statements

– Cache Indexes and Load Indexes into Cache
– Flush to disk, privileges, binary logs and logs in general
– Kill user processes from the server
– Reset, Restart and Shutdown on the master server.
– Describe and Explain
– Help – User Manual
– Database selection

Course evaluation

– This course contains a final exam

G-Tools: For Students

– Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.

⚑ Certificate of completion

– Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.