Microsoft SQL for Database Creation

Description

In this course, you will :

• Instead of relying on the user interface, create databases using SQL syntax.
• Create database creation solutions that can be reused and adapted for various projects.
• In your applications, use SQL database creation syntax.
• To rationalise security, use SQL to create and modify database schemas.

Syllabus :

1. CRUD Essential Syntax

• Writing comments and getting help
• CREATE, USE and DROP DATABASE
• CREATE TABLE
• The INSERT statement
• The SELECT statement
• The UPDATE statement
• The DELETE statement

 

2. Understanding Table Relationships

• Relational databases and tables
• Understanding primary and foreign key
• One to many relationships
• One to one relationships
• Many to many relationships

 

3. Creating Database Schemas

• Creating schemas
• Creating a table inside a schema
• Moving a table to another schema
• Schemas and security

 

4. Columns and Data Types

• Overview of SQL data types
• Creating IDENTITY columns
• Using the CHAR and VARCHAR data types
• Using the NVARCHAR data type
• INT variation data types
• Using the DECIMAL and MONEY data types
• Using the DATE and DATETIME data types

 

5. Constraints and Indexes

• The NOT NULL constraint
• Creating primary key constraints
• Creating a composite primary key
• The UNIQUE constraint
• Creating foreign key constraints
• Using the DEFAULT constraint
• Using the CHECK constraint
• Overview of indexes
• Creating clustered indexes
• Creating non-clustered indexes

 

6. Creating the Final Database

• Creating the database and schemas
• Creating the Zones table
• Creating the Sales.Countries table
• Creating the Sales.Clients table
• Creating the Media.Testimonials table
• Creating the Sales.Categories table
• Creating the Sales.Workshops table
• Creating the HR.Venues table
• Creating the Sales.EventsData table
• Creating the Sales.EventsClients table
• Creating the HR.Tutors table
• Creating the HR.EventsTutors table

Show more