SQL For Non-Technical Users
What You Need to Know to Get Started
4.54 (24 reviews)
62
students
1.5 hours
content
Feb 2025
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.
Screenshots
Related Topics
2522240
udemy ID
8/22/2019
course created date
11/22/2019
course indexed date
Bot
course submited by