Linkedin Learning
Linkedin Learning Logo

SQL for Non-Programmers 

  • Offered byLinkedin Learning

SQL for Non-Programmers
 at 
Linkedin Learning 
Overview

Duration

2 hours

Total fee

1,150

Mode of learning

Online

Difficulty level

Beginner

Credential

Certificate

SQL for Non-Programmers
 at 
Linkedin Learning 
Highlights

  • Earn a sharable certificate
  • 1 exercise file
  • 4 quizzes
  • Access on tablet and phone
Read more
Details Icon

SQL for Non-Programmers
 at 
Linkedin Learning 
Course details

More about this course
  • In this beginner-level course, instructor Julianne Thouin covers basic concepts of relational database design and explains how to write simple SELECT statements using joins and proper filtering
  • The course explains how AND and OR logic applies to filtering queries on more than one data point, then discusses INNER joins and OUTER joins

SQL for Non-Programmers
 at 
Linkedin Learning 
Curriculum

Introduction

How can SQL answer your data questions?

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

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

Multiple Table Select Statements

Inner joins

Multiple inner joins

Outer joins

Subqueries

Additional SQL Query Tools

Case statements

Built-in functions

Aggregates

Query processing order

Conclusion

Next steps

Other courses offered by Linkedin Learning

– / –
1 hours
Intermediate
25 K
1 month
– / –
899
1 hours
Intermediate
– / –
1 hours
Advanced
View Other 504 CoursesRight Arrow Icon
qna

SQL for Non-Programmers
 at 
Linkedin Learning 

Student Forum

chatAnything you would want to ask experts?
Write here...