Data Analytics: Intro to SQL using Healthcare Data

Master SQL using Microsoft SQL Server Management Studio (Updated for 2024!)

4.59 (962 reviews)

Udemy

platform

English

language

Data & Analytics

What you will learn

Master the basics to Microsoft SQL Server Management Studio.

Understand the basics to SQL - Select, Into, From, Where, Group by, Having, Order by.

Learn to create, access, and drop databases.

Learn to write complex SQL syntax - Joins, Nested Queries, Creating tables.

Practice with a large healthcare database - thousands of rows, multiple tables.

Become a data expert and add SQL to your resume.

Gain applicable experience that will elevate your career!

Healthcare Data

Electronic Medical Record Data

Why take this course?

This course is a comprehensive introduction to SQL. This course is for everyone! Although we will be learning SQL using Microsoft SQL Server Management Studio the skills learned in this course will easily transfer to other database languages (MySQL) and database management systems (Postgres, Oracle, etc.). The purpose of this course is to help you feel comfortable working with complex data and writing SQL scripts while becoming familiar with healthcare data.

It doesn’t matter whether you work in healthcare or not, the examples in this course will help you learn SQL. Individuals who know SQL are in high demand. In fact, the U.S. Bureau of Labor Statistics reported that many SQL experts make over $100,000 per year! Data analytics is a growing field and understanding SQL is essential to becoming an analytics expert.

During this course we will:

Learn the basics to SQL and Microsoft SQL Server Management Studio
Write complex SQL syntax - Starting with the basics
Create Databases and inserting thousands of values
Analyze thousands of rows of data – real world healthcare data
Prepare data for visualizations such as PowerBI, Tableau, etc.
Design Entity Relationship Diagrams
Aggregate, format, and modify data using SQL operators and functions
Gain experience with Big Data and solving complex questions using data
Learn SQL Joins – working with multiple tables and databases
Practice, Practice, Practice.
And much more!

Feedback from students is very important to me. I take this feedback and add content to help students understand new concepts. Can't wait to have you join us.

Screenshots

Data Analytics: Intro to SQL using Healthcare Data - Screenshot_01

Data Analytics: Intro to SQL using Healthcare Data - Screenshot_02

Data Analytics: Intro to SQL using Healthcare Data - Screenshot_03

Data Analytics: Intro to SQL using Healthcare Data - Screenshot_04

Reviews

Carlos

October 21, 2023

This course is an excellent introduction. I am not a beginner but I am taking it to refresh and understand better the roots of SQL

Nikita

October 10, 2023

It is great course and does not require any prerequisite , me being a professional medical coder it was amazing course which will help me to transition in data analysis role in healthcare domain.

Raphael

October 2, 2023

Feel like I'm learning and progressing. He explains well and provides the code in a way that even if I get stuck, I'm able to identify what went wrong and fix. Nicely done!

Kamátikos

September 24, 2023

Pretty good course. I'm not using Windows, so I followed along with Postgres and PgAdmin. I ran into a few issues with importing the database (as a result of not using the intended set-up), but they were easily solved with reading error messages and searching the internet for work-arounds or the equivalent ways to do things for my set-up. I have given this course a rating of 4.5 and not 5 because it's a little rough around the edges and some of the practice questions didn't seem to convey properly what the intended query results ought to be.

Kate

August 23, 2023

amazing course that helped me gain solid understanding of SQL programming and functions with great examples using healthcare data and problem sets

SARA

August 23, 2023

very clear! I am starting a new job in healthtech, this has been super helpful. Thank you so much. Everything is super relevant. Highly recommend!

Kamal

August 10, 2023

I SOMETIES FIND IT DIFFCULT TO NAVIGATE THE SYSTEM. I HAVE GO GO BACK ABD WATCH THE VIDEO BEFORE GETTING IT, SOMETIES A COUPLE OF TIMES. I BELEIVE IT WILL BE BETTER IF YOU ADD MOORE EXPLANATIONS AT PLACES WHERE YOU THINK ITS GOING TO BE DIFFCULT FOR LEARNRS

Ryo

June 4, 2023

Such an informative course with a crystal clear explanation. I'm going to apply for a healthcare data analyst position, so it is truely helpful for me both SQL foundation and dealing with healthcare data.

June 3, 2023

This was a very useful and well-structured course. I have taken another introductory SQL course and still found new perspectives, tips and information in this course that was very helpful. I found the integration of healthcare data very interesting! I highly recommend!

May 15, 2023

Really enjoyed this course. Working with a large dataset is one of the things that excited me most about the course. I thought the questions at the end were quite hard for someone who has little to no experience in healthcare data specifically but regardless of that, working with the data was enjoyable. All the lectures were concise and the tutor was easy to understand. Would recommend this course.

Natalie

April 17, 2023

Curtis is very good at breaking down the information so it is easily understandable to someone who is new to SQL. I'm looking forward to continuing the course!

Jay

February 28, 2023

My company does a lot of SQL on the backend of our products, and I figured it would be good on that front as well as just having a passion to learn it, to take a SQL course. So far so good.

Gaurav

February 9, 2023

It was an amazing course to refresh MySQL knowledge. Got to learn about healthcare terminologies and use them.

Chris

February 3, 2023

A brilliant and impressive SQL course! After viewing multiple SQL online classes and taking a Junior College class this is the one course where the material "stuck" with me, thanks to the way that Curtis structured the course. This course is the best for learning and understanding the fundamentals of SQL.

Himanshu

November 6, 2022

I went through many courses for sql or ssms but this is best one till now. I am a tableau developer needed to use ssms. so for basics its is best. It would have been much better if little bit more about stored procedures would have been explained as they are used a lot

Charts

Price

Rating

Enrollment distribution

Data Analytics: Intro to SQL using Healthcare Data - Distribution chart