Designing and Implementing SQL Server Tables and Views

File Name

Size

01. Course Overview/01. Course Overview.mp4

3.8 MB

01. Course Overview/01. Course Overview.srt

3.0 kB

02. Introducing Tables and Views/01. Version Check.mp4

716 kB

02. Introducing Tables and Views/02. Introduction.mp4

1.8 MB

02. Introducing Tables and Views/02. Introduction.srt

1.8 kB

02. Introducing Tables and Views/03. Relational Database Foundations.mp4

2.6 MB

02. Introducing Tables and Views/03. Relational Database Foundations.srt

2.2 kB

02. Introducing Tables and Views/04. Azure Data Studio Demo.mp4

5.3 MB

02. Introducing Tables and Views/04. Azure Data Studio Demo.srt

4.0 kB

02. Introducing Tables and Views/05. Business Problem- Bob's Shoes.mp4

1.3 MB

02. Introducing Tables and Views/05. Business Problem- Bob's Shoes.srt

1.3 kB

02. Introducing Tables and Views/06. Course Overview.mp4

2.0 MB

02. Introducing Tables and Views/06. Course Overview.srt

2.0 kB

03. Designing and Implementing Tables/01. Introduction.mp4

2.4 MB

03. Designing and Implementing Tables/01. Introduction.srt

3.3 kB

03. Designing and Implementing Tables/02. Creating Identifiers.mp4

2.6 MB

03. Designing and Implementing Tables/02. Creating Identifiers.srt

2.8 kB

03. Designing and Implementing Tables/03. Using Naming Conventions and ... The Mice!.mp4

2.7 MB

03. Designing and Implementing Tables/03. Using Naming Conventions and ... The Mice!.srt

2.9 kB

03. Designing and Implementing Tables/04. Using Character Data Types.mp4

4.5 MB

03. Designing and Implementing Tables/04. Using Character Data Types.srt

5.0 kB

03. Designing and Implementing Tables/05. Using Integer Types.mp4

1.1 MB

03. Designing and Implementing Tables/05. Using Integer Types.srt

1.4 kB

03. Designing and Implementing Tables/06. Using Decimal Types.mp4

3.4 MB

03. Designing and Implementing Tables/06. Using Decimal Types.srt

3.7 kB

03. Designing and Implementing Tables/07. Using Date and Time Types.mp4

3.4 MB

03. Designing and Implementing Tables/07. Using Date and Time Types.srt

3.6 kB

03. Designing and Implementing Tables/08. Demo 1- Creating the Order Tracking Table.mp4

19 MB

03. Designing and Implementing Tables/08. Demo 1- Creating the Order Tracking Table.srt

13 kB

03. Designing and Implementing Tables/09. Using Collations.mp4

2.1 MB

03. Designing and Implementing Tables/09. Using Collations.srt

1.9 kB

03. Designing and Implementing Tables/10. Demo 2- Using Collations.mp4

5.8 MB

03. Designing and Implementing Tables/10. Demo 2- Using Collations.srt

3.6 kB

03. Designing and Implementing Tables/11. Summary.mp4

1.2 MB

03. Designing and Implementing Tables/11. Summary.srt

1.7 kB

04. Improving Table Design Through Normalization/01. Introduction.mp4

2.0 MB

04. Improving Table Design Through Normalization/01. Introduction.srt

2.6 kB

04. Improving Table Design Through Normalization/02. Identifying Problems with Unnormalized Data.mp4

3.8 MB

04. Improving Table Design Through Normalization/02. Identifying Problems with Unnormalized Data.srt

3.0 kB

04. Improving Table Design Through Normalization/03. Setting Objectives for Normalization.mp4

1.3 MB

04. Improving Table Design Through Normalization/03. Setting Objectives for Normalization.srt

1.9 kB

04. Improving Table Design Through Normalization/04. Demo 1 - Discovering Anomalies with Unnormalized Data.mp4

3.9 MB

04. Improving Table Design Through Normalization/04. Demo 1 - Discovering Anomalies with Unnormalized Data.srt

2.6 kB

04. Improving Table Design Through Normalization/05. Understanding First Normal Form.mp4

1.2 MB

04. Improving Table Design Through Normalization/05. Understanding First Normal Form.srt

1.9 kB

04. Improving Table Design Through Normalization/06. Demo 2 - Transforming the Design to 1NF.mp4

15 MB

04. Improving Table Design Through Normalization/06. Demo 2 - Transforming the Design to 1NF.srt

9.8 kB

04. Improving Table Design Through Normalization/07. Understanding Second Normal Form.mp4

1.2 MB

04. Improving Table Design Through Normalization/07. Understanding Second Normal Form.srt

