Data Core Concepts (Online Courses)
Elevate your career trajectory with our premier online course, designed to sharpen your competitive edge. Explore our curated selection of top-tier digital programs to hone your skills and propel your professional journey forward. Experience transformative learning tailored to empower your career advancement in today's dynamic landscape.
Price on Request
Start Learning
This Course Includes
-
11 hours 30 minutesof self-paced video lessons -
11 Programscrafting your path to success -
Completion Certificateawarded on course completion
Architecture Concepts
Price on Request
1 hour 15 minutes
A database is used by organizations to store their data and to allow their employees to access, update, and manage it. Learn about databases, including types, users, characteristics, architectures, and database models.
Perks of Course
Certificate: Yes
CPD Points: 74
Compliance Standards: AICC
Components, Procedures, & Functions
Price on Request
1 hour
The Data Definition Language (DDL) is used to create databases and their components. Discover how to create databases, tables, views, and stored procedures using DDL.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Database Design
Price on Request
1 hour 15 minutes
A Database Management System, also known as a DBMS, is used to control, store, organize, and retrieve that data. Discover databases, DBMS, and RDBMS, and explore different database models.
Perks of Course
Certificate: Yes
CPD Points: 74
Compliance Standards: AICC
Database Security
Price on Request
45 minutes
A major concern for any database administrator is data security. Explore security considerations for SQL Server databases, how to assign permissions to database objects, and how to back up and restore databases.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC
DML & Multi-table Queries
Price on Request
1 hour 10 minutes
A relational database stores data in tables that store data in rows or tuples and columns or attributes. Explore how to use DML statements to query data and manipulate result sets.
Perks of Course
Certificate: Yes
CPD Points: 70
Compliance Standards: AICC
Normalization & Indexes
Price on Request
45 minutes
Data redundancy negatively affects storage, scalability, and responsiveness. Learn how to use database normalization and indexes in SQL Server to counter these negative effects.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC
Normalization Concepts
Price on Request
1 hour 25 minutes
Organizations use a Database Management System to manipulate, organize and retrieve data. Learn about these systems, their components, and Dr. Edgar Codd's rules for a database to be considered relational.
Perks of Course
Certificate: Yes
CPD Points: 83
Compliance Standards: AICC
Relational Algebra & Calculus
Price on Request
1 hour
Storing data is important, but it's equally important to be able to manipulate and analyze it using a query language like SQL. Explore relational algebra and calculus, developed by Dr. Edgar Codd for his theory for the relational database.
Perks of Course
Certificate: Yes
CPD Points: 62
Compliance Standards: AICC
SQL & Concurrency Concepts
Price on Request
1 hour 20 minutes
SQL is the main query language used by most DBMSs. Learn how to use SQL to manage data, how transactions and concurrency control ensure data integrity and consistency, and how security is implemented in a relational database.
Perks of Course
Certificate: Yes
CPD Points: 79
Compliance Standards: AICC
Working with Data
Price on Request
50 minutes
AngularJS lets you develop rich, robust, single-page web applications. Discover how to work with AngularJS application data in a client browser, offline detection and availability, and application caching.
Perks of Course
Certificate: Yes
CPD Points: 50
Compliance Standards: AICC
Working with Data
Price on Request
45 minutes
Discover how to update and delete data from a SQL Server database and how to use transactions to ensure data and referential integrity.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC