AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses 10985A: Introduction to SQL Databases

Courses


10985A: Introduction to SQL Databases

Length: 3    Cost: $1,945 + GST    Version: SQL Server 2016

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreMayJunJulAug
Auckland--
19
--
16
Hamilton--------
Christchurch--------
Wellington
31
28
24
--

Can't find a class in your area? Contact our sales team and request a class date.


About this Course

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.

Please note from 1 April 2017 we will only supply digital courseware, if a hard copy is preferred an additional cost will apply.



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.

Prerequisites

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

At Course Completion

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

Course Outline


Module 1: Introduction to databasesThis 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

Lab : Querying SQ Server

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 2016
• Describe data analytics
• Describe database languages used in SQL Server 2016

Module 2: Data ModellingThis module describes data modelling techniques.Lessons

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

Lab : 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

 

Module 3: NormalizationThis module describes normalization and denormalization techniques.Lessons

  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization

Lab : Normalizing raw 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

Module 4: RelationshipsThis module describes relationship types and effects in database design.Lessons

  • Schema mapping
  • Referential integrity

Lab : Designing relationships

After completing this module, you will be able to:
• Describe relationship types
• Describe the use, types, and effects of referential integrity

Module 5: PerformanceThis module introduces the effects of database design on performance.Lessons

  • Indexing
  • Query performance
  • Concurrency

Lab : Query performance

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

Module 6: Database ObjectsThis module introduces commonly used database objects.Lessons

  • Tables
  • Views
  • Stored procedures
  • Other database objects

Lab : Using SQL Server in a hybrid cloud

After completing this module, you will be able to:
• Describe the use of tables in SQL Server 2016
• Describe the use of views in SQL Server 2016
• Describe the use of stored procedures in SQL Server 2016
• Describe other database objects commonly used in SQL Server 2016


 Print this page