About this course
This course of study introduces students to basic relational database concepts. The course teaches students relational database terminology, as well as data modeling concepts, building Entity Relationship Diagrams (ERDs), and mapping ERDs. Oracle SQL Developer Data Modeler is utilized to build ERDs and The Structured Query Language (SQL) is used to interact with a relational database and manipulate data within the database. Oracle Application Express is used utilized to provide practical, hands-on, engaging activities. Leveraging project-based learning techniques, students will create and work with projects which challenge them to design, implement, and demonstrate a database solution for a business or organization.
Curriculum
Module 1: Selecting columns (10 Hours)
Onboarding | Tables Onboarding | Query Result Onboarding | Errors Onboarding | Bullet Exercises SELECTing single columns SELECTing multiple columns SELECT DISTINCT Learning to COUNT Practice with COUNT Module 2: Filtering rows (10 Hours)
Filtering results Simple filtering of numeric values Simple filtering of text WHERE AND WHERE AND OR BETWEEN Introduction to NULL and IS NULL LIKE and NOT LIKE Module 3: Aggregate Functions (10 Hours)
Aggregate functions Combining aggregate functions with WHERE A note on arithmetic It's AS simple AS aliasing Even more aliasing Module 4: Sorting, grouping and joins (10 Hours)
ORDER BY Sorting single columns Sorting multiple columns GROUP BY HAVING a great time All together now A taste of things to come
Reviews
03-05-2024
03-11-2024
03-12-2024
03-18-2024
03-19-2024
03-24-2024
03-31-2024
04-02-2024
04-02-2024
04-07-2024
04-07-2024
04-12-2024
04-12-2024
04-12-2024
04-12-2024
04-12-2024
04-12-2024
04-12-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-13-2024
04-14-2024
04-14-2024
04-14-2024
04-14-2024
04-14-2024
04-14-2024
04-14-2024
04-14-2024
04-14-2024
04-14-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-15-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-16-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-17-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-18-2024
04-19-2024
04-19-2024
04-19-2024
04-19-2024
04-19-2024
04-19-2024
04-19-2024
04-19-2024
04-19-2024
04-19-2024
04-19-2024
04-20-2024
04-20-2024
04-20-2024
04-20-2024
04-20-2024
04-20-2024
04-20-2024
04-21-2024
04-21-2024
04-21-2024
04-21-2024
04-21-2024
04-21-2024
04-21-2024
04-21-2024
04-21-2024
04-21-2024
04-21-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-22-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-23-2024
04-24-2024
04-24-2024
04-24-2024
04-24-2024
04-24-2024
04-24-2024
04-24-2024
04-24-2024
04-24-2024
04-24-2024
06-27-2024
06-30-2024
06-30-2024
06-30-2024
06-30-2024
07-01-2024
07-01-2024
07-02-2024
07-03-2024
07-03-2024
07-03-2024
07-03-2024
07-03-2024
07-06-2024
07-07-2024
07-08-2024
07-08-2024
07-09-2024
07-10-2024
07-10-2024
07-12-2024
07-12-2024
07-12-2024
07-12-2024
07-12-2024
07-13-2024
07-14-2024
07-15-2024
07-15-2024
07-16-2024
07-16-2024
07-21-2024
07-21-2024
07-21-2024
07-22-2024
07-22-2024
07-23-2024
07-25-2024
07-25-2024
07-25-2024
07-25-2024
07-25-2024
07-26-2024
07-27-2024
07-28-2024
07-28-2024
07-28-2024
07-28-2024
07-31-2024
08-02-2024
08-03-2024
08-03-2024
08-04-2024
08-04-2024
08-04-2024
08-04-2024
08-04-2024
08-06-2024
08-07-2024
08-07-2024
08-07-2024
08-09-2024
08-09-2024
11-13-2024
Prerequisites
There are no prerequisites for this course; however, some prior programming language knowledge is helpful.
semaglutide tablet