SQL For Non-Technical Users

What You Need to Know to Get Started

4.45 (19 reviews)
Udemy
platform
English
language
Other
category
instructor
57
students
1.5 hours
content
Aug 2020
last update
$44.99
regular price

What you will learn

Define basic SQL terminology and list the seven types of clauses in an SQL statement.

Write an SQL query that retrieves data from one table.

Clean your query results by sorting, filtering, and adding column aliases.

Use the WHERE clause to filter results based on comparisons to numbers and strings.

Write an SQL query that retrieves data from multiple tables using inner joins and WHERE clause joins.

Use outer joins to retrieve results where one of the tables does not have matching records.

Use date functions to format dates in your results (DATEPART, DATENAME) and to calculate the difference between two dates (DATEDIFF).

Concatenate columns using string functions (+, TRIM) and summarize a column using aggregate functions (SUM, AVG).

Collect data across multiple records and group the results using the GROUP BY clause and filter based on grouped data using the HAVING clause.

Use subqueries to retrieve more complex results that cannot be achieved with a single SQL query.

Description

Learn to write simple queries to get the information you need to do your job

Do you often have to ask others to write SQL queries for you? Are you intimidated by the idea of writing your own SQL query? It’s time to take matters into your own hands.

In this course, you’ll learn how to write a basic SQL query from start to finish. This course will quickly teach you what you need to know to get started. By the end of the course, you’ll be able to retrieve data from multiple tables, sort and filter query results, and use simple calculations. We’ll cover commonly used functions, so you can format dates and text as well as calculate sums and averages.

These lessons will help you learn the fundamentals of the SQL language while also introducing you to some of the more advanced topics. If you’re ready to stop waiting on someone else to pull data for you, this course is for you.

Note: This course uses SQL Server Management Studio, but the language of an SQL query is not specific to any one tool.

Topics covered include:

  • Retrieving data from one or multiple tables

  • Using aliases to simplify your queries

  • Filtering data with the WHERE clause

  • Using Outer Joins

  • Working with functions: DATEPART, DATENAME, DATEDIFF, TRIM, SUM, AVG

  • Using the GROUP BY and HAVING clauses to retrieve and filter summarized data

  • Writing subqueries including nested subqueries

Enjoy seventy-five minutes of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Content

Introduction

Introduction
Fundamentals and Terminology
Creating a Simple Query
Cleaning Query Results
Using the WHERE Clause
Querying Multiple Tables
Using Outer Joins
Working with Functions, Part 1
Working with Functions, Part 2
Using the GROUP BY and HAVING Clauses
Writing Subqueries

Screenshots

SQL For Non-Technical Users - Screenshot_01SQL For Non-Technical Users - Screenshot_02SQL For Non-Technical Users - Screenshot_03SQL For Non-Technical Users - Screenshot_04

Reviews

Wendy
February 18, 2022
This course was very helpful. It would have been nice to have some examples to do along side the instructor. I also could not print the certificate at the end.
Chris
August 14, 2020
It was a good introduction to SQL, nice and simple to understand and not overbearing IT jargon. I would have liked to have been able to download the first slide (terminology plus order of operations)

Charts

Price

SQL For Non-Technical Users - Price chart

Rating

SQL For Non-Technical Users - Ratings chart

Enrollment distribution

SQL For Non-Technical Users - Distribution chart

Related Topics

2522240
udemy ID
8/22/2019
course created date
11/22/2019
course indexed date
Bot
course submited by