SQL - MySQL for Data Analytics and Business Intelligence

Course Feature
  • Cost
    Paid
  • Provider
    Udemy
  • Certificate
    Paid Certification
  • Language
    English
  • Start Date
    2023-06-01
  • Learners
    No Information
  • Duration
    No Information
  • Instructor
    365 Careers
Next Course
4.6
207,735 Ratings
This course is the perfect opportunity to learn SQL and gain a competitive advantage in the job market. With an average salary of $103,400, SQL developers are in high demand. This course covers a variety of topics, from the basics to more advanced topics, and is taught in MySQL, the most popular SQL database management system. It also includes downloadable exercises, course notes, and quiz questions. With over 1,750,000 students already enrolled, this course is the best training material out there. Upon completion, you will receive a certificate of completion to upload to LinkedIn and show potential employers. Don't miss out on this great opportunity - click the "Buy now" button and start your journey today!
Show All
Course Overview

❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 13th, 2023]

Skills and Knowledge Acquired:
By taking this course, students will acquire the skills and knowledge necessary to work with SQL and MySQL for data analytics and business intelligence. This includes understanding the fundamentals of database management, learning how to write SQL queries, and gaining an understanding of how to use SQL for data analysis and decision making. Additionally, students will learn how to work with a real-life database, as well as best practices for working with SQL and MySQL. Upon completion of the course, students will be able to download a certificate of completion with their name on it.


Contribution to Professional Growth:
This course provides an opportunity for professional growth by teaching the fundamentals of SQL and MySQL, which are essential for data analytics and business intelligence. It covers a variety of topics, from the basics to more advanced concepts, and provides practical exercises and quizzes to help students gain a better understanding of the material. Additionally, the course provides a certificate of completion, which can be used to demonstrate the student's knowledge and skills to potential employers. With the knowledge gained from this course, students can gain a competitive advantage in the job market and potentially increase their salary.


Suitability for Further Education:
This course is suitable for preparing further education as it provides comprehensive coverage of topics related to database management, data analysis, and business intelligence. It is taught in MySQL, the most popular SQL database management system, and contains plenty of downloadable exercises, course notes, and quiz questions. Additionally, upon completion of the course, students will be able to download a certificate of completion with their name on it, which can be used to demonstrate their knowledge and skills to potential employers.

Course Syllabus

Introduction to databases, SQL, and MySQL

SQL theory

Basic database terminology

Installing MySQL and getting acquainted with the interface

First steps in SQL

MySQL constraints

SQL best practices

Loading the 'employees' database

SQL SELECT statement

SQL INSERT statement

SQL UPDATE Statement

SQL DELETE Statement

MySQL - Aggregate functions

SQL Joins

SQL Subqueries

SQL Self Join

SQL Views

Stored routines

Advanced SQL Topics

SQL Window Functions

SQL Common Table Expressions (CTEs)

SQL Temporary Tables

Combining SQL and Tableau - Introduction

Combining SQL and Tableau - Task 1

Combining SQL and Tableau - Task 2

Combining SQL and Tableau - Task 3

Combining SQL and Tableau - Task 4

Combining SQL and Tableau - Task 5

Practice SQL – 10 Final Query Questions

BONUS LECTURE

Show All
Recommended Courses
oracle-database-19c-basic-sql-16139
Oracle Database 19c: Basic SQL
4.5
LinkedIn Learning 1 learners
Learn More
Discover the fundamentals of Oracle Database 19c: Basic SQL
free hosting-your-online-course-on-squarespace-version-70-16140
Hosting Your Online Course on Squarespace (Version 70)
2.0
Youtube 20,463 learners
Learn More
Are you an entrepreneur looking to host your online course on Squarespace (Version 70)? Louise Henry has the perfect course for you! In this course, Louise will show you how to set up your online course with Squarespace, and provide you with all the tools and links you need to get started. She will also provide you with her favorite tools and products, and share her affiliate links so that you can get started with ease. Plus, Louise will provide you with her contact information and social media links so that you can connect with her and get the support you need. Don't miss out on this amazing opportunity to learn from Louise and get your online course up and running!
free squarespace-version-70-vs-teachable-to-host-your-online-course-16141
Squarespace (Version 70) vs Teachable to Host Your Online Course
3.0
Youtube 10,519 learners
Learn More
Are you looking for the best online course platform for your business? Louise Henry has the answer! In this video, she compares Squarespace (Version 70) and Teachable to help viewers decide which platform is best for them. She provides a 10% discount code for Squarespace, links to her blog post with all the resources and links mentioned in the video, and encourages viewers to join her Website that Wows program. Don't miss out on this great opportunity to get the best online course platform for your business!
free build-a-squarespace-website-step-by-step-template-included-16142
Build a Squarespace website step by step (template included)
4.1
Udemy 7,496 learners
Learn More
This course is perfect for entrepreneurs who need a website that sells. It provides a step-by-step guide to building a Squarespace website, from the basics of typography, color, layout, and call to action, to creating a website from scratch or using a provided template. The 1.5 hour class is designed for new learners, so no prior knowledge is required. With this course, learners will have the opportunity to create a website that is attractive, professional, and effective.
Favorites (0)
Favorites
0 favorite option

You have no favorites

Name delet
arrow Click Allow to get free SQL - MySQL for Data Analytics and Business Intelligence courses!