55315A: Introduction to SQL Databases Courseware

55315A is the updated version of the retired legacy Microsoft Official Curriculum (MOC) Course 10985C - Introduction to SQL Databases.

The 55315A 3-day instructor-led course is 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.  New content has been added to help administrators leverage new AI and ML features in SQL Server.  Students will run T-SQL, Python and R commands on SQL Server databases.

Students will learn fundamental database concepts through demonstrations and hands-on labs on SQL Server, Azure SQL Server and other cloud-based SQL Server databases.

Audience Profile

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.

At Course Completion:

After completing this instructor-led course, students 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