Designing and Implementing SQL Server Tables and Views | 3A2BA2549C178EE4F164D6A01424CB2008D506A5

Designing and Implementing SQL Server Tables and Views

Name	Designing and Implementing SQL Server Tables and Views	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	268.9 MB
Total Files	138
Hash	3A2BA2549C178EE4F164D6A01424CB2008D506A5

/01. Course Overview/
01. Course Overview.mp4	4.0 MB
01. Course Overview.srt	3.0 KB
/02. Introducing Tables and Views/
01. Version Check.mp4	733.6 KB
02. Introduction.mp4	1.9 MB
02. Introduction.srt	1.8 KB
03. Relational Database Foundations.mp4	2.7 MB
03. Relational Database Foundations.srt	2.2 KB
04. Azure Data Studio Demo.mp4	5.6 MB
04. Azure Data Studio Demo.srt	4.1 KB
05. Business Problem- Bob's Shoes.mp4	1.3 MB
05. Business Problem- Bob's Shoes.srt	1.4 KB
06. Course Overview.mp4	2.1 MB
06. Course Overview.srt	2.0 KB
/03. Designing and Implementing Tables/
01. Introduction.mp4	2.5 MB
01. Introduction.srt	3.3 KB
02. Creating Identifiers.mp4	2.7 MB
02. Creating Identifiers.srt	2.8 KB
03. Using Naming Conventions and ... The Mice!.mp4	2.9 MB
03. Using Naming Conventions and ... The Mice!.srt	3.0 KB
04. Using Character Data Types.mp4	4.7 MB
04. Using Character Data Types.srt	5.2 KB
05. Using Integer Types.mp4	1.2 MB
05. Using Integer Types.srt	1.5 KB
06. Using Decimal Types.mp4	3.6 MB
06. Using Decimal Types.srt	3.8 KB
07. Using Date and Time Types.mp4	3.6 MB
07. Using Date and Time Types.srt	3.7 KB
08. Demo 1- Creating the Order Tracking Table.mp4	19.6 MB
08. Demo 1- Creating the Order Tracking Table.srt	13.7 KB
09. Using Collations.mp4	2.2 MB
09. Using Collations.srt	1.9 KB
10. Demo 2- Using Collations.mp4	6.1 MB
10. Demo 2- Using Collations.srt	3.7 KB
11. Summary.mp4	1.2 MB
11. Summary.srt	1.7 KB
/04. Improving Table Design Through Normalization/
01. Introduction.mp4	2.1 MB
01. Introduction.srt	2.7 KB
02. Identifying Problems with Unnormalized Data.mp4	4.0 MB
02. Identifying Problems with Unnormalized Data.srt	3.1 KB
03. Setting Objectives for Normalization.mp4	1.4 MB
03. Setting Objectives for Normalization.srt	2.0 KB
04. Demo 1 - Discovering Anomalies with Unnormalized Data.mp4	4.1 MB
04. Demo 1 - Discovering Anomalies with Unnormalized Data.srt	2.7 KB
05. Understanding First Normal Form.mp4	1.3 MB
05. Understanding First Normal Form.srt	2.0 KB
06. Demo 2 - Transforming the Design to 1NF.mp4	16.0 MB
06. Demo 2 - Transforming the Design to 1NF.srt	10.0 KB
07. Understanding Second Normal Form.mp4	1.3 MB
07. Understanding Second Normal Form.srt	1.5 KB
08. Demo 3 - Transforming the Design to 2NF.mp4	6.3 MB
08. Demo 3 - Transforming the Design to 2NF.srt	4.2 KB
09. Understanding Third Normal Form.mp4	1.6 MB
09. Understanding Third Normal Form.srt	1.7 KB
10. Demo 3 - Transforming the Design to 3NF.mp4	7.4 MB
10. Demo 3 - Transforming the Design to 3NF.srt	4.5 KB
11. Considering Other Normal Forms.mp4	3.1 MB
11. Considering Other Normal Forms.srt	4.8 KB
12. Summary.mp4	1.7 MB
12. Summary.srt	2.1 KB
/05. Ensuring Data Integrity with Constraints/
01. Introduction and Overview.mp4	2.2 MB
01. Introduction and Overview.srt	3.0 KB
02. Using NULL and DEFAULT Constraints.mp4	3.8 MB
02. Using NULL and DEFAULT Constraints.srt	5.5 KB
03. Demo 1 - NULL and DEFAULT Constraints.mp4	7.8 MB
03. Demo 1 - NULL and DEFAULT Constraints.srt	5.5 KB
04. Implementing the PRIMARY KEY Constraint.mp4	3.0 MB
04. Implementing the PRIMARY KEY Constraint.srt	3.8 KB
05. Using Index Types and the UNIQUE Constraint.mp4	3.6 MB
05. Using Index Types and the UNIQUE Constraint.srt	3.5 KB
06. Demo 2 - Implementing PRIMARY KEY and UNIQUE Constraints.mp4	8.2 MB
06. Demo 2 - Implementing PRIMARY KEY and UNIQUE Constraints.srt	4.7 KB
07. More About Foreign Key Constraints.mp4	2.2 MB
07. More About Foreign Key Constraints.srt	2.9 KB
08. Demo 3 - Using FOREIGN KEY Constraints.mp4	8.3 MB
08. Demo 3 - Using FOREIGN KEY Constraints.srt	6.6 KB
09. Introducing CHECK Constraints.mp4	2.6 MB
09. Introducing CHECK Constraints.srt	3.9 KB
10. Demo 4 - Using CHECK Constraints.mp4	11.5 MB
10. Demo 4 - Using CHECK Constraints.srt	5.6 KB
11. Options for Defining CHECK Constraints.mp4	2.7 MB
11. Options for Defining CHECK Constraints.srt	3.5 KB
12. Summary.mp4	1.8 MB
12. Summary.srt	2.7 KB
/06. Designing View to Meet Business Requirements/
01. Introducing Views.mp4	2.3 MB
01. Introducing Views.srt	2.6 KB
02. Overview and Motivation.mp4	3.1 MB
02. Overview and Motivation.srt	4.2 KB
03. Reviewing the Bobs Shoes Order System Design.mp4	754.3 KB
03. Reviewing the Bobs Shoes Order System Design.srt	0.9 KB
04. Demo 1 - Creating a View to Produced a List of Customers.mp4	5.4 MB
04. Demo 1 - Creating a View to Produced a List of Customers.srt	3.3 KB
05. Demo 2 - Using WITH SCHEMABINDING.mp4	6.1 MB
05. Demo 2 - Using WITH SCHEMABINDING.srt	4.7 KB
06. Working with Updateable Views.mp4	3.5 MB
06. Working with Updateable Views.srt	2.9 KB
07. Demo 3 - Updating Tables using Views.mp4	5.8 MB
07. Demo 3 - Updating Tables using Views.srt	3.5 KB
08. Summary.mp4	1.1 MB
08. Summary.srt	1.6 KB
/07. Implementing Indexed Views/
01. Introducing Indexed Views.mp4	4.8 MB
01. Introducing Indexed Views.srt	5.3 KB
02. Requirements for Indexed Views.mp4	5.9 MB
02. Requirements for Indexed Views.srt	6.5 KB
03. Demo 1 - Determining Determinism.mp4	2.8 MB
03. Demo 1 - Determining Determinism.srt	1.6 KB
04. YMIVR - Yet More Indexed View Requirements.mp4	1.8 MB
04. YMIVR - Yet More Indexed View Requirements.srt	2.1 KB
05. Demo 2 - Indexing the Customer List View.mp4	3.5 MB
05. Demo 2 - Indexing the Customer List View.srt	2.0 KB
06. Demo 3 - Adding a Nonclustered Index and Views with Aggregates.mp4	5.2 MB
06. Demo 3 - Adding a Nonclustered Index and Views with Aggregates.srt	3.2 KB
07. Summary.mp4	2.1 MB
07. Summary.srt	2.3 KB
/08. Implementing Partitioned Views/
01. Introducing Partitioned Views.mp4	1.8 MB
01. Introducing Partitioned Views.srt	2.4 KB
02. Outlining a Partitioned View.mp4	2.6 MB
02. Outlining a Partitioned View.srt	3.2 KB
03. Reviewing the Requirements and Restrictions.mp4	3.4 MB
03. Reviewing the Requirements and Restrictions.srt	4.3 KB
04. Demo 1 - Building a Partitioned View for the Orders Table.mp4	7.9 MB
04. Demo 1 - Building a Partitioned View for the Orders Table.srt	4.6 KB
05. Designing and Updating Partitioned Views.mp4	2.7 MB
05. Designing and Updating Partitioned Views.srt	4.3 KB
06. Summary.mp4	2.3 MB
06. Summary.srt	2.7 KB
/09. Summary/
01. Wrapping Up.mp4	985.7 KB
01. Wrapping Up.srt	1.3 KB
02. Designing Tables.mp4	2.5 MB
02. Designing Tables.srt	3.8 KB
03. Sqlserver Tables View Designing Implementing.mp4	1.3 MB
03. Sqlserver Tables View Designing Implementing.srt	2.2 KB
04. Considering Other Table Types.mp4	2.0 MB
04. Considering Other Table Types.srt	3.3 KB
05. Looking at Other Data Types.mp4	4.2 MB
05. Looking at Other Data Types.srt	4.4 KB
06. Finishing Strong!.mp4	447.9 KB
06. Finishing Strong!.srt	0.5 KB
/
sqlserver-tables-view-designing-implementing.zip	5.8 MB
Total files 138