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 Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business 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
Business Business Analytics & Intelligence MySQL

SQL - MySQL for Data Analytics and Business Intelligence

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management
Bestseller
Rating: 4.6 out of 54.6 (27,025 ratings)
101,777 students
Created by 365 Careers
Last updated 3/2021
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Become an expert in SQL
  • Learn how to code in SQL
  • Boost your resume by learning an in-demand skill
  • Create, design, and operate with SQL databases
  • Start using MySQL – the #1 Database Management System
  • Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
  • Adopt professionally tested SQL best practices
  • Gain theoretical insights about relational databases
  • Work with a sophisticated real-life database throughout the course
  • Get maximum preparation for real-life database management
  • Add data analytical tools to your skillset
  • Develop business intuition while solving tasks with big data
  • Study relational database management theory that you will need in your workplace every day
  • Learn how to create a database from scratch
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Be confident while working with constraints and relating data tables
  • Become a proficient MySQL Workbench user
  • Acquire top-notch coding techniques and best practices
  • Know how to answer specific business questions by using SQL’s aggregate functions
  • Handle complex SQL joins with ease
  • Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
  • Merge coding skills and business acumen to solve complex analytical problems
  • Become a proficient SQL user by writing flawless and efficient queries
  • Tons of exercises that will solidify your knowledge
  • The freedom to query anything you like from a database
Curated for the Udemy for Business collection

Requirements

  • No prior experience is required. We will start from the very basics

Description

How important is database management in the age of big data and analytics?

It is really important.   


How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.  

How many people have these skills?

Not enough.  

This is why now is the time to learn SQL and gain a competitive advantage in the job market. Remember, the average salary of a SQL developer is $92,000! That’s a lucrative career.   


How come?   

Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making.   


Worried that you have no previous experience? 

Not an issue. We will start from the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.   


Why take this course in particular? Isn’t it like the rest of the SQL courses out there?  

We would like to think it isn’t. Our team worked hard to create a course that is:  

  • Easy to understand  

  • Time efficient and concise  

  • Shows how SQL can be crucial for data analytics and business intelligence   


  • Comprehensive – it covers several topics not shown in other SQL courses   


  • Practical – it teaches you how to work with a real-life database   


  • Corresponds to professional best practices  

  • Taught in MySQL – The most popular SQL database management system  

  • Contains plenty of downloadable exercises, course notes, and quiz questions  

Some of these aspects have been covered in other courses. Others haven’t. However, no one provides such a variety of topics in one place.  

We firmly believe this course is the best training material out there. It is a truly interactive experience preparing you for a real-life working environment.   


We love teaching   

So far, over 210,000 students have enrolled in our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the best content for you, our students. Our mission is to help you bridge the gap between theoretical knowledge taught at school and in universities and the practical application required at the workplace.   

So, why do you need to enroll in this course and learn SQL?  

  1. Salary/Income. As we pointed out earlier, learning SQL is a great opportunity. There is a significant surge in demand for skills revolving around database management, database administration, and business analysis relying on data. Companies will pay top dollars for specialists who have such know-how  

  2. Profession of the future. In the years to come, data will only grow in importance and size. Therefore, it is great to pick up a skill that will likely increase in demand over the years to come  

  3. Analytical reasoning. Programming languages are a great way to train your mind. Furthermore, understanding a business task and looking for its solution through writing code can be really interesting and stimulating once you become familiar with the basics  

What about certificates? Do you provide a certificate?

Upon completion of the course, you will be able to download a certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.  

Sounds awesome, right?  

So, what are you waiting for? Click the “Take this course” button, and let’s begin this journey together!  

Who this course is for:

  • People interested in SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
  • Beginners to programming
  • Everyone who wants to learn how to code and apply their skills in practice

Featured review

Serif Paradigm
Serif Paradigm
30 courses
7 reviews
Rating: 5.0 out of 5a year ago
I was skeptical when the person presenting the course in the demo video was not the voice instructing, but it turned out to be the best taught course I've encountered on Udemy so far. Logical and linear progression of topics, and a solid consistent reinforcement of them via exercises after each video. Every instructor on this site could learn something from this course, and not just SQL - but definitely that too.

Course content

27 sections • 287 lectures • 10h 1m total length

  • Preview04:14
  • Why SQL?
    Preview03:17
  • Why SQL?
    2 questions
  • Why MySQL?
    Preview01:57
  • Why MySQL?
    1 question
  • Introduction to databases
    Preview04:44
  • Introduction to databases
    2 questions

  • SQL as a declarative language
    02:10
  • SQL as a declarative language
    2 questions
  • Data definition language (DDL)
    04:12
  • Data definition language (DDL)
    1 question
  • SQL keywords
    01:12
  • SQL keywords
    1 question
  • Data manipulation language (DML)
    04:55
  • Data manipulation language (DML)
    1 question
  • Data control language (DCL)
    05:03
  • Data control language (DCL)
    1 question
  • Transaction control language (TCL)
    03:02
  • Transaction control language (TCL)
    1 question

  • Relational database essentials
    Preview04:51
  • Relational database essentials
    2 questions
  • Databases vs spreadsheets
    Preview08:06
  • Databases vs spreadsheets
    2 questions
  • Database terminology
    04:17
  • Database terminology
    1 question
  • Relational schemas - Primary key
    04:55
  • Relational schemas - Primary key
    1 question
  • Relational schemas - Foreign key
    04:58
  • Relational schemas - Foreign key
    3 questions
  • Relational schemas - Unique key and null values
    03:07
  • Relational Schemas - Unique key
    1 question
  • Relationships
    04:39
  • Relational Schemas – Relationships
    1 question

  • Installing MySQL
    10:48
  • Additional note – Installing – Visual C
    00:21
  • Installing MySQL on macOS and Unix systems
    01:24
  • The Client-Server Model
    00:00
  • Setting up a connection
    02:34
  • Read me!!!
    00:44
  • New Authentication Plugin - Creating a New User
    06:18
  • Introduction to the MySQL interface
    05:09

  • Creating a Database - Part I
    05:12
  • SQL files
    00:47
  • Creating a Database - Part I - exercise
    00:06
  • Creating a Database - Part I - solution
    00:03
  • Creating a Database - Part II
    02:21
  • Creating a Database - Part II - exercise
    00:02
  • Creating a Database - Part II - solution
    00:00
  • Introduction to data types
    02:16
  • Introduction to data types
    1 question
  • String data types
    05:01
  • String data types
    2 questions
  • Integers
    04:10
  • Integers
    1 question
  • Fixed and floating-point data types
    05:43
  • Fixed and floating-point data types
    1 question
  • Other useful data types
    06:12
  • Other useful data types
    1 question
  • Creating a table
    05:16
  • Creating a table - exercise
    00:10
  • Creating a table - solution
    00:03
  • Using databases and tables
    03:03
  • Using databases and tables - exercise
    00:10
  • Using databases and tables - solution
    00:01
  • Additional notes on using tables
    02:12
  • Additional notes on using tables
    1 question
  • Additional notes on using tables - exercise
    00:09

  • PRIMARY KEY constraint
    05:23
  • PRIMARY KEY Constraint
    1 question
  • PRIMARY KEY constraint - exercise
    00:17
  • PRIMARY KEY constraint - solution
    00:11
  • FOREIGN KEY constraint - Part I
    05:25
  • FOREIGN KEY constraint - Part II
    05:26
  • FOREIGN KEY constraint - Part II - exercise
    00:07
  • FOREIGN KEY constraint - Part II - solution
    00:03
  • UNIQUE Constraint
    05:00
  • UNIQUE Constraint - exercise
    00:29
  • DEFAULT Constraint
    05:24
  • DEFAULT Constraint - exercise
    00:11
  • DEFAULT Constraint - solution
    00:04
  • NOT NULL Constraint - Part I
    05:53
  • NOT NULL Constraint - Part I - exercise
    00:05
  • NOT NULL Constraint - Part I - solution
    00:04
  • NOT NULL Constraint - Part II
    01:59

  • Coding techniques and best practices - Part I
    05:34
  • Coding techniques and best practices – Part I
    1 question
  • Coding techniques and best practices - Part II
    04:11
  • Coding techniques and best practices – Part II
    2 questions

  • Loading the 'employees' database
    02:19
  • Loading the 'employees' database
    00:37

  • SELECT - FROM
    04:57
  • SELECT - FROM - exercise
    00:04
  • SELECT - FROM - solution
    00:01
  • WHERE
    02:30
  • WHERE - exercise
    00:03
  • WHERE - solution
    00:01
  • AND
    02:14
  • AND - exercise
    00:03
  • AND - solution
    00:02
  • OR
    03:35
  • OR - exercise
    00:03
  • OR - solution
    00:02
  • Operator precedence
    03:34
  • Operator precedence - exercise
    00:03
  • Operator precedence - solution
    00:03
  • IN - NOT IN
    03:12
  • IN - NOT IN - exercise 1
    00:05
  • IN - NOT IN - solution 1
    00:02
  • IN - NOT IN - exercise 2
    00:04
  • IN - NOT IN - solution 2
    00:02
  • LIKE - NOT LIKE
    03:36
  • LIKE - NOT LIKE - exercise
    00:16
  • LIKE - NOT LIKE - solution
    00:05
  • Wildcard characters
    01:44
  • Wildcard characters - exercise
    00:07
  • Wildcard characters - solution
    00:03
  • BETWEEN - AND
    02:19
  • BETWEEN - AND - exercise
    00:11
  • BETWEEN - AND- solution
    00:08
  • IS NOT NULL - IS NULL
    01:37
  • IS NOT NULL - IS NULL - exercise
    00:03
  • IS NOT NULL - IS NULL - solution
    00:02
  • Other comparison operators
    04:30
  • Other comparison operators - exercise
    00:10
  • Other comparison operators - solution
    00:03
  • SELECT DISTINCT
    02:05
  • SELECT DISTINCT - exercise
    00:13
  • SELECT DISTINCT - solution
    00:01
  • Introduction to aggregate functions
    05:24
  • Introduction to aggregate functions - exercise
    00:10
  • Introduction to aggregate functions - solution
    00:02
  • ORDER BY
    03:46
  • ORDER BY - exercise
    00:03
  • ORDER BY - solution
    00:01
  • GROUP BY
    06:00
  • Using Aliases (AS)
    02:08
  • Using Aliases (AS) - exercise
    00:12
  • Using Aliases (AS) - solution
    00:04
  • HAVING
    03:26
  • HAVING - exercise
    00:13
  • HAVING - solution
    00:16
  • WHERE vs HAVING- Part I
    Preview04:03
  • WHERE vs HAVING- Part II
    03:08
  • WHERE vs HAVING - Part II - exercise
    00:07
  • WHERE vs HAVING - Part II - solution
    00:04
  • LIMIT
    04:51
  • LIMIT - exercise
    00:02
  • LIMIT - solution
    00:01

  • The INSERT statement - Part I
    06:04
  • The INSERT statement - Part II
    02:19
  • The INSERT statement - exercise 1
    00:38
  • The INSERT statement - solution 1
    00:05
  • The INSERT statement - exercise 2
    00:12
  • The INSERT statement - solution 2
    00:05
  • Inserting data INTO a new table
    03:55
  • Inserting Data INTO a New Table - exercise
    00:05
  • Inserting Data INTO a New Table - solution
    00:01

Instructor

365 Careers
Creating opportunities for Business & Finance students
365 Careers
  • 4.5 Instructor Rating
  • 407,201 Reviews
  • 1,386,787 Students
  • 71 Courses

365 Careers is the #1 best-selling provider of finance courses on Udemy. The company’s courses have been taken by more than 1,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings.  

Currently, the firm focuses on the following topics on Udemy:  

1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA

2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics

3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing

4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook

5) Blockchain for Business

All of the company’s courses are:  

Pre-scripted  

Hands-on  

Laser-focused  

Engaging  

Real-life tested  

By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time.  

If you want to become a financial analyst, a finance manager, an FP&A analyst, an investment banker, a business executive, an entrepreneur, a business intelligence analyst, a data analyst, or a data scientist, 365 Careers’ courses are the perfect place to start. 

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