Microsoft SQL for Beginners (SQL Server and T-SQL)
3.9 (111 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,456 students enrolled

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

Learn the basic of SQL and SQL Server with no previous experience needed!
3.9 (111 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,456 students enrolled
Created by Vimal Vachhani
Last updated 4/2020
English
English [Auto]
Current price: $20.99 Original price: $29.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 39 lectures 01:48:02
+ Basic SQL Writing
11 lectures 30:17
Basic SQL Syntax and Select
06:32
Select Distinct
01:03
Where Clause
02:58
And, Or, Not
03:34
Order By
03:10
Top
00:53
Putting it Together
01:52
Max and Min
02:23
Like
04:12
In
01:30
Between
02:10
+ Advanced SQL Statements
9 lectures 25:07
Count, Avg and Sum
02:53
Nulls
01:36
Group By
04:02
Having
02:00
Nested SQL
02:11
Case
02:47
Temporary Tables
03:45
Common Table Expressions
02:47
Date Functions
03:06
+ Joins
8 lectures 21:06
Joins
01:29
Inner Join
02:29
Left Join
02:06
Right Join
01:17
Outer Join
01:07
Joining Multiple Tables
02:54
Join Lab
08:22
Union
01:22
+ WORKING WITH TABLES
5 lectures 06:47
Insert Into
02:04
Insert Into Select
00:58
Update
01:51
Delete
01:16
Truncate
00:38
+ Programmability
2 lectures 09:23
Views
04:03
Stored Procedures
05:20
Requirements
  • No prior knowledge of Databases, SQL or SQL Server is needed. We walk you through installation to writing your first lines of code!
  • A PC or Mac is required
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.

Who this course is for:
  • Beginner or Brand New Developers looking to learn SQL and SQL Server Basics
  • Wanting to get into Data Science or become a data scientist. Learning SQL is a great first step!