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 CompTIA Security+ Amazon AWS 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 Personal Transformation Meditation Life Purpose Emotional Intelligence 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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis 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
30-Day Money-Back Guarantee
Development Database Design & Development MySQL

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!
Rating: 4.5 out of 54.5 (883 ratings)
19,272 students
Created by John Thompson
Last updated 11/2019
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Become a SQL Guru! Be that 'go-to' person!
  • Master SQL to create reports from realistic MySQL databases
  • See how to aggregate and analyze data using SQL functions
  • Create your own database through the power of SQL
  • Understand How to Leverage Database Transactions
  • Tune SQL statements for optimum performance
  • Avoid common mistakes with SQL

Course content

16 sections • 166 lectures • 11h 1m total length

  • Preview04:04
  • Slack Group for SQL Beginner to Guru MySQL Edition
    00:49
  • Preview07:46
  • Preview03:17

  • Preview01:03
  • Preview08:35
  • Preview13:08
  • Preview02:33
  • Preview03:27
  • History of SQL
    13:31
  • What is a Relational Database Management System?
    11:19
  • History of MySQL
    10:41
  • RDBMS Deployment Architectures
    09:25
  • Flashcards
    04:52
  • Conclusion
    00:35

  • Preview01:45
  • Review of MySQL Installation Options
    03:26
  • Preview00:38
  • Preview06:07
  • Preview01:03
  • Preview06:05
  • MySQL Linux Installation Quick Start
    01:11
  • MySQL Linux Installation Ubuntu
    03:21
  • MySQL Linux Installation CentOS
    04:51

  • Preview01:17
  • Connecting to MySQL Overview
    07:45
  • MySQL Command Line for OSX and Linux
    05:06
  • MySQL Command Line for Docker
    07:47
  • Preview00:37
  • Preview00:19
  • MySQL Workbench OSX Installation
    07:14
  • MySQL Workbench Linux Installation Quick Start
    00:50
  • MySQL Workbench Linux Installation
    00:00

  • Preview02:51
  • Preview06:44
  • Preview00:47
  • Quiz - SQL Row Counts
    6 questions
  • Preview02:22
  • Preview05:13
  • Preview01:56
  • Preview02:54
  • Preview02:26
  • Preview02:26
  • Preview07:14
  • Preview16:24
  • Preview06:45
  • Using the LEFT and RIGHT MySQL Functions
    04:02
  • SQL Select Clause Quiz
    7 questions
  • Introduction to the SQL WHERE Clause
    08:44
  • SQL WHERE Clause with Equals and Not Equals
    03:19
  • Using AND and OR with SQL WHERE Clause
    03:52
  • Using IN and NOT IN with with SQL WHERE Clause
    05:03
  • Dealing with NULL Values in SQL WHERE Clause
    03:27
  • Using Greater Than and Less Than with SQL WHERE Clause
    04:00
  • Using LIKE and NOT LIKE with SQL WHERE Clause
    03:49
  • Using BETWEEN and NOT BETWEEN with SQL WHERE Clause
    04:30
  • Ordering Results with SQL ORDER BY
    04:30
  • Limit Results with SQL LIMIT Clause
    06:19
  • Using SQL to Select DISTINCT Values
    02:12
  • Using SQL Sub-selects with IN in SQL Where Clause
    03:12
  • Assignment - Fix SQL Statements
    02:05
  • Assignment Review
    08:44
  • Conclusion
    02:18

  • Preview01:00
  • Preview02:49
  • Preview02:03
  • Using the SQL HAVING Clause
    04:17
  • Using the SQL SUM Function
    02:00
  • Using the SQL Min and Max Functions
    05:50
  • Using the SQL AVG Function
    03:55
  • Assignment - Write SQL Report for Salary Information by Year Excluding Managers
    01:58
  • Salary Report Quiz
    3 questions
  • Assignment Review
    04:12
  • Conclusion
    00:34

  • Preview01:15
  • Preview05:13
  • Preview03:34
  • Using Table Aliases with SQL Inner Joins
    03:38
  • Limiting Columns Displayed with SQL Inner Joins
    03:02
  • Using a WHERE Clause with SQL Inner Joins
    04:33
  • Assignment - Create Department Employee Report
    01:44
  • Assignment Review - Create Department Employee Report
    06:52
  • Using SQL Natural Joins
    03:10
  • Using SQL Equi-Joins
    04:48
  • Using SQL Union Joins
    05:04
  • Other MySQL Functions
    08:55
  • Using SQL LEFT OUTER JOINS
    05:09
  • Assignment - Write SQL LEFT OUTER JOIN
    01:32
  • Assignment Review - Write SQL LEFT OUTER JOIN
    06:13
  • Conclusion
    01:31

  • Preview00:44
  • Preview02:44
  • Preview02:38
  • Specifying Columns in SQL Inserts
    04:05
  • Assignment - Use SQL to create a record in DEPARTMENTS table
    00:45
  • Assignment Review - Use SQL to create a record in DEPARTMENTS table
    05:07
  • Using a SQL Sub-select with SQL Insert Statements
    04:02
  • SQL Core Concept - Foreign Key Constraints
    04:24
  • Preview00:51
  • Assignment Review - Use SQL Inserts to create a new Employee
    06:23
  • Conclusion
    00:59

  • Preview01:23
  • Preview03:55
  • Preview03:07
  • Assignment - Use SQL Update Statement to Change Employee Name
    00:48
  • Assignment Review - Use SQL Update Statement to Change Employee Name
    02:22
  • Assignment - Using SQL Update and Insert to Create a New Salary Record
    01:40
  • Assignment Review - Using SQL Update and Insert to Create a New Salary Record
    03:35
  • Using SQL to drop the employee database
    02:49
  • Assignment - Re-import the employee database
    00:43
  • Assignment - Review re-import employee database
    03:26
  • Conclusion
    00:40

  • Preview01:00
  • Overview of the SQL DELETE statement
    02:33
  • Example of the SQL DELETE Statement
    09:42
  • Assignment - Create, Update, and Delete an Employee record
    01:20
  • Assignment Review - Create, Update, and Delete an Employee Record
    04:05
  • Conclusion
    00:36

