MySQL Database Administration – SQL Database for Beginners

MySQL Database Administration – SQL Database for Beginners

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 7 Hours | 2.20 GB

Learn Database Design with MySQL Workbench. SQL DBA for Beginners: A Relational Database Management System Introduction.

If you’re looking to develop practical, real-world analytics and BI skills, and learn how to create and maintain databases, you’ve come to the right place.

This course is unlike anything you’ve seen before, guaranteed. We’ll start from the ground up, teaching you the tools to get the job done, and most importantly how to you apply your skills to real projects and learn how to truly think like a Database Administrator.

You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases. Throughout the course, you’ll be working directly with the owners of various companies to help them manage data in their new and scaling enterprises. You will use the skills you learn to complete actual projects that database administration professionals work on every day.

SQL Intro & MySQL Setup

For students who haven’t completed one of our other SQL courses, we’ll demonstrate exactly how to download and install the tools that we’ll need to access MySQL, including MySQL Community Server & MySQL Workbench. We’ll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we’ll analyze throughout the course.

Creating, Altering, and Deleting Schemas & Tables

In this section we’ll learn how to create schemas and tables using SQL code and with the Workbench UI tools. Then, we will learn how to alter tables by adding and removing columns. Finally, we will walk through dropping schemas and tables (be careful with this one).

Inserting, Updating, and Deleting Records

After we get up to speed creating and altering tables, we will learn how to populate those tables with records of data, and update and delete records as needed.

Database Design

Now that we have covered the basic mechanics, we will learn how tables relate to one another optimally, and discuss best practices for database design. We will explore the EER Diagram Editor, and you will have some opportunities to create your own database models.

MID-COURSE PROJECT: Normalize this database for your client!

Advanced Concepts
In this section, we will get into concepts like adding an index to a column, imposing constraints, and creating stored procedures and triggers. This is powerful stuff!

Server & User Management
In our last section before the Final Project, we will learn how to monitor servers to make sure they are running, and how to restart them when needed. You will also get your hands on user management tools to assign roles and manage permissions, just like a real DBA.

FINAL COURSE PROJECT: Design and build an entire database from scratch!

What you’ll learn

  • Write SQL queries and use the MySQL Workbench UI to create databases and tables
  • Learn how to alter tables by adding and removing columns
  • Connect data between tables by creating primary and foreign key relationships
  • Assign user roles and permissions to database users, just like a real DBA
  • Solve practical hands-on assignments and real-world business use cases
  • Master unique tips, tools and case studies that you won’t find anywhere else
  • Understand common Relational Database Management Systems (RDBMS)

+ Table of Contents

Getting Started
1 Introduction
2 READ ME Important Notes for New Students
3 DOWNLOAD Course Resources
4 Introducing The Course Project
5 Setting Expectations

SQL & Relational Database Overview
6 Introduction to SQL
7 Relational Databases
8 Relational Database Management Systems

MySQL Intro & Setup
9 MySQL Installation Overview
10 Mac Download Community Server
11 Mac Download MySQL Workbench
12 PC Download Community Server Workbench
13 Connecting Workbench To The Server
14 MySQL Workbench Interface
15 Creating Initial Schemas

Creating and Altering Schemas & Tables
16 Creating A Schema Using The UI
17 Creating A Schema Using SQL Code
18 Creating A Table Using The UI
19 Creating A Table With A SQL Query
20 MySQL Data Types
21 Assignment Creating Your Own Schema And Tables
22 Solution Creating Your Own Schema And Tables
23 Adding and Removing Columns In The Editor
24 Adding And Removing Columns With SQL Code
25 Assignment Adding And Removing Columns
26 Solution Adding And Removing Columns
27 Dropping Schemas And Tables
28 Assignment Dropping Schemas And Tables
29 Solution Dropping Schemas And Tables

Inserting, Updating, and Deleting Records
30 Inserting Records Into A Table
31 Updating Data Records
32 Assignment Inserting And Updating Records
33 Solution Inserting And Updating Records
34 Deleting Specific Records
35 Deleting All Records With Truncate
36 Assignment Deleting Records
37 Solution Deleting Records

Database Design
38 Primary Keys and Foreign Keys
39 Primary Keys and Foreign Keys Demo
40 Assignment Table Relationships
41 Solution Table Relationships
42 Database Normalization
43 Database Normalization Demo
44 Assignment Normalization
45 Solution Normalization
46 The EER Diagram Editor
47 Assignment EER Diagram Editor
48 Solution EER Diagram Editor

Mid-Course Project
49 Assignment Mid Course Project
50 Solution Mid Course Project

Advanced Concepts
51 Creating An Index
52 The Unique Constraint
53 The Non Null Constraint
54 Assignment Indexes And Constraints
55 Solution Indexes And Constraints
56 Stored Procedures
57 Assignment Stored Procedures
58 Solution Stored Procedures
59 Triggers
60 Assignment Triggers
61 Solution Triggers

Server & User Management
62 Server Management
63 Assignment Server Management
64 Solution Server Management
65 Managing Users And Permissions
66 Assignment Managing Users And Permissions
67 Solution Managing Users And Permissions

Final Course Project
68 Assignment Final Course Project
69 Solution Final Course Project

Wrapping Up
70 Resources & Next Steps
71 BONUS LECTURE More from Maven Analytics