Certiport

IT Specialist Databases

(ITSPC-DATABASE) / ISBN : 9781644593301

This course includes
Lessons
TestPrep
LiveLab

A database is a collection of data organized to provide efficient retrieval. Get the real-world experience of working with databases with uCertify's course IT Specialist Databases. The course contains interactive lessons, practice tests, knowledge checks, quizzes, flashcards, glossaries, and live labs to comprehensively cover the ITSPC exam objectives. It equips the candidates with all the skills required to pass the ITSPC Databases exam.

Here's what you will get

The Information Technology Specialist program validates the candidates for entry-level IT skills that employers look for. The ITSPC Databases program covers the concepts of Database Design, Database Object Management using DDL, Data Retrieval, Data Manipulation using DML, and Troubleshooting. The exam is designed for candidates who have the skills required to design and query relational databases, such as MySQL, Microsoft SQL Server, or Oracle.

Lessons

6+ Lessons | 50+ Quizzes | 76+ Flashcards | 76+ Glossary of terms

TestPrep

50+ Pre Assessment Questions | 2+ Full Length Tests | 54+ Post Assessment Questions | 108+ Practice Test Questions

Hand on lab

42+ LiveLab | 42+ Video tutorials | 39+ Minutes

Video Lessons

319+ Videos | 06:03+ Hours

Here's what you will learn

Download Course Outline

  • Understand How Data is Stored in Tables
  • Understand Relational Database Concepts
  • Understand Data Manipulation Language (DML)
  • Understand Data Definition Language (DDL)
  • Summary

  • Choose Data Types
  • Understand Tables and How to Create them
  • Create Views
  • Create Stored Procedures and Functions
  • Summary

  • Select Data
  • Insert Data
  • Update Data
  • Delete Data
  • Transaction Controls
  • Summary

  • Understand Normalization
  • Understand Primary, Foreign, and Composite keys
  • Understand Indexes
  • Summary

  • Understand Database Security Concepts
  • Understand Database Backups and Restore
  • Summary

Hands-on LAB Activities

  • Creating a Database
  • Deleting a Database
  • Adding a Column to a Table
  • Renaming a Table
  • Modifying a Column in a Table
  • Dropping a Column from a Table
  • Using the SELECT Command
  • Creating an ER Diagram
  • Using the CREATE Command

  • Exceeding Data Type Limit
  • Handling NULL Values
  • Inserting Values into a Table using the Stored Procedure
  • Creating an Inline Table-Valued Function
  • Using the CREATE VIEW Syntax
  • Using the ALTER VIEW Statement
  • Creating a View using the WITH CHECK OPTION Clause
  • Creating a Stored Procedure
  • Altering a Stored Procedure
  • Modifying Stored Proc Definitions

  • Using the SELECT DISTINCT Statement
  • Using the SELECT, FROM, and WHERE Clauses
  • Using the ORDER BY Keyword
  • Using the UNION Operator
  • Using the INTERSECT Operator
  • Using the EXCEPT Operator
  • Using LEFT OUTER JOIN
  • Using RIGHT OUTER JOIN
  • Using FULL OUTER JOIN
  • Using CROSS JOIN
  • Using a Simple Inner Join
  • Using a Complex Inner Join
  • Using the INSERT statement
  • Using the UPDATE Statement
  • Using the DELETE Statement
  • Using Transaction Controls

  • Using Referential Integrity Constraints
  • Creating a Function-Based Index
  • Using a Function-Based Index
  • Creating a Non-Clustered Index

  • Adding a New Login
  • Accessing the Database Roles
  • Creating a Backup

Exam FAQs

Pearson VUE

The exam contains 35-45 questions.

50 minutes

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait seven days before retaking the exam a third time.
  • A seven-day waiting period is imposed between each subsequent exam retake.
  • A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts from the first attempt. The candidate is then eligible to retake the exam 12 months from the date of the first attempt.