Program Overview

Program Overview

The MOC-10985 course provides fundamental concepts of databases, including data types, languages, and database models. The course aims to equip students with practical skills in database design.

Target Audience

The primary target audience for this course is specialists interested in mastering database technologies.

Course Details

• Level of complexity: Not specified
• Course duration: 24 academic hours
• Training schedule: 3 days, 8 hours per day
• Course materials are in English

Knowledge and Skills Acquired

After completing the course, students will be able to:

• Describe and understand key database concepts in the context of SQL Server 2016
• Identify database languages used in SQL Server 2016
• Apply data modeling techniques
• Understand normalization and denormalization techniques
• Recognize types of relationships and their impact on database design
• Analyze the impact of database design on performance
• Identify basic objects used in databases

Instructors

• G

Course Content

Module 1. Introduction to Databases

• Introduction to relational databases
• Overview of database types
• Data analysis
• Database languages
• Laboratory work: SQL Server queries

Module 2. Data Modeling

• Data modeling
• ANSI/SPARC database model
• Modeling relationships between objects
• Laboratory work: Modeling relationships between objects

Module 3. Normalization

• Need for data normalization
• Benefits of normalization
• Levels of normalization
• Denormalization
• Laboratory work: Normalizing initial data

Module 4. Relationships

• Schema mapping
• Referential integrity
• Laboratory work: Designing relationships

Module 5. Performance

• Indexing
• Query performance
• Competition
• Laboratory work: Query performance

Module 6. Database Objects

• Tables
• Views
• Stored procedures
• Other database objects
• Laboratory work: Using SQL Server in a hybrid cloud

Tuition Fees

• For individuals: 15,600
• Discounts:
  • 10%: 14,000
  • 15%: 13,200
• For legal entities: 15,600
• Discounts are provided based on the number of students, contract amount, and other conditions agreed upon with the client

Requirements

• Skills in working with and administering the Windows operating system family
• Knowledge of technical English (course materials are in English)

Related Courses

• MOC-20761. Creating Data Queries using Transact-SQL
• MOC-20762. Developing SQL Databases
• MOC-20764. Administering SQL Database Infrastructure
• MOC-20765. Deploying SQL Server Database Server