Title: MySQL

Title

MySQL

Package

Digitale SAP-Bibliothek

Platform

Your learning platform for SAP software

URL

https://et.training/dashboard/product/video/840 

Status

Deleted

Publication Type

Other

Medium

Empty

Language

First Author

Simon Sez IT

First Editor

Empty

Publisher Name

Empty

Date First in Print

Empty

Date First Online

2021-01-01

Access Start Date

Empty

Access End Date

Empty

Volume Number

Empty

Edition Statement

Empty

Access Type

Empty

Note

"Chapter 1: IntroductionCourse Outline and Intro to MySQL and DatabaseMySQL Architecture and Installation of MySQLInstallation Demo - Part 1Installation Demo - Part 2Chapter 2: Database DesignDatabase DesignMySQL Workbench DownloadDatabase Table and ConstraintsDatabase Designing and Normalization - Part 1Database Designing and Normalization - Part 2Storage and Data TypesData Types DemoACID and TransactionsLocks, Deadlocks, Isolation Levels and LoggingIsolation Levels and Locking DemoLocking Mechanism Demo and MySQL ACID SupportChapter 3: AdministrationResponsibilities of a Database AdministratorCreating a User and Limiting Access to a Database; Basic Table Maintainance FunctionProtecting your Database; How to Perform Database BackupPerformance MonitoringChapter 4: Indexing for PerformanceInnoDB Indexing and Clustered vs. Unclustered Index Query and Where Clause Impact of Indexing on Database Performance Performance Optimization Chapter 5: SQL for DevelopersChar 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 OptimizationQuery Optimization Query Optimization Demo Chapter 7: Data ReplicationDatabase Replication Setting Up Replication in MySQL Data Encryption Column-Level Database Encryption Demo High Availability Chapter 8: Conclusion"

Last Changed External

Empty