SQL for Non-Programmers
5.0 /5
- Offered byLinkedin Learning
SQL for Non-Programmers at Linkedin Learning Overview
SQL for Non-Programmers
at Linkedin Learning
Duration | 2 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
SQL for Non-Programmers at Linkedin Learning Highlights
SQL for Non-Programmers
at Linkedin Learning
- Earn a sharable certificate
- 1 exercise file
- 4 quizzes
- Access on tablet and phone
Read more
SQL for Non-Programmers at Linkedin Learning Course details
SQL for Non-Programmers
at Linkedin Learning
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
SQL for Non-Programmers
at Linkedin Learning
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
View Other 504 Courses
SQL for Non-Programmers
at Linkedin Learning
Student Forum
Anything you would want to ask experts?
Write here...