ΠΕΡΙΓΡΑΦΗ

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 at work? 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. 

We’ve designed the lessons specifically for those with little to no experience with writing queries, to teach you only what you need to know to get started writing queries today.

By the end of the course, you’ll be able to retrieve data from multiple tables, sort and filter your query results, and use simple calculations. We’ll cover some commonly used functions so you can format dates and text as well as calculate sums and averages.   If you’re ready to stop waiting on someone else to pull data for you, this course is for you. 

Topics covered in this course include:

• Retrieving data from one table 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 on summarized data
• Writing subqueries included nested subqueries 

Course Contents: 

• Getting Started
•     Lesson 01: Introduction (2:47)
•     Lesson 02: Fundamentals and Terminology (6:25) 
• Single-Table Queries 
•     Lesson 03: Creating a Simple Query (4:25)
•     Lesson 04: Cleaning Query Results (7:13)
•     Lesson 05: Using the WHERE Clause (6:48) 
• Multi-Table Queries 
•     Lesson 06: Querying Multiple Tables (9:58)
•     Lesson 07: Using Outer Joins (6:36) 
• Functions and Subqueries 
•     Lesson 08: Working with Functions Part I (5:44)
•     Lesson 09: Working with Functions Part II (5:53)
•     Lesson 10: Using GROUP BY and HAVING (8:51)
•     Lesson 11: Writing Subqueries (11:50)