Accelerate

Accelerate: Microsoft SQL

Get the Microsoft SQL Server database skills you need today.

34 lessons3 hoursEN & ES subtitles

What you'll work with

Development database installationT-SQL queriesTables, Views, and Stored ProceduresIndexesExecution PlansPerformance Evaluation

About this course

All applications need to store and retrieve data. The solution is a database like Microsoft SQL Server. This course quickly gets you up to speed on building a database, storing your data, and efficiently retrieving your data. Gaining these database skills will help you go further, faster as a software developer.

Watch the course intro →

What you'll be able to do

  • Set up Microsoft SQL for development
  • Build a real-world database
  • Create all CRUD queries
  • Evaluate and improve query performance

Every lesson, in the open

34 lessons · 3 hours of video. Here's exactly what's inside.

TrainingLearn how to build powerful SQL databases
  1. 1
    Course Introduction 6 lessons · 19 min
    • Introduction 1:27
    • Why Take This Course 7:42
    • Who This Course Is For 4:11
    • What This Course Covers 4:43
    • What This Course Does Not Cover 2:30
    • What Outcomes Should You Expect 1:20
  2. 2
    Getting Started with SQL 7 lessons · 1h 22m
    • Introduction 1:39
    • SQL Server Developer Edition 18:55
    • Azure SQL 24:01
    • SQL in Docker 7:11
    • LocalDB 4:33
    • Tooling Options 16:05
    • Connection Strings 12:37
  3. 3
    T-SQL 10 lessons · 2h 09m
    • Introduction 0:44
    • Databases 18:43
    • Tables 26:43
    • Insert 7:45
    • Select 13:34
    • Join 27:20
    • Update 6:01
    • Delete 2:45
    • Views 6:57
    • Stored Procedures 23:39
  4. 4
    Performance 4 lessons · 52 min
    • Introduction 1:03
    • Indexes 20:19
    • Execution Plans 21:11
    • Query Performance 10:40
AssessmentsPractice working with real GitHub situations
  1. 5
    Skills Assessment #1 3 lessons · 19 min
    • Introduction 1:09
    • Challenge 2:06
    • Solution 16:05
  2. 6
    Skills Assessment #2 3 lessons · 39 min
    • Introduction 0:45
    • Challenge 1:55
    • Solution 37:15
  3. 7
    Course Conclusion 1 lesson · 1 min
    • Conclusion 1:30
Tim Corey

Hi, I'm Tim Corey.

I learned software development the hard way, with lots of dead-ends, confusion, and knowledge gaps. I kept thinking, “It shouldn't be this hard!” Now I teach students how to think and code like professional developers. My goal is to make it easier for you to become a developer.

25+ Years experience
400,000+ Students taught
400+ Hours of training
10x Microsoft MVP

Frequently asked questions

When does this course start and finish?
The course starts now and never ends! It is a completely self-paced online course; you decide when you start and when you finish.
How long do I have to access the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like; across any and all devices you own.
What if I am unhappy with the course?
I do my best to provide the highest quality training to help you become a successful developer. But if this course isn't for you, then you can count on a no-hassle 30 Day Money Back Guarantee.

This course is part of a Learning Path

Take Accelerate: Microsoft SQL on its own, or follow a path that builds around it.

Step 3 of 5 Starting C# You have the training of an intermediate C# developer! Step 4 of 5 Back-End C# You are now a back-end C# developer! Step 5 of 6 Full-Stack C# You are now a full-stack C# developer!