Oracle Sql 2025 : Beginner to Sql Database Pro

Learn how to create tables in Oracle SQL using create table syntax, defining columns with integer and varchar data types and setting primary keys for students and teachers.

Insert values into the created students and teachers tables using the insert into table values syntax, detailing roll number or id, name, course, department, and age for each row.

Master the select command to display all values with select star from the students table and use distinct and unique to remove duplicates.

Learn to filter data with the where clause in SQL by selecting ages greater than 20 from the students table, showing values 25, 24, and 22.

Master and, or, and not conditions in sql queries on the students table to display names and courses when age is 20 and roll is 100, or exclude age 20.

learn to use the min and max aggregate functions in sql to find the smallest and largest ages in the students table by using select min(age) and select max(age).

Cover aggregate functions in SQL, including min, max, count, average, and sum, with practical examples counting ages, averaging roll numbers, and summing IDs.

Understand how the as keyword renames the mean of age to minimum age in a select query, using the from table and the student table as examples.

Learn how to use like and not like with percent wildcards (%) to filter names by starting or ending patterns, with practical examples from the student table.

Learn how primary keys ensure uniqueness, how foreign keys reference primary keys across tables, and how check and not null constraints enforce valid, non-null data in Oracle SQL.

Explore the group by command for aggregate functions such as min, max, count, avg, and sum, with syntax using select and from the student table grouped by name.

This lecture explains the having condition as an alternative to where for aggregate functions, showing group by name and filtering with min(age) > 20, with results ordered alphabetically.

Learn to use the union command to combine two select statements, such as selecting from students and from teachers, and note the statements must match to avoid an error.

Learn how inner join matches common values between student and teacher tables using the on condition, with examples of department-based results and the setup for left, right, and full joins.

Learn left and right joins in sql, where left join returns matches from left table and right join returns matches from right table, illustrated with student and teacher tables.

Master the alter table command to add column and drop column operations, with syntax examples and a practical demo of changing a table and observing resulting errors.

Learn how truncate and drop commands differ: truncate removes all values from a table, while drop completely removes the table, as shown with a student table.

Master Oracle SQL transactions by using save point creation, rollback, and commit, with the save point syntax and its role as checkpoints to preserve work.

Explore savepoints and rollback in oracle sql by updating a name when age equals 20, then undo changes with a savepoint named add.

Master the commit command in Oracle SQL: understand that committed changes are permanent, cannot be undone, and learn to verify data before executing the commit syntax.

Master the Oracle SQL update command with a where clause to modify specific rows. See how age = 20 changes the name and is shown by a select.

Learn how to rename a table and a column in Oracle sql 2025 using alter table, including renaming the students table to student and depart to department.