• ICT Database Essentials

The ICT Database Essentials course focuses on fundamentals of using relational databases. Students will learn about common database components including tables, record and field structures, and data types. They will learn about queries and how to create them. They will study data import/export mechanisms. They will learn the basics of Structured Query Language (SQL) statements for managing and manipulating data. Finally, they will use the skills they have learned to create basic database tables, data queries and data reports.

After completing the ICT Database Essentials course, students will be able to:

  • Describe the purpose and uses of relational databases, including databases vs. spreadsheets, advantages of databases, real-world uses, and "Big Data."
  • Identify database components and functions, including fields vs. records, basic data types, table vs. query, primary and foreign keys, table relationships, reports, Structured Query Language (SQL), and popular database applications.
  • Create a database table and organize data in it, including multiple data types in a table, adding records, deleting records, editing records and sorting records.
  • Manipulate and share data in a database, including troubleshooting errors, select queries, action queries, table joins, importing and exporting spreadsheet data, and creating reports.

Write a review

Please login or register to review

ICT Database Essentials

Related Products

ICT Computing Essentials

ICT Computing Essentials

The ICT Computing Essentials course focuses on fundamentals of computers and their functionality. St..

Please contact customer service for pricing.

ICT Cyber Security Essentials

ICT Cyber Security Essentials

The ICT Cyber Security Essentials course focuses on fundamentals of personal online security and s..

Please contact customer service for pricing.

ICT Programming & Logic Essentials

ICT Programming & Logic Essentials

The ICT Programming & Logic Essentials course focuses on fundamental programming concepts. Stu..

Please contact customer service for pricing.

ICT Communications Essentials

ICT Communications Essentials

The ICT Communications Essentials course focuses on fundamentals of effective communications in a ..

Please contact customer service for pricing.

ICT Word Processing Essentials

ICT Word Processing Essentials

The ICT Word Processing Essentials course focuses on the fundamentals of using common word-process..

Please contact customer service for pricing.

ICT Spreadsheet Essentials

ICT Spreadsheet Essentials

The ICT Spreadsheet Essentials course focuses on fundamentals of creating and using spreadsheets. ..

Please contact customer service for pricing.

ICT Web Design Essentials

ICT Web Design Essentials

The ICT Web Design Essentials course focuses on fundamentals of designing websites. Students will ..

Please contact customer service for pricing.

ICT Multimedia Essentials

ICT Multimedia Essentials

The ICT Multimedia Essentials course teaches students fundamental multimedia skills, including how..

Please contact customer service for pricing.

ICT Gaming Essentials

ICT Gaming Essentials

The ICT Gaming Essentials course focuses on fundamentals of interactive computer game creation. St..

Please contact customer service for pricing.

Tags: ICT, ICT Essentials, technology, digital literacy, database