Microsoft MTA Database Fundamentals - Just 2 Days

Why

What do our customers say?

"This is my 4th time at firebrand the training is EXCELLENT! Staff are always very helpful, training is very educational and informative. The courses can be very challenging but the rewards are worth it in the end!"
Harry Holdstock, Key Intelligence - Microsoft MTA Database Fundamentals (2 days), 6/10/2016 to 7/10/2016

Four reasons why you should sit your MTA Database Fundamentals course with Firebrand Training

Find Out How We Help You To Learn New Skills Quickly

  1. You'll be MTA Database Fundamentals trained and certified faster. Learn more on this 2-day accelerated course. You'll get at least 12 hours a day of quality learning time in a distraction-free environment
  2. Your MTA Database Fundamentals course is all-inclusive. One simple price covers all course materials, exams, accommodation and meals – so you can focus on learning
  3. Pass MTA Database Fundamentals first time or train again for free. Your expert instructor will deliver our unique accelerated learning methods, allowing you to learn faster and be in the best possible position to pass first time. In the unlikely event that you don't, it's covered by your Certification Guarantee
  4. Study MTA Database Fundamentals with an award-winning training provider. We've won the Learning and Performance Institute's "Training Company of the Year" three times. Firebrand is your fastest way to learn, with 68.075 students saving more than one million hours since 2001

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

What

Årets Microsoft Learning Partner

Use your free Microsoft training vouchers

You may be entitled to heavily-discounted training via Microsoft's Software Assurance Training Voucher (SATV) scheme. If your business has bought Microsoft software, check to see if it came bundled with free training vouchers! Vouchers can be exchanged against training for all Microsoft technologies. If you’re unsure, get in touch with us

Learn how to create, manipulate and administer a database on this Microsoft MTA Database Fundamentals course. You’ll learn the basics of relational databases, data security concepts and how to implement T-SQL.

After completing this course, you’ll be able to:

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

Read more ...

Interested? See prices or call 78 79 16 53

Read more ...

Interested? See prices or call 78 79 16 53

Module 1: Understanding Core Database Concepts

  • Understand how data is stored in tables
  • Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established
  • Work with the data manipulation language (DML)
  • Study data definition language (DDL)
  • Utilise T-SQL to create database objects, such as tables and views

Module 2: Creating Database Objects

  • Learn what data types are, why they are important and how they affect storage requirements
  • Understand and create tables
  • How to create and use views by using T-SQL or a graphical designer
  • Create stored procedures and functions

Module 3: Manipulating Data

  • Utilise SELECT queries to extract data from one table, extract data by using joins, combine result sets by using UNION and INTERSECT
  • Understand how data is inserted into a database, how to use INSERT statements
  • Update data in a database and learn how to write the updated data to the database by using the appropriate UPDATE statements, update by using a table
  • Delete data from single or multiple tables, ensure data and referential integrity by using transactions

Module 4: Understanding Data Storage

  • Understand the reasons for normalisation, the five most common levels of normalisation, how to normalise a database to third normal form
  • Choose appropriate primary keys, select appropriate data type for keys, select appropriate fields for composite keys and understand the relationship between foreign and primary keys
  • Learn the purpose of clustered and non-clustered indexes in a database

Module 5: Administering a Database

  • Learn database security concepts
  • How to secure a database: what objects can be secured, what objects should be secured, user accounts and roles
  • How to implement various backup types, such as full and incremental

Read more ...

Interested? See prices or call 78 79 16 53

You'll sit the following exam at the Firebrand Training Centre, covered by your certification guarantee:

  • Microsoft Exam 98-364: Database Fundamentals

Read more ...

Interested? See prices or call 78 79 16 53

Microsoft Official Courseware:

  • MOC 40364: Database Administration Fundamentals

Firebrand Training offers top-quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their studies and certification goals.

Our Accelerated Learning Programmes include:

  • Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery
  • Comprehensive Study Materials, Program Courseware and Self-Testing Software including MeasureUp *
  • Fully instructor-led program with 24 hour lab access
  • Examination vouchers **
  • On site testing ***
  • Accommodation, all meals, unlimited beverages, snacks and tea / coffee****
  • Transportation to/from designated local railway stations
  • Examination Passing Policy

Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.

Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.

Firebrand goes digital

We’re currently migrating from printed to digital courseware. Some courseware is already available in digital, while other books remain in printed form. To find out if this course is digital, call us on 78 79 16 53.

