LearnNowOnline - SQL Server 2014: Designing and Creating a Database
English | 5/2/2015 | mp4 | H264 800x600, 1024x768 | AAC 1 ch | 2 hr 25 min | 176 MB
eLearning | Level: Intermediate
English | 5/2/2015 | mp4 | H264 800x600, 1024x768 | AAC 1 ch | 2 hr 25 min | 176 MB
eLearning | Level: Intermediate
Creating a database is not just inputting data into a computer and expecting a database to appear. This course will teach you the basics of relational database design principles. You will then see how to create a SQL Server database based on sound design principles. Then see how to build tables using the SQL Server Management Studio designers. You will learn about SQL Server data types, how to create constraints, triggers, and indexes. Then to finish up create a database diagram and define relationships to enforce referential integrity.
Prerequisites
The users should have a working knowledge of the Microsoft OS, Visual Studio and Server environment. This course assumes that you have at least a basic familiarity with the concept of relational databases and a basic understanding of what SQL Server is and the high-level tools in it.
Screenshots: