Lynda Developing Microsoft SQL Server 2014 Databases

/01. Introduction/

01_01-Welcome.mp4

01. Introduction/

01_02-What you should know before watching this course.mp4

02. Working with SQL Server Development Tools/

02_01-Using SQL Server Management Studio.mp4

02_02-Managing projects with SSMS.mp4

02_03-Using SQL Server data tools.mp4

02_04-Creating database diagrams.mp4

02_05-Understanding the SQL Server services.mp4

03. Designing Data Tables/

03_01-Reviewing database normalization.mp4

03_02-Introduction to designing tables.mp4

03_03-Designing tables.mp4

03_04-Utilizing schemas with tables.mp4

03_05-Exploring SQL Server data types.mp4

03_06-Altering tables.mp4

04. Understanding the Concept of Constraints/

04_01-Using constraints to enforce integrity.mp4

04_02-More on using constraints to enforce integrity.mp4

04_03-Implementing check constraints.mp4

04_04-Implementing entity constraints.mp4

04_05-Implementing referential integrity.mp4

05. Storage and Indexes/

05_01-Understanding the SQL file structure.mp4

05_02-How SQL stores data.mp4

05_03-How SQL locates data.mp4

05_04-Implementing nonclustered indexes.mp4

06. Designing Views/

06_01-Introducing views.mp4

06_02-Creating and managing views.mp4

07. Working with Stored Procedures/

07_01-Understanding stored procedures.mp4

07_02-Using parameters with stored procedures.mp4

08. Performing Data Modification with Triggers/

08_01-Understanding triggers.mp4

08_02-Utilizing triggers.mp4

09. InMemory Databases/

09_01-What is inmemory.mp4

09_02-Inmemory More details.mp4

09_03-Creating inmemory tables.mp4

09_04-Inmemory stored procedures.mp4

09_05-Migrating.mp4

10. Conclusion/

10_01-Next steps.mp4

Total files 34