Unit 03: LO 4 - 4.3 - Data System (use) - Excel Online

Using a data system effectively in an IT environment is like being a librarian who knows exactly where each book is and ensures that all library transactions are secure. Let's look at two key activities: securely downloading data and performing queries or searches.

Ensuring Data is Downloaded Securely

To make sure that data is downloaded securely, you'll want to use HTTPS, which encrypts the information going to and from your server. This is like sending a sealed, coded letter instead of an open postcard.

How to do it:

• Check for HTTPS in the URL: Always ensure that the URL from which you are downloading data starts with "https://".

• Verify SSL/TLS Certificates: Check for a padlock symbol in the address bar, indicating a secure site. Clicking on it will show details about the site's security credentials.

• Use Secure FTP (SFTP) for File Transfers: If you're downloading files directly from a server, use SFTP protocols instead of FTP to ensure secure, encrypted transfers.

Performing Queries or Searches

Performing queries is like using the library's search system to find exactly the books you need. You can search, sort, or group data based on specific criteria.

How to do it:

• SQL Queries for Databases:

  • Use SQL (Structured Query Language) queries to fetch specific data from a database.

• Use Search Functions in Spreadsheets:

  • If you're using something like Excel, you can use various sorting and filtering options directly through the interface.

• Search Engines for Data Lakes:

  • If your data is stored in a data lake, you may have a search engine interface that allows you to perform complex queries to retrieve data.

By using HTTPS for secure downloads and knowing how to perform queries effectively, you're making sure that you can both securely and efficiently use your data system, just like a librarian who can quickly find books and ensure they are securely checked out.