Download Database Development Strands and Standards and more Schemes and Mind Maps Ethics in PDF only on Docsity!
STRANDS AND STANDARDS
Database Development
Course Description
This course is designed to educate students on the fundamentals of database and to provide introductory knowledge of and skills with database, including relational databases using SQL. This course will provide students with the necessary skills to pursue academic and professional opportunities. Intended Grade Level 10 - 12 Units of Credit 1. Core Code 35 - 02 - 00 - 00 - 021 Concurrent Enrollment Core Code 35 - 02 - 00 - 13 - 021 Prerequisite Introduction to Information Technology, Computer Science Principles Skill Certification Test Numbers 860 , 944 Test Weight 1. License Type CTE and/or Secondary Education 6- 12 Required Endorsement(s) Endorsement 1 or Cybersecurity Endorsement 2 or Information Technology Systems Endorsement 3 or Programming & Software Development Endorsement 4 Web Development ADA Compliant: June 2020
STRAND 1
Students will be introduced to Database Fundamentals.
Standard 1
Ethics of Database.
- Identify ethics within the industry.
- Identify personal ethics.
Standard 2
History of Databases.
- Order of database management systems in history (DBMS, RDBMS, OODBMS, ORDBMS).
- Understand what a relational database is.
- Understand the need for relational data management systems (RDMS).
Standard 3
Database industry aware of opportunities.
- Identify career opportunities in the database industry (DBA, programmer, reporting programmer, database designer, and database developer).
Standard 4
Types of Databases used today and where they are moving to in the future.
- Show understanding of the difference between OLTP vs Reporting.
- Data Lakes/reservoirs
STRAND 2
Students will be familiar with the languages types of database development.
Standard 1
DCL (Data Control Language).
- Grant rights to database objects.
- Revoking rights to database objects.
Standard 2
DDL (Data Definition Language).
- Create a database.
- Create objects in a database.
- Maintenance of the database and objects.
- Remove database objects
Standard 5
Create indexes.
- Understand clustered and non-clustered indexes.
- Add, delete and manage indexes for fast access to table rows and enforcing certain constraints.
- Explain benefits and costs of using indexes.
STRAND 4
Demonstrate use of data manipulation language to view, change, create and remove data in the database.
Standard 1
Demonstrate select statements to view data in the database.
- Demonstrate simple one table selects.
- Demonstrate joined tables using inner and outer joins.
- Understand what a Cartesian product is and how to avoid creating one.
- Demonstrate grouping and sorting in joins.
- Demonstrate the use of inline functions in SQL.
- Check for NULL values.
Standard 2
Demonstrate insert statements to load data into the database.
- Demonstrate inserting data into a table.
- Demonstrate order when inserting into parent/child tables.
Standard 3
Demonstrate update statements to change data.
- Demonstrate updating one row updates.
- Demonstrate multiple rows to full table updates.
Standard 4
Demonstrate delete statements to remove data.
- Demonstrate deleting one row.
- Demonstrate deleting multiple rows to full table deletes.
- Show understanding of the difference between truncate and delete.
STRAND 5
Database Security.
Standard 1
Understand database security concepts.
- Understand the need to secure a database.
- Understand what objects can be secured.
- Understand what objects should be secured, user accounts, and roles.
Standard 2
Understand database backups and restore.
- Understand various backup trips, such as full and incremental.
- Understand the importance of backups.
- Understand how to restore a database.
Performance Skills
- Understand Database Fundamentals.
- Know the language types of database development.
- Demonstrate the creation of a Logical ERD model and taking it to the physical database.
- Demonstrate use of data manipulation language to view, change, create and remove data in the database.
- Understand Database Security.
Workplace Skills
Workplace skills should be practiced and improved on daily in the classroom to help students become efficient and reliable employees.
- Communication
- Problem Solving
- Critical Thinking
- Dependability
- Accountability
Skill Certificate Test Points by Strand
