Designing and Implementing SQL Server Tables and Views
Focused View
2:27:53
16 View
01 Course Overview.mp4
01:56
02 Introduction.mp4
02:02
03 Relational Database Foundations.mp4
01:50
04 Azure Data Studio Demo.mp4
01:51
05 Business Problem - Bobs Shoes.mp4
03:24
06 Course Overview.mp4
00:59
07 Introduction.mp4
02:02
08 Creating Identifiers.mp4
01:50
09 Using Naming Conventions and ... The Mice!.mp4
01:51
10 Using Character Data Types.mp4
03:24
11 Using Integer Types.mp4
00:59
12 Using Decimal Types.mp4
02:21
13 Using Date and Time Types.mp4
02:27
14 Demo 1 - Creating the Order Tracking Table.mp4
08:05
15 Using Collations.mp4
01:16
16 Demo 2 - Using Collations.mp4
02:20
17 Summary.mp4
00:54
18 Introduction.mp4
01:39
19 Identifying Problems with Unnormalized Data.mp4
02:00
20 Setting Objectives for Normalization.mp4
01:09
21 Demo 1 - Discovering Anomalies with Unnormalized Data.mp4
01:44
22 Understanding First Normal Form.mp4
01:13
23 Demo 2 - Transforming the Design to 1NF.mp4
06:16
24 Understanding Second Normal Form.mp4
01:01
25 Demo 3 - Transforming the Design to 2NF.mp4
02:33
26 Understanding Third Normal Form.mp4
01:13
27 Demo 3 - Transforming the Design to 3NF.mp4
02:41
28 Considering Other Normal Forms.mp4
03:07
29 Summary.mp4
01:18
30 Introduction and Overview.mp4
01:40
31 Using NULL and DEFAULT Constraints.mp4
03:14
32 Demo 1 - NULL and DEFAULT Constraints.mp4
03:20
33 Implementing the PRIMARY KEY Constraint.mp4
02:19
34 Using Index Types and the UNIQUE Constraint.mp4
02:09
35 Demo 2 - Implementing PRIMARY KEY and UNIQUE Constraints.mp4
02:58
36 More About Foreign Key Constraints.mp4
01:44
37 Demo 3 - Using FOREIGN KEY Constraints.mp4
03:54
38 Introducing CHECK Constraints.mp4
02:23
39 Demo 4 - Using CHECK Constraints.mp4
03:34
40 Options for Defining CHECK Constraints.mp4
01:59
41 Summary.mp4
01:36
42 Introducing Views.mp4
01:30
43 Overview and Motivation.mp4
02:45
44 Reviewing the Bobs Shoes Order System Design.mp4
00:35
45 Demo 1 - Creating a View to Produced a List of Customers.mp4
02:17
46 Demo 2 - Using WITH SCHEMABINDING.mp4
02:59
47 Working with Updateable Views.mp4
01:51
48 Demo 3 - Updating Tables using Views.mp4
02:12
49 Summary.mp4
00:56
50 Introducing Indexed Views.mp4
03:02
51 Requirements for Indexed Views.mp4
03:59
52 Demo 1 - Determining Determinism.mp4
01:04
53 YMIVR - Yet More Indexed View Requirements.mp4
01:31
54 Demo 2 - Indexing the Customer List View.mp4
01:16
55 Demo 3 - Adding a Nonclustered Index and Views with Aggregates.mp4
02:00
56 Summary.mp4
01:29
57 Introducing Partitioned Views.mp4
01:25
58 Outlining a Partitioned View.mp4
01:48
59 Reviewing the Requirements and Restrictions.mp4
02:40
60 Demo 1 - Building a Partitioned View for the Orders Table.mp4
02:52
61 Designing and Updating Partitioned Views.mp4
02:25
62 Summary.mp4
01:31
63 Wrapping Up.mp4
00:44
64 Designing Tables.mp4
02:20
65 Sqlserver Tables View Designing Implementing.mp4
01:15
66 Considering Other Table Types.mp4
02:02
67 Looking at Other Data Types.mp4
02:50
68 Finishing Strong!.mp4
00:20
More details
User Reviews
Rating
average 0
Focused display
Category
Pluralsight
View courses PluralsightPluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.
- language english
- Training sessions 68
- duration 2:27:53
- Release Date 2024/01/27
