Objective:
This section contains six domain practice reviews related to the CompTIA ITF Practice Exam Domains:
The domain practices:
- Have 20 questions per domain review
- Are randomly generated
- Have no time limit
- Are not pass/fail
- Have a percentage score at the end of the session
- Recommend an 80% passing score.
Links:
Topics Discussed:
- Section 3.1: Databases
- Section 3.2: Interfacing with Databases
Assignment:
- Access the TestOut Courseware through the provided link.
- Review Section 3.1: Databases and Section 3.2: Interfacing with Databases, and take the 20 question A.2.5 practice test. Your goal is to achieve a score of 80% or higher on the practice test.
- After you finish, you may review each question by selecting the Individual Responses option, then return to the relevant section in the course to review the instructional material.
- Retake the practice test after reviewing the material to make progress towards and achieve the 80% passing score before advancing to the next Practice Exam.
Assigned: February 10th, 2020
Teacher Pacing Due Date: February 11th, 2020
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:
- Access the TestOut Courseware through the provided link.
- 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
It's dangerous to go alone!
