Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-20 21:05:12
30-Day Money-Back Guarantee

This course includes:

  • 7 hours on-demand video
  • 4 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development Database Administration

MySQL Database Administration - SQL Database for Beginners

Learn Database Design with MySQL Workbench. SQL DBA for Beginners: A Relational Database Management System Introduction.
Bestseller
Rating: 4.6 out of 54.6 (725 ratings)
4,393 students
Created by Maven Analytics, John Pauler - SQL | MySQL | Data Analysis
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

Course content

11 sections • 71 lectures • 6h 58m total length

  • Preview01:51
  • READ ME: Important Notes for New Students
    01:54
  • DOWNLOAD: Course Resources
    00:15
  • Preview01:11
  • Preview02:21

  • Introduction to SQL
    02:25
  • Relational Databases
    02:03
  • Relational Database Management Systems
    01:40
  • QUIZ: SQL & Relational Database Overview
    5 questions

  • MySQL Installation Overview
    01:45
  • Mac Download Community Server
    04:53
  • Mac Download MySQL Workbench
    02:50
  • PC Download Community Server Workbench
    07:41
  • Connecting Workbench To The Server
    02:20
  • MySQL Workbench Interface
    10:47
  • Creating Initial Schemas
    04:08

  • Creating A Schema Using The UI
    02:58
  • Creating A Schema Using SQL Code
    04:27
  • Creating A Table Using The UI
    06:52
  • Creating A Table With A SQL Query
    06:03
  • MySQL Data Types
    05:40
  • Preview02:28
  • Preview12:01
  • Adding and Removing Columns In The Editor
    13:39
  • Adding And Removing Columns With SQL Code
    05:04
  • Assignment: Adding And Removing Columns
    01:25
  • Solution: Adding And Removing Columns
    06:59
  • Dropping Schemas And Tables
    06:45
  • Assignment: Dropping Schemas And Tables
    01:46
  • Solution: Dropping Schemas And Tables
    02:22
  • QUIZ: Creating and Altering Schemas & Tables
    5 questions

  • Inserting Records Into A Table
    08:00
  • Updating Data Records
    07:33
  • Assignment: Inserting And Updating Records
    01:30
  • Solution: Inserting And Updating Records
    07:30
  • Deleting Specific Records
    09:41
  • Deleting All Records With Truncate
    10:28
  • Assignment: Deleting Records
    01:32
  • Solution: Deleting Records
    08:16
  • QUIZ: Inserting, Updating, and Deleting Records
    5 questions

  • Primary Keys and Foreign Keys
    09:30
  • Primary Keys and Foreign Keys Demo
    12:46
  • Assignment: Table Relationships
    01:29
  • Solution: Table Relationships
    09:50
  • Database Normalization
    02:40
  • Database Normalization Demo
    14:36
  • Assignment: Normalization
    01:44
  • Solution: Normalization
    05:50
  • The EER Diagram Editor
    19:13
  • Assignment: EER Diagram Editor
    01:23
  • Solution: EER Diagram Editor
    11:34
  • QUIZ: Database Design
    5 questions

  • Assignment: Mid Course Project
    01:37
  • Solution: Mid Course Project
    28:18

  • Creating An Index
    04:41
  • The Unique Constraint
    04:08
  • The Non Null Constraint
    04:00
  • Assignment: Indexes And Constraints
    01:12
  • Solution: Indexes And Constraints
    09:24
  • Stored Procedures
    06:27
  • Assignment: Stored Procedures
    02:03
  • Solution: Stored Procedures
    04:24
  • Triggers
    07:50
  • Assignment: Triggers
    01:41
  • Solution: Triggers
    05:08
  • QUIZ: Advanced Concepts
    5 questions

  • Server Management
    04:09
  • Assignment: Server Management
    00:59
  • Solution: Server Management
    01:46
  • Managing Users And Permissions
    08:05
  • Assignment: Managing Users And Permissions
    01:13
  • Solution: Managing Users And Permissions
    03:09
  • QUIZ: Server & User Management
    4 questions

  • Assignment: Final Course Project
    01:50
  • Solution: Final Course Project
    43:11

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

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 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 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 the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

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)

Featured review

Sandra Schultz
Sandra Schultz
32 courses
8 reviews
Rating: 5.0 out of 55 months ago
Am enjoying this course. I had instructors 10 years ago with little to no business experience in software development, mainly academic work. As a result, this course is doing an excellent job expanding their work. You've added a wonderful dimension with your years of real life experience.

Instructors

Maven Analytics
Award-Winning Analytics & Business Intelligence Training
Maven Analytics
  • 4.6 Instructor Rating
  • 138,603 Reviews
  • 427,746 Students
  • 19 Courses

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 shouldn’t 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.

John Pauler - SQL | MySQL | Data Analysis
Analytics Expert
John Pauler - SQL | MySQL | Data Analysis
  • 4.7 Instructor Rating
  • 5,396 Reviews
  • 34,970 Students
  • 4 Courses

Over a decade of Analytics experience for companies ranging from Fortune 500 to early stage startups. I work with data from websites, customers, marketing channels, and software products. I have been a pure play Analyst, and I have also led large Marketing P&Ls and served as a Product Owner. Throughout it all, I've made data mastery a pillar of my career, and am excited to share my experience on Udemy.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.