Lynda - Developing Microsoft SQL Server 2014 Databases with Ron Davis [MJ] (Size: 305.32 MB)
| | | 2-What you should know before watching this course.mp4 | 4.26 MB |
| | | 1-Welcome.mp4 | 2.1 MB |
| | | 1-Using SQL Server Management Studio.mp4 | 13.51 MB |
| | | 4-Creating database diagrams.mp4 | 12.1 MB |
| | | 2-Managing projects with SSMS.mp4 | 11.7 MB |
| | | 5-Understanding the SQL Server services.mp4 | 11.64 MB |
| | | 3-Using SQL Server data tools.mp4 | 10.91 MB |
| | | 1-Reviewing database normalization.mp4 | 16.74 MB |
| | | 2-Introduction to designing tables.mp4 | 14.25 MB |
| | | 3-Designing tables.mp4 | 14.25 MB |
| | | 5-Exploring SQL Server data types.mp4 | 5.89 MB |
| | | 4-Utilizing schemas with tables.mp4 | 5.49 MB |
| | | 6-Altering tables.mp4 | 4.15 MB |
| | | 5-Implementing referential integrity.mp4 | 17.43 MB |
| | | 1-Using constraints to enforce integrity.mp4 | 11.49 MB |
| | | 3-Implementing check constraints.mp4 | 10.12 MB |
| | | 4-Implementing entity constraints.mp4 | 5.43 MB |
| | | 2-More on using constraints to enforce integrity.mp4 | 4.32 MB |
| | | 4-Implementing nonclustered indexes.mp4 | 12.27 MB |
| | | 3-How SQL locates data.mp4 | 11.3 MB |
| | | 2-How SQL stores data.mp4 | 10.42 MB |
| | | 1-Understanding the SQL file structure.mp4 | 7.49 MB |
| | | 1-Introducing views.mp4 | 11.78 MB |
| | | 2-Creating and managing views.mp4 | 4.61 MB |
| | | 1-Understanding stored procedures.mp4 | 5.49 MB |
| | | 2-Using parameters with stored procedures.mp4 | 3.03 MB |
| | | 2-Utilizing triggers.mp4 | 7.58 MB |
| | | 1-Understanding triggers.mp4 | 6.08 MB |
| | | 1-What is in-memory-.mp4 | 13.22 MB |
| | | 2-In-memory- More details.mp4 | 10.03 MB |
| | | 4-In-memory stored procedures.mp4 | 9.94 MB |
| | | 5-Migrating.mp4 | 9.65 MB |
| | | 3-Creating in-memory tables.mp4 | 4.44 MB |
| | | Next steps.mp4 | 2.21 MB |
Description
Learn how to develop databases with the latest version of SQL Server. Ron Davis shows how to design tables and views, use constraints, and create and implement indexes. He also discusses stored procedures, and using triggers to modify data. Plus, learn about features unique to SQL Server 2014: in-memory tables and in-memory (or natively compiled) stored procedures.
Topics include:
Working with SQL Server development tools
Designing database tables
Utilizing schemas with tables
Using constraints to enforce integrity
Understanding how SQL stores and locates data
Designing database views
Working with stored procedures
Using triggers to modify data
Creating in-memory databases.
KEEP SEEDING
Sharing Widget