Trial, buy to get premium features

Previous Buy now to get complete version Next
  • Home
uCertify Logo
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • login
  • Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Cart 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

Database Fundamentals

(DB-FUND.AA1) / ISBN: 978-1-64459-307-3
This course includes
Lessons
TestPrep
LiveLab
98-364 98-364
$279.99
Buy Now
Try this course Pre-Assessment and first two Lessons free No credit card required
Are you an instructor? Teach using uCertify products
Request a free evaluation copy

Database Fundamentals

Here's what you will get

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
Here's what you will learn
Download Course Outline
Lesson 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
Lesson 2: Create Database Objects
  • Choose Data Types
  • Understand Tables and How to Create them
  • Create Views
  • Create Stored Procedures and Functions
  • Summary
Lesson 3: Manipulate Data
  • Select Data
  • Insert Data
  • Update Data
  • Delete Data
  • Transaction Controls
  • Summary
Lesson 4: Understand Data Storage
  • Understand Normalization
  • Understand Primary, Foreign, and Composite keys
  • Understand Indexes
  • Summary
Lesson 5: Administer a Database
  • Understand Database Security Concepts
  • Understand Database Backups and Restore
  • Summary

Hands on Activities (Live Labs)

Understand Core Database Concepts

  • 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

Create Database Objects

  • 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

Manipulate Data

  • 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

Understand Data Storage

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

Administer a Database

  • Adding a New Login
  • Accessing the Database Roles
  • Creating a Backup
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept