top of page
Game Developers

Databases

IT Specialist Databases course serves as a foundation layer of many web and data applications, business reporting functions, and prediction algorithms. In this course, students will learn:

  • how to design and optimize a database

  • how to create, update and delete records and tables

  • how to filter and aggregate data

  • how to automate certain procedures

Databases.png

Self-Study Course Includes:

Books: a $75 value

Videos: a $250 value

Practice Test by MeasureUp: a $100 value

​​

 

With CertPREP, you get all this and
more for just $199.00. Get started today!

Course Outline

Lesson 1: Database Design

  • Skill 1.1: Given a scenario, design tables for storing data

  • Skill 1.2: Given a scenario, identify the appropriate primary key

  • Skill 1.3: Given a scenario, choose data types to meet the requirements

  • Skill 1.4: Given a scenario, design relationships between tables

  • Skill 1.5: Normalize a database

  • Skill 1.6: Given a scenario, identify data protection measures

Lesson 2: Database Object Management using DDL

  • Skill 2.1: Construct and analyze queries that create, alter, and drop tables

  • Skill 2.2: Construct and analyze queries that create, alter, and drop views

  • Skill 2.3: Construct and analyze stored procedures and functions

  • Skill 2.4: Given a scenario, choose between clustered and non-clustered indexes

Lesson 3: Data Retrieval

  • Skill 3.1: Construct and analyze queries that select data

  • Skill 3.2: Construct and analyze queries that sort and filter data

  • Skill 3.3: Construct and analyze queries that aggregate data

Lesson 4: Data Manipulation using DML

  • Skill 4.1: Construct and analyze INSERT statements

  • Skill 4.2: Construct and analyze UPDATE statements

  • Skill 4.3: Construct and analyze DELETE statements

Lesson 5: Troubleshooting

  • Skill 5.1: Troubleshoot data object management query failures

  • Skill 5.2: Troubleshoot data retrieval query failures

  • Skill 5.3: Troubleshoot data manipulation query failures

bottom of page