0992 400 376   0317 0017 706

SQL Database

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

 

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

    1 - Introduction to databases

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

    2 - Data Modelling

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

    3 - Normalization

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

    4 - Relationships

    • Schema mapping
    • Referential integrity

    5 - Performance

    • Indexing
    • Query performance
    • Concurrency

    6 - Database Objects

    • Tables
    • Views
    • Stored procedures
    • Other database objects

 

 

Own your future by learning new skills

A Magical And Revolutionary Way Of Training At An Unbelievable Pace

Opening Hours

  • Monday - Saturday: 8:00am - 17:00pm
  • Saturday: 9:00am - 11:00am | 1:30pm - 17:00pm
  • Sunday: 8:00am - 19:00pm

Our Location

  • 1st Floor Gohar Arcade Opposite To Rehmat Memorial Hospital, Supply, Abbottabad
  • Phone: 0992 400 376 | 0317 0017 706
  • Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Our Partners

  • alwees.jpg
  • brilliantebiz.jpg
  • dubaihit.jpg
  • gulfitsolutions.jpg
  • khaleejad.jpg
  • saudihit.jpg
  • technogut.jpg
Top