MySQL

Part of:

Simon Sez IT

Language

English

Duration

05:36:31

Level

Beginner

Flat rate

$19 per month

Single license
1000+ eBooks and video tutorials
Instant access
12 months($228per year)
Automatic renewal

More options

Already have an account? Sign in here!

More Details

Chapter 1: IntroductionCourse Outline and Intro to MySQL and Database
MySQL Architecture and Installation of MySQL
Installation Demo - Part 1
Installation Demo - Part 2

Chapter 2: Database Design

Database Design
MySQL Workbench Download
Database Table and Constraints
Database Designing and Normalization - Part 1
Database Designing and Normalization - Part 2
Storage and Data Types
Data Types Demo
ACID and Transactions
Locks, Deadlocks, Isolation Levels and Logging
Isolation Levels and Locking Demo
Locking Mechanism Demo and MySQL ACID Support

Chapter 3: Administration

Responsibilities of a Database Administrator
Creating a User and Limiting Access to a Database; Basic Table Maintainance Function
Protecting your Database; How to Perform Database Backup
Performance Monitoring

Chapter 4: Indexing for Performance

InnoDB Indexing and Clustered vs. Unclustered Index
Query and Where Clause
Impact of Indexing on Database Performance
Performance Optimization

Chapter 5: SQL for Developers

Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
Data Definition Language; How to Create Database Objects
SQL Select Statements
SQL Select Statements Demo
Joins
Combining Related Table Using Joins
Insert, Update and Delete Commands
Insert, Update, and Delete Commands Demo

Chapter 6: Query Analysis and Optimization

Query Optimization
Query Optimization Demo

Chapter 7: Data Replication

Database Replication
Setting Up Replication in MySQL
Data Encryption
Column-Level Database Encryption Demo
High Availability

Chapter 8: Conclusion

Authors

Simon Sez IT More about the author

Frequentlyasked questions

General questions and answers about our learning content.

Who is the learning content suitable for?

The learning content is designed for anyone who wants to gain SAP knowledge in a simple, compact, and practical way. Our learning platform offers content for beginners, advanced learners, and experts. This enables you to expand your knowledge step by step and continuously develop your skills toward becoming an SAP expert.

What makes the learning content special?

Our products—whether books, videos, or online training—deliver SAP knowledge concisely and practically, so you can apply it directly in your daily work, even if you have limited time. You benefit from a broad coverage of relevant SAP topics, high-quality content in four languages, and learning formats designed to fit your individual needs. This ensures that you can stay up to date and continuously develop your expertise.

What distinguishes our books from those of other providers?

Our books are characterized by a clear practical focus and a compact, easy-to-understand presentation. We explain complex SAP topics concisely—without unnecessary marketing buzzwords—so readers can quickly grasp the essentials and apply the new knowledge directly.

Can the product be exchanged?

Our print books can be returned within 14 days, in original condition. Return shipping is at your own cost.

How can I order a book outside of Germany?

We currently only ship books directly within Germany. If you are ordering from outside Germany, we recommend purchasing via Amazon. You can find the link by selecting “Buy eBook” on any product in our webshop and Amazon will then show you both the eBook and print versions available for purchase.

Alternatively, you can access all our content with a digital subscription, starting at $19 per month.

Who can I contact if I have questions?

Our team is always happy to help and will respond to your questions as quickly as possible (usually within 1–2 days). You can also contact us if you have questions for one of the authors. Email: contact@espresso-tutorials.com