It would be nice if you could code along on your own device with SQL already installed. If not, n this hour, you can sit back, relax and enjoy the demonstration.

We cover MS SQL Server in Azure Data Studio. If you have a different database, you will still learn the basics and may have to research some differences. Send us a request for your database, and we can host it as well in a different time slot.

Multiple dates

SQL: Create a professional relational database

By PCWorkshops

SQL Course: Create a database: Relationships, Primary & Foreign Keys, tables, columns, datatypes, indexes, constraints

Location

Online

Good to know

Highlights

5 hours
Online

Refund Policy

No Refunds

About this event

Science & Tech • Medicine

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

Organised by

PCWorkshops

Followers

--

Events

--

Hosting

--