MySQL Database Administration - SQL Database for Beginners (Udemy.com)
Learn Database Design with MySQL Workbench. SQL DBA for Beginners: A Relational Database Management System Introduction.
Created by: Maven Analytics
Produced in 2021
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
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 92 / 100
Course Description
See why John is one of theTOP-RATEDSQL/MySQLInstructors 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 MySQLand 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 both SQL courses from Maven Analytics and highly recommend both. 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 MySQLcourses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"- Steven M.______________________________COURSEDESCRIPTION:
If youre looking to develop practical, real-world analytics and BI skills, and learn how to create and maintain databases, youve come to the right place.
This course is unlike anything youve 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.
Youll 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, youll 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.______________________________COURSEOUTLINE:
SQLIntro &MySQLSetupFor 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 MySQLCommunity Server &MySQLWorkbench. We'll share download guides for both Mac & PC, and run our first piece of SQLcode 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 SQLcode and with the Workbench UItools. 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-COURSEPROJECT: 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. ***FINALCOURSEPROJECT: Design and build an entire database from scratch!
IMPORTANTNOTE:
This course does NOTcover data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQLWorkbench (we cover data analysis in-depth in separate courses).______________________________Enroll today and get LIFETIMEaccess to:
7 hours of high-quality videoDownloadable MySQLebook and cheat sheetsQuizzes and homework assignmentsMid-course and Final SQLprojects30-day money-back guaranteeIf youre 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 SQLInstructor &MySQLExpert, Maven Analytics)______________________________Looking for the full business intelligence stack? Search for "Maven Analytics"to browse our full course library, including Excel, Power BI, MySQL, andTableaucourses!
Who this course is for:
Analysts or BI professionals looking to improve their understanding of relational database systemsExcel users looking to shift into a broader business intelligence or database-focused roleAnyone seeking to learn one of the worlds most popular and powerful database programming languages (SQL)Students looking for a hands-on and highly engaging introduction to MySQL for database administrationAnyone looking to pursue a career as a database administratorNOTE: This course does NOT database analysis (we cover data analysis in a separate course)
If youre looking to develop practical, real-world analytics and BI skills, and learn how to create and maintain databases, youve come to the right place.
This course is unlike anything youve 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.
Youll 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, youll 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.______________________________COURSEOUTLINE:
SQLIntro &MySQLSetupFor 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 MySQLCommunity Server &MySQLWorkbench. We'll share download guides for both Mac & PC, and run our first piece of SQLcode 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 SQLcode and with the Workbench UItools. 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-COURSEPROJECT: 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. ***FINALCOURSEPROJECT: Design and build an entire database from scratch!
IMPORTANTNOTE:
This course does NOTcover data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQLWorkbench (we cover data analysis in-depth in separate courses).______________________________Enroll today and get LIFETIMEaccess to:
7 hours of high-quality videoDownloadable MySQLebook and cheat sheetsQuizzes and homework assignmentsMid-course and Final SQLprojects30-day money-back guaranteeIf youre 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 SQLInstructor &MySQLExpert, Maven Analytics)______________________________Looking for the full business intelligence stack? Search for "Maven Analytics"to browse our full course library, including Excel, Power BI, MySQL, andTableaucourses!
Who this course is for:
Analysts or BI professionals looking to improve their understanding of relational database systemsExcel users looking to shift into a broader business intelligence or database-focused roleAnyone seeking to learn one of the worlds most popular and powerful database programming languages (SQL)Students looking for a hands-on and highly engaging introduction to MySQL for database administrationAnyone looking to pursue a career as a database administratorNOTE: This course does NOT database analysis (we cover data analysis in a separate course)
Instructor Details
- 4.6 Rating
130 Reviews
Maven Analytics
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.
Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Learning new skills shouldnt be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.
More courses by Maven Analytics
Microsoft Excel - Data Analysis with Excel Pivot Tables (2021)
4.8 (412 Reviews)
Provider: Udemy
Time: 6.5h
$11.99
Microsoft Excel - Advanced Excel Formulas & Functions (2021)
4.7 (412 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel - Data Visualization, Excel Charts & Graphs (2021)
4.7 (412 Reviews)
- Provider: Udemy
- Time: 4.5h
$11.99
Excel PRO TIPS: 75+ Tips to go from Excel Beginner to Pro (2021)
4.8 (410 Reviews)
- Provider: Udemy
- Time: 10.5h
$11.99
Microsoft Power BI - Up & Running With Power BI Desktop (2021)
4.8 (312 Reviews)
- Provider: Udemy
- Time: 10.5h
$11.99
Microsoft Power BI - Publishing to Power BI Service (2021)
4.6 (296 Reviews)
- Provider: Udemy
- Time: 4h
$11.99
More mysql courses
PHP 7 y MYSQL: El Curso Completo, Prctico y Desde Cero ! (2019)
4.7 (310 Reviews)
- Provider: Udemy
- Time: 20h
$11.99
Create a Netflix clone from Scratch: JavaScript PHP + MySQL (2019)
4.7 (100 Reviews)
- Provider: Udemy
- Time: 11.5h
$11.99
E-Commerce Website in PHP & MySQL From Scratch! (2021)
4.3 (312 Reviews)
- Provider: Udemy
- Time: 7.5h
$11.99
Reviews
- Video Duration:
7h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
