Career and Technical Education (CTE) Course Description

LearnKey's Databases course is an introduction to building, entering information into, and querying databases. The course also provides a solid introduction to Structured Query Language (SQL), the primary language used to get the desired information from a database. This course helps one get ready to take and pass the IT Specialist Databases exam and will help one’s employability prospects in any job requiring querying and junior database administration skills. 

Students will have the opportunity to showcase their accomplishments by participating in Business Professionals of America (BPA) Competitions. It is a “hand-on” class and much of the work is completed independently.  There will also be opportunities in Soft Skills and Work Based Learning.

Topics Covered

1. Database Design

2. Database Object Management

3. Data Retrieval

4. Data Manipulation

5. Troubleshooting.

Course Prerequisites

• Java or Python

• Good Work Ethic

• 8th grade reading skills

• Some familiarity with data organization concepts

• Critical thinking and problem-solving skills

• Digital literacy skills, including the ability to research, create content, and solve problems using technology

Certification Preparation:

• Certiport IT Specialist:  Databases

  • Required (BPA Contest 345 - SQL Database Fundamentals - Free testing at NLC)

  • Certification Test Total Points:  1000

  • Certification Test Passing Points:  700

  • Certification Retake Policy:

    • If you don’t receive a passing score on an exam the first time, you must wait 24 hours before retaking the exam.

    • If you don’t receive a passing score on your second attempt, you must wait seven days before retaking the exam a third time.

    • A seven-day waiting period is imposed between each subsequent exam retake.

    • You may not take a given exam any more than five times per year/12-month period, which starts from your first attempt. If you take a given exam five times in that period, you will become eligible to retake the exam 12 months from the date of your first attempt.

  • If a candidate achieves a passing score on an IT Specialist exam, the candidate cannot take it again.

• Microsoft Office Specialist: Access 2019 Expert (Certiport)

  • Optional (BPA contest 240 - Database Applications - Free testing at NLC)

  • Certification Test Total Points:  1000

  • Certification Test Passing Points:  700

  • Certification Test Attempts:  Unlimited

Articulation

• Database Articulation Agreements

• Access Articulation Agreements

Michigan Merit Curriculum High School Graduation Requirements

• Language Other Than English:  The second credit can be substituted with CTE program completion

• Physical Education & Health:  PE/Health credit can be substituted with additional CTE program completion

• Science:  One credit of Physics or Chemistry can be substituted with CTE program completion

• Social Studies:  One credit of Social Studies (except Govt) can be substituted with additional CTE program completion

• Visual, Performing, and Applied Arts:  Credit can be substituted with CTE program completion

Other

• • • Grades:  9-12

    • Length:  1 semester

    • Credits:  1/2

    • CTE CIP:  11.0201 Computer Programming/Programmer

    • PSN:  20362

Agenda: