IT Specialist Databases
(ITSPC-DATABASE) / ISBN : 978-1-64459-330-1
About This Course
Skills You’ll Get
Get the support you need. Enroll in our Instructor-Led Course.
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
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?
Contact Us Now