In this module, you will learn the MySQL products, professional services, and support for your operating system. While defining a relational database management system (RDBMS) and describe its structure.

• MySQL Features
• MySQL Versions
• MySQL Data Types
• MySQL Variables
• Install MySQL
• MySQL Connection
• MySQL Workbench
  • MySQL Workbench
  • MySQL Comments
• MySQL versus other Databases
  • MySQL vs MongoDB
  • MySQL vs MS SQL Server
  • MySQL vs Oracle
  • MySQL vs MariaDB
  • MySQL vs PostgreSQL
  • MySQL vs SQL

In this module, you will learn to Create user accounts, design a permission structure, Control user permissions, Grant access to system operations, expire accounts manually and automatically and reset a forgotten root password.

• MySQL Create & Drop User
• MySQL Show Users
• Change User Password
• MySQL Privileges
  • MySQL Grant Privilege
  • MySQL Revoke Privilege
  • Login with Different User
• MySQL Key
  • MySQL Unique Key
  • MySQL Primary Key
  • MySQL Foreign Key
  • MySQL Composite Key
  • Primary Key vs Foreign Key
  • Primary Key vs Unique key
  • Primary Key vs Candidate Key
• MySQL Globalisation
  • MySQL Character Set
  • MySQL Collation

In this module you will learn to create, drop, show, delete a database, Import and Export CSV files in the database while managing MySQL privileges.

• MySQL Create Database
• MySQL Select Database
• MySQL Show Databases
• MySQL Drop Database
• MySQL Copy Database
• Export & Import Database
• Import CSV File in Database
• Export Table to CSV
• Database vs Schema
• Delete vs Truncate Command
• Change Storage Engine

In this module you will learn to Modify table columns, show CREATE table statements, set column and table options, Create and delete a table while Add and remove table columns.

• Table vs View
• MySQL CREATE Table
• MySQL ALTER Table
• MySQL Show Tables
• MySQL Rename Table
• MySQL TRUNCATE Table
• MySQL Describe Table
• MySQL DROP Table
• MySQL Temporary Table
• MySQL Copy Table
• MySQL Repair Table
• MySQL Add/Delete Column
• MySQL Show Columns
• MySQL Rename Column
• MySQL Views
• MySQL Table Locking
• MySQL Account Lock
• MySQL Account Unlock

In this module you will learn to Queries in MySQL, Running MySQL queries, enhance these queries to suit your particular scenario, MySQL query to retrieve data with example.

• MySQL Constraints
• MySQL INSERT Record
• MySQL UPDATE Record
• MySQL DELETE Record
• MySQL SELECT Record
• MySQL Replace
• MySQL Insert On Duplicate Key Update
• MySQL INSERT IGNORE
• MySQL Insert Into Select
• MySQL Subquery

In this module, you will learn MySQL data types with examples.

• MySQL BIT
• MySQL BOOLEAN
• MySQL CHAR
• MySQL DATE
• MySQL Date & Time
• MySQL DECIMAL
• MySQL ENUM
• MySQL INT
• MySQL JSON
• MySQL TIME
• MySQL TIMESTAMP
• MySQL VARCHAR

In this module you will learn MySQL indexes, types of indexes in MySQL, Leverage MySQL Database Indexing, Create indexes, keys, and constraints with best practices in MySQL Indexes.

• MySQL Create Index
• MySQL Drop Index
• MySQL Show Indexes
• MySQL Unique Index
• MySQL Clustered Index
• MySQL Clustered vs Non-Clustered Index

In this module, you will learn Comparison Functions and Operators, Create, operate, and scale self-healing MySQL and MySQL operators important.

• Arithmetic Operator
• Logical Operator
• Comparison Operators
• MySQL Wildcards

In this module, you will learn to retrieve database data using the SELECT statement from your database. Use the SELECT statement clauses: FROM, DISTINCT, WHERE, ORDER BY, and LIMIT, Create views and Query data from application code while exporting and importing a delimited file.

• MySQL WHERE
• MySQL DISTINCT
• MySQL FROM
• MySQL ORDER BY
• MySQL GROUP BY
• MySQL HAVING
• MySQL SELECT
• MySQL UPDATE
• MySQL INSERT
• MySQL DELETE
• MySQL UNION
• MySQL LIMIT
• MySQL LIKE

