New Training: Query Access Tables
| 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.

Download

Download

Ultimate Systems Administration Cert Guide

A 158-page guide to every Microsoft, VMware, Citrix, AWS, Google, and Linux certification, and how they fit into your career.

By submitting this form you agree that you have read, understood, and are able to consent to our privacy policy.

LEARNING ON MOBILE

Learn anytime anywhere with our mobile apps.

I have read and understood the privacy policy and am able to consent to it.

© 2021 CBT Nuggets. All rights reserved. Terms | Privacy Policy | Accessibility | Sitemap | 1550 Valley River Drive, Eugene, OR 97401 | 541-284-5522
CBT Nuggets