Chat with us, powered by LiveChat

Enter your keyword

Course

10985 Introduction to SQL Databases

National Business Training - Computer Training

Course Summary

Course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database design

Course Schedule

    • This course is not currently scheduled. Call 919-595-8200 or email info@nationalbusinesstraining.com for dates or private training.
  • S - ScheduledGTR - Guaranteed to Run

Course Outline

1 – INTRODUCTION TO DATABASES

Introduction to relational databases
Other types of database
Data analysis
Database languages
Lab : Querying SQ Server

2 – DATA MODELLING

Data modelling
ANSI/SPARC database model
Entity relationship modelling
Lab : Entity relationship modelling

3 – NORMALIZATION

Why normalize data?
Normalization terms
Levels of normalization
De-normalization
Lab : Normalizing raw data

4 – RELATIONSHIPS

Schema mapping
Referential integrity
Lab : Designing relationships

5 – PERFORMANCE

Indexing
Query performance
Concurrency
Lab : Query performance

6 – DATABASE OBJECTS

Tables
Views
Stored procedures
Other database objects
Lab : Using SQL Server in a hybrid cloud

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Course Objectives

After completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and de-normalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

Target Audience

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

 

This product is currently out of stock and unavailable.

Share our course