SQL: Create a professional relational database
By PCWorkshops
Online event
Multiple dates
Overview
SQL Course: Create a database: Relationships, Primary & Foreign Keys, tables, columns, datatypes, indexes, constraints
SQL DDL Course details
Duration:3 hours
Pre-requisite: It will help if you know SQL basics, but not essential
Location: Online, Instructor-led
SQL Course outline:
HOUR 1:
- Understand Relational Database, ERD Diagram, Relationships, Primary and Foreign Keys. Discussing data types.
HOUR 2:
Creating Tables in SQL:
- Table names,
- Columns, datatypes.
- Primary Key
- Foreign Key
- Identity / Auto-increments
Add Constraints:
- Not Null
- Unique
- Default
- Check
Hour 3:
- Views, Indexes, and sequencing.
- SQL Temporary Tables
Do the full course : https://pcworkshopslondon.co.uk/sql-advanced-course.html. Read more
Category: Science & Tech, Medicine
Good to know
Highlights
- 5 hours
- Online
Refund Policy
No refunds
Location
Online event
Frequently asked questions
Organised by
PCWorkshops
Followers
--
Events
--
Hosting
--