Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

SQL For Beginners : Microsoft : Beginner To Expert


Introduction :
Introduction to the course: SQL For Beginners : Microsoft : Beginner To Expert
Leave a review and win FREE access to courses

Help with this course and Support :
Help with this course and Support

Installing SQL Server on a Windows Server Environment :
Download and Installing SQL Server on the Windows Server environment

Using SQL Server Management Studio :
Using SQL Server Management Studio

How to create a database and table a SQL Server Database :
What is a database
What is a table
Setup and creating test data

Getting information from tables using SELECT Statements :
SELECT
UNION
DATE Functions
CASE Statements
Further Reading
TSQL
2 questions
Learn TSQL
1 question

Joining tables using JOIN Statements :
JOINS : INNER, LEFT AND RIGHT JOINS
Which JOIN is better? PART 1
Which JOIN is better? PART 2

Aggregation Functions :
COUNT Statement
SUM Statement
AVG (Average) Statement

Filter GROUP BY Statement using HAVING Statements :
Filter GROUP BY Statement using HAVING Statements

Insert Statements :
Insert Statements
Further Reading

Update Statements :
Update Statements
Further Reading

Delete Statements :
Delete Statements
Further Reading

Condition Statements :
IF / ELSE
Further Reading

Practice Assignment :
Practice Assignment
1 question

Learn how to import a file into SQL Server :
Importing a file into SQL Server
Practice Assignment - Import File
1 question

DISCOUNTS. FREE Courses and Extra Training! :
DISCOUNTS and FREE Courses
Well Done

Conclusion :
What to learn next