SQL Server Developer : SELECT query foundations

SQL Server Developer : SELECT query foundations, available at $64.99, has an average rating of 4.65, with 41 lectures, based on 12 reviews, and has 42 subscribers.

You will learn about Querying SQL server databases using the SELECT clause Joining multiple tables in different ways to combine information Filtering data to retrieve only the information you need Using aggregation functions and processes to find totals and averages for reports This course is ideal for individuals who are Data Science beginners or Someone curious to extend their data skills, perhaps used to working with Excel or Programmers looking to add database capabilities to their applications or Someone looking to enter the world of data analysis and machine learning It is particularly useful for Data Science beginners or Someone curious to extend their data skills, perhaps used to working with Excel or Programmers looking to add database capabilities to their applications or Someone looking to enter the world of data analysis and machine learning.

Enroll now: SQL Server Developer : SELECT query foundations

Summary

Title: SQL Server Developer : SELECT query foundations

Price: $64.99

Average Rating: 4.65

Number of Lectures: 41

Number of Published Lectures: 41

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Querying SQL server databases using the SELECT clause
Joining multiple tables in different ways to combine information
Filtering data to retrieve only the information you need
Using aggregation functions and processes to find totals and averages for reports

Who Should Attend

Data Science beginners
Someone curious to extend their data skills, perhaps used to working with Excel
Programmers looking to add database capabilities to their applications
Someone looking to enter the world of data analysis and machine learning

Target Audiences

Data Science beginners
Someone curious to extend their data skills, perhaps used to working with Excel
Programmers looking to add database capabilities to their applications
Someone looking to enter the world of data analysis and machine learning

SQL Server SELECT query foundations aims to teach you the basics of retrieving data from the Microsoft SQL server database engine.

the course contains details on how to use the SELECT clause in the SQL server environment to query database tables and bring back data to present in reports or applications

This course is aimed at anyone looking to improve their understanding of database development, from data analysts looking to increase their skills on data querying, programmers looking to add database capabilities to their apps, or anyone who needs to get at the wealth of data contained in their companies’ database servers.

the course includes lessons on :

Retrieving and combining columns from SQL server tables using the SELECT clause to define columns and functions to display to the end users.

Joining multiple tables in different ways to combine information. Using the FROM clause to specify which tables you want to connect to, and multiple JOIN clauses to connect tables to each other.
Filtering data to retrieve only the information you want. Using the WHERE clause to filter your data on one or multiple columns, and the ways to combine the WHERE clause with JOINs on your tables to efficiently retrieve information.
Using aggregate functions to GROUP BY information and find totals and averages of data to perform analysis and make reports

the course contains lessons on how to download and install all the tools you need to become proficient in coding SQL; I’ll take you through how you can download and install SQL server express edition, a free personal use version of SQL server, and the sample ‘AdventureWorks’ database so you can try out all the examples, and develop and test your own queries.

We’ll also download SQL Server Management Studio; your best interface into the database environment, and I’ll go through the basics of how to connect to Databases, and how to use the tool more efficiently.

I’ve included handouts with summaries and further information on some topics, as well as increasingly difficult review questions for you to try yourself. each set of questions is followed by a video analysis of the solutions and the different ways you could choose to solve them.

There’s also an end of course test that combines all the techniques you’ve learned into one final exam.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introdution

Chapter 2: Downloading and installing the required software and data

Lecture 1: Download and Install SQL Server Express

Lecture 2: Download and Install SQL Server Management Studio (SSMS)

Lecture 3: AdventureWorks Database – Introduction

Lecture 4: Option 1 – Install AdventureWorks from a backup

Lecture 5: Option 2 – Install AdventureWorks from a script file

Chapter 3: SQL Server Management Studio Overview

Lecture 1: SSMS Layout and Connecting to a Database

Lecture 2: Tree view, Menus and Editing code

Chapter 4: SQL Server SELECT query foundations

Lecture 1: SELECT clause – Introduction and Demonstration

Lecture 2: FROM clause – Introduction

Lecture 3: FROM clause – Demonstration

Lecture 4: FROM Clause – Test Answers

Lecture 5: A note about Data Types

Lecture 6: WHERE Clause – Part 1 – Introduction

Lecture 7: WHERE Clause – Part 1 – Demonstration

Lecture 8: A Note about Dates

Lecture 9: WHERE Clause – Part 2 – LIKE operator – Introduction

Lecture 10: WHERE Clause – Part 2 – LIKE operator – Demonstration

Lecture 11: A note about NULLs

Lecture 12: WHERE Clause – Part 3 – Combining clauses – Demonstration

Lecture 13: WHERE Clause – Test Answers

Lecture 14: ORDER BY Clause – Introduction

Lecture 15: ORDER BY Clause – Demonstration

Lecture 16: ORDER BY Clause – Test Answers

Lecture 17: JOIN Clause – Part 1 – Introduction

Lecture 18: JOIN Clause – Part 1 – Demonstration

Lecture 19: JOIN Clause – Part 1 – Test Answers

Lecture 20: JOIN Clause – Part 2 – Joining multiple tables – Introduction

Lecture 21: JOIN Clause – Part 2 – Joining multiple tables – Demonstration

Lecture 22: JOIN Clause – Part 2 – Joining multiple tables – Test Answers

Lecture 23: Aggregates and Grouping – Introduction

Lecture 24: Aggregate Functions – Demonstration

Lecture 25: GROUP BY Clause – Introduction

Lecture 26: GROUP BY Clause – Demonstration

Lecture 27: GROUP BY Clause – Test Answers

Lecture 28: HAVING Clause – Introduction

Lecture 29: HAVING Clause – Demonstration

Lecture 30: HAVING Clause – Test Answers

Chapter 5: Summary and final test

Lecture 1: SELECT course final summary

Lecture 2: SELECT course final test answers

Lecture 3: Course Outro

Instructors

Ben Osborn
Database administration and development

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 2 votes
5 stars: 9 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