UDEMY
UDEMY Logo

Microsoft SQL for Beginners 

  • Offered byUDEMY

Microsoft SQL for Beginners
 at 
UDEMY 
Overview

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language

Duration

4 hours

Total fee

490

Mode of learning

Online

Difficulty level

Beginner

Credential

Certificate

Microsoft SQL for Beginners
Table of contents
Accordion Icon V3

Microsoft SQL for Beginners
 at 
UDEMY 
Highlights

  • Full lifetime access
  • Earn a Certificate of completion from Udemy
  • Learn from 3 downloadable resource
  • Comes with 30 days money back guarantee and full lifetime access
Read more
Details Icon

Microsoft SQL for Beginners
 at 
UDEMY 
Course details

Skills you will learn
Who should do this course?
  • For Anyone who works with data, tables, or databases
  • For Those who work in organizations where the company typically uses Microsoft databases
  • For Someone who wants to learn skills that give them the potential to earn near SIX figures
What are the course deliverables?
  • Complete literal SELECT statements
  • Filter data using the WHERE clause
  • Learn about database design and normalization
  • Group data together using the GROUP BY clause
  • Sort data using the ORDER BY clause
  • Complete SQL statements that use aggregate functions
More about this course
  • SQL (Structured Query Language) is the language we use to interact with databases that store data
  • This allows us to retrieve data with ease and simplicity
  • As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language
  • This course will teach how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world

Microsoft SQL for Beginners
 at 
UDEMY 
Curriculum

Introductions to Select Statements

How to Download and Install SQL Server Express

How to Attach the Adventure Works Database

Introduction to T-SQL and Database Concepts

Literal SELECT Statements

Filtering Data with the Where Clause

Using the WHERE Clause - Part 1

Using the WHERE Clause - Part 2

Using the WHERE Clause - Part 3

Using the WHERE Clause - Part 4

Using the WHERE Clause - Part 5

Using the WHERE Clause - Part 6

Using the WHERE Clause - Part 7

Sorting with the ORDER BY Clause

Sorting with the ORDER BY Clause - Part 1

Sorting with the ORDER BY Clause - Part 2

Querying Multiple tables with Joins

Using the INNER JOIN - Part 1

Using the LEFT OUTER JOIN - Part 1

Using the LEFT OUTER JOIN - Part 2

Using the LEFT OUTER JOIN - Part 3

Using the INNER JOIN - Part 2

Aggregate Functions

Aggregate Functions - Part 1

Aggregate Functions - Part 2

Grouping with the GROUP BY Clause

Grouping with the GROUP BY Clause - Part 1

Grouping with the GROUP BY Clause - Part 2

Filtering Groups with the HAVING Clause

Filtering Groups with the HAVING Clause - Part 1

Filtering Groups with the HAVING Clause - Part 2

Faculty Icon

Microsoft SQL for Beginners
 at 
UDEMY 
Faculty details

Brewster Knowlton
Brewster Knowlton has worked in all facets of the business intelligence industry. With significant experience writing SQL code, developing ETL processes, and architecting and designing data warehouse systems, his greatest strength is the ability to communicate difficult concepts in an easily understood way.

Other courses offered by UDEMY

549
50 hours
– / –
3 K
10 hours
– / –
399
19 hours
– / –
499
5 hours
– / –
View Other 2371 Courses
Right Arrow Icon

Microsoft SQL for Beginners
 at 
UDEMY 
Students Ratings & Reviews

4.3/5
Verified Icon14 Ratings
qna

Microsoft SQL for Beginners
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...