There are several benefits of easy-to-use digital courseware: downloads are immediate, and you’ll always have your courseware available wherever you are. You won’t need to wait for a printed book to be delivered before you start learning – and it’s better for the environment. You can choose to download the courseware to your own device, or borrow one of ours.

Considering a Microsoft course? Always have the most up-to-date Microsoft digital courseware with ‘Fresh Editions’. This gives you access to all versions of digital courseware – you’ll receive updates and revisions of your textbook, at no charge, for the life of that course.

Examination Passing Policy

Should a student complete a Firebrand Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year.  Students will only be responsible for accommodations and vendor exam fees.

Please note

  • * Not on all courses
  • ** Examination vouchers are not included for the following courses: PMI, GIAC and CISSP CBK Review. Exam vouchers may also not be included for Apprentices and will require a separate purchase by an employer due to Education and Skills Funding Agency guidelines.
  • *** On site testing is not included for our PMI, GIAC, CREST, CSX Practitioner or ITIL Managers and Revision Certification Courses
  • **** Accommodation not included on the CISSP CBK Review Seminar

Read more ...

Interested? See prices or call 78 79 16 53

There are no prerequisites for this entry-level course.

Are you ready to get certified in record time?

We interview all applicants for the course on their technical background, degrees and certifications held, and general suitability. If you get through this screening process, it means you stand a great chance of passing.

Firebrand Training is an immersive training environment. You must be committed to the course. The above prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through Firebrand Training.

If you have any doubts as to whether you meet the pre-requisites please call 78 79 16 53 and speak to one of our enrolment consultants, who can help you with a training plan.

Interested? See prices or call 78 79 16 53

When

When do you want to sit your accelerated course?

Start

Finish

Status

Book now

Limited availability

Book now

Open

Book now

Open

Book now

Reviews

We've currently trained 68.075 students in 12 years. We asked them all to review our Accelerated Learning. Currently,
96,69% have said Firebrand exceeded their expectations:

"I recommend Firabrand Training to anyone who wants to extend their knowledge on any of the courses that they teach because it is fast track and it is well organised."
David Coleto, CityWest Homes. - Microsoft MTA Database Fundamentals (2 days) (11/6/2018 to 12/6/2018)

"The trainer was excellent, as he was very informative, friendly and patient. I do wish that there was more time for the course, because I found it difficult to process such a vast amount of information, in such a short space of time."
Anonymous - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"The instructor was a very interactive and enjoyable tutor. His vast knowledge was clear and he explained everything in great detail."
J.H., Lloyds Banking Group. - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"At the beginning of the course, I had very little knowledge but feel as though I have learn a lot in a short space of time."
Anonymous - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"Great teacher"
A.N., Lloyds banking group . - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"At the beginning of the course, I had very little knowledge but feel as though I have learnt a lot in a short space of time."
Anonymous - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"Great course and tutor who was very enthusiastic and helpful."
Anonymous - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"The course felt very well paced and was structured in a way that didn't feel like an overload of information all at once. The instructor was very helpful and willing to go through a topic multiple times to ensure you understand it fully. "
B.M., Cambridgeshire Fire & Rescue. - Microsoft MTA Database Fundamentals (2 days) (16/12/2017 to 17/12/2017)

"Very useful, very intense, Plenty of information to take in but it was all useful and will be practical for when i take it back to work. Only positives to say really."
Aman Kumar, DMS. - Microsoft MTA Database Fundamentals (2 days) (20/3/2017 to 21/3/2017)

"This is my 4th time at firebrand the training is EXCELLENT! Staff are always very helpful, training is very educational and informative. The courses can be very challenging but the rewards are worth it in the end!"
Harry Holdstock, Key Intelligence. - Microsoft MTA Database Fundamentals (2 days) (6/10/2016 to 7/10/2016)

"Very thorough, intense training. Excellent teaching. Amazing facilities."
T.B, Microtech Electronics. - Microsoft MTA Database Fundamentals (2 days) (6/10/2016 to 7/10/2016)

"I recommend Firabrand Training to anyone who wants to extend their knowledge on any of the courses that they teach because it is fast track and it is well organised."
David Coleto, CityWest Homes. - Microsoft MTA Database Fundamentals (2 days) (11/6/2018 to 12/6/2018)

