| new skills - Team Nuggets
New Training: Query Access Tables
In this 10-video skill, CBT Nuggets trainer Ben Finkel discusses how SQL is written and how it’s used to query databases. Watch this new Microsoft 365,Microsoft Office training.
Watch the full course: Microsoft Access 2019 Training
This training includes:
- 10 videos
- 49 minutes of training
You’ll learn these topics in this skill:
- Query Access Tables
- Understanding SQL and Access
- Creating Queries
- Retrieving Data with Select
- Adding Data with Insert
- Modifying Data with Update
- Removing Data with Delete
- Filtering Data with the Where Clause
- Summing Data with Group By
- Query Access Tables Summary
The Strengths of SQL
SQL (pronounced "sequel") is a language purposely designed for managing data, particularly structured data, stored in relational database management systems. SQL is used to define data schema, control access to the data, query the data, and manipulate data by inserting new data or updating and deleting existing data. It is one of the most widely used programming languages, even though it is almost 50 years old, because it is efficient, stable, and relatively easy to use.
SQL is a declarative programming language, which means the user states what they want, such as SELECT * FROM Customers WHERE Last_Name = "Doe", which would retrieve records containing the Last_Name "Doe". Databases that use SQL interpret SQL queries and respond appropriately. Unfortunately, there are variations of SQL, so code may have to be modified to be used in different databases, but it's easier to modify SQL than to learn an entirely new language for each type of database.