DVANA
Menu

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.

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!

Course

MBT: Databases

Book Now

Class Size

To give you the best learning outcome, we try to limit classes as follows:

  • Min: 4
  • Max: 12

When a class is too large, we split it into two smaller classes. This maximizes your learning, with your co-workers and colleagues.

Equipment

We make the general assumption that you’ll provide your own computer, laptop etc.

If you need to use one of our computers, please mention it when you book, as there is a nominal extra charge.

We supply everything else, including high quality printed materials.

Duration

This is a full two day course. Delivered either on your site or at an off-site location.

Typically, we start at about 09:30 and work through the day until finished.

Adequate time is allowed for breaks, lunch, questions and individual tuition.


Please feel free to share this around your social networks.

Need a special course? Contact us.

We have a wide range of ready-made courses. However, if you need something extra, we are happy to devise a course that meets your needs, contact us today.