Course
|
SQL

Understanding SQL Databases

Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
12 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Understand the value of SQL
Understand the need for arranging data in separate tables
Understand data relationships
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
SQL

Understanding SQL Databases

Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
12 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Understand the value of SQL
Understand the need for arranging data in separate tables
Understand data relationships
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

12 Lessons
Understanding the Value of SQL
3 MINS
LESSON
Understanding the Value of SQL
Exercise

This lesson introduces SQL as a useful tool for anyone who regularly works with data.

Demonstrating an SQL Query
5 MINS
LESSON
Demonstrating an SQL Query
Exercise

In this lesson, we learn how SQL queries can be used to acquire useful insights.

Exploring the Uses of SQL
4 MINS
LESSON
Exploring the Uses of SQL
Exercise

Learn about the various types of SQL and how professionals use them.

Comparing Spreadsheets and Databases
4 MINS
LESSON
Comparing Spreadsheets and Databases
Exercise

Explore the basics of how data is stored in either a spreadsheet or a database.

Understanding Data Redundancy
4 MINS
LESSON
Understanding Data Redundancy
Exercise

Learn how redundancy can make our data inefficient.

Removing Redundant Data
5 MINS
LESSON
Removing Redundant Data
Exercise

Learn how splitting tables removes redundant data.

Establishing Simple Relationships
5 MINS
LESSON
Establishing Simple Relationships
Exercise

Learn how relationships are used to connect separate tables.

Understanding Many to Many Relationships
3 MINS
LESSON
Understanding Many to Many Relationships
Exercise

Learn how about how many to many relationships can be problematic.

Resolving Many to Many Relationships
3 MINS
LESSON
Resolving Many to Many Relationships
Exercise

Learn how to use junction tables to work around many to many relationships.

Querying a Database
4 MINS
LESSON
Querying a Database
Exercise

Learn about the mechanics of SQL queries.

Performing Basic SQL Queries
6 MINS
LESSON
Performing Basic SQL Queries
Exercise

Perform a basic SQL query that selects data from a databse.

Performing a Basic SQL Join
5 MINS
LESSON
Performing a Basic SQL Join
Exercise

Learn how to join two tables and to sort the output of a query.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo