bestcourses is supported by learners. When you buy through links on our website, we may earn an affiliate commission. Learn more

SQL Server 2017 Express Basics

Update Notice 4/3/2018: Course has been updated to SQL Server 2017!

4.7 / 5.0
1803 students6 hours 8 minutes

Created by T O, offered on Udemy

bestcourses score™

Student feedback


To make sure that we score courses properly, we pay a lot of attention to the reviews students leave on courses and how many students are taking a course in the first place. This course has a total of 1803 students which left 358 reviews at an average rating of 4.7, which is average.

Course length


We analyze course length to see if courses cover all important aspects of a topic, taking into account how long the course is compared to the category average. This course has a length of 6 hours 8 minutes, which is pretty short. This might not be a bad thing, but we've found that longer courses are often more detailed & comprehensive. The average course length for this entire category is 6 hours 21 minutes.

Overall score


This course currently has a bestcourses score of 6.2/10, which makes it an average course. Overall, there are probably better courses available for this topic on our platform.


Most Important:  Friends, please be sure to look through the course curriculum with meticulous care before buying to be sure this course will work for you. Thank you. 

  1. This course is being updated to bring it up to date with SQL Server 2017. 

  2. As of 3/27/2018, 40 videos have been replaced. 

  3. Replacement of all videos will happen over a month or so.

  4. Reviews from before 3/6/2017 are from the older version of this course. 

  5. The new course features questions built right into the videos. 

  6. The new course features audio done with a studio microphone. 

  7. If you are at the intermediate or advanced level in SQL, do not join this course. 

  8. My explanation can be very detailed at times, so be sure you enjoy that. 

  9. Some of the videos cover programming, and some cover using a variety of resources without programming.

  10. I use AdventureWorks2016CTP3, but you can also use AdventureWorks2017. Both are saved under the lesson 2 resources. There is no practical difference between the two for the purposes of this course. You must already know how to download lesson resources. I do not show how to do that.

  11. Various topics are discussed through the videos. For example, there is not just one video on indexes because indexes are too big a topic. I discuss indexes through the videos where they play a role. The same applies to other concepts. 

  12. Be sure to look under the lesson resources for additional information and the code.

  13. My explanations, in some of the videos, but not all, can be very detailed, so be sure you enjoy that before enrolling.

  14. If you are looking for powerpoints, fancy graphics or a talking head, please do not enroll. I don't use those. 

  15. I do in different places use zooming to emphasize points. 

  16. The videos are an average in 10 minutes in length, so please be aware of that. 

  17. All the code is created in the Microsoft SQL Server Management Studio. 

  18. I talk about execution plans quite a lot over multiple videos.

  19. This course does not cover joins, normalization or stored procedures.

  20. Friends, to get the most from this course, please watch it all, from beginning to end. There is a lot of information here:) 

Thank you,

Tom and Adiv

What you will learn

  • Download and install SQL Server 2017 Express
  • Download and Install SQL Server Management Studio 2017
  • Write queries that control how many columns are displayed
  • Write queries that summarize large quantities of data
  • Understand how to choose different data types
  • Create a table to represent an entity
  • Insert records into tables
  • Create indexes to ensure data integrity
  • Learn how to restore databases
  • Learn how clustered indexes operate
  • Learn about SQL Server execution plans
  • Learn about a variety of SQL functions
  • Understand how to use a variety of online resources related to SQL Server
  • Learn how to read simple execution plans
  • Learn about physical SQL Server operators like Table Scan and Index Scan
  • Learn about scalar physical operators
  • Understand how/why to apply column constraints
  • Understand the concept of a computed column and why they are useful
  • Understand how to use a variety of logical conditions
  • Understand how to use where clauses
  • Understand how to use where clauses with two logical conditions
  • Describe the concept of a parameter
  • Explain the reasons for data conversions
  • Explain how to use N and $ symbols in data conversions
  • Understand the difference between clustered and non clustered indexes
  • Understand how to use key statistics like io/cpu readings
  • Understand how to differentiate between various icons in the sql plan panel
  • Understand the concept of a seek
  • Understand how to read and interpret a variety of online resources related to SQL Server
  • Understand how to read values from the various panels in SQL Server SSMS
  • Understand how to sort data on indexes
  • Understand how to read seek predicates
  • Understand how to build a nonclustered index with included columns
  • Understand how to summarize records with group by
  • Understand how to read various stats related to stream aggregation
  • Understand the concepts behind clustered index designs
  • Understand how to use the over clause
  • Understand how clauses are designed to run logically, step by step
  • Understand when aliased columns can be used with various clauses


  • Must be able to download and install SQL Server 2017 Express
  • Must be able to download and install SQL Server 2017 Management Console
  • You need to use AdventureWorks2016CTP3 or AdventureWorks2017
Udemy logo
Available on


With almost 200,000 courses and close to 50 million students, Udemy is one of the most visited online learning platforms. Popular topics include software development, the digital economy, but also more traditional topics like cooking and music.

Frequently asked questions

  • Price: $19.99
  • Platform: Udemy
  • Language: English
  • 6 hours 8 minutes
SQL Server 2017 Express Basics thumbnail

bestcourses score: 6.2/10

There might be better courses available for this topic.