🎓 Authorised Pearson VUE and Prometric Test Centre · CIET Country Director for Syria · training in Mazzeh since 2010·Exams we deliver →
Home/Courses/Microsoft Data & Power BI/55315 Introduction to SQL Databases
Microsoft Data & Power BI

55315 Introduction to SQL Databases

A three-day introduction to databases with SQL Server.

3 daysFoundation6 modules
Overview

About this course

A three-day introduction to databases with SQL Server. You will learn database concepts and languages, data modelling, normalisation, relationships, performance and database objects.

What you'll learn

What you'll learn

  • Describe key database concepts in the context of SQL Server
  • Describe database languages used in SQL Server
  • Describe data modeling techniques
  • Describe normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects
Curriculum

Curriculum

6 modules
  • Introduction to Relational Databases
  • Other Databases and Storage
  • Data Analysis
  • SQL Server Database Languages
  • Data Modelling
  • Designing a Database
  • Relationship Modeling
  • Fundamentals of Normalization
  • Normal Form
  • Denormalization
  • Introduction to Relationships
  • Planning Referential Integrity
  • Indexing
  • Query Performance
  • Concurrency
  • Tables
  • Views
  • Stored Procedures, Triggers and Functions
Who it's for

Who it's for

Newcomers to databases, including analysts and junior developers.

Before you start

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

Let's plan your next step together.

Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.

Talk to an advisor →WhatsApp