Microsoft SQL for Beginners (SQL Server and T-SQL)

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

4.38 (327 reviews)
Udemy
platform
English
language
Databases
category
instructor
8,094
students
2 hours
content
Apr 2020
last update
FREE
regular price

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 Language - SQL 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

- 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.

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

Screenshots

Microsoft SQL for Beginners (SQL Server and T-SQL) - Screenshot_01Microsoft SQL for Beginners (SQL Server and T-SQL) - Screenshot_02Microsoft SQL for Beginners (SQL Server and T-SQL) - Screenshot_03Microsoft SQL for Beginners (SQL Server and T-SQL) - Screenshot_04

Reviews

Neeraj
November 4, 2023
Its a Good course, though things on some topics could have been explained in a better way. On SSMS you clicked on a tab to go to a previous screen or command, I couldn't get that!
Mukesh
April 27, 2023
Very small screen and fonts, can't see any words clearly no proper sound, noise disturbances in background. No practice questions are available.
Mark
March 30, 2023
Sound quality could have been better, notifications were going off through some vids and mic quality was poor on some videos. Some labs with written courses to follow would have also been helpful. Other than that, the course was well explained and got to the point quickly.
Fern
November 14, 2022
Great course, most of which was explained very well. A few things although had great examples, didn't offer context of what it actually was or would be used for. Had to do further research to fill in the gaps. Overall, I really enjoyed this and love that it is broken down into small videos. Would defiantly recommend.
Iga
November 5, 2022
The quality of the recording is very poor, both vision and audio. There are no quizes, resources, time for self work, no interaction. The course seems chaotic to me, like it was created on the go. The plus is that it is concise, it is a quick reminder of SQL, not much about the tool itself other than installation.
Jada
November 3, 2022
Course went very fast. I think more explanation was needed. It didn't seem like a course for beginners.
Sowmya
July 5, 2022
Its been an excellent experience. As I'm going through tutorial, I'm able to get hands on & download SQL server, SSMS & setup the environment. Looking forward to the rest of the tutorial now!
BSV
May 4, 2021
Basics were taught with perfection. However, there is a bit of discrepancies where observed during the tables creation and views statements. Creation of tables should have been included.
Michael
April 8, 2021
Its difficult to see the video. The audio pierces my ears. The information may be valuable, but I am getting a headache trying to complete.
Olga
December 15, 2020
I just started watching this course today. In my opinion, this course is very dynamic and interesting. It looks like it is right what I need.
Magnus
December 14, 2020
No databases ended up at any of those locations that were supposed to happen "automatically" so I had to spend hours on trying to figure out what went wrong.
Deepali
December 13, 2020
As a beginner this course was very good, it guides you from the start. An excellent course for those who have no prior experience of SQL.
Brett
December 5, 2020
It would bet better if there were scenarios we were asked to run after each lesson and more in depth examples.
Angelo
November 27, 2020
Nice course! Would have loved to be little longer as Vimal is a great teacher. Only had some troubles with the Join lab section, but nothing more than that
Ellyn
November 11, 2020
The relatively-up-to-date information helps to ensure that what I'm searching for is what is being shown by the instructor. I have found that in other courses, the websites no longer contain the data that is being shown, which makes it very difficult and discouraging to follow along especially when the subject matter is a new skill.

Charts

Price

Microsoft SQL for Beginners (SQL Server and T-SQL) - Price chart

Rating

Microsoft SQL for Beginners (SQL Server and T-SQL) - Ratings chart

Enrollment distribution

Microsoft SQL for Beginners (SQL Server and T-SQL) - Distribution chart

Related Topics

3002764
udemy ID
4/14/2020
course created date
4/22/2020
course indexed date
Angelcrc Seven
course submited by