Udemy – MySQL Database Administration: Beginner SQL Database Design 2021-11

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. This course does NOT cover data exploration and database analysis. Our goal here is to focus on building, altering, and maintainin SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses)

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)

Who this course is for

• 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)

Specificatoin of MySQL Database Administration: Beginner SQL Database Design

• Publisher : Udemy
• Teacher : Maven Analytics , John Pauler
• Language : English
• Level : All levels
• Number of Course : 71
• Duration : 6 hours and 58 minutes

Content of 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

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : English

Quality: 720p

Download Links

Download Part 1 – 1 GB

Download Part 2 – 784 MB

File size

1.76 GB