Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019

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