Microsoft Data & Power BI
55315 Introduction to SQL Databases
A three-day introduction to databases with SQL Server.
3 daysFoundation6 modules
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
- 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
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
Newcomers to databases, including analysts and junior developers.
Before you start
- This is a foundation level course and therefore only requires general computer literacy.
Related courses
More in Microsoft Data & Power BI →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →IntermediateDP-300 Exam Prep/DP-300T00
Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →Foundation
Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →IntermediateDP-203/DP-203T00
Data Engineering on Microsoft Azure (DP-203/DP-203T00)
Microsoft Data & Power BI
View course →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.