Product image media
Product image media

Introduction to SQL Databases

11.850,00 kr

Beskrivelse


På dette kursus får du viden om og forståelse af:

  • Vigtige og centrale databasebegreber inden for SQL Server 2016
  • Databasesprog brugt i SQL Server 2016
  • Datamodellerings-teknikker
  • Normaliserings- og denormaliserings-teknikker
  • Relationstyper og indvirkningen på databasedesign
  • Indvirkningen af databasedesign på performance
  • Ofte anvendte databaseobjekter Kurset retter sig især mod personer, der skal til at udfylde en rolle som professionel databasemedarbejder, eller hvis jobfunktion også skal til at omfatte databaseelementer.

Indhold


Module 1: 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
  • Lab : Querying SQ Server Module 2: Data Modelling
  • This module describes data modelling techniques.
  • Lessons
  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling
  • Lab : Entity relationship modelling Module 3: Normalization
  • This module describes normalization and denormalization techniques.
  • Lessons
  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization
  • Lab : Normalizing raw data Module 4: Relationships
  • This module describes relationship types and effects in database design.
  • Lessons
  • Schema mapping
  • Referential integrity
  • Lab : Designing relationships Module 5: Performance
  • This module introduces the effects of database design on performance.
  • Lessons
  • Indexing
  • Query performance
  • Concurrency
  • Lab : Query performance Module 6: Database Objects
  • This module introduces commonly used database objects.
  • Lessons
  • Tables
  • Views
  • Stored procedures
  • Other database objects
  • Lab : Using SQL Server in a hybrid cloud