array(3) {
  ["banner_text"]=>
  string(305) "
Want to get to grip with apprenticeships? Download the latest free whitepaper and playbook here.

"
  ["background_colour"]=>
  string(7) "#19072d"
  ["link_colour"]=>
  string(7) "#f7eefd"
}

Want to get to grip with apprenticeships? Download the latest free whitepaper and playbook here.

DIGITAL, DATA AND IT PROFESSIONAL QUALIFICATION

Database Fundamentals

This Database Fundamentals course allows learners to gain an understanding of core database concepts, how to administer a database and create database objects. You will also understand the importance of efficient data storage and how to manipulate data. 

This self-directed course is for anyone interested in learning core database concepts. Taking this course is a great opportunity to develop key database management skills and progress your career  

Each chapter includes detailed content, a glossary of terms, interactive videos, quizzes, exercises and flashcards which help you to understand the topics easier and progress through the course with ease, at your own pace.  

Lab features:

  • Provide hands-on experience in a safe, online environment
  • Labs simulate real world, hardware, software & CLI environment
  • Flexible alternative to physical Labs
Enquire

At a glance

Professional Qualification

Type

Professional Qualification

Standard

Database Fundamentals

Format/Modality

Virtual delivery

Duration

12 months access, 40 – 60 hours of learning

Nationwide

Geography

Nationwide

Cost

£400

Add to cart accept
Add to cart
banner

LEARNING TOPICS

Learning journey overview

  • This course begins with a pre-assessment. It will identify how much you know about a topic and any possible areas of improvement before you start learning.

  • Gain an understanding of core data concepts and how data is stored
  • Understand Data Manipulation Language (DML) and Data Definition Language (DDL)

  • Learn how to choose data types, create tables, stored procedures, and functions

  • To understand how to manipulate data, you’ll learn about transaction controls as well as how to select, insert, update and delete data correctly

  • You'll build on your knowledge and cover Primary, Foreign and ComposIte keys

  • Gain an understanding of database backups and security concepts

  • After completion of the course, you’ll have a short Post-Assessment to measure your achievement

Course includes

  • 300+ 'How To' videos to help you complete lab tasks
  • 50 quizzes to test your knowledge
  • 76 flashcards to support your retention of key definitions and terminology

Learning outcomes

For Employers

This course can help data professionals at any level to understand or refresh their knowledge of basic but important data concepts. On completion, employees will understand how to store, manage, reports and secure data. These skills are an asset to any business that relies on data in any capacity.

For Learners

On completion of this course, you’ll be confident in the management, reporting and basic functions and keys relating to data. This course offers you the chance to digest the content in multiple ways, ensuring you can understand the topics and apply your new skills when handling

digital data and it
Ready to improve your data skills? Purchase this course

Related products

You might also like these

CompTIA Network+

This CompTIA Network+ N10-007 course and lab allows learners to gain hands-on experience to pass the CompTIA Network+ exam. in a safe, online environment. . This CompTIA Network+ N10-007 course and lab allows learners to gain hands-on experience to pass the CompTIA Network+ exam. in a safe, online environment. ... Read More Read Less

  • <p>Virtual delivery</p> Virtual delivery
  • <p>12 months access, 40 – 80 hours of learning</p> 12 months access, 40 – 80 hours of learning
  • Nationwide Nationwide
Learn more
SQL for Data Analytics

This SQL course and lab will teach everything from the basics of SQL for Analytics to SQL for Data preparation, aggregate functions for Data analysis, importing and exporting data; analytics using complex data types, and more.. This SQL course and lab will teach everything from the basics of SQL for Analytics to SQL for Data preparation, aggregate functions for Data analysis, importing and exporting data; analytics using complex data types, and more.... Read More Read Less

  • <p>Virtual delivery</p> Virtual delivery
  • <p>12 months access, 40 – 60 hours of learning</p> 12 months access, 40 – 60 hours of learning
  • Nationwide Nationwide
Learn more
Microsoft Project 2021

Learn how to effectively manage your projects through the basics of Microsoft Project capabilities. . Learn how to effectively manage your projects through the basics of Microsoft Project capabilities. ... Read More Read Less

  • <p>Virtual delivery</p> Virtual delivery
  • <p>12 months access, 60 – 120 hours of learning</p> 12 months access, 60 – 120 hours of learning
  • Nationwide Nationwide
Learn more
AWS Certified Cloud Practitioner

Prepare for the AWS CLF-C01 exam with the AWS Cloud Practitioner course. This AWS Cloud Practitioner training course covers the CLF-C01 exam objectives and helps you master the skills required to describe and position the core AWS services, explain the value of the AWS Cloud, and identify AWS services for common use cases.. Prepare for the AWS CLF-C01 exam with the AWS Cloud Practitioner course. This AWS Cloud Practitioner training course covers the CLF-C01 exam objectives and helps you master the skills required to describe and position the core AWS services, explain the value of the AWS Cloud, and identify AWS services for common use cases.... Read More Read Less

  • <p>Virtual delivery</p> Virtual delivery
  • <p>12 months access, 20 – 40 hours of learning</p> 12 months access, 20 – 40 hours of learning
  • Nationwide Nationwide
Learn more

Explore our full programme offering. View all programmes