10985 MOD+DMOC Introduction to SQL Databases

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

Vaativuus
Arvostelut
1100,00 

Kieli: Englanti

Agenda

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.

Material: This course is delivered as MOC on Demand. In addition you will have Digital MOC available for reading online or offline.

 

Module 1: Introduction to databases
  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages
Module 2: Data Modelling
  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling
Module 3: Normalization
  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization
Module 4: Relationships
  • Schema mapping
  • Referential integrity
Module 5: Performance
  • Indexing
  • Query performance
  • Concurrency
Module 6: Database Objects
  • Tables
  • Views
  • Stored procedures
  • Other database objects

 

Avainsanat:

Agenda

Paikkoja jäljellä:
Ei paikkarajoitusta
1100,00  + alv./VAT

Vastuuhenkilö


Pekka Korhonen

Pekka Korhonen

  • pekka.korhonen@sovelto.fi

Pekka Korhonen on tunnettu SQL Server-, SQL- ja Business Intelligence -tekniikoiden asiantuntija, arkkitehti, kouluttaja ja konsultti. Hänelle on kertynyt kokemusta parikymmentä vuotta. Soveltossa Pekka toimii senior-konsulttina ja partnerina. Pekka on suorittanut harvinaisen SQL Server Master -sertifikaatin, joita on maailmassa vain noin 150 kpl. Pidettyjä kursseja Pekalle on kertynyt jo yli tuhat!

SQL Server Master, Master Certified (MCSM: Data Platform), MCSE: Data Platform, MCSE: Business Intelligence, MCSA, MCTS, MCT, MCITP.