In this module, you will learn to explain the concept of a join, use the JOIN keyword to query multiple tables, execute inner and outer joins, use the UNION keyword to combine multiple queries.

• MySQL Inner Join
• MySQL Left Join
• MySQL Right Join
• MySQL CROSS JOIN
• MySQL SELF JOIN
• MySQL DELETE JOIN
• MySQL Update Join
• MySQL EquiJoin
• MySQL Natural Join
• MySQL Left Join vs Right Join
• MySQL Union vs Join
• MySQL Union vs Union All

In this module, you will learn triggers and how they can be used in MySQL, create the trigger in MySQL, different types of MySQL Triggers, use MySQL Triggers with Examples.

• MySQL Trigger
• MySQL Create Trigger
• MySQL Show Trigger
• MySQL DROP Trigger
• MySQL Before Insert Trigger
• MySQL After Insert Trigger
• MySQL BEFORE UPDATE Trigger
• MySQL AFTER UPDATE Trigger
• MySQL BEFORE DELETE Trigger
• MySQL AFTER DELETE Trigger

In this module you will learn MySQL Aggregate Functions description, a clause is used with aggregate functions in MySQL, aggregate function in MySQL like AVG, COUNT, SUM, MAX, MIN with the help of simple examples, while using built-in functions in MySQL.

• MySQL Aggregate Functions
• MySQL count()
• MySQL sum()
• MySQL avg()
• MySQL min()
• MySQL max()
• MySQL GROUP_CONCAT()
• MySQL first()
• MySQL last()
• MySQL IF()
• MySQL IFNULL()
• MySQL NULLIF()
• MySQL CASE
• MySQL IF Statement
• MySQL LEAD And LAG Function
• MySQL Stored Function
• MySQL Number Format Function
• MySQL Ranking Functions
• MySQL Window Functions
• MySQL Convert()
• MySQL COALESCE()

In this module you will learn MYSQL Regular Expressions (REGEXP) with Syntax, validate a regular expression in MySQL, correct syntax for regular expression, regular expression replace in MySQL, MySQL – REGEXP, RLIKE – Examples and Alternatives.

• MySQL Regular Expressions
• MySQL RLIKE
• MySQL Not Like Operator
• MySQL Not regexp Operator
• MySQL regexp Operator
• MySQL regexp_instr() Function
• MySQL regexp_like() Function
• MySQL regexp_replace() Function
• MySQL regexp_substr() Function

In this module, you will learn advanced MySQL tricks that will help you to automate your MySQL queries and do better data analysis using MySQL advanced functions.

• MySQL CHECK CONSTRAINT
• MySQL Derived Table
• MySQL UUID
• MySQL CTE
• MySQL On Delete Cascade
• MySQL UPSERT
• MySQL Transaction
• MySQL Partitioning
• MySQL ROW_NUMBER()
• MySQL Cursor
• MySQL Limit
• MySQL Signal Resignal
• MySQL ENUM
• MySQL SET
• MySQL CAST
• MySQL Alias
• MySQL ROLLUP
• MySQL INT
• MySQL Today
• MySQL ROW COUNT
• MySQL Prepared Statement
• MySQL Literals(Constants)

Web Scraping with Python

• Introduction to Web Scraping
• Setting Up Web Scraping Libraries
• Grabbing a Title, Grabbing a Class, Grabbing an Image
• Python Web Scraping – Book Examples Part One
• Python Web Scraping – Exercise Overview
• Python Web Scraping – Exercise Solutions

Images with Python

• Introduction to Images with Python
• Working with Images with Python
• Python Image Exercises – Overview
• Python Image Exercises – Solution

PDFs and Spreadsheet CSV Files

• Introduction to PDFs and Spreadsheets with Python
• Working with CSV Files in Python
• Working with PDF Files in Python
• PDFs and Spreadsheets Python Puzzle Exercise
• PDFs and Spreadsheets Python Puzzle Exercise – Solutions

Emails with Python

• Introduction to Emails with Python
• Sending Emails with Python
• Receiving Emails with Python