English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 6h 07m | 1.47 GB
An updated course incorporating SQL Server 2017!
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. 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.
Learn more SQL programming from this course. All the code is created in the Microsoft SQL Server Management Studio.
What You Will Learn
- 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 create and execute stored procedures, how to restore databases, how to combine tables with inner joins, how to combine a table with left outer joins, how to use joins to make
- new tables, how to add data input validation to websites, how clustered indexes operate.
- Learn about SQL Server execution plans, understand how to use a variety of online resources related to SQL Server.
- Learn how to read simple execution plans, physical SQL Server operators like Table Scan and Index Scan, scalar physical operators, understand how/why to apply column constraints.
- Understand the concept of a computed column and why they are useful, how to use a variety of logical conditions, how to use where clauses, how to use where clauses with two logical conditions.
- Describe the concept of a parameter
- Explain the reasons for data conversions, how to use N and $ symbols in data conversions, understand the difference between clustered and non clustered indexes, how to use key statistics like IO/CPU readingsUnderstand how to differentiate between various icons in the SQL plan panel.
Table of Contents
Get the Needed Tools
1 Get SQL Server 2017 with Management Studio
2 Restore AdventureWorks2016CTP from Backup
Operating on Columns
3 Display All the Columns in a Table
4 Practical Consequences of Understanding and Not Understanding Data Types
5 Select a Variety of Columns
6 Introduction to Clustered Indexes, Execution Plans and Properties
7 Index Scans, Table Scans, and Physical Operators
8 User Defined Data Types and Online Resources
9 Aliasing Columns
10 Formatting Displayed Columns
11 Using Functions that Operate on Two Columns
12 Execution Plans with Computed Scalars
13 Column Constraints
14 Computed Columns
Operating on Rows
15 Filtering Rows with Where, Part 1
16 Filtering Rows with Where, Part 2
17 Where with Two Logical Conditions
18 Make a Table with a Clustered Index
19 Index Scans, Table Scans with Where
20 Index Scans vs. Index Seeks with Non-Clustered Indexes
21 Where with Like
22 Index Seek with Statistics On
23 Non-clustered Indexes with Ordering and Included Columns
24 Clustered Indexes with Order By
25 Clustered Index Design Guidelines
26 Summarizing Rows with Group By, Part 1
27 Summarizing Grouped Data with Group By, Part 2
28 Ordering by Group by Columns
29 Group by with Having
30 Grouped Data with Formatting
31 Breaking Rows into Sets with Over, Part 1
32 Breaking Rows into Sets with Over, Part 2
33 Understand the Clause Sequence
34 Using the Query Designer
Changing One Table
35 Deleting Records in Tables With Without Indexes
36 Deleting Records from a Table with a Clustered Index
37 Inserting Values into Records, Part 1
38 Inserting Values into Records, Part 2
39 Inserting Values into Records, Part 3 (Clustered Indexes)
40 Inserting Query Results into Tables
Resolve the captcha to access the links!