Microsoft SQL for Beginners

Microsoft SQL for Beginners, available at $149.99, has an average rating of 4.54, with 39 lectures, based on 28985 reviews, and has 110739 subscribers.

You will learn about Complete literal SELECT statements. Complete basic SELECT statements querying against a single table Filter data using the WHERE clause Sort data using the ORDER BY clause Learn about database design and normalization Using joins, return columns from multiple tables in the same query Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN Complete SQL statements that use aggregate functions Group data together using the GROUP BY clause Filter groups of data using the HAVING clause This course is ideal for individuals who are Anyone who works with data, tables, or databases! or Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course. or If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information or Someone who wants to learn skills that give them the potential to earn near SIX figures! It is particularly useful for Anyone who works with data, tables, or databases! or Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course. or If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information or Someone who wants to learn skills that give them the potential to earn near SIX figures!.

Enroll now: Microsoft SQL for Beginners

Summary

Title: Microsoft SQL for Beginners

Price: $149.99

Average Rating: 4.54

Number of Lectures: 39

Number of Published Lectures: 39

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 39

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will Learn

Complete literal SELECT statements.

Complete basic SELECT statements querying against a single table

Filter data using the WHERE clause

Sort data using the ORDER BY clause

Learn about database design and normalization

Using joins, return columns from multiple tables in the same query

Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN

Complete SQL statements that use aggregate functions

Group data together using the GROUP BY clause

Filter groups of data using the HAVING clause

Who Should Attend

Anyone who works with data, tables, or databases!

Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.

If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information

Someone who wants to learn skills that give them the potential to earn near SIX figures!

Target Audiences

Anyone who works with data, tables, or databases!

Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.

If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information

Someone who wants to learn skills that give them the potential to earn near SIX figures!

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

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 intelligenceand big data become more familiar, businesses will need more people to learn the SQL language.

This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.

You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.

Course Curriculum

Chapter 1: Introduction to SELECT Statements

Lecture 1: START HERE: Introduction Lecture

Lecture 2: How to Install Microsoft SQL Server Express

Lecture 3: How to Download and Install SQL Server Express

Lecture 4: How to Attach the AdventureWorks Database

Lecture 5: Introduction to T-SQL and Database Concepts

Lecture 6: Literal SELECT Statements – Part 1

Lecture 7: Literal SELECT Statements – Part 2

Lecture 8: Literal SELECT Statement Practice Problems

Lecture 9: Basic SELECT Statements – Part 1

Lecture 10: Basic SELECT Statements – Part 2

Lecture 11: Basic SELECT Statements – Part 3

Lecture 12: Basic SELECT Statement Practice Problems

Chapter 2: Filtering Data with the WHERE Clause

Lecture 1: Using the WHERE Clause – Part 1

Lecture 2: Using the WHERE Clause – Part 2

Lecture 3: Using the WHERE Clause – Part 3

Lecture 4: Using the WHERE Clause – Part 4

Lecture 5: Using the WHERE Clause – Part 5

Lecture 6: Using the WHERE Clause – Part 6

Lecture 7: Using the WHERE Clause – Part 7

Lecture 8: WHERE Clause Practice Problems

Chapter 3: Sorting Data with the ORDER BY Clause

Lecture 1: Sorting with the ORDER BY Clause – Part 1

Lecture 2: Sorting with the ORDER BY Clause – Part 2

Lecture 3: ORDER BY Clause Practice Problems

Chapter 4: Querying Multiple Tables with Joins

Lecture 1: Using the INNER JOIN – Part 1

Lecture 2: Using the INNER JOIN – Part 2

Lecture 3: INNER JOIN Practice Problems

Lecture 4: Using the LEFT OUTER JOIN – Part 1

Lecture 5: Using the LEFT OUTER JOIN – Part 2

Lecture 6: Using the LEFT OUTER JOIN – Part 3

Lecture 7: LEFT/RIGHT OUTER JOIN Practice Problems

Chapter 5: Aggregate Functions

Lecture 1: Aggregate Functions – Part 1

Lecture 2: Aggregate Functions – Part 2

Lecture 3: Aggregate Function Practice Problems

Chapter 6: Grouping Data with the GROUP BY Clause

Lecture 1: Grouping with the GROUP BY Clause – Part 1

Lecture 2: Grouping with the GROUP BY Clause – Part 2

Lecture 3: GROUP BY Clause Practice Problems

Chapter 7: Filtering Groups with the HAVING Clause

Lecture 1: Filtering Groups with the HAVING Clause – Part 1

Lecture 2: Filtering Groups with the HAVING Clause – Part 2

Lecture 3: HAVING Clause Practice Problems

Instructors

Brewster Knowlton
Business Intelligence Expert

Rating Distribution

1 stars: 165 votes

2 stars: 296 votes

3 stars: 2553 votes

4 stars: 10921 votes

5 stars: 15065 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!