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 | 42+ Exercises | 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
Lessons 1: 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
Lessons 2: Create Database Objects
- Choose Data Types
- Understand Tables and How to Create them
- Create Views
- Create Stored Procedures and Functions
- Summary
Lessons 3: Manipulate Data
- Select Data
- Insert Data
- Update Data
- Delete Data
- Transaction Controls
- Summary
Lessons 4: Understand Data Storage
- Understand Normalization
- Understand Primary, Foreign, and Composite keys
- Understand Indexes
- Summary
Lessons 5: Administer a Database
- Understand Database Security Concepts
- Understand Database Backups and Restore
- Summary
Appendix
Hands-on LAB Activities
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
Reviews
There are no reviews yet.