1.4 kB

04. Improving Table Design Through Normalization/08. Demo 3 - Transforming the Design to 2NF.mp4

6.0 MB

04. Improving Table Design Through Normalization/08. Demo 3 - Transforming the Design to 2NF.srt

4.1 kB

04. Improving Table Design Through Normalization/09. Understanding Third Normal Form.mp4

1.6 MB

04. Improving Table Design Through Normalization/09. Understanding Third Normal Form.srt

1.7 kB

04. Improving Table Design Through Normalization/10. Demo 3 - Transforming the Design to 3NF.mp4

7.1 MB

04. Improving Table Design Through Normalization/10. Demo 3 - Transforming the Design to 3NF.srt

4.4 kB

04. Improving Table Design Through Normalization/11. Considering Other Normal Forms.mp4

3.0 MB

04. Improving Table Design Through Normalization/11. Considering Other Normal Forms.srt

4.7 kB

04. Improving Table Design Through Normalization/12. Summary.mp4

1.6 MB

04. Improving Table Design Through Normalization/12. Summary.srt

2.0 kB

05. Ensuring Data Integrity with Constraints/01. Introduction and Overview.mp4

2.1 MB

05. Ensuring Data Integrity with Constraints/01. Introduction and Overview.srt

2.9 kB

05. Ensuring Data Integrity with Constraints/02. Using NULL and DEFAULT Constraints.mp4

3.6 MB

05. Ensuring Data Integrity with Constraints/02. Using NULL and DEFAULT Constraints.srt

5.3 kB

05. Ensuring Data Integrity with Constraints/03. Demo 1 - NULL and DEFAULT Constraints.mp4

7.5 MB

05. Ensuring Data Integrity with Constraints/03. Demo 1 - NULL and DEFAULT Constraints.srt

5.4 kB

05. Ensuring Data Integrity with Constraints/04. Implementing the PRIMARY KEY Constraint.mp4

2.9 MB

05. Ensuring Data Integrity with Constraints/04. Implementing the PRIMARY KEY Constraint.srt

3.7 kB

05. Ensuring Data Integrity with Constraints/05. Using Index Types and the UNIQUE Constraint.mp4

3.4 MB

05. Ensuring Data Integrity with Constraints/05. Using Index Types and the UNIQUE Constraint.srt

3.4 kB

05. Ensuring Data Integrity with Constraints/06. Demo 2 - Implementing PRIMARY KEY and UNIQUE Constraints.mp4

7.9 MB

05. Ensuring Data Integrity with Constraints/06. Demo 2 - Implementing PRIMARY KEY and UNIQUE Constraints.srt

4.6 kB

05. Ensuring Data Integrity with Constraints/07. More About Foreign Key Constraints.mp4

2.1 MB

05. Ensuring Data Integrity with Constraints/07. More About Foreign Key Constraints.srt

2.9 kB

05. Ensuring Data Integrity with Constraints/08. Demo 3 - Using FOREIGN KEY Constraints.mp4

7.9 MB

05. Ensuring Data Integrity with Constraints/08. Demo 3 - Using FOREIGN KEY Constraints.srt

6.4 kB

05. Ensuring Data Integrity with Constraints/09. Introducing CHECK Constraints.mp4

2.4 MB

05. Ensuring Data Integrity with Constraints/09. Introducing CHECK Constraints.srt

3.8 kB

05. Ensuring Data Integrity with Constraints/10. Demo 4 - Using CHECK Constraints.mp4

11 MB

05. Ensuring Data Integrity with Constraints/10. Demo 4 - Using CHECK Constraints.srt

5.4 kB

05. Ensuring Data Integrity with Constraints/11. Options for Defining CHECK Constraints.mp4

2.6 MB

05. Ensuring Data Integrity with Constraints/11. Options for Defining CHECK Constraints.srt

3.4 kB

05. Ensuring Data Integrity with Constraints/12. Summary.mp4

1.7 MB

05. Ensuring Data Integrity with Constraints/12. Summary.srt

2.7 kB

06. Designing View to Meet Business Requirements/01. Introducing Views.mp4

2.2 MB

06. Designing View to Meet Business Requirements/01. Introducing Views.srt

2.5 kB

06. Designing View to Meet Business Requirements/02. Overview and Motivation.mp4

3.0 MB

06. Designing View to Meet Business Requirements/02. Overview and Motivation.srt

4.1 kB

06. Designing View to Meet Business Requirements/03. Reviewing the Bobs Shoes Order System Design.mp4

737 kB

06. Designing View to Meet Business Requirements/03. Reviewing the Bobs Shoes Order System Design.srt

901 B

