SQL Course for Beginner

Learn to create an Oracle table using the syntax create table table_name (column data_type). Implement a two-column example with id integer and name varchar2(20) in a 19c pluggable database.

Master the alter table statement in sql to add, rename, modify, or drop columns, change data types, and rename tables with practical examples.

Learn how the update statement changes a record in a database, using a practical example to update an employee salary from 10000 to 20000 with a where condition.

Learn how to fetch a subset of records in Oracle SQL using the fetch clause, limit results, and select specific columns like name and email for efficient queries.

Learn how the order by clause sorts query results in SQL, with default ascending order and the option to specify descending order on any column.

Use the between clause in SQL to filter records within a range, such as salaries between 500 and 800 or years between 1988 and 2002, including select, delete, and update.

Learn how to filter data in sql using the in operator by listing multiple years in a where clause, turning lengthy conditions into a simple year list.

Learn how to use the sum aggregate function to total salaries in a table, optionally filter by country or gender, and compare results with the average.

Explore transaction control in Oracle database, mastering insert, update, and delete operations, and learning how commit makes changes permanent while rollback undoes uncommitted actions.