Microsoft SQL for Database Creation

Microsoft SQL for Database Creation
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 2.38 GB
Genre: eLearning Video | Duration: 50 lectures (4 hour, 31 mins) | Language: English

Enhance your SQL knowledge

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.

Requirements

No prior knowledge of SQL is assumed. Familiarity with databases and database terminology is useful but not essential.
Students will need to be using a Windows computer capable of running SQL Server.

Description

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.

Who this course is for:

This course is designed for anyone needing to increase their familiarity with SQL and move beyond basic SELECT statements.