Introduction to Database Fundamentals | Database Fundamentals Training

Authorized Training and Certification/Testing centre

MTA: Database Fundamentals

Course Description

Course Curriculum: MTA: Database Fundamentals

Prerequisites

(Click to find out more) +–

No Requirements

Course context

44 Lectures

00 : 00 : 00

+

Syllabus work in Progress

1 Lectures 00 : 00 : 00

Syllabus work in Progress

+

Introduction to Databases

11 Lectures 00 : 00 : 00

What Should a Database Provide?

Database Types

Relational Database Management Systems (RDBMS)

Good Design is Vital

The Basics of Tables

Foundations of the Modern Database

Record Uniqueness and Keys

Relationship Types

Entities and Relationships

Maintaining Data Integrity

Understanding Normalization

+

Creating Database Objects

9 Lectures 00 : 00 : 00

A Review of the Design Process

Structured Query Language (SQL)

Data Types

Database Products and Server Instances

SQL Server 2008 Express

Data Definition Language (DDL)

Introducing HomeGrown Gardening Supplies

Creating Tables

Dropping Tables

+

Manipulating Data

6 Lectures 00 : 00 : 00

Data Manipulation Language (DML)

Re-creating the HomeGrown Database

The INSERT Statement

Selecting Data

Updating Data

Deleting Data

+

Using Advanced SQL Commands

13 Lectures 00 : 00 : 00

A Review of the Basic SELECT Statement

Selecting Data from Multiple Tables using a WHERE clause

Using Joins

SQL Union and Intersect

SQL Subqueries

Using INSERT INTO with SELECT

Using Aggregate Functions

Using Scalar Functions

Using Database Views

Functions and Stored Procedures

User-Defined Functions

Using Stored Procedures

Modifying and deleting functions and stored procedures

+

Database Performance and Security

4 Lectures 00 : 00 : 00

Understanding Indexes

Using Transactions to Ensure Integrity

Database Security

Backing Up and Restoring