Database Fundamentals

Duration: 15 hours (5 lessons, 3 hrs/day)

Cost: $749 + GST

Grades 5 to 12 recommended.

Enrollment for additional Course or second kid - 10% discount

Course Content

• Part 1: Relational Database Fundamentals
• Identify database concepts, database models, and logical modeling.
• Identify entities, relationships, and the physical design of relational databases.
• Identify relational data structure principles, normalization, and index structures.
• Identify Databases, extended relational databases, implementation technologies, and database maintenance.
• Part 2: Introduction to SQL
• Identify what SQL is, why and where it is used.
• Identify how to retrieve data from a database.
• Identify how to order, limit, and group their query results using various SQL clauses, keywords, and operators.
• Identify how to use arithmetic operators, single row functions, and group functions to manipulate query data.
• Identify how to retrieve database information using subqueries and joins.
• Identify the guidelines for naming tables as well as the datatypes and constraints available for table creation.
• Identify how to create, alter, and delete database tables.
• Identify the data manipulation commands (INSERT, UPDATE, and DELETE) as well as the transaction control commands (COMMIT and ROLLBACK).
• Identify the general overview of views and indexes, including how to create these database elements.