MySQL Database Administration: Beginner SQL Database Design
MySQL Database Administration: Beginner SQL Database Design, available at $109.99, has an average rating of 4.52, with 76 lectures, 6 quizzes, based on 3219 reviews, and has 15947 subscribers.
You will learn about 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 This course is ideal for individuals who are Analysts or BI professionals looking to improve their understanding of relational database systems or Excel users looking to shift into a broader business intelligence or database-focused role or Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL) or Students looking for a hands-on and highly engaging introduction to MySQL for database administration or Anyone looking to pursue a career as a database administrator or NOTE: This course does NOT database analysis (we cover data analysis in a separate course) It is particularly useful for Analysts or BI professionals looking to improve their understanding of relational database systems or Excel users looking to shift into a broader business intelligence or database-focused role or Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL) or Students looking for a hands-on and highly engaging introduction to MySQL for database administration or Anyone looking to pursue a career as a database administrator or NOTE: This course does NOT database analysis (we cover data analysis in a separate course).
Enroll now: MySQL Database Administration: Beginner SQL Database Design
Summary
Title: MySQL Database Administration: Beginner SQL Database Design
Price: $109.99
Average Rating: 4.52
Number of Lectures: 76
Number of Quizzes: 6
Number of Published Lectures: 71
Number of Published Quizzes: 6
Number of Curriculum Items: 82
Number of Published Curriculum Objects: 77
Original Price: $129.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- 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)
Target Audiences
- 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)
If you’re looking to develop practical, real-world data analytics & business intelligence skills and learn the foundations of database administration (DBA) and analysis, 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 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!
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 video
-
Downloadable MySQL ebook and cheat sheets
-
Quizzes and homework assignments
-
Mid-course and Final SQL projects
-
30-day money-back guarantee
If 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 our full course library? Search “Maven Analytics” to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learningcourses!
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.
Course Curriculum
Chapter 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
Chapter 2: SQL & Relational Database Overview
Lecture 1: Introduction to SQL
Lecture 2: Relational Databases
Lecture 3: Relational Database Management Systems
Chapter 3: MySQL Intro & Setup
Lecture 1: MySQL Installation Overview
Lecture 2: Mac Download – MySQL Community Server
Lecture 3: Mac Download – MySQL Workbench
Lecture 4: PC Download – MySQL Community Server & MySQL Workbench
Lecture 5: Connecting Workbench To The Server
Lecture 6: MySQL Workbench Interface
Lecture 7: Creating Initial Schemas
Chapter 4: Creating and Altering Schemas & Tables
Lecture 1: Creating A Schema Using The UI
Lecture 2: Creating A Schema Using SQL Code
Lecture 3: Creating A Table Using The UI
Lecture 4: Creating A Table With A SQL Query
Lecture 5: MySQL Data Types
Lecture 6: Assignment: Creating Your Own Schema And Tables
Lecture 7: Solution: Creating Your Own Schema And Tables
Lecture 8: Adding and Removing Columns In The Editor
Lecture 9: Adding And Removing Columns With SQL Code
Lecture 10: Assignment: Adding And Removing Columns
Lecture 11: Solution: Adding And Removing Columns
Lecture 12: Dropping Schemas And Tables
Lecture 13: Assignment: Dropping Schemas And Tables
Lecture 14: Solution: Dropping Schemas And Tables
Chapter 5: Inserting, Updating, and Deleting Records
Lecture 1: Inserting Records Into A Table
Lecture 2: Updating Data Records
Lecture 3: Assignment: Inserting And Updating Records
Lecture 4: Solution: Inserting And Updating Records
Lecture 5: Deleting Specific Records
Lecture 6: Deleting All Records With Truncate
Lecture 7: Assignment: Deleting Records
Lecture 8: Solution: Deleting Records
Chapter 6: Database Design
Lecture 1: Primary Keys and Foreign Keys
Lecture 2: Primary Keys and Foreign Keys Demo
Lecture 3: Assignment: Table Relationships
Lecture 4: Solution: Table Relationships
Lecture 5: Database Normalization
Lecture 6: Database Normalization Demo
Lecture 7: Assignment: Normalization
Lecture 8: Solution: Normalization
Lecture 9: The EER Diagram Editor
Lecture 10: Assignment: EER Diagram Editor
Lecture 11: Solution: EER Diagram Editor
Chapter 7: Mid-Course Project
Lecture 1: Assignment: Mid Course Project
Lecture 2: Solution: Mid Course Project
Chapter 8: Advanced Concepts
Lecture 1: Creating An Index
Lecture 2: The Unique Constraint
Lecture 3: The Non Null Constraint
Lecture 4: Assignment: Indexes And Constraints
Lecture 5: Solution: Indexes And Constraints
Lecture 6: Stored Procedures
Lecture 7: Assignment: Stored Procedures
Lecture 8: Solution: Stored Procedures
Lecture 9: Triggers
Lecture 10: Assignment: Triggers
Lecture 11: Solution: Triggers
Chapter 9: Server & User Management
Lecture 1: Server Management
Lecture 2: Assignment: Server Management
Lecture 3: Solution: Server Management
Lecture 4: Managing Users And Permissions
Lecture 5: Assignment: Managing Users And Permissions
Lecture 6: Solution: Managing Users And Permissions
Chapter 10: Final Course Project
Lecture 1: Assignment: Final Course Project
Lecture 2: Solution: Final Course Project
Chapter 11: Wrapping Up
Lecture 1: Resources & Next Steps
Lecture 2: BONUS LESSON
Instructors
-
Maven Analytics
Empowering everyday people with life-changing data skills -
John Pauler
Analytics Expert
Rating Distribution
- 1 stars: 23 votes
- 2 stars: 32 votes
- 3 stars: 234 votes
- 4 stars: 1076 votes
- 5 stars: 1854 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024