What you'll learn:
- 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.
We also take an in-depth look at the creation of database columns of different data types; and the SQL techniques for inserting data in the correct format.
You will also learn the SQL syntax for creating database constraints to enhance the integrity of your data.
And the course will also show you how to use SQL statements to create clustered and non-clustered indexes, to improve the performance of your databases.
So, if you need a Transact SQL course to take your basic knowledge to the next level, this could be just the course you are looking for.
