Networking and Operating Systems

Section 3.2 – Interfacing with Databases – TestOut

Objective: 

This section introduces you to database access methods, big data, and careers in working with databases. After finishing this section, you should be able to:

  • Explain what SQL is and interpret a basic SQL query.
  • Compare and contrast different methods of accessing data from a database.
  • Define the term Big Data and describe its related challenges and opportunities.
  • Describe various careers in working with databases
  • Use Microsoft Access to perform basic queries on a database.

Links:

Key Terms:

  • Data Definition Language (DDL) Database commands that change the structure, or schema, of the database.
  • Data Manipulation Language (DML) Database commands that modify the records within the database and not the schema itself.
  • Direct Access A method of accessing a database directly using the database management system itself.
  • Query Builder A method of accessing a database using a graphical user interface that allows users to select what actions they want to perform on a database.
  • User Interface Access A method of accessing a database using forms that allow users to interact with the database.
  • Programmatic Access A method of accessing a database using custom computer programs.
  • Data Extraction The process of gathering and organizing big data.
  • Data Mining A broad and open-ended analysis of extracted big data.
  • Big Data Analytics The process of asking specific questions to help interpret big data.
  • NoSQL Nonrelational databases that arise from big data.
  • Database Administrator A person who is responsible for designing, maintaining, backing up, and securing an organization’s databases.
  • Database Developer A person who designs and implements databases, usually by writing SQL code and conducting performance tests to ensure database optimization.
  • Data Analyst A person who specializes in gathering and analyzing data to inform business decisions.
  • Data Scientist A person who focuses on data analysis, especially as it relates to data mining and big data analytics. These positions require even more advanced programming and analytical skills.

Topics Discussed:

  • How can you access and analyze data that’s stored in a relational database?
  • What kinds of questions can be answered by analyzing Big Data?
  • What career opportunities are available in working with databases?

Assignment:

  1. Access the TestOut Courseware through the provided link.
  2. Study Section 3.2: Interfacing with Databases, and achieve a score of 80% or higher on the 10 question Exam to complete the Section.

Assigned: December 9th, 2019
Teacher Pacing Due Date: December 10th, 2019