Database Fundamentals
(DB-FUND.AA1)
/ ISBN: 978-1-64459-307-3
This course includes
Lessons
TestPrep
LiveLab
Database Fundamentals
Lessons
-
5+ 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
LiveLab
-
42+ LiveLab
-
42+ Video tutorials
-
39+ Minutes
Video Lessons
-
319+ Videos
-
06:03+ Hours
- 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 Activities (Live Labs)
- 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
×