Introduction to SQL Databases

Descrizione del corso

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.

Programma

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

Module 2: Data Modelling
• Data modelling
• ANSI/SPARC database model
• Entity relationship modelling

Module 3: Normalization
• Fundamentals of Normalization
• Normal form
• Denormalization

Module 4: Relationships
• Introduction to relationships
• Planning referential integrity

Module 5: Performance
• Indexing
• Query performance
• Concurrency

Module 6: Database Objects
• Tables
• Views
• Stored procedures, triggers and functions