Data Analytics: Intro to SQL using Healthcare Data

Data Analytics: Intro to SQL using Healthcare Data

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!

Master SQL using Microsoft SQL Server Management Studio in 2022

Url: View Details

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.

Rating: 4.67886

Level: All Levels

Duration: 11.5 hours

Instructor: Curtis Norman