CBT IT Certification Training

Unlimited IT Certification Courses via Streaming Video

Login to this site requires ssl communication.
Click here to reload the page over ssl.

  • Lost your password?

  • Back to login
Loading
Login to this site requires ssl communication.
Click here to reload the page over ssl.

  • Lost your password?

  • Back to login
Loading
  • Home
  • New Courses
        • Cisco
          • Cisco CCNA Primer
          • Cisco CCNA
  • Courses
        • Amazon
          • AWS Certified Solutions Architect – Associate
          • Amazon AWS SysOps – Associate
        • Career
        • Cisco
        • NetApp
        • CompTIA
        • ITIL
        • Juniper
        • Custom menu
          • custom menu 1
          • custom menu 2
          • Custom menu 3
          • custom menu 4
        • Linux
        • Microsoft
          • Security Fundamentals
          • Windows OS
          • Windows Server
          • Microsoft MCSA – Windows Server 2012
          • Microsoft MTA – Database Administration Fundamentals
          • Microsoft MCSA – Administering Windows Server 2012
          • Microsoft MCSA Configuring Advanced Windows Server 2012 Services
        • TCP-IP
        • Wireshark
        • VMware
        • Web Development
  • Racks
    • vRack
    • Live Cisco Racks
  • Tour
  • Join
  • Join
  • Free Training
  • Meet the Trainers
  • Help
    • Helpdesk
    • FAQ
    • Contact Us
    • Privacy
  • Products
    • Books
    • Audiobooks
  • Login
  • Members
    • Account
    • Exams
    • Forum
    • Live Cisco Rack Training
    • Members Training
    • Member Bonuses
    • My Courses
  • Home
  • New Courses
        • Cisco
          • Cisco CCNA Primer
          • Cisco CCNA
  • Courses
        • Amazon
          • AWS Certified Solutions Architect – Associate
          • Amazon AWS SysOps – Associate
        • Career
        • Cisco
        • NetApp
        • CompTIA
        • ITIL
        • Juniper
        • Custom menu
          • custom menu 1
          • custom menu 2
          • Custom menu 3
          • custom menu 4
        • Linux
        • Microsoft
          • Security Fundamentals
          • Windows OS
          • Windows Server
          • Microsoft MCSA – Windows Server 2012
          • Microsoft MTA – Database Administration Fundamentals
          • Microsoft MCSA – Administering Windows Server 2012
          • Microsoft MCSA Configuring Advanced Windows Server 2012 Services
        • TCP-IP
        • Wireshark
        • VMware
        • Web Development
  • Racks
    • vRack
    • Live Cisco Racks
  • Tour
  • Join
  • Join
  • Free Training
  • Meet the Trainers
  • Help
    • Helpdesk
    • FAQ
    • Contact Us
    • Privacy
  • Products
    • Books
    • Audiobooks
  • Login
  • Members
    • Account
    • Exams
    • Forum
    • Live Cisco Rack Training
    • Members Training
    • Member Bonuses
    • My Courses

Microsoft MTA – Database Administration Fundamentals

Video training course for the 98-364 Microsoft Technology Associate Database Administration Fundamentals exam. The perfect course for anyone interested in building a career in data platform administration or business intelligence. There is a heavy emphasis on SQL in this course but no previous knowledge is assumed. The course is based upon Microsoft SQL Server 2008 R2.

By the end of the course, you will be able to:

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

Your Instructor

Lawrence ‘Toby’ Rose 
Is a graduate of the University of London, and has a background in project management, software development and user training. He is a Microsoft Certified Professional with extensive experience across the whole of the Microsoft Office product set and with many Adobe products.Lawrence has worked in several countries and is a keen traveler.

  • 7 hours of video training
  • Instructor set examples throughout
  • End-of-course exams
  • End-of-course certificate
  • Captions available
  • Access to members only forum
  • Exam vendor – Certiport or Prometric
  • Prerequisites – None
  • Recommended – None
Module 1 Course Introduction and Exam Information
Unit 1 Welcome to the Course
Module 2 Understanding Core Database Concepts
Unit 1 Understand How Data is stored in Tables
Unit 2 Understand Relational Database Concepts
Unit 3 Understand Data Manipulation Language (DML)
Unit 4 Understand Data Definition Language (DDL)
Module 3 Creating Database Objects
Unit 1 Choose Data Types - Part 1
Unit 2 Choose Data Types - Part 2
Unit 3 Understand Tables and How to Create Them
Unit 4 Create Views
Unit 5 Create Stored Procedures and Functions
Module 4 Manipulating Data
Unit 1 Select Data - Part 1
Unit 2 Select Data - Part 2
Unit 3 Insert and Update Data
Unit 4 Delete Data
Module 5 Understanding Data Storage
Unit 1 Understand Normalization
Unit 2 Understand Primary, Foreign and Composite Keys
Unit 3 Understand Indexes
Module 6 Administering a Database
Unit 1 Understand Database Security Concepts
Unit 2 Understand Database Backups and Restore
Module 7 Bonus Exams
Unit 1 Bonus Exam 1
Unit 2 Bonus Exam 2

About Us

This site has been created to help you make the best out of your IT career. Whether you are trying to get your first job, get promoted, or start your own IT business, we have a course for you.

Most Popular

Cisco ICND1 Wireshark WCNA NetApp NCSA CompTIA Network+ VMware VCA-DCV Microsoft MTA OS Fundamentals

Members

  • Account
  • Forum
  • Live Cisco Rack Training
  • Members Training
  • Member Bonuses
  • My Courses

Newsletter

Free IT Webinar Training

Secure Site

website security

Copyright 2016 Reality Press Ltd . / Paul Browning