• 98-364 Microsoft Database Fundamentals

  • 3 Day Course | £1195.00 (+VAT) | 9am-5pm

  • On demand, please enquire

Target Audience

Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server.  Although minimal hands-on experience with the technologies is recommended, job experience is not assumed for these courses.

Required Knowledge

  • Basic understanding of relational databases
  • Basic T-SQL knowledge

Purpose of the Course

By the end of this course you will understand core database concepts, create database objects, manipulate data, understand data storage, and administer a database.

This information will be the underlying knowledge to build on when looking to improve and upgrade your career.

Topics Covered

  • Relational Database Concepts
  • Create database objects such as tables, views, functions, procedures etc.
  • Write SELECT, UPDATE, DELETE, and INSERT commands
  • Understand Normalisation alongside Primary and Foreign Keys
  • Index composition and usage
  • Basic database security
  • Backup and Restore and database

Course Modules

Module 1: Core Concepts

  • What is a Table?
  • How is data stored?
  • Relational Concepts
  • What is DML?
  • What is T-SQL?

Module 2: Creating Database Objects

  • What are Data Types?
  • Choosing a Data Type
  • Creating Tables with T-SQL
  • Creating Views with T-SQL
  • What are Stored Procedures and Functions?
  • Creating a Stored Procedure
  • Creating a Function

Module 3: Data Manipulation

  • Single Table Extracts
  • Joining Tables
  • Join Types
  • Union, Intersect, Except
  • Insert, Update, Delete

Module 4: Data Storage

  • Normalisation
  • Referential Integrity
  • Indexes

Module 5: Administer a Database

  • Database Security Concepts
  • Database Backup Types
  • Database Backup and Restore
  • Would you like to discuss your training requirements with me?

    I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.