Introduction to SQL Databases


Ημερομηνία Έναρξης
24 hours
Εξέταση - Πιστοποίηση



Audience profile

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


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

Course outline

1. Introduction to Databases

  • Relational databases
  • Other types of databases
  • Data analysis
  • Database languages in SQL Server

2. Data Modeling

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

3. Normalization

  • Fundamentals of Normalization
  • Normal from
  • Denormalization

4. Relationships

  • Introduction to relationships
  • Planning referential integrity

5. Performance

  • Indexing
  • Query performance
  • Concurrency

6. Database Objects

  • Tables
  • Views
  • Stored procedures, triggers and functions

Lab 1: Exploring and querying SQL Server databases

Lab 2: Identify components in entity relationship modeling

Lab 3: Normalizing data

Lab 4: Planning and implementing referential integrity

Lab 5: Performance issues

Lab 6: Using SQL Server

Δήλωσε Συμμετοχή

Προέκυψε κάποιο σφάλμα

Παρακαλούμε προσπαθήστε ξανά σε λίγο

Επιτυχής Εγγραφή

Σύντομα θα επικοινωνήσουμε μαζί σας.