Skip to content
TruEducate Learning Academy
TruEducate Learning Academy
  • Home
  • Course Info
    • Microsoft Project
  • Log In
  • Articles

Topic 0: SQL Overview

Topic Progress:
← Back to Lesson
https://s3-us-west-1.amazonaws.com/trueducate-courses/0002-sql-novice-to-ninja/01-Overview-HD.mp4


Topic Description:
In this video we will learn the basics of SQL.

Steps:

  1. Watch this video lesson.
  2. Follow the instructions step by step.
  3. Once completed, proceed to the next lesson.

Course Progress

Course Navigation

Lesson 1: Understanding Databases
  • Topic 0: SQL Overview
  • Topic 1: Introduction to Databases
  • Topic 2: SQL Exercise Files
Lesson 2: Set Up a Database
  • Topic 3: Installation Set-Up
  • Topic 4: SQL Database Fundamentals
Lesson 3: Building Simple Queries
  • Topic 5: Writing Simple Queries
  • Topic 6: Selecting Everything
  • Topic 7: Filter - Using WHERE Clause
  • Topic 8: Filter - Using Operators
  • Topic 9: Using Compound Conditions
  • Topic 10: Using Compound Conditions (NOT)
  • Topic 11: Using BETWEEN Operator
Lesson 4: Using Calculations, Functions, Sorting
  • Topic 12: Using Computed Columns
  • Topic 13: Using LIKE Clause
  • Topic 14: Using IN Clause
  • Topic 15: Sorting Data
  • Topic 16: Using Functions
  • Topic 17: Using DISTINCT Function
Lesson 5: Using Nested Queries
  • Topic 18: Nesting Queries
Lesson 6: Grouping Data
  • Topic 19: Using Group By Clause
  • Topic 20: Using Having Clause
Return to SQL: From Novice To Ninja

Search This Site

Ready To Get Started?

Join the TruEducate community today and you will see why Fortune 500 companies, major corporations, start-ups & individual learners from all over the world trust us to train them on the latest technologies, skills & techniques.

Love To Teach?

If you would like to teach a course here and share your knowledge and get paid every time someone signs-up for your course, do contact us.

© 2023 TruEducate.com