Szkolenie Database Fundamentals

This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.

Profil uczestnika

The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.

Agenda

Understanding Core Database Concepts

• Understanding Database Concepts 
• Understanding Flat-Type Databases 
• Understanding Hierarchical Databases 
• Understanding Relational Databases 
• Understanding Database Fundamentals 
• Understanding Relational Database Concepts 
• Using the SQL Server Management Studio Interface 
• Understanding Data Manipulation Language (DML) 
• Understanding Data Definition Language (DDL) 
• Using DDL Statements 

Creating Database Objects 

• Defining Data Types 
• Using Built-in Data Types 
• Using Exact Numeric Data Types 
• Using Approximate Numeric Data Types 
• Creating and Using Tables 
• Creating Views 
• Creating Stored Procedures 
• Understanding SQL Injections 

Manipulating Data 

• Using Queries to Select Data 
• Combining Conditions 
• Using the BETWEEN Clause 
• Using the NOT Clause 
• Using the UNION Clause 
• Using the EXCEPT and INTERSECT Clauses 
• Using the JOIN Clause 
• Using Queries to Insert Data 
• Inserting Data 
• Updating Data and Databases 
• Using the UPDATE Statement 
• Deleting Data 
• Using the DELETE Statement 
• Truncating a Table with TRUNCATE TABLE 
• Deleting a Table with DROP TABLE 
• Using Referential Integrity 

Understanding Data Storage 

• Using Queries to Select Data 
• Normalizing a Database 
• Understanding Normalization 
• Understanding the First Normal Form 
• Understanding the Second Normal Form 
• Understanding the Third Normal Form 
• Understanding the Fourth Normal Form 
• Understanding the Fifth Normal Form 
• Understanding Primary, Foreign, and Composite Keys 
• Understanding Primary Keys 
• Understanding Foreign Keys 
• Understanding Composite Primary Keys 
• Understanding Clustered and Non-clustered Indexes 
• Understanding Clustered Indexes 
• Understanding Non-clustered Indexes 
• Creating a Non-clustered Table 

Administering a Database 

• Securing Databases 
• Understanding Server-Level Security 
• Understanding Database-Level Security 
• Understanding Windows Security 
• Understanding SQL Authentication 
• Understanding Database Server Roles 
• Granting Access to a Database 
• Understanding Fixed Database Roles 
• Understanding Object Permissions 
• Managing Roles 
• Understanding Ownership Chains 
• Reviewing a Sample Security Model 
• Backing Up and Restoring Databases 
• Understanding Recovery Models 
• Understanding Database Backups 
• Understanding Backup Devices 
• Understanding Database Restores

Korzyści

After completing this course, students will be able to:

• Understand Core Database Concepts
• Create Database Objects
• Manipulate Data
• Understand Data Storage
• Administer a Database

Poznaj naszą firmę