SQL Server Essentials in an hour: The SELECT statement (Udemy.com)

Learn how to use SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER in SQL Server. Create views+procedures. Export in Excel

( 183 Reviews )

Created by: Phillip Burton

Produced in 2021

What you will learn

Build your own SQL Server SELECT statements.
Use the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses.
Encapsulate (save) your statements as views or procedures.
Dynamically connect the results of your SELECT statements into Excel.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Course Description

Want to learn SQL Server quickly?
In this course, we'll look in an hour at the SELECT statement.
There are six constituent clauses in this statement:

SELECT - this is akin to the Print statement in other languages, and
FROM - this shows your data source,
WHERE - this filters down your data source,
GROUP BY - this enables the results to be summarised,
HAVING - this filters the summary, and
ORDER BY - this sorts your results.

We'll then look at saving your code using both views and procedures.
Finally, we'll export your reports into Excel, both statistically (copy and paste) and dynamically (so that you always have the latest reports).
In just an hour, you'll be able to create your own SELECT statements, so you can use them in SQL Server (SSMS, SSRS and SSIS) and in Excel. This is all you need to start writing and using your own code. Quick and easily.Who this course is for:

This course is for you if you want to learn about SQL Server's SELECT statement.
You can use the SELECT statement in SSMS, SSRS, SSIS and Excel.

Time: 1h

Instructor Details

Phillip Burton

4.5 Rating
183 Reviews

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

More courses by Phillip Burton

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)

- Provider: Udemy
- Time: 29.5h

$11.99

SQL Server Integration Services (SSIS) - An Introduction

SQL Server Integration Services (SSIS) - An Introduction (2021)
4.6 (355 Reviews)

- Provider: Udemy
- Time: 4h

$11.99

70-462: SQL Server Database Administration (DBA)

70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

Microsoft SQL Server Reporting Services (SSRS)

Microsoft SQL Server Reporting Services (SSRS) (2021)
4.2 (338 Reviews)

- Provider: Udemy
- Time: 6h

$11.99

70-778, DA-100: Analyzing and Visualizing Data with Power BI

70-778, DA-100: Analyzing and Visualizing Data with Power BI (2021)
4.5 (224 Reviews)

- Provider: Udemy
- Time: 24h

$11.99

SQL Server SSAS (Multidimensional MDX) - an Introduction

SQL Server SSAS (Multidimensional MDX) - an Introduction (2021)
4.5 (207 Reviews)

- Provider: Udemy
- Time: 8h

$11.99

All courses by Phillip Burton

Reviews

4.5

183 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Karen Binns on 11/8/2020

I have never used SQL so this is very interesting and helpful.

By Zhanna Galochkina on 11/1/2020

Course is concise and gives enough knowledge. Awesome!

By Dan A North on 10/24/2020

Excellent refresher. I always enjoy Mr. Burton's courses. He is by far, the best instructor I have viewed on the Udemy site.

By Lautaro N Giglio on 10/11/2020

Muy buen curso!

By Fatoyinbo Abiodun on 10/9/2020

Awesome

By James Dean on 10/8/2020

Easy to follow and well explained!

By Karina Bakal on 10/1/2020

thank you so much

By Alberto Castillo on 9/25/2020

Yes i think this is exactly what I was looking for.

By Jabin Shalom Selvanson on 9/20/2020

Nice explanation by Phillip, really helpful for my current project.

By Neethu Sathyan on 9/17/2020

Informative

By Jenny Grant on 9/5/2020

I am a beginner in SQL. The basics are well thought out and very helpful. Worded great for someone who is just learning the language.

By Michelle Ayers on 9/4/2020

Previously only self-taught myself into SQL Server and SSMS as needed (though I have many years experience of SQL on IBMi DB2) - found this course showed lots of interested tips and explained things I had previously 'just accepted' like IntelliSense. Also learned about Excel which was a bonus!