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

Microsoft SQL for Beginners (SQL Server and T-SQL), available at Free, has an average rating of 4.53, with 39 lectures, based on 359 reviews, and has 8819 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner or Brand New Developers looking to learn SQL and SQL Server Basics or Wanting to get into Data Science or become a data scientist. Learning SQL is a great first step! It is particularly useful for Beginner or Brand New Developers looking to learn SQL and SQL Server Basics or Wanting to get into Data Science or become a data scientist. Learning SQL is a great first step!.

Enroll now: Microsoft SQL for Beginners (SQL Server and T-SQL)

Summary

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

Price: Free

Average Rating: 4.53

Number of Lectures: 39

Number of Published Lectures: 39

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 39

Original Price: Free

Quality Status: approved

Status: Live

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

Who Should Attend

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!

Target Audiences

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!

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Setup and Installation of Tools

Lecture 1: Downloading and Installing SQL Server

Lecture 2: Downloading and Installing SQL Management Studio

Lecture 3: Download and Restore AdventureWorks Sample Database

Chapter 3: Basic SQL Writing

Lecture 1: Basic SQL Syntax and Select

Lecture 2: Select Distinct

Lecture 3: Where Clause

Lecture 4: And, Or, Not

Lecture 5: Order By

Lecture 6: Top

Lecture 7: Putting it Together

Lecture 8: Max and Min

Lecture 9: Like

Lecture 10: In

Lecture 11: Between

Chapter 4: Advanced SQL Statements

Lecture 1: Count, Avg and Sum

Lecture 2: Nulls

Lecture 3: Group By

Lecture 4: Having

Lecture 5: Nested SQL

Lecture 6: Case

Lecture 7: Temporary Tables

Lecture 8: Common Table Expressions

Lecture 9: Date Functions

Chapter 5: Joins

Lecture 1: Joins

Lecture 2: Inner Join

Lecture 3: Left Join

Lecture 4: Right Join

Lecture 5: Outer Join

Lecture 6: Joining Multiple Tables

Lecture 7: Join Lab

Lecture 8: Union

Chapter 6: WORKING WITH TABLES

Lecture 1: Insert Into

Lecture 2: Insert Into Select

Lecture 3: Update

Lecture 4: Delete

Lecture 5: Truncate

Chapter 7: Programmability

Lecture 1: Views

Lecture 2: Stored Procedures

Instructors

Vimal Vachhani
Technology Expert

Rating Distribution

1 stars: 9 votes
2 stars: 12 votes
3 stars: 60 votes
4 stars: 145 votes
5 stars: 133 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu