MS SQL Server 2012: Creating a Database, the first course in the SQL Server 2012 Database Implementation Certification series.
This series is designed to
After completing the course, you will be able to:
Describe the overall SQL Server 7.0 architecture
Use the tools that come with SQL Server 7.0
Define key relational concepts, such as relational integrity, data integrity, and prima, foreign, and unique keys
Create, modify, and delete databases
Create, modify, and delete tables
Use SQL Server constraints and indexes
As you probably know, you can interact with SQL Server in two ways: by issuing Transact-SQL commands, and by interacting with its GUI,
or Graphical User Interface. This course uses Slideshow and Tooltips to explain the code syntax used in Transact-SQL commands,
and simulations for practicing different elements of the SQL Server GUI.
For additional information on these and other applets, see the Course Orientation .