Requirements

  • Just a computer - Any modern PC, Mac or Linux system will work!
  • Fundamental computer skills are helpful (you understand what files and directories are)

Description

SQL is the programming language used to get data in and out of databases. Relational Databases are extremely popular with companies of all sizes.

Employers are searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'. You will see 10's of THOUSANDS of job postings.

Right now these positions are going unfilled - because companies cannot find enough people with SQL skills.

In this course, you will learn how to use SQL using the MySQL relational database - the most popular database in the world.

No previous SQL experience is needed. This course is perfect for beginners. 

In this course, you will:

  • Learn how to install MySQL on your computer.

  • Learn how to install MySQL Workbench on your computer.

  • See how to import the famous MySQL employee database into your MySQL database.

  • Get hands on experience generating SQL reports.

  • Master SQL join statements.

  • Create table joins using database tables with MILLIONS of records!

  • See how easy it is to use SQL to update one record or many records in the database.

  • Learn to use SQL Sub-Selects.

  • Write advanced SQL reports against a ecommerce database.

  • Understand what database transactions are, and the tools you have to control them with MySQL.

  • Use SQL to create tables in your MySQL database.

  • Learn the MySQL syntax to alter existing database tables.

  • Tackle challenging real world like assignments for SQL reporting and database maintenance tasks. 

  • Leverage using SQL views for common reports.

Course Extras

  • Slack Community - Join the instructor, teacher's assistants, and other students in a Slack Community exclusive to this course!

  • All Source Code in GitHub - Get access to all source code used in course via GitHub (no experience with GitHub necessary)

  • All Lecture Slides Downloadable as PDFs - Download lecture slides for study and future reference!

Other Databases?

This course is focused on using SQL with the MySQL database. 

SQL is a standard, which which is supported by many other databases. The SQL skills you learn in this course can be applied to other databases such as Postgres, Oracle, and MS SQL Server.

There is a ton of demand for people with SQL skills. In the US, there are over 100,000 job openings for people with SQL skills.

Through this course, you will master SQL. 

Open the door to new opportunities and enroll today!

Who this course is for:

  • Anyone wishing to learn how to use SQL!

Instructor

John Thompson
Spring Framework Guru - Best Selling Instructor
John Thompson
  • 4.4 Instructor Rating
  • 32,525 Reviews
  • 185,377 Students
  • 17 Courses

Hi. I'm John.

I've been in the IT industry for over 20 years. Today, I specialize mainly in Java, the most successful and widely known programming language in use today. I also specialize with the Spring Framework, which the most popular open source application framework for building enterprise class applications on the Java platform. Just some of the organizations I've worked with include Visa, Kohls, Federal Home Loan Bank, and Belk Department Stores.

Through the courses I'm providing, I hope to leverage my years of experience to accelerate your learning of the Spring Framework. I'm not going to lie to you. The Spring Framework is a big framework. The environment for enterprise Java is even bigger. If you're new to Java, you have a lot to learn. I hope through the content on this web site I can accelerate your education of the Java and Spring landscape.

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