In this class, you’ll get an introduction to the types of table available in Oracle Database and their uses. We will be using Oracle DB for this course.
When creating columns you need to choose a data type for them. This class gives a rundown of the common data types and their uses.
Deciding where to store what is one of the fundamental decisions you make when building a database. This class gives an overview of the things you need to consider when designing your tables.
A chance to catch up on the material from module 1-3
A select statement returns you rows from your database. This class covers how to use this and filter the data with a where clause.
When fetching data, often you want to get related rows from two (or more) tables. To do that, you need a join. This class covers the join types in SQL Databases.
This class covers how you can summarize your data using aggregate functions and group by.
A chance to recap and catch up on the past three weeks covering select, joins and group by.
You'll create a final project which serves as your portfolio to show to potential employers.
|1||Level 1||Introduction to SQL graduates at this level will have knowledge and skills for initial work, community involvement and/or further learning.||Certificate I|