SQL Queries
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…
Nov 22, 2021
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.
More videos in this series
How to Add and Remove Azure Roles
Azure roles play a very important part in your Azure architecture. But what are roles, and how do they work? Azure Active Directory, also known…
Nov 15, 2021
What is Kubernetes (K8s)?
If you’re working with containers at all, there’s a good chance you’ve heard of Kubernetes (or K8s), but you may still be asking yourself “what…
Nov 5, 2021
Creating a Kubernetes Cluster with Minikube
Kubernetes is one of the most popular tools for managing and orchestrating containers, but getting started with Kubernetes can be tricky. One tool that can…
Oct 27, 2021
Azure PowerShell account management with Azure contexts
If you’ve been using Azure PowerShell, you might’ve noticed that when you launch a script, you’ll need to authenticate. That’s simple enough when you have…
Oct 26, 2021
Beginner’s Guide: Azure PowerShell
PowerShell has been a preferred method of automating different actions and processes with Windows Administrators. As a cross-platform command-line and scripting environment, it employs cmdlets…
Oct 13, 2021