Mysql Database Training For Beginners

What you'll learn
Understanding MySQL architecture and installation of MySQL
Learning database design
Administration of a database
Using indexing for database performance
Discover SQL for Developers
Understanding query analysis and optimization
Setting up replication in MySQL
Requirements
A computer
Description
Discover how to use MySQL, a popular choice of database for use in powerful web applications!
During this 5.5-hour MySQL beginner course, discover the fundamental concepts beginner MySQL administrators need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics.
Follow along as you learn how to install MySQL for the first time. Discover critical concepts for designing a database. Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring. Then get ready to take your MySQL skills to the next level as you learn SQL for developers, database replication, data encryption and more.
This course includes a certificate of completion, and quiz.What People Are Saying
★★★★★ "Good overview, good pace. I like the trainer's manner and style of presenting." – Rik Williams
★★★★★ "This course is very informative. It could go into a little more detail when looking at the codes because as a beginner I find myself pausing frequently to figure out where the instructor has navigated between query screens. Overall I think this course is very valuable." -Sam Marotta
★★★★★ "Very thorough Explanation of the basic concepts. A bit dry at times but certainly necessary. Great examples to underline the theory" -Jürg Horisberger
Overview
Section 1: Introduction
Lecture 1 Course Outline and Intro to MySQL and Database
Lecture 2 READ ME: Essential Information for a Successful Training Experience
Lecture 3 MySQL Architecture and Installation of MySQL
Lecture 4 Installation Demo - Part 1
Lecture 5 Installation Demo - Part 2
Section 2: Database Design
Lecture 6 Database Design
Lecture 7 MySQL Workbench Download
Lecture 8 Database Table and Constraints
Lecture 9 Database Designing and Normalization - Part 1
Lecture 10 Database Designing and Normalization - Part 2
Lecture 11 Storage and Data Types
Lecture 12 Data Types Demo
Lecture 13 ACID and Transactions
Lecture 14 Locks, Deadlocks, Isolation Levels and Logging
Lecture 15 Isolation Levels and Locking Demo
Lecture 16 Locking Mechanism Demo and MySQL ACID Support
Section 3: Administration
Lecture 17 Responsibilities of a Database Administrator
Lecture 18 Creating a User and Limiting Access to a Database; Basic Maintainance Function
Lecture 19 Protecting your Database; How to Perform Database Backup
Lecture 20 Performance Monitoring
Section 4: Indexing for Performance
Lecture 21 Course Review
Lecture 22 InnoDB Indexing and Clustered vs. Unclustered Index
Lecture 23 Query and Where Clause
Lecture 24 Impact of Indexing on Database Performance
Lecture 25 Performance Optimization
Section 5: SQL for Developers
Lecture 26 Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
Lecture 27 Data Definition Language; How to Create Database Objects
Lecture 28 SQL Select Statements
Lecture 29 SQL Select Statements Demo
Lecture 30 Joins
Lecture 31 Combining Related Table Using Joins
Lecture 32 Insert, Update and Delete Commands
Lecture 33 Insert, Update, and Delete Commands Demo
Section 6: Query Analysis and Optimization
Lecture 34 Query Optimization
Lecture 35 Query Optimization Demo
Section 7: Data Replication
Lecture 36 Database Replication
Lecture 37 Setting Up Replication in MySQL
Lecture 38 Data Encryption
Lecture 39 Column-Level Database Encryption Demo
Lecture 40 High Availability
Section 8: Conclusion
Lecture 41 Closing
Web developers,Anyone new to databases


Homepage

https://www.udemy.com/course/mysql-database-training-course/