What's New?
# of Lessons
Duration
Skill Level
MSRP
Instructor(s)
Available Captions
Also Included
Learn to Write Simple Queries to Get the Information You Need to Do Your Job
Do you often have to ask others to write SQL queries for you? Are you intimidated by the idea of writing your own SQL query? It’s time to take matters into your own hands. In this course, you’ll learn how to write a basic SQL query from start to finish. We’ve designed the lessons specifically for those with little to no experience with writing queries, to teach you only what you need to know to get started.
By the end of the course, you’ll be able to retrieve data from multiple tables, sort and filter your query results, and use simple calculations. We’ll cover some commonly used functions, so you can format dates and text as well as calculate sums and averages. If you’re ready to stop waiting on someone else to pull data for you, this course is for you.
Note: This course uses SQL Server Management Studio, but the language of an SQL query is not specific to any one tool.
Topics covered include:
Seventy-five minutes of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!
Course Contents:
# | Section | # | Lesson | Length |
1 | Getting Started | 1 | Introduction | 1:21 |
2 | Fundamentals and Terminology | 6:25 | ||
2 | Single-Table Queries | 3 | Creating a Simple Query | 4:25 |
4 | Cleaning Query Results | 7:13 | ||
5 | Using the WHERE Clause | 6:48 | ||
3 | Multi-Table Queries | 6 | Querying Multiple Tables | 9:58 |
7 | Using Outer Joins | 6:36 | ||
4 | Functions and Subqueries | 8 | Working with Functions Part I | 5:44 |
9 | Working with Functions Part II | 5:53 | ||
10 | Using GROUP BY and HAVING | 8:51 | ||
11 | Writing Subqueries | 11:50 |
Related Course Recommendations:
Copyright ©2021 . TripleTech LLC, dba Bigger Brains . All Rights Reserved
This website uses cookies to improve your experience. Please select whether you would like to accept our decline tracking technologies and cookies. https://getbiggerbrains.com/privacy-policy/ Read More