Master of Business Technology

Databases

Course Overview

This course is intended to provide a deeper understanding of the concepts and utilization of database technologies. The theory part will be broadly applicable across platforms, so will apply to databases running on Linux, Microsoft Windows and Apple Mac OSX, along with different database engines. The practical portion will be done with Microsoft Windows and Microsoft SQL Server.

You will benefit by having practical processes and procedures which will be applicable to your infrastructure and needs.

Database is more than storage…

Who is this course aimed at?

You will be the owner of a small to medium sized business, or someone who has been given the role of looking after the IT or computing for your business, but don’t have the knowledge you really need to make this a success.

What does the course offer me?

To give you a better understanding of databases as they applies to business. The ability to help you purchase more effectively, to liaise with external providers and to generally improve your understanding and delivery. It will also help you choose if an external provider will be suitable for your needs.

What do I take away?

The practical skills and knowledge necessary to design and maintain a database infrastructure and understand the trade-offs made in the process.

Course Outline

The following should give you a good idea as to what the course contains. This is a fast paced course with full days.

Chapter 1 - Database Design

  • Relationships
  • Normal forms
  • Indexing

Chapter 2 - Hardware & Performance

  • Physical machines
  • Virtual machines
  • Performance trade-offs

Chapter 3 - Setup & Configure

  • Database selection
  • User accounts
  • Post setup configuration

Chapter 4 - Management & Maintenance Practical

  • Backup & Restore
  • Regular maintenance tasks
  • Preventing corruption

Chapter 5 - Security

  • Input sanitization
  • User access security
  • System security

Chapter 6 - Queries

  • Structure & Design
  • Common pitfalls
  • Best practice

Chapter 7 - Optimization Practical

  • Using SQL Server Management Studio
  • Basic commands
  • Optimization tools

Throughout the course we will cover the jargon used in the industry and you will have a chance to use it in real world situations, as we discuss your unique questions.

You might know what you want to do, but you might not know how to ask for it. When you are finished, you will!