CertPREP Courseware: IT Specialist Databases - Instructor-Led
WEB PRICE:
$149.00
Member price:
$149.00
Qty
Please select required options above
Summary
WEB PRICE:
$149.00
Member price:
$149.00
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 how to:
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 any learner 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
- design and optimize a database
- create, update and delete records and tables
- filter and aggregate data
- 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 any learner 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
