
G Com Solutions
Online Training
About the instructor
All G Com Solutions trainers (both online and in person) are highly experienced IT professionals and qualified to deliver a wide range of Microsoft training courses.
They have a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes and have all obtained the MCSA BI Reporting certification.
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.
Course Contents
Course Curriculum
- 6.1 The NOT NULL constraint
- 6.2 Creating primary key constraints
- 6.3 Creating a composite primary key
- 6.4 The UNIQUE constraint
- 6.5 Creating foreign key constraints
- 6.6 Using the DEFAULT constraint
- 6.7 Using the CHECK constraint
- 6.8 Overview of indexes
- 6.9 Creating clustered indexes
- 6.10 Creating non-clustered indexes
- 7.1 Creating the Database And Schemas
- 7.2 Creating the Sales.Zones Table
- 7.3 Creating the Sales.Countries Table
- 7.4 Creating the Sales.Clients Table
- 7.5 Creating the Media.Testimonials Table
- 7.6 Creating the Sales.Categories Table
- 7.7 Creating the Sales.Workshops Table
- 7.8 Creating the HR.Venues Table
- 7.9 Creating the Sales.EventsData Table
- 7.10 Creating the Sales.EventsClients Table
- 7.11 Creating the HR.Tutors Table
- 7.12 Creating the HR.EventsTutors Table