Relational Database
Computer
Training
Provided by Makau Corporation
This tutorial training series will teach you the concept of Relational Databases and how to plan, build, write to, query and manage them.
|
|
||||||||||||||
Relational Database
Course Instructor: Tutorial Text-Based Training
This self-led instructional course is designed to provide graphical examples and engaging activities to complement the in-depth text-based instructions.
Course Outline
Relational Database Concepts and Facilities
Basic Relational Concepts
Database Terminology
Practice
Database Objects
Data Structures
Database Management System
Roles of Database Personnel
Practice
Designing the Logical Model
Data Modeling
Normalization
Practice
Developing the Relational Model
Relational (Physical) Model
Data Storage Language
Data Definition Language
Data Manipulation Language
Practice
Using the Database
Writing Applications
Structured Query Language
Unit of Work
Application Functions
Authentication
Distributed Databases
Practice
Relational Database Concepts: Structured Query Language
SQL History and Concepts
SQL Overview
SQL Evolution
SQL Concepts
Practice
Creation Using SQL
Data Definition Language
Practice
Update and Access Using SQL
Data Manipulation Language
Data Control Language
Practice
Relational Database Design and Administration
SQL Server Administration
Server Features
Administrative Tasks
Server Tools
Server Basic Concepts
Practice
Installation and Configuration
Pre-Installation
Installation
Post-Installation
Practice
Managing with SQL Server
Devices and Databases
SQL Security
Backup and Restore
Scheduling and Alerts
Practice
Replication
Concepts
Implementing
Practice
Performance
SQL Performance Monitor
Troubleshooting
Practice
Accessing SQL Server
Client Utilities
SQL Compatible Applications
Practice
This self-led instructional course is designed to provide graphical examples and engaging activities to complement the in-depth text-based instructions.
Course Outline
Relational Database Concepts and Facilities
Basic Relational Concepts
Database Terminology
Practice
Database Objects
Data Structures
Database Management System
Roles of Database Personnel
Practice
Designing the Logical Model
Data Modeling
Normalization
Practice
Developing the Relational Model
Relational (Physical) Model
Data Storage Language
Data Definition Language
Data Manipulation Language
Practice
Using the Database
Writing Applications
Structured Query Language
Unit of Work
Application Functions
Authentication
Distributed Databases
Practice
Relational Database Concepts: Structured Query Language
SQL History and Concepts
SQL Overview
SQL Evolution
SQL Concepts
Practice
Creation Using SQL
Data Definition Language
Practice
Update and Access Using SQL
Data Manipulation Language
Data Control Language
Practice
Relational Database Design and Administration
SQL Server Administration
Server Features
Administrative Tasks
Server Tools
Server Basic Concepts
Practice
Installation and Configuration
Pre-Installation
Installation
Post-Installation
Practice
Managing with SQL Server
Devices and Databases
SQL Security
Backup and Restore
Scheduling and Alerts
Practice
Replication
Concepts
Implementing
Practice
Performance
SQL Performance Monitor
Troubleshooting
Practice
Accessing SQL Server
Client Utilities
SQL Compatible Applications
Practice
About The Training Provider: Makau Corporation
Makau Corporation - Makau Corporation, your training partner, specializes in flexible training solutions that meet 'your' training needs. Makau empowers computer users at all levels, from novice to expert, with the skills and knowledge necessary to compete successfully in today's rapid changing business environment. Certified trainers with years of hands-on experience take the confusion out of learning by walking...
