array(3) {
  ["banner_text"]=>
  string(336) "
Unlock the potential of your workforce with funded learning. Discover ‘Untapped to Unlimited’ and get the latest free resources here.

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

Unlock the potential of your workforce with funded learning. Discover ‘Untapped to Unlimited’ and get the latest free resources 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 Cyber Security Analyst

Gain the skills required to pass the CompTIA CySA+ certification exam with the CompTIA Cybersecurity Analyst (CySA+) course and lab. The lab is versatile and delivers a hands-on experience, replacing expensive physical labs. . Gain the skills required to pass the CompTIA CySA+ certification exam with the CompTIA Cybersecurity Analyst (CySA+) course and lab. The lab is versatile and delivers a hands-on experience, replacing expensive physical labs. ... 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
Power BI: Data Analysis Professional

Develop the confidence to explore, visualize and analyse data with Power BI. This course provides learners with the knowledge and skills required to complete basic and advanced complex tasks with self-service BI.. Develop the confidence to explore, visualize and analyse data with Power BI. This course provides learners with the knowledge and skills required to complete basic and advanced complex tasks with self-service BI.... 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
AWS Certified Machine Learning

Gain the skills required to pass the AWS ML specialty exam with the AWS Certified Machine Learning Study Guide: Specialty (MLS-C01) course and lab.. Gain the skills required to pass the AWS ML specialty exam with the AWS Certified Machine Learning Study Guide: Specialty (MLS-C01) course and lab.... 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