categories: Technology, Science & Productivity
Level: Specialized
Course Language: English
Create and modify tables by setting constraints to columns and using some of the most useful built-in functions in SQL as well as data type conversion.
Select and filter data using SQL, fetch data for useful reports, and manipulate data by adding new records and modifying or deleting the existing ones.
Improve your SQL skills and take your skills to the next level, as SQL is in high demand because all big tech companies use it to query data and perform analysis.
Free lessons
Introduction
Download PostgreSQL
Tools Used in This Course
Install PostgreSQL
Download SQLectron
Install SQLectron
1. Introduction
Introduction
Tools Used in This Course
2. Setting Up Course Tools
Download PostgreSQL
Install PostgreSQL
Download SQLectron
Install SQLectron
Connect to PostgreSQL - Credentials
Connect to PostgreSQL Using SQLectron
Import Course Data Using SQLectron
FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver
3. NULL, DISTINCT & CASE Statements
Fetch A Field's Unique Values Using DISTINCT
Using DISTINCT Keyword with Multiple Columns
What is a NULL Value?
Build More Sophisticated Queries with CASE Statements
Your Knowledge So Far Under A Great Test
4. Functions in SQL: Multiple-Row Functions
Introduction to Functions
SUM Function
AVG (Average) Function
COUNT Function
MIN & MAX Functions
How To Count Your Field's Unique Values
GROUP BY Clause: Use Functions with Dimensions
GROUP BY More Than One Dimension
Now For Some Tough Workout
Filter By Aggregate Functions with HAVING Clause
5. Functions in SQL: Single-Row Functions
Character Functions - UPPER, LOWER & INITCAP
Character Functions - CONCAT & LENGTH
Character Functions - LPAD & RPAD
Character Functions - TRIM
Character Functions - SUBSTR
Character Functions - REPLACE
Number Functions - MOD & ROUND
Number Functions - TRUNC
6. Data Manipulation (DML)
INSERT a New Record to a Table
Insert Without Specifying Column Names
UPDATE a Record's Field Values
CAUTION! How an UPDATE Query Can Go Wrong
Update a Record Using Single-Row Functions
A Good Exercise: Extract Employee's Email Address
Solution: Extract Employee's Email Address
DELETE a Table's Record
Insert Records with Nested Select Queries
7. SQL Data Definition Language (DDL)
SQL Data Types Revised
Bookstore Data Set: Let's Move It to Database
Create Your First Table!
Insert Data to Your New Table
Change Column Data Type
Rename Column
Add a New Column to Table
Drop Column
DROP Table
Data analysis requires working with a large amount of data and performing manipulation on it. If you are interested in data science and want to pursue a career in it, SQL is listed as one of the most in-demand skills in the skill set for data analyst roles. Therefore, this course was prepared to help you learn about functions in SQL and manipulate data by adding new records and modifying or deleting existing ones.
If you wish to have more information, we recommend you check part one of this course.
Data Engineer
814 Learners
3 Courses