Description

Create databases using SQL syntax rather than relying on the user interface..

Build database creation solutions which can be reused and adapted for different projects..

Use SQL database creation syntax in your applications..

Use SQL to create and modify database schemas to rationalize security..

This course will enable you to enhance your basic knowledge of Microsoft Transact SQL by learning the key SQL statements involved in the creation of databases. Although you can create a complete database manually, using the SQL Server Management Studio interface, knowing the SQL commands for database creation is essential if you are preparing yourself for a role as a database administrator, a database engineer or Microsoft web developer. This course assumes that you know the basics of SQL; but we do begin with a revision of some key SQL CRUD syntax: Create, Read, Update and Delete. The course will explain the mechanics of, and SQL syntax for, the creation of the three types of database relationship used in SQL Server: one-to-many, one-to-one and many-to-many; and the use of primary and foreign key constraints. You will learn how to use SQL to create database schemas; how to create tables within a schema; move tables between schemas; and the security benefits of using schemas.