Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Udemy Learn SQL Beginner to Advanced Level

Video Introducing this tutorial


Introduction :
SQL Course Introduction
Instructor Introduction
Course Requirement & Prerequisite
Course Curriculum
Course Structure
Application Downloads & Installation
Windows Applications Download & Installation
Mac book Applications Download & Installation
Microsoft SQL Server Environment Review

Data, Databases & Database Management system :
Section Introduction
What is Data?
What are Databases?
Introduction to Database Management System (DBMS)
Relational Database Management System (RDBMS)
How to Create a database
Saving Queries in SQL Server
Selecting a Database
Delete a Database

Introduction to SQL (Structured Query Language) :
Section Introduction
What is SQL ?
SQL Dialect
SQL Naming Convention

Data Types in SQL :
Section Introduction
SQL Data Types
Numeric Data Type
String Data Type

Tables in SQL :
Section Introduction
Introduction to Tables
Create Tables
Insert Data into Tables
Retrieve Data from Tables
Delete a Table

Data Definition Language (DDL) :
Section Introduction
CREATE, DROP, ALTER
Adding comments to query
Null & Not Null - SQL Constraint
Add a Default Constraint
Add a Unique Constraint
Primary Key Constraint
Using IDENTITY in SQL

Data Query Language (DQL) :
Section Introduction
SELECT statement
WHERE clause

Data Manipulation Language (DML) :
Section Introduction
UPDATE command
DELETE command
Adding Aliases
Decimal Data Type - Numeric Data Type

String Functions :
Section Introduction
String Functions
CONCAT Function
CONCAT_WS Function
LEFT Function
RIGHT Function
LEN Function
UPPER Function
LOWER Function
LTRIM, TRIM, TRIM Function
REVERSE Function
REPLACE Function
SUBSTRING Function
Sorting Records
Section Introduction
Insert character value with apostrophe/single quote
Order By
DISTINCT Statement
TOP Clause
OFFSET & FETCH
% Percentage Wildcard
Underscore Wildcard

Aggregate Functions :
Section Introduction
COUNT Function
GROUP BY
AVERAGE Function
SUM Function
MAX Function
MIN Function
HAVING Clause
IN Operator
Sub Queries

Date & Time Data Type :
Section Introduction
Date & Time Data Type
Extract Part of Date Values
GETDATE Function
CURRENT_TIMESTAMP
DATEPART Function
DATEDIFF Function
DATEADD Function
DATE Format
TIME Format
DATE&TIME Format
CAST & CONVERT - More Date & Time Format

Comparison Operators :
Section Introduction
Understanding Comparison Operators
Equal
Not Equal
Greater Than
Less Than
Greater Than or Equal
Less Than or Equal

Logical Operators :
Section Introduction
AND
OR
BETWEEN
LIKE & NOT LIKE
Case Statement

Data Relationships :
Section Introduction
Understanding Data Relationship
One to One Relationship
One to Many Relationship
Many to Many Relationship
Normalization

Create One to Many Relationship :
Section Introduction
Creating A One to Many Relationship
Foreign Keys
One to Many Schema
Introduction to JOIN
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN

Create Many to Many Relationship :
Section Introduction
Creating a Many to Many Relationship
Creating Many to Many Schema
Insert Records into Schema
Many to Many Task 1
Many to Many Task 2
Many to Many Task 3
Many to Many Task 4
Many to Many Task 5
Many to Many Task 6
Many to Many Task 7
Many to Many Task 8
Many to Many Task 9
Many to Many Task 10

Conclusion :
What Next?