Skip to content

Contact sales

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

ACG Fundamentals

SQL Syntax Basics

Episode description

If you work with databases, you may already be working with a structured query language, or SQL, without even knowing it. In this video, Lark Klint teaches you the basics of SQL and SQL statement syntax, with the aid of entirely free resources: the AdventureWorks sample database from Microsoft, a SQL Server and the SQL Server Management Studio (SSMS). You’ll also learn what a relational database management system (RDBMS) is, and how you use SQL statements to interact with them.

0:00 Introduction
0:37 What is SQL and how does it relate to RDBMS?
2:18 What can you do with SQL?
2:55 Tables, columns and rows
3:57 SQL statement syntax
10:04 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?