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