Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

ACG Fundamentals

SQL Queries

Episode description

Structured Query Language, more commonly known as SQL, can help you insert and retrieve data from databases. In this episode, Lars Klint teaches you how to use SQL queries to interact with databases using entirely free resources: the AdventureWorks sample database from Microsoft, a SQL Server and the SQL Server Management Studio (SSMS). You’ll learn how to retrieve data with the SELECT statement, filter with WHERE, combine sets with AND and OR, as well as order your data.

0:00 Introduction
0:41 Data and tooling
1:12 The SELECT statement
3:03 Filtering with WHERE
4:24 Combining data sets with AND and OR
6:27 Ordering data
7:34 Conclusion

Watch the complete ACG Fundamentals series for free
https://bit.ly/2PvKpvK

SQL Server
https://www.microsoft.com/en-au/sql-server/sql-server-downloads

AdventureWorks DB
https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks

SQL Server Management Studio (SSMS)
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Join the conversation on Discord
https://discord.gg/U3aBQq8Nnbp

Like and follow us on Facebook and Twitter
Facebook: https://www.facebook.com/acloudguru
Twitter: https://twitter.com/acloudguru

 

Series description

Being an avid learner means we are always beginners to a new topic or concept. With ACG Fundamentals, we want to equip you with the lessons you need to tackle new cloud concepts, projects, and real-world scenarios. With fun, bite-sized and succinct lessons, you'll be able to learn from anywhere in a matter of minutes. This is the series that puts the fun in fundamentals.

Get Started with Pluralsight

Develop better skills and deliver better products. Upgrade your processes and unlock your people's potential. And it all begins right here. Is your clicking finger tingling with excitement?