Part 1: SQL fundamentals for Data Science
Text Lesson
Install Microsoft SQL Server and SSMS
Learn how to install Microsoft SQL Server and SSMS
Study Duration
10 Min
Text Lessons
#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