Microsoft SQL Database Training

This Database Fundamentals course validates foundational knowledge of database concepts, management, and administration using Microsoft SQL Server, targeting beginners in data platform administration or business intelligence.

12889 learners enrolled

Skill level

Beginner, Intermediate

Hours to complete

Projects

Prerequisites

None

Your Guided Learning Pathway

In this 7 hour course your instructor will take you from beginner to intermediate level practitioner.

Step 1

Step 2

Step 3

Advanced Database Principles

While studying for the MTA Database Fundamentals certification, you’ll learn core database concepts, including how to create and manage database objects, manipulate data, and administer Microsoft SQL Server databases.

The course provides foundational data storage and retrieval skills, preparing you for database administration or business intelligence roles.

Manage a Database

After passing the MTA Database Fundamentals, you can manage and maintain SQL Server databases, ensuring efficient data storage, retrieval, and security for your company’s operations.

Your skills will support business intelligence initiatives by enabling accurate data manipulation and reporting, contributing to data-driven decision-making.

Get Exam Ready

This course not only prepares you to become a database administrator, but it also prepares you for the exam.

Read real-world case studies about database administration and practice exams.

Please note that Microsoft has retired this exam.

What it covers

This course prepares you for a database administrator in any organization.

Database Concepts
Creating Database Objects
Manipulating Data
Data Storage
Database Administration Fundamentals

Benefits of the certification

Getting certified in your chosen career path is essential, but passing the MTA Database exam gets you:

Entry-Level Database Credential
Validates SQL Server Knowledge
Enhances Career Opportunities
Builds Foundation for Advanced Certifications
Increases Professional Credibility
Demonstrates Data Management Skills
Supports Academic and Career Growth
Recognized by Employers

Target audience

This certification is ideal for:

Aspiring Database Administrators
Business Intelligence Professionals
IT Students
Entry-Level IT Professionals
Career Changers in Data Management

Prerequisites

While there are no mandatory prerequisites, Microsoft recommends having:

Basic IT Knowledge
Familiarity with Relational Databases
No Formal Certification Required
Basic Understanding of Microsoft SQL Server Recommended

Your Instructor

Lawrence Rose

He 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.

Curriculum

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

What’s in every How to Network membership?

Try Us Out Risk Free

We’re so confident that you will love our videos, labs and practice exams that we offer a 30-day 100% money back guarantee.

Choose your plan. Cancel anytime.

Access All Areas - Monthly

After a 7 day trial for $1

$29 Per month

Unlimited IT certification courses
Video lessons
Exam brain training drills and lessons
End-of-lesson exams
Instructor-led hands-on labs
End-of-course certificates
Forum supported by experts
Exam Prep PBQs - Value $297
Discounts on products and websites
Live Linux VMs 24/7
Live Cisco rack access 24/7
Cancel anytime

Best Value – Over 5 Months Free

Access All Areas - Yearly

5.1 months free! One Free book!

$199 Per year

Unlimited IT certification courses
Video lessons
Exam brain training drills and lessons
End-of-lesson exams
Instructor-led hands-on labs
End-of-course certificates
Forum supported by experts
Exam Prep PBQs - Value $297
Discounts on products and websites
Live Linux VMs 24/7
Live Cisco rack access 24/7
Cancel anytime

Access All Areas - Lifetime

One payment, no renewals. Three free books!

$497 Lifetime

Unlimited IT certification courses
Video lessons
Exam brain training drills and lessons
End-of-lesson exams
Instructor-led hands-on labs
End-of-course certificates
Forum supported by experts
Exam Prep PBQs - Value $297
Discounts on products and websites
Live Linux VMs 24/7
Live Cisco rack access 24/7
Cancel anytime

Recent Courses

cybersecurity vs information security illustrationweb

4.5

4.6K Students

Cisco CCNA Cybersecurity

Cisco CCNA Cybersecurity Operations Fundamentals v1.2 certification validates foundational cybersecurity skills for analyzing threats, monitoring security, and responding to incidents in a Security Operations Center (SOC).

Cisco, Beginner, Cybersecurity, Intermediate

4.6

3.8K Students

Microsoft Azure AI Fundamentals

The Microsoft Azure AI Fundamentals (AI-900) exam validates foundational knowledge of AI concepts, including machine learning, computer vision, NLP, and generative AI, and their application using Azure AI tools, preparing candidates for entry-level AI roles.

Microsoft, AI, Beginner

4.3

2.4K Students

CompTIA SecurityX

The CompTIA SecurityX [CAS-005] is an advanced-level cybersecurity certification for security infrastructure architects and experienced security engineers who are responsible for leading and improving an enterprise’s cybersecurity readiness.

CompTIA, Advanced, Cybersecurity, Intermediate

Reviews

I passed my Network+ using howtonetworks training videos, follow-along labs and practice exams. I highly recommend them if you want to pass first time.

Adam

CompTIA Network+ Certified

I was struggling to understand the materials but following the howtonetwork.com course really helped make it all clear to me. Highly recommended.

Ajlinda

Microsoft Azure Certified

I passed the Cisco CCNA, CCNA Security and CCNP exams in six months. Doing the hands-on labs really helped and of course the live Cisco racks are perfect!

Igor

Cisco CCNA & CCNP

I passed my Network+ on my first attempt. I'd been dreading it but I was more than ready come exam day. The practice exams and labs really helped me to understand everthing.

Kristy

CompTIA Network+

Frequently Asked Questions

If your questions isn’t answered here then please log a ticket and we’ll get right back to you.

What does the site teach me?

If you want to have a successful career in IT you need to be qualified. We help you prepare for your IT certification exams with video lectures, exams, case studies and lab exercises to follow along.

I'm a beginner. Where do I start?

We’ve set out a roadmap for you to follow. This is based on many years experience in the IT industry. It gives you a solid foundation and internationally recognized qualifications. From there you can choose to specialize.

What is included in the joining fee?

Everything! All courses, videos and exams. All future courses we add. No hidden extras and no catches. Check out the full list of courses here.

How much is it to join?

It’s $1 to join and then $20 per month thereafter. You can quit any time by logging into your account.

Is there a money back guarantee?

Yes. You have a full 30 days to try the site out. If you aren’t happy for any reason then please log a ticket and we will refund you. This applies if you haven’t completely finished your course.

Are my credit card details safe?

Absolutely. We don’t actually store any card details. All transactions take place via a fully PCI compliant card processing company.

How many courses can I take at once?

You can access one course at a time. We have this limit to prevent overwhelm. There are hundreds of hours of training here and most people take one certification at a time. If you need to study for a related course at the same time then please log a ticket.

Can I download the course videos?

Unfortunately not. But your videos all stream off super fast cloud servers on the cloud so are delivered locally to you.

Microsoft SQL Database Training

Your Guided Learning Pathway

Advanced Database Principles

Manage a Database