Introduction to SQL Databases

M10985

Ημερομηνία Έναρξης
Σε αναμονή
Διάρκεια
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.

Prerequisites

  • 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

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

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

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

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

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