"The trainer was excellent, as he was very informative, friendly and patient. I do wish that there was more time for the course, because I found it difficult to process such a vast amount of information, in such a short space of time."
Anonymous - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"The instructor was a very interactive and enjoyable tutor. His vast knowledge was clear and he explained everything in great detail."
J.H., Lloyds Banking Group. - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"At the beginning of the course, I had very little knowledge but feel as though I have learn a lot in a short space of time."
Anonymous - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"Great teacher"
A.N., Lloyds banking group . - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"At the beginning of the course, I had very little knowledge but feel as though I have learnt a lot in a short space of time."
Anonymous - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"Great course and tutor who was very enthusiastic and helpful."
Anonymous - Microsoft MTA Database Fundamentals (2 days) (8/3/2018 to 9/3/2018)

"The course felt very well paced and was structured in a way that didn't feel like an overload of information all at once. The instructor was very helpful and willing to go through a topic multiple times to ensure you understand it fully. "
B.M., Cambridgeshire Fire & Rescue. - Microsoft MTA Database Fundamentals (2 days) (16/12/2017 to 17/12/2017)

"Very useful, very intense, Plenty of information to take in but it was all useful and will be practical for when i take it back to work. Only positives to say really."
Aman Kumar, DMS. - Microsoft MTA Database Fundamentals (2 days) (20/3/2017 to 21/3/2017)

"This is my 4th time at firebrand the training is EXCELLENT! Staff are always very helpful, training is very educational and informative. The courses can be very challenging but the rewards are worth it in the end!"
Harry Holdstock, Key Intelligence. - Microsoft MTA Database Fundamentals (2 days) (6/10/2016 to 7/10/2016)

"Very thorough, intense training. Excellent teaching. Amazing facilities."
T.B, Microtech Electronics. - Microsoft MTA Database Fundamentals (2 days) (6/10/2016 to 7/10/2016)

"Have learned so much on this course, looking forward to putting it all into practice!"
Anonymous - Microsoft Dynamics AX 2012 R3 Trade & Logistics (5 days) (27/6/2016 to 1/7/2016)

"We had a perfect trainer who answered every question we had, and explained more we ever expected. He was available for us at all times for any questions we had outside of regular classes. I got deep insight into the product which is what I came to the course for. We got hands-on experience in the labs and excellent explanations of the technical background. The instructor is highly motivated and speaks with the experience of a senior consultant with many years of experience. The course was never boring despite the long hours and the difficult subject matters. We got the real thing and no "death by Powerpoint" "
Marco Marzorati, ISS World Services A/S. - Microsoft MCSE: Communication (Skype for Business) (6 days) (30/5/2016 to 4/6/2016)

"You know you are in the right place, when your instructor on the first evening of training, during the intro to the course says, "PowerShell is not for wimps! It is a mans tool!". 10/10 - would Firebrand again :D"
Kasper Kaas Hansen, ALSO A/S. - Microsoft Implementing Microsoft Azure Infrastructure Solutions (3 days) (23/5/2016 to 29/5/2016)

"I learned a lot, this course helped me understand all the fundamentals of web development"
Anonymous - Microsoft Programming in HTML5 with JavaScript and CSS3 (3 days) (16/5/2016 to 18/5/2016)

"Enjoyed the environment - Firebrand provide correct atmosphere and tools to allow candidate to disconnect from everything and just focus on their studies."
F.A.. - Microsoft Dynamics AX 2012 Development - Advanced (4 days) (26/5/2016 to 29/5/2016)

"Very intensive training and you will have to come with an open and clear mind, to be able to handle a 7 days course with Firebrand. If you are able to do that, you will get much more from this course, that any other course possible can give you!"
Martin G Rasmussen, EG A/S. - Microsoft MCSD: Azure Solutions Architect (9 days) (23/5/2016 to 29/5/2016)

"The facility is perfectly adequate for this type of course, in that everything one needs is provided. The course instructor was very knowledgeable and was able to spend quite a lot of time explaining each subject."
Anonymous - Microsoft Dynamics AX 2012 Development - Introduction (4 days) (22/5/2016 to 25/5/2016)

"Very intense course. Definitely more than I expected from Introduction course. "
Lucas Bertek, TempurSealy. - Microsoft Dynamics AX 2012 Development - Introduction (4 days) (22/5/2016 to 25/5/2016)

"Overall good, knowledgeable tutor, broad coverage."
Anonymous - Microsoft Dynamics NAV 2016 Developer (6 days) (9/5/2016 to 14/5/2016)

"Learned a lot of new information regarding Dynamics NAV in a fantastic environment. The tutor is very knowledgeable and made learning interesting and fun. The location of the course at Sundsgårdens is great and the food and drink provided was first rate!"
Simon Thompson, R. H. Smith & Sons. - Microsoft Dynamics NAV 2016 Developer (6 days) (9/5/2016 to 14/5/2016)

