SQL Server 2017 Express Basics

SQL Server 2017 Express Basics

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

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

Url: View Details

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

Rating: 4.6

Level: Beginner Level

Duration: 6 hours

Instructor: T O