MySQL Database Administration Beginner SQL Database Design

Learn Database Design with MySQL Workbench. SQL DBA for Beginners: A Relational Database Management System Introduction.
MySQL Database Administration Beginner SQL Database Design
File Size :
2.08 GB
Total length :
6h 58m

Category

Instructor

Maven Analytics

Language

Last update

Last updated 11/2022

Ratings

4.6/5

MySQL Database Administration Beginner SQL Database Design

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)
Get LIFETIME access to resource files, quizzes, assignments, and expert support

MySQL Database Administration Beginner SQL Database Design

Requirements

MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free install process)
Basic understanding of database fundamentals encouraged, but not required

Description

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.COURSE OUTLINE:SQL Intro & MySQL SetupFor 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 RecordsAfter 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 DesignNow 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 ConceptsIn 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 ManagementIn 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! IMPORTANT NOTE: This course does NOT cover data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).______________________________Enroll today and get LIFETIME access to:7 hours of high-quality videoDownloadable MySQL ebook and cheat sheetsQuizzes and homework assignmentsMid-course and Final SQL projects30-day money-back guaranteeIf you’re looking for a hands-on, practical guide to mastering database administration skills using SQL/MySQL, this is the course for you!Happy administering!-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)______________________________Looking for the full business intelligence stack? Search for “Maven Analytics” to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:”I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn’t want to stop learning — I wanted to keep charging on to the next lesson!”- Ann S.”This is an excellent advanced course! I’ve taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It’s much easier to grasp the concepts when you can see how they’re literally applied to scenarios and outcomes as opposed to just theory. Great work!”- Dan S.”John’s deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I’ve taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!”- Steven M.

Overview

Section 1: Getting Started

Lecture 1 Introduction

Lecture 2 READ ME: Important Notes for New Students

Lecture 3 DOWNLOAD: Course Resources

Lecture 4 Introducing The Course Project

Lecture 5 Setting Expectations

Section 2: SQL & Relational Database Overview

Lecture 6 Introduction to SQL

Lecture 7 Relational Databases

Lecture 8 Relational Database Management Systems

Section 3: MySQL Intro & Setup

Lecture 9 MySQL Installation Overview

Lecture 10 Mac Download – MySQL Community Server

Lecture 11 Mac Download – MySQL Workbench

Lecture 12 PC Download – MySQL Community Server & MySQL Workbench

Lecture 13 Connecting Workbench To The Server

Lecture 14 MySQL Workbench Interface

Lecture 15 Creating Initial Schemas

Section 4: Creating and Altering Schemas & Tables

Lecture 16 Creating A Schema Using The UI

Lecture 17 Creating A Schema Using SQL Code

Lecture 18 Creating A Table Using The UI

Lecture 19 Creating A Table With A SQL Query

Lecture 20 MySQL Data Types

Lecture 21 Assignment: Creating Your Own Schema And Tables

Lecture 22 Solution: Creating Your Own Schema And Tables

Lecture 23 Adding and Removing Columns In The Editor

Lecture 24 Adding And Removing Columns With SQL Code

Lecture 25 Assignment: Adding And Removing Columns

Lecture 26 Solution: Adding And Removing Columns

Lecture 27 Dropping Schemas And Tables

Lecture 28 Assignment: Dropping Schemas And Tables

Lecture 29 Solution: Dropping Schemas And Tables

Section 5: Inserting, Updating, and Deleting Records

Lecture 30 Inserting Records Into A Table

Lecture 31 Updating Data Records

Lecture 32 Assignment: Inserting And Updating Records

Lecture 33 Solution: Inserting And Updating Records

Lecture 34 Deleting Specific Records

Lecture 35 Deleting All Records With Truncate

Lecture 36 Assignment: Deleting Records

Lecture 37 Solution: Deleting Records

Section 6: Database Design

Lecture 38 Primary Keys and Foreign Keys

Lecture 39 Primary Keys and Foreign Keys Demo

Lecture 40 Assignment: Table Relationships

Lecture 41 Solution: Table Relationships

Lecture 42 Database Normalization

Lecture 43 Database Normalization Demo

Lecture 44 Assignment: Normalization

Lecture 45 Solution: Normalization

Lecture 46 The EER Diagram Editor

Lecture 47 Assignment: EER Diagram Editor

Lecture 48 Solution: EER Diagram Editor

Section 7: Mid-Course Project

Lecture 49 Assignment: Mid Course Project

Lecture 50 Solution: Mid Course Project

Section 8: Advanced Concepts

Lecture 51 Creating An Index

Lecture 52 The Unique Constraint

Lecture 53 The Non Null Constraint

Lecture 54 Assignment: Indexes And Constraints

Lecture 55 Solution: Indexes And Constraints

Lecture 56 Stored Procedures

Lecture 57 Assignment: Stored Procedures

Lecture 58 Solution: Stored Procedures

Lecture 59 Triggers

Lecture 60 Assignment: Triggers

Lecture 61 Solution: Triggers

Section 9: Server & User Management

Lecture 62 Server Management

Lecture 63 Assignment: Server Management

Lecture 64 Solution: Server Management

Lecture 65 Managing Users And Permissions

Lecture 66 Assignment: Managing Users And Permissions

Lecture 67 Solution: Managing Users And Permissions

Section 10: Final Course Project

Lecture 68 Assignment: Final Course Project

Lecture 69 Solution: Final Course Project

Section 11: Wrapping Up

Lecture 70 Resources & Next Steps

Lecture 71 BONUS LESSON

Analysts or BI professionals looking to improve their understanding of relational database systems,Excel users looking to shift into a broader business intelligence or database-focused role,Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL),Students looking for a hands-on and highly engaging introduction to MySQL for database administration,Anyone looking to pursue a career as a database administrator,NOTE: This course does NOT database analysis (we cover data analysis in a separate course)

Course Information:

Udemy | English | 6h 58m | 2.08 GB
Created by: Maven Analytics

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top