TOIT Training

SQL for Non Technical Users

SQL for Non Technical Users
  • Overview
  • Curriculum
  • Reviews

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. 

  • 4 Sections
  • 11 Lessons
  • 1h 15m Duration
Expand All

Getting Started

2 Lessons
  • Introduction
  • Fundamentals and Terminology

Single-Table Queries

3 Lessons
  • Creating a Simple Query
  • Cleaning Query Results
  • Using the WHERE Clause

Multi-Table Queries

2 Lessons
  • Querying Multiple Tables
  • Using Outer Joins

Functions and Subqueries

4 Lessons
  • Working with Functions Part I
  • Working with Functions Part II
  • Using GROUP BY and HAVING
  • Writing Subqueries

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • 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 

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

SQL for Non Technical Users
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)