watching now
62 Students

#### What Will You Learn?

• learn to use MS SQL professional way, learn new SQL!
• create basic SQL queries
• know how to simplify reports like spreadsheets! with huge data sets
• learn how to protect your data by doing backup and restore methods!
• create left, right, inner and full outer joins

#### Requirements

• A basic knowledge of computers
• No prior technical experience is required! All you need a computer with internet access!

#### Curriculum

Course consist of total 8h 49min of content, in total.

##### Section 2: SQL Environment Setup
45:26
Connecting to MS-SQL (Windows Authentication)ture
04:41
Connecting to MS-SQL (SQL Server Authentication)
05:35
##### Section 3: SQL Statement Basics
1:07:49
Overview of Challenges
02:38
SQL Statement Basic
12:54
SELECT Statement
16:29
SELECT DISTINCT
16:54
Column AS Statement
09:12
COUNT
09:42
##### Section 4: Filtering Data Rows
16:36
SELECT WHERE Clause â€“ One
04:58
SELECT WHERE Clause â€“ Two
11:38
##### Section 5: SQL Query Operators
49:32
ORDER BY
09:34
TOP in MSSQL
05:39
BETWEEN
13:13
In Operator
08:12
SQL LIKE Operator
12:54
##### Section 6: GROUP BY Statements
1:08:01
Overview of GROUP BY
08:12
Aggregation Function â€“ SUM()
11:52
Aggregation Function â€“ MIN()-MAX()
08:21
GROUP BY â€“ One(theory)
10:55
GROUP BY â€“ Two(practical)
13:55
HAVING
14:46
##### Section 7: Assessment Test 1
02:43
Overview Assessment Test 1
02:43
Assessment Test
Solution for an Assessment Test
##### Section 8: JOINS
58:30
Overview of JOINS
06:39
Introduction to JOINS
07:08
AS Statement
03:44
INNER Join
12:21
Full Outer Join
07:24
Left Outer Join
05:59
Right Outer Join
07:51
Union
07:24
##### Section 9: Advanced SQL Commands
57:19
04:20
Timestamp
11:40
Extract from Timestamp
06:22
Mathematical Scalar Functions
11:08
String Functions
16:40
SubQuery
07:09
##### Section 10: Creating Database and Tables
33:26
Basic of Database and Tables
09:41
Data Types
10:54
Select Data type on SSMS
05:06
Create Table on SSMS
07:45
##### Section 11: Primary Key and Foreign Key
25:00
How to set Primary Key
05:37
How to set Foreign Key
12:11
Create Table using SQL Script
07:12
##### Section 12: SQL CRUD Operations
1:05:29
Insert
06:29
Update
08:02
Delete
06:35
Alter Table
04:20
Drop Table
02:55
Check Constraint
14:07
NOT NULL Constraint
11:46
UNIQUE Constraint
11:15
##### Section 13: Backup and Restore Functions
21:58
Overview of Database and Tables
03:32
Creating a Database backup using SSMS
10:51
Restoring a Database from backup using SSMS
07:35