Certiport

IT Specialist Databases

(ITSPC-DATABASE) / ISBN : 978-1-64459-330-1

This course includes

Lessons

TestPrep

Hands-On Labs

AI Tutor (Add-on)

Get A Free Trial

This course includes:

Free pre-assessment and first 2 lessons

6+ Interactive Lessons | 42+ Exercises

319+ Videos | 05:06+ Hours

Accessible on mobile and tablet too

Certificate of completion

$279.99

Buy Now

Are you an instructor?

Access detailed information about the course content, learning objectives, activities, and assessments before adding it to your curriculum.

About This Course

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

Get Started

Interactive Lessons

6+ Interactive Lessons | 42+ Exercises | 50+ Quizzes | 76+ Flashcards | 76+ Glossary of terms

Gamified TestPrep

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

Hands-On Labs

42+ LiveLab | 84+ Video tutorials | 01:44+ Hours

Video Lessons

319+ Videos | 05:06+ Hours

Download Course Outline

Understand Core Database Concepts

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

Create Database Objects

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

Manipulate Data

Select Data
Insert Data
Update Data
Delete Data
Transaction Controls
Summary

Understand Data Storage

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

Administer a Database

Understand Database Security Concepts
Understand Database Backups and Restore
Summary

Appendix

Understand Core Database Concepts

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

Create Database Objects

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

Manipulate Data

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

Understand Data Storage

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

Administer a Database

Creating a Backup
Accessing the Database Roles
Adding a New Login

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?