Information Technology
55315: Introduction to SQL Databases
This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title.
3 Days
24 Hrs
6 Lessons
Course Objectives
After completing this course, you will be able to:
- Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling 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
Agenda
- 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
FREE
Interested in course?
Course Type: Instructor Led