"Very intense course, but being away from distractions allows you to get the most from it. "
Anonymous, Bluerock Systems Ltd - Microsoft Dynamics NAV 2016 Developer (6 days) (9/5/2016 to 14/5/2016)

"Instructor was very good. Explained the course well and went at a good pace for a course lasted 3.5 days."
Anonymous - Microsoft MCTS System Center 2012 Configuration Manager (4 days) (3/5/2016 to 5/5/2016)

"Feels like I have jacked into the Matrix and downloaded a new skillset. Was hard work, but I have learnt so much!"
Jimmie Eriksson, FordonsData Nordic AB. - Microsoft MCTS System Center 2012 Configuration Manager (4 days) (3/5/2016 to 5/5/2016)

"Firebrand has given you a skipping board to learn and start using the skills. Lots to learn and qould say a good start."
Vinod Nagdev. - Microsoft Dynamics AX 2012 R3 Trade & Logistics (5 days) (18/4/2016 to 22/4/2016)

"Intensive! But you learn a lot!"
Alfez Mannan, Acando. - Microsoft Dynamics AX 2012 R3 Trade & Logistics (5 days) (18/4/2016 to 22/4/2016)

"I would fully recommend Firebrand, to accelerate your IT skills. The training, provided by an expert in the field, offers practical advice for real world scenarios throughout. The course material is thorough, and the labs fully tested and easy to follow."
A.F., Freelance. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (9/4/2016 to 17/4/2016)

"A brilliant accelerated course which taught all the main aspects of the certification. A very good comfortable venue as well."
Sagar Hussain, IPU Limited. - Microsoft Dynamics AX 2012 Installation & Configuration (3 days) (30/3/2016 to 1/4/2016)

"Great course. You manage to basically cover everything in a short period of time. Saves allot of time. For other students it is advised to have some level (e.g.100/200) of knowledge / experience of CRM (Online) to be able to follow everything. This has definitely helped me in understanding everything and not falling behind."
Hubert Berger, Microsoft. - Microsoft Dynamics CRM 2015 (8 days) (13/3/2016 to 20/3/2016)

"All is arranged for you to only concentrate on the course to follow. From transport housing, venue facilities, meals and drinks during the whole day. The trainer is a highly business experienced expert that guides you through all aspects you need to know to both pass your exam(s) and give you best practices or what-not-to-do."
Jolanda Verwoert. - Microsoft Dynamics CRM Online 2015 (7 days) (14/3/2016 to 20/3/2016)

"Amazing experience. Cant believe how much was packed into such a short time. I cant imagine a better way to learn."
S.K.. - Microsoft Dynamics CRM Online 2015 (7 days) (14/3/2016 to 20/3/2016)

"Overall the course was well organized and our very experienced Instructor provided a lot of extra business process insights. "
Volker Schwarz, DEDON GmbH. - Microsoft Dynamics NAV 2016 Financials (5 days) (14/3/2016 to 19/3/2016)

"Great Instructor!"
Anonymous - Microsoft Dynamics NAV 2016 Financials (5 days) (14/3/2016 to 19/3/2016)

"Very detailed. It answered all my questions."
Derek Dongray, European Metal Recycling Ltd. - Microsoft Dynamics AX 2012 Development - Advanced (4 days) (10/3/2016 to 13/3/2016)

"Excellent course... Worked at a very fast pace, covering a lot of information. Excellent facilities and excellent tuition."
Miles Griffiths, EMR Group. - Microsoft Dynamics AX 2009 Advanced Developer (4 days) (10/3/2016 to 13/3/2016)

"Really good and intensive Course - learnt a lot in a short amount of time"
Jamie Robinson, Intelisense IT. - Microsoft Dynamics AX 2012 Manufacturing, Production & Logistics (6 days) (7/3/2016 to 12/3/2016)

"The course was in a lot a detail. I learnt a lot in a short apace of time."
Jake Huebner, Intelisense IT. - Microsoft Dynamics AX 2012 Manufacturing, Production & Logistics (6 days) (7/3/2016 to 12/3/2016)

"The course is intense and focused to give you all you need to know as quickly as possible."
Derek Dongray, European Metal Recycling Ltd. - Microsoft Dynamics AX 2012 Development - Introduction (4 days) (6/3/2016 to 9/3/2016)

"The course was intense, but also very enjoyable. The level of tuition was of a very high standard, and the location and facilities are excellent."
Miles Griffiths, EMR Group. - Microsoft Dynamics AX 2012 Development - Introduction (4 days) (6/3/2016 to 9/3/2016)

See prices