Part 1: SQL fundamentals for Data Science

Introduction to SQL

19 Parts - 0:04 Hr

Learning Community

Join the course community. Ask questions, engage with instructors or share your knowledge with peers.

4 Min

Attachments:

Introduction to SQL

7.54 MB MB

SQL as declarative language

7.31 MB MB

Relational Database Management Systems(RDMS)

7.73 MB MB

Introduction to Databases

7.21 MB MB

Introduction to Tables

9.93 MB MB

Introduction to SQL Data types

8.54 MB MB

Approximate numeric Data types

5.50 MB MB

Exact numeric Data types

12.86 MB MB

Character Data types

4.31 MB MB

Date and Time Data types

11.30 MB MB

Introduction type of SQL Statements

8.09 MB MB

The CREATE Statement

8.78 MB MB

The ALTER Statement

7.72 MB MB

The DROP Statement

5.35 MB MB

INSERT Statement

8.38 MB MB

UPDATE Statement

7.33 MB MB

The DELETE Statement

7.24 MB MB

The SELECT Statement

7.69 MB MB

Getting started with Microsoft SQL Server and Azure

6 Parts - 0:10 Hr

Introduction to Microsoft SQL Server

6.99 MB MB

Introduction SQL Server Management Studio

8.46 MB MB

Introduction to Azure Data Studio

3.01 MB MB

Exploring Microsoft SQL Server Mgt Studio

16.56 MB MB

Install Microsoft SQL Server and SSMS

Learn how to install Microsoft SQL Server and SSMS

10 Min

Attachments:

Setting up your environment

12.17 MB MB

SQL Scripting

18 Parts - 1:22 Hr

Exercise Files

Download the sample code for your review.

13.81 KB MB

Creating Databases

Learn how to create databases.

5 Min

Attachments:

Creating table

Learn how to create tables within databases.

9 Min

Attachments:

View tables with SELECT statement

Learn how to view tables with the SELECT statement.

2 Min

Attachments:

Adding new columns to a Table

Adding new columns to existing tables

4 Min

Attachments:

Changing data type of a column

Learn how to change the column of an existing column

6 Min

Attachments:

Drop columns in a table

How to drop or delete columns in a table.

3 Min

Attachments:

Rename columns in a table

How to rename an existing column in a table

5 Min

Attachments:

Rename existing tables

3 Min

Attachments:

Using the DROP statement

3 Min

Attachments:

Inserting values into tables

8 Min

Attachments:

Inserting values into tables 2

Inserting values into tables

7 Min

Attachments:

Using the UPDATE statement

Updating records in a table

6 Min

Attachments:

Using the UPDATE statement 2

Update records with the UPDATE statement

2 Min

Attachments:

Delete records with the DELETE statement

Delete records from tables

4 Min

Attachments:

Delete records using TRUNCATE statement

Using the truncate statement

2 Min

Attachments:

Drop TOP N records from a table

Delete top N records in a table

3 Min

Attachments:

Qualified Assessment

Test your knowledge

10 Min

Attachments:

SQL Constraints

9 Parts - 0:49 Hr

Introduction to SQL Constraints

4 Min

Attachments:

Introduction to SQL Constraints 2

Introduction to SQL Constraints

3 Min

Attachments:

Working with NULL Constraint

6 Min

Attachments:

Working with UNIQUE Constraint

5 Min

Attachments:

Working with DEFAULT Constraint

5 Min

Attachments:

Working with the PRIMARY KEY Constraint

7 Min

Attachments:

Working with FOREIGN KEY constraint

13 Min

Attachments:

Working with IDENTITY constraint

6 Min

Attachments:

Viewing Database objects

32.31 MB MB

Working with External Data

2 Parts

Import Data from Flat file

55.48 MB MB

Importing Data from Microsoft Excel

60.66 MB MB

Getting started with Azure Data Studio

3 Parts - 0:14 Hr

Exploring Azure Data Studio Interface

4 Min

Attachments:

Working with the Query editor

5 Min

Attachments:

Working with Notebooks

5 Min

Attachments:

Exploring Data with SQL

15 Parts - 0:43 Hr

Exploring the datasets

5 Min

Attachments:

Retrieving data with the SELECT statement

5 Min

Attachments:

Copy data from one table to another

5 Min

Attachments:

Select Distinct Values

6 Min

Attachments:

Sort data with ORDER BY Clause

20.89 MB MB

Select TOP N items

20.19 MB MB

Filter data with WHERE Clause

16.60 MB MB

Filter data with WHERE Clause & AND

14.58 MB MB

Introduction to Aggregate functions

16.43 MB MB

Summarize values with Aggregate functions

13.21 MB MB

Using Alias

12.00 MB MB

Qualified Assessment

Apply your skills to a real world data.

20 Min

Attachments:

Course conclusion

4.36 MB MB

Qualified Assessment

Just indicate you have completed the qualified assessment in the previous lesson.

Reply yes in the textbox below if you are done.

Min Grade: 80

Course review

2 Min

Attachments:

Part 1: SQL fundamentals for Data Science

About this course

Comments (0)

Reviews (1)

Gift this course

Course specifications

THOMAS FESTUS CUDJOE

Tags

Report course

Share

Buy with points

18 Weeks Business Intelligence and Data Analytics