06. Designing View to Meet Business Requirements/04. Demo 1 - Creating a View to Produced a List of Customers.mp4

5.1 MB

06. Designing View to Meet Business Requirements/04. Demo 1 - Creating a View to Produced a List of Customers.srt

3.2 kB

06. Designing View to Meet Business Requirements/05. Demo 2 - Using WITH SCHEMABINDING.mp4

5.8 MB

06. Designing View to Meet Business Requirements/05. Demo 2 - Using WITH SCHEMABINDING.srt

4.6 kB

06. Designing View to Meet Business Requirements/06. Working with Updateable Views.mp4

3.3 MB

06. Designing View to Meet Business Requirements/06. Working with Updateable Views.srt

2.9 kB

06. Designing View to Meet Business Requirements/07. Demo 3 - Updating Tables using Views.mp4

5.5 MB

06. Designing View to Meet Business Requirements/07. Demo 3 - Updating Tables using Views.srt

3.4 kB

06. Designing View to Meet Business Requirements/08. Summary.mp4

1.0 MB

06. Designing View to Meet Business Requirements/08. Summary.srt

1.5 kB

07. Implementing Indexed Views/01. Introducing Indexed Views.mp4

4.6 MB

07. Implementing Indexed Views/01. Introducing Indexed Views.srt

5.2 kB

07. Implementing Indexed Views/02. Requirements for Indexed Views.mp4

5.7 MB

07. Implementing Indexed Views/02. Requirements for Indexed Views.srt

6.4 kB

07. Implementing Indexed Views/03. Demo 1 - Determining Determinism.mp4

2.7 MB

07. Implementing Indexed Views/03. Demo 1 - Determining Determinism.srt

1.6 kB

07. Implementing Indexed Views/04. YMIVR - Yet More Indexed View Requirements.mp4

1.8 MB

07. Implementing Indexed Views/04. YMIVR - Yet More Indexed View Requirements.srt

2.0 kB

07. Implementing Indexed Views/05. Demo 2 - Indexing the Customer List View.mp4

3.3 MB

07. Implementing Indexed Views/05. Demo 2 - Indexing the Customer List View.srt

2.0 kB

07. Implementing Indexed Views/06. Demo 3 - Adding a Nonclustered Index and Views with Aggregates.mp4

4.9 MB

07. Implementing Indexed Views/06. Demo 3 - Adding a Nonclustered Index and Views with Aggregates.srt

3.1 kB

07. Implementing Indexed Views/07. Summary.mp4

2.0 MB

07. Implementing Indexed Views/07. Summary.srt

2.2 kB

08. Implementing Partitioned Views/01. Introducing Partitioned Views.mp4

1.7 MB

08. Implementing Partitioned Views/01. Introducing Partitioned Views.srt

2.4 kB

08. Implementing Partitioned Views/02. Outlining a Partitioned View.mp4

2.4 MB

08. Implementing Partitioned Views/02. Outlining a Partitioned View.srt

3.1 kB

08. Implementing Partitioned Views/03. Reviewing the Requirements and Restrictions.mp4

3.3 MB

08. Implementing Partitioned Views/03. Reviewing the Requirements and Restrictions.srt

4.2 kB

08. Implementing Partitioned Views/04. Demo 1 - Building a Partitioned View for the Orders Table.mp4

7.6 MB

08. Implementing Partitioned Views/04. Demo 1 - Building a Partitioned View for the Orders Table.srt

4.5 kB

08. Implementing Partitioned Views/05. Designing and Updating Partitioned Views.mp4

2.6 MB

08. Implementing Partitioned Views/05. Designing and Updating Partitioned Views.srt

4.2 kB

08. Implementing Partitioned Views/06. Summary.mp4

2.1 MB

08. Implementing Partitioned Views/06. Summary.srt

2.6 kB

09. Summary/01. Wrapping Up.mp4

963 kB

09. Summary/01. Wrapping Up.srt

1.3 kB

09. Summary/02. Designing Tables.mp4

2.4 MB

09. Summary/02. Designing Tables.srt

3.7 kB

09. Summary/03. Sqlserver Tables View Designing Implementing.mp4

1.2 MB

09. Summary/03. Sqlserver Tables View Designing Implementing.srt

2.1 kB

09. Summary/04. Considering Other Table Types.mp4

1.9 MB

09. Summary/04. Considering Other Table Types.srt

3.2 kB

09. Summary/05. Looking at Other Data Types.mp4

4.0 MB

09. Summary/05. Looking at Other Data Types.srt

4.3 kB

09. Summary/06. Finishing Strong!.mp4

437 kB

09. Summary/06. Finishing Strong!.srt

548 B

sqlserver-tables-view-designing-implementing.zip

5.5 MB