Install Microsoft SQL Server and SSMS

#1

Learning Community

#2

Qualified Assessment

#3

Creating Databases

#4

Creating table

#5

View tables with SELECT statement

#6

Adding new columns to a Table

#7

Changing data type of a column

#8

Drop columns in a table

#9

Rename columns in a table

#10

Rename existing tables

#11

Using the DROP statement

#12

Inserting values into tables

#13

Inserting values into tables 2

#14

Using the UPDATE statement

#15

Using the UPDATE statement 2

#16

Delete records with the DELETE statement

#17

Delete records using TRUNCATE statement

#18

Drop TOP N records from a table

#19

Introduction to SQL Constraints

#20

Introduction to SQL Constraints 2

#21

Working with NULL Constraint

#22

Working with UNIQUE Constraint

#23

Working with DEFAULT Constraint

#24

Working with the PRIMARY KEY Constraint

#25

Working with FOREIGN KEY constraint

#26

Working with IDENTITY constraint

#27

Exploring Azure Data Studio Interface

#28

Qualified Assessment

#29

Course review

#30

Install Microsoft SQL Server and SSMS

#31

Exploring the datasets

#32

Retrieving data with the SELECT statement

#33

Copy data from one table to another

#34

Select Distinct Values

#35

Working with the Query editor

#36

Working with Notebooks

#37

Optional: Installing MYSQL Workbench and Server

#38

Exploring the interface of MYSQL Workbench

View full lessons Check course learning page