Classes Data & Analytics
55315 Microsoft Technical Partner Delivered
55315 Introduction to SQL Databases
- 3 days
- 2 upcoming dates
- 2 guaranteed to run
- May qualify for CEU/PDU credit
Upcoming dates
All times shown in the class's own timezone. 2 of 2 are guaranteed to run, meaning they go ahead regardless of enrollment.
| Dates | Starts | Where | Status | Seat | Book |
|---|---|---|---|---|---|
| Nov 23-25 | 9:00 AM to 5:00 PM EST | Live virtual | GUARANTEED | $1,895 | |
| Jan 13-15 | 9:00 AM to 5:00 PM EST | Live virtual | GUARANTEED | $1,895 |
About this class
We have 2 scheduled dates of 55315 Introduction to SQL Databases, from Nov 23-25 through Jan 13-15. Every one is guaranteed to run regardless of enrollment. Seats are $1,895 each over 3 days, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.
This three-day instructor-led 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. This course updates and replaces course 10985C previously published under the same title.
What you'll be able to do
- 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
Course outline
1 - Introduction to databases
- Introduction to Relational Databases
- Other Databases and Storage
- Data Analysis
- SQL Server Database Languages
2 - Data Modeling
- Data Modelling
- Designing a Database
- Relationship Modeling
3 - Normalization
- Fundamentals of Normalization
- Normal Form
- 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
Before you attend
This is a foundation level course and therefore only requires general computer literacy.
Who this is for
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.
How reserving works. Your card is authorized, not charged. We confirm the seat with the training center, usually within one business day, and take payment only once it is held. If the class turns out to be full we release the authorization and you are not charged.
Request a quote
Tell us how many people and roughly when. We'll come back with dates, seat price, and a total by the end of the next business day.