Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL for Non-Programmers

via LinkedIn Learning

Overview

This course provides a straightforward, concise resource for non-developers to learn enough about relational databases and SQL syntax to write simple queries.

Syllabus

Introduction
  • How can SQL answer your data questions?
1. Introduction to SQL Server and Relational Database Concepts
  • What is SQL Server?
  • Understanding servers, databases, and tables
  • Relational database concepts
  • Surrogate, primary, and foreign keys
2. Single Table Select Statements
  • SQL data types and nullability
  • Reading from a single table in SQL
  • Filtering on a single condition in SQL
  • Filtering on multiple conditions in SQL
3. Multiple Table Select Statements
  • Inner joins
  • Multiple inner joins
  • Outer joins
  • Subqueries
4. Additional SQL Query Tools
  • Case statements
  • Built-in functions
  • Aggregates
  • Query processing order
Conclusion
  • Next steps

Taught by

Julianne Thouin

Reviews

4.6 rating at LinkedIn Learning based on 4793 ratings

Start your review of SQL for Non-Programmers

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.