Course 10985-C: Introduction to SQL Databases

Course Modality

Instructor-led (classroom)

Course Level

Intermediate

Course Time

3 days

Course Language

English

Course Overview

This three-day instructor-led 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 designs.

Prerequisites

  • This is a foundation level course and therefore only requires general computer literacy.

Intended 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.

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

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 denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects

Get In Touch

Course Curriculum

Introduction to databases

This module introduces key database concepts in the context of SQL Server 2016.

Lessons

  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages in SQL Server

 

Lab : Exploring and querying SQL Server databases

After completing this module, you will be able to:

  • Describe what a database is
  • Understand basic relational aspects
  • Describe database languages used in SQL Server
  • Describe data analytics

 Data Modelling

This module describes data modelling techniques.

Lessons

  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling

 

Lab : Identify components in entity relationship modelling

After completing this module, you will be able to:

  • Understand the common data modelling techniques
  • Describe the ANSI/SPARC database model
  • Describe entity relationship modelling



Normalization

This module describes normalization and denormalization techniques.

Lessons

  • Fundamentals of Normalization
  • Normal form
  • Denormalization

 

Lab : Normalizing data

After completing this module, you will be able to:

  • Describe normalization benefits and notation
  • Describe important normalization terms
  • Describe the normalization levels
  • Describe the role of denormalization

Relationships

This module describes relationship types and effects in database design.

Lessons

  • Introduction to relationships
  • Planning referential integrity

 

Lab : Planning and implementing referential integrity

After completing this module, you will be able to:

  • Describe relationship types
  • Describe the use, types, and effects of referential integrity

 Performance

This module introduces the effects of database design on performance.

Lessons

  • Indexing
  • Query performance
  • Concurrency

 

Lab : Performance issues

After completing this module, you will be able to:

  • Discuss the performance effects of indexing
  • Describe the performance effects of join and search types
  • Describe the performance effects of concurrency

Database Objects

This module introduces commonly used database objects.

Lessons

  • Tables
  • Views
  • Stored procedures, triggers and functions

 

Lab : Using SQL server

After completing this module, you will be able to:

  • Describe the use of tables in SQL Server
  • Describe the use of views in SQL Server
  • Describe the use of stored procedures in SQL Server
  • Describe other database objects commonly used in SQL Server

Reviews

Get in touch, enquire now!


By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.

© 2020 The Data Tech Labs Inc. All rights reserved.

TDTL-arrow
[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure