98-364 Microsoft Database Fundamentals

3 Day Course  |  £1195.00 (+VAT)

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 Security

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.
Copyright © 2018 London SQL Server Training Courses @ SQL Training | Website Design From Scott Heron