Learn the basic of SQL and SQL Server with no previous experience needed!

What you will learn

T-SQL

SQL

Microsoft SQL Server

Basic SQL – Select, Filter, Where and More…

Advanced SQL – Group By, Having, Temporary Tables

Joins

Working with Tables – Insert, Update, Deletes

Programmability – Stored Procedures and Views

Description

Are you interesting in learning a skill that can start you in a job between $85,000-$125,000?

In this course you will learn Structured Query LanguageSQL and how to use Microsoft SQL Server

Databases are incredibly important in our modern world with many organizations using data to run and drive their business and learning SQL is the staring point to roles in Data Science and Big Data.

This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server

This course covers a series of topics including…

– Setting up and installing SQL Server

– Installing a sample database

– Select Queries


Get Instant Notification of New Courses on our Telegram channel.


– Where Clauses

– Advanced SQL Queries

– Joins

– Aggregate Functions

– Subqueries

– Stored Procedures and Views

Click the Signup button to sign up for the course!

  • A PC or Mac is required
  • No prior knowledge of Databases, SQL or SQL Server  is needed.
English
language

Content

Introduction

Introduction

Setup and Installation of Tools

Downloading and Installing SQL Server
Downloading and Installing SQL Management Studio
Download and Restore AdventureWorks Sample Database

Basic SQL Writing

Basic SQL Syntax and Select
Select Distinct
Where Clause
And, Or, Not
Order By
Top
Putting it Together
Max and Min
Like
In
Between

Advanced SQL Statements

Count, Avg and Sum
Nulls
Group By
Having
Nested SQL
Case
Temporary Tables
Common Table Expressions
Date Functions

Joins

Joins
Inner Join
Left Join
Right Join
Outer Join
Joining Multiple Tables
Join Lab
Union

WORKING WITH TABLES

Insert Into
Insert Into Select
Update
Delete
Truncate

Programmability

Views
Stored Procedures