watching now
22 Students

#### What Will You Learn?

• learn to use SQL professional way, learn new SQL!
• know how to prepare Data structures
• start to create table relations by creating relational tables
• know how to JOIN multiple table to get single result set for analysis reports
• know how to simplify reports like spreadsheets! with huge data sets

#### Requirements

• No prior technical experience is required! All you need a computer!
• Able to read and write on computer system with internet access

#### Curriculum

Course consist of total 5h 53min of content, in total.

24:14
##### Section 3: SQL Statement Basics
46:31
Overview of Challenges
04:02
SQL Statement Basic
07:15
SELECT Statement
12:16
SELECT DISTINCT
09:40
Column AS Statement
06:32
COUNT
06:46
##### Section 4: Filtering Data Rows
44:38
SELECT WHERE Clause â€“ One
05:43
SELECT WHERE Clause â€“ Two
11:26
ORDER BY
04:54
LIMIT
04:28
BETWEEN
08:04
LIKE and ILIKE
10:03
##### Section 5: GROUP BY Statements
30:11
Overview of GROUP BY
03:06
Aggregation Function
11:50
GROUP BY - One
04:40
GROUP BY â€“ Two
06:14
HAVING
04:21
##### Section 6: Assessment Test 1
02:01
Overview Assessment Test 1
02:01
Assessment Test 1
Solution to Assessment Test 1
##### Section 7: JOINS
47:35
Overview of JOINS
06:47
Introduction to JOINS
06:04
AS Statement
04:36
INNER Joins
13:33
Full Outer Joins
04:04
Left Outer Join
02:57
Right Outer Join
04:36
Union
04:58
##### Section 9: Advanced SQL Commands
55:56
03:31
Timestamps
16:50
Extract from Timestamp
05:11
Mathematical Functions
06:04
String Functions
16:20
SubQuery
08:00
##### Section 10: Creating Database and Tables
34:35
Basic of Database and Tables
06:24
Data Types
07:09
Primary Keys and Foreign Keys
04:17
Create Table in SQL Script
16:45
##### Section 11: Create Table
43:43
Insert
05:27
Update
05:22
Delete
03:15
Alter Table
05:23
Drop Table
01:53
Check Constraint
12:27
NOT NULL Constraint
04:25
UNIQUE Constraint
05:31
##### Section 12: Databases and Tables
09:13
Overview of Databases and Tables
02:25
Creating a Database backup
03:15
Restoring a Database from backup
03:33