CertPREP Courseware: IT Specialist Databases - Instructor-Led
Qty
Please select required options above
CertPREP Courseware: IT Specialist Databases - Instructor-Led
Qty
Please select required options above
Description
Databases serve as a foundation layer of many web and data applications, business reporting functions, and prediction algorithms. In this course, students will learn
Taken together, these skills will serve as an entry point into data-related careers in reporting, data engineering, and automation.
Duration: 4 days of training
Audience:
Designed for high school-level students and learners interested in obtaining a working-level proficiency with databases. After completing this course, you will be able to perform the basic responsibilities of an entry-level professional in the IT field, or take advanced database courses that will allow you to become a database administrator.
Prerequisites: None
Course objectives:
Upon successful completion of this course, students should be able to:
Required course materials: None
- 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
Taken together, these skills will serve as an entry point into data-related careers in reporting, data engineering, and automation.
Duration: 4 days of training
Audience:
Designed for high school-level students and learners interested in obtaining a working-level proficiency with databases. After completing this course, you will be able to perform the basic responsibilities of an entry-level professional in the IT field, or take advanced database courses that will allow you to become a database administrator.
Prerequisites: None
Course objectives:
Upon successful completion of this course, students should be able to:
- Translate business case into a normalized database design
- Create and maintain tables, views, and stored procedures that support business operations
- Create and maintain tables, views, and stored procedures that support reporting functions
- Optimize and troubleshoot queries
Required course materials: None
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
- 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
- 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
- Skill 4.1: Construct and analyze INSERT statements
- Skill 4.2: Construct and analyze UPDATE statements
- Skill 4.3: Construct and analyze DELETE statements
- 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


COURSEWARE
The ultimate teaching tool
CertPREP courseware is a comprehensive learning toolkit that saves trainers time and money. Everything you need to teach the class is at your fingertips — texts, practice labs, videos, practice tests and quizzes. By integrating materials together into one consistent interface, you can deliver the best IT certification exam prep experience on the market.