by Tom Owziak | Released June 2018 | ISBN: 9781789539868

An updated course incorporating SQL Server 2017!About This VideoClearly and succinctly describes the fundamentals needed to really understand the later stuff.A very good overview with some depth added with basic extensions to updating and selection parameters.In DetailMost 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. This course has been updated to bring it up to date with SQL Server 2017. The new course features audio done with a studio microphone. If you are at the intermediate or advanced level in SQL, do not join this course. The explanations can be very detailed at times, so be sure you enjoy that. Some of the videos cover programming, and some cover using a variety of resources without programming. Various topics are discussed through the videos. For example, there is not just one video on indexes because indexes are too big a topic. The author discuss indexes through the videos where they play a role. The same applies to other concepts. Be sure to look under the lesson resources for additional information and the code. The author's explanations, in some of the videos, but not all, can be very detailed, so be sure you enjoy that before enrolling. Show and hide more

1. Chapter 1 : Get the Needed Tools
   • Get SQL Server 2017 with Management Studio 00:05:38
   • Restore AdventureWorks2016CTP from Backup 00:06:47
2. Chapter 2 : Operating on Columns
   • Display All the Columns in a Table 00:08:46
   • Practical Consequences of Understanding and Not Understanding Data Types 00:12:25
   • Select a Variety of Columns 00:07:12
   • Introduction to Clustered Indexes, Execution Plans and Properties 00:09:17
   • Index Scans, Table Scans, and Physical Operators 00:09:07
   • User Defined Data Types and Online Resources 00:07:53
   • Aliasing Columns 00:06:34
   • Formatting Displayed Columns 00:09:03
   • Using Functions that Operate on Two Columns 00:06:53
   • Execution Plans with Computed Scalars 00:11:26
   • Column Constraints 00:08:06
   • Computed Columns 00:09:24
3. Chapter 3 : Operating on Rows
   • Filtering Rows with Where, Part 1 00:08:07
   • Filtering Rows with Where, Part 2 00:09:04
   • Where with Two Logical Conditions 00:07:52
   • Make a Table with a Clustered Index 00:06:40
   • Index Scans, Table Scans with Where 00:10:13
   • Index Scans vs. Index Seeks with Non-Clustered Indexes 00:09:23
   • Where with Like 00:10:39
   • Index Seek with Statistics On 00:07:55
   • Non-clustered Indexes with Ordering and Included Columns 00:08:16
   • Clustered Indexes with Order By 00:11:54
   • Clustered Index Design Guidelines 00:13:48
   • Summarizing Rows with Group By, Part 1 00:10:06
   • Summarizing Grouped Data with Group By, Part 2 00:09:10
   • Ordering by Group by Columns 00:04:34
   • Group by with Having 00:09:06
   • Grouped Data with Formatting 00:07:37
   • Breaking Rows into Sets with Over, Part 1 00:09:11
   • Breaking Rows into Sets with Over, Part 2 00:08:49
   • Understand the Clause Sequence 00:08:02
   • Using the Query Designer 00:13:06
4. Chapter 4 : Changing One Table
   • Deleting Records in Tables With/Without Indexes 00:09:14
   • Deleting Records from a Table with a Clustered Index 00:09:41
   • Inserting Values into Records, Part 1 00:11:58
   • Inserting Values into Records, Part 2 00:11:35
   • Inserting Values into Records, Part 3 (Clustered Indexes) 00:08:09
   • Inserting Query Results into Tables 00:14:37
Show and hide more