Insert, Update and Delete ReviewA final set of quizzes to check you've understood the material on insert, update, delete, and truncate. This class covers the differences between these operations and when you should use one or the other.
This module also covers the concept of a transaction: a single, logical unit of work.ĭelete and TruncateLearn how to remove data from your database using delete and truncate. Update and TransactionsMaster the basics of changing values in your tables with the update statement. And save and undo your changes with commit and rollback. Insert and CommitLearn how to use insert to loads data into your database tables. Select, Joins and Group By ReviewA chance to recap and catch up on modules 5-7 covering the basics of SQL queries: select, joins and group by. JoinsThis module teaches you about the different types SQL join: inner, left and right outer, full, and cross.Īggregates and Group ByThis class covers how you can summarize your data using aggregate functions and group by. And filter these data using a where clause. Select and WhereLearn how to use a select statement to get you rows from your database. Tables, Columns and Modeling ReviewA series of quizzes to recap the material from modules 1-3. This class gives an overview of the things you need to consider when designing your tables. This class you about the common SQL data types and their uses.ĭata ModelingDeciding where to store what is one of the fundamental decisions you make when building a database. The following statement creates a table with three columns.
The data type determines the values you can store in the column and the operations you can do on it. You can also add them to existing tables. You define these when you create a table.
TablesLearn about the types of table available in Oracle Database, their uses, and how to use create table.Ĭolumns and Data TypesWhen defining columns in a table, you need to choose a data type for them. A table in Oracle Database can have up to 1,000 columns.