SQL Server Fundamentals: Master Basic Query Techniques
With Julianne Thouin
Liked by 19,117 users
Duration: 1h 30m
Skill level: Beginner
Released: 1/12/2021
Course details
Do you want to learn about SQL but aren’t sure where to start? 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. Julianne explains what SQL Server is and what it is used for. Next, she shows how tables in a relational database relate to one another through surrogate, primary, and foreign keys. Julianne teaches you how to tackle the most basic query possible. She explains how AND and OR logic applies to filtering queries on more than one data point, then discusses INNER joins and OUTER joins. Julianne covers how to use subqueries for filtering your results. She walks you through some commonly used examples of built-in functions. In conclusion, Julianne shows you how aggregate functions work using the GROUP BY and HAVING clauses.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Simphiwe Nonkonyana
Simphiwe Nonkonyana
Head Regional Cash Operations @ Standard Bank | Adaptive Leadership
-
-
Nicolás Matías Cabrera
Nicolás Matías Cabrera
Analista de Segmentos en Galicia Más/ Licenciado en Comercialización - IUEAN / Posgrado en Marketing Digital - Digital House
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 4 quizzes
- Learn on the go Access on tablet and phone
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.