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.
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.