Data Analysis using Analytic Functions: SQL ,SQL Server,SSMS

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

Created by: Curtis Norman
Healthcare Finance and Analytics Consultant

What Will I 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

Requirements

• No SQL experience needed
• We will download Microsoft SQL Server Management Studio
• Microsoft Excel is a plus

Target audience

• Everyone!
• Anyone wanting to learn SQL to make them better at their current job or find a new job.
• Students who want to get ahead of the learning curve and learn using applicable data.
• Healthcare professionals who want to become data experts.
• Those wanting to learn Microsoft SQL Server Management Studio.