Title: MySQL

Title

MySQL

Package

+MS-Office und Programmierung (Zusatzmodul)

Platform

Your learning platform for SAP software

URL

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

Status

Current

Publication Type

Other

Medium

Empty

Language

First Author

Sez IT, Simon

First Editor

Empty

Publisher Name

Empty

Date First in Print

Empty

Date First Online

Empty

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