Objective:
This section describes common careers in working with databases. After finishing this section, you should be able to:
- Describe various careers in working with databases, including database administrator, database developer, and data analyst.
- Identify skills and educational requirements for databases careers.
Links:
Key Terms:
- Database Administrator
- Data Scientist
- Database Developer
- Data Analyst
Topics Discussed:
- How does the work of database professionals affect my daily life?
- How can I prepare for a career in databases?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study 7.6: Database Careers and complete the 5 question Exam to complete the Section.
Assigned: April 26th, 2024
Teacher Pacing Due Date: April 29th, 2024
AZ CS Standard: Computing Systems – HS.CS.T.1
Objective:
This section introduces non-relational databases and how they relate to Big Data. After finishing this section, you should be able to:
- Describe the basic functions and types of non-relational databases.
- Define the term Big Data and describe its related challenges and opportunities.
Links:
Key Terms:
- Structured Query Language (SQL)
- Structured Data
- Unstructured Data
- Semi-Structured Data
- Big Data
- Data Extraction
- Data Mining
- Big Data Analytics
- NoSQL
Topics Discussed:
- How are non-relational databases similar to relational databases? How are they different?
- How has Big Data changed the world of business?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study 7.5: Non-relational Databases and complete the 10 question Exam to complete the Section.
Assigned: April 25th, 2024
Teacher Pacing Due Date: April 26th, 2024
AZ CS Standard: Computing Systems – HS.CS.T.1
Objective:
This section introduces database queries. After finishing this section, you should be able to:
- Compare and contrast different methods of accessing data from a database.
- Describe the purpose of basic SQL commands.
- Interpret simple SQL queries.
- Answer basic questions about existing Microsoft Access queries.
- Use Microsoft Access to perform basic queries on a database.
- Write SQL commands to do the following:
- Retrieve all data from a particular table.
- Retrieve table data that matches certain criteria.
- Add a new record to an existing table.
- Delete a record from a table.
Links:
Key Terms:
- Query
- Direct Access
- Query Builder
- User Interface Access
- Programmatic Access
- SQL
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
Topics Discussed:
- What kinds of database queries do I already use?
- What is the relationship between queries and CRUD (Create, Read, Update, Delete)?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study 7.4: Querying Databases and complete the 7.4.5, 7.4.7, 7.4.11, 7.4.12, 7.4.13, 7.4.14 & 7.4.15 Labs/Activities and the 10 question Exam to complete the Section.
Assigned: April 24th, 2024
Teacher Pacing Due Date: April 25th, 2024
AZ CS Standard: Computing Systems – HS.CS.T.1
Objective:
This section introduces the purposes, properties and operation of relational databases. After finishing this section, you should be able to:
- Describe the purposes of a relational database.
- Define basic relational database terminology, including fields, records, primary keys, foreign keys, and one-to-many relationships.
- Define the term normalization as it relates to storing and retrieving data.
- Answer basic questions about Microsoft Access table relationships.
- Perform the following database design tasks in Microsoft Access:
- Change the data type and size of a field.
- Set default field values.
- Create table relationships.
Links:
Key Terms:
- Relational Database
- Table
- Field
- Record
- Primary Key
- Foreign Key
- Query
- Form
- Report
- Normalization
Topics Discussed:
- What are some primary keys that databases use to identify me?
- What one-to-one, one-to-many, and many-to-many relationships do I encounter in a typical day?
- How does normalization improve a database?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study 7.3: Relational Databases and complete the 7.3.9 and 7.3.11 Labs/Activities and the 11 question Exam to complete the Section.
Assigned: April 23rd, 2024
Teacher Pacing Due Date: April 24th, 2024
AZ CS Standard: Computing Systems – HS.CS.T.1
Objective:
This section introduces fundamental database concepts. After finishing this section, you should be able to:
- Describe the advantages of using a database rather than a flat file to store information.
- Describe the role of data modeling in database design.
- Compare and contrast operational data with analytical data.
- Describe the purpose of a database management system.
- Use Microsoft Access to explore database objects.
Links:
Key Terms:
- Database
- Data Modeling
- Operational Data
- Analytical Data
- Database Management System (DBMS)
- Table
- Query
- Form
- Report
Topics Discussed:
- How do I use databases in my everyday life?
- How do different kinds of database objects work together?
- How are databases similar to spreadsheets? How are they different?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study 7.2: Introduction to Databases and complete the 7.2.7 Lab/Activity and the 10 question Exam to complete the Section.
Assigned: April 22nd, 2024
Teacher Pacing Due Date: April 23rd, 2024
AZ CS Standard: Computing Systems – HS.CS.T.1
Objective:
This section introduces you to databases and gives you practice using a relational database management system. After finishing this section, you should be able to:
- Describe
the purposes of a relational database.
- Define
basic relational database terminology, including fields, records, primary keys,
foreign keys, and one-to-many relationships.
- Describe
the basic functions of a non-relational database.
- Describe
the purpose of a database management system.
- Use
Microsoft Access to explore database objects and create table relationships.
Links:
Key Terms:
- Database A structured set of data held in a computer, usually in a way that that is accessible in multiple ways.
- Relational Database A database that is structured to recognize relationships between items of information.
- Table A container in a relational database that is comprised of fields (columns) and records (rows).
- Field A single attribute of each record in a table.
- Record A single instance of an object stored in a database table.
- Primary Key A field in a table that uniquely identifies a row.
- Foreign Key A field in a second table that matches the primary key in another table.
- Query A method of asking questions about the data stored in a database.
- Form A graphical interface that allows users to query a database by filling in information on the form.
- Report An easy-to-read listing of the results of a query.
- Structured Query Language (SQL) A computer language used by most relational databases for creating queries.
- Structured Data Data that can be divided into discrete categories.
- Unstructured Data Data that doesn’t follow a clear pattern.
- Semi-Structured Data Data that has some discrete categories but also other information that doesn’t follow a clear pattern.
- Database Management System (DBMS) Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access.
Topics Discussed:
- What
databases do you interact with in your everyday life?
- What
are the advantages to storing data in a relational database? Are there
disadvantages?
- What
is the purpose of a database management system?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study Section 3.1: Databases, and achieve a score of 80% or higher on the 14 question Exam to complete the Section.
Assigned: December 4th, 2019
Teacher Pacing Due Date: December 6th, 2019
It's dangerous to go alone!
