Oracle SQL for Beginners - The fundamentals

Explore Oracle SQL fundamentals by retrieving data: select all columns or specific fields from a table and apply conditions to filter rows that meet criteria.

Master basic comparison operators to filter data with select statements, using equal, greater than, greater than or equal, less than, and less than or equal on the friends table.

Compare two columns in the same table using a where clause and the greater-than operator to filter rows where column one exceeds column two.

Apply the between and not between operators to filter data, using a movies table to compare budgets and release dates while matching data types.

Learn how to use the in and not in comparison operators to filter rows by a list of values in Oracle SQL, with practical syntax and examples.

Master the like operator in the where clause to search patterns with percent and underscore wildcards, apply escape characters, and build pattern-based Oracle SQL queries with practical examples.

Identify null values and apply is null or is not null to filter records in Oracle SQL, using a books table with a name column as examples.

Explore how to use and, or, and not in Oracle SQL to filter results with complex conditions, including between and not between in where clauses.

Learn arithmetic operators and salary calculations using plus, divide by two, and greater than comparisons to generate reports.

Learn to read data from a table, filter with operators, and compare columns; practice creating a table with price, expired, and production, and display records with price greater than 100.

Create a table with one or more columns, define column names and constraints, apply default values, and insert and view a record.

use alter table to modify an existing table by adding, dropping, or renaming columns, changing data types, and renaming the table to maintain structure.

Explore Oracle SQL constraints, including primary key, unique (single and composite), foreign key, and check constraints, and learn how these enforce data integrity and referential integrity.

Explore how unique constraints ensure a column or a combination of columns uniquely identifies records in a table, how to define them, and how the system enforces uniqueness and reports violations.

Explore creating primary keys in sql using create table with a constraint or alter table, choose a column or column set as primary key to ensure unique row identification.

Create foreign key constraints that link the employee table to the department table primary keys, enforcing referential integrity and preventing non-existent department references.

Discover how a check constraint enforces a column condition, using an employees table example to ensure values, such as lead, are limited to 0 or 1.

Learn how to enable and disable constraints in Oracle SQL without dropping them, switching constraints on and off to control data validation during inserts and tests.

Explore how naming conventions constrain identifiers in Oracle SQL, with suggestions for column names, the use of underscores, and abbreviations for primary keys, foreign keys, and check constraints.

Create a new table as select to copy all columns and rows from a source table, or copy only selected columns, or create an empty structure with a never-fulfilled condition.

Drop table in Oracle SQL deletes the specified table and its data, including associated constraints. Practice shows constructing the correct syntax and handling non-existent tables by recreating as needed.

Learn to create and alter tables in Oracle SQL, define primary key, foreign key, and check constraints, enable or disable constraints, and practice cloning or dropping tables.

Learn to insert data in Oracle SQL by specifying columns or using default order, aligning values with columns, and handling multiple values per table.

Learn to update existing records in Oracle sql by setting column values and using where clauses, including date and price updates and the effect of omitting where.

Delete data by using the delete statement to remove one or more rows based on a condition. See practical examples to illustrate applying deletions to your data.

Learn how to sort data in Oracle SQL using order by, sorting by one or more columns, choosing ascending or descending, and applying these rules to the result set.

Learn to combine results from two tables using set operators such as union, union all, intersect, and minus, with matching column counts and compatible data types.

The distinct clause removes duplicates from a select result set. Apply it to one column or multiple columns to enforce unique values or unique combinations, using a where condition.

Explore set operators, join tables, create and populate tables, update prices, remove duplicates, and query listings across tables in Oracle SQL for beginners.

Explore how joins combine data from two or more tables using related columns, including inner, left, right, cross, and natural joins, with on clauses to specify matching conditions.

Explore inner join in Oracle SQL for beginners by combining rows from two participating tables where keys match, selecting relevant columns and applying join conditions to display only matched records.

Explore left join and right join concepts in Oracle SQL by linking two tables with on conditions, matching records, and understanding when matches exist or are absent.

Explore how a full outer join combines all records from two tables, showing matches and nonmatches between sales and products.

Learn how natural join connects tables by matching common column names, such as product id, without specifying a join condition; however, explicit joins are recommended.

Explore cross join concepts by forming the Cartesian product between two tables, producing all row combinations; a two-table example shows 2 rows in each table yielding 4 results.

Learn how to perform multiple joins across four tables in Oracle SQL, using left joins to connect sales with accounts and related tables, with alias usage and example queries.

Explore old syntax joins in Oracle SQL, including left and right joins, and see how matched and unmatched rows appear in simple select examples.

Explore the fundamentals of Oracle SQL joins, including left join, right join, full outer join, and cross join, with ansi syntax and how matching affects results.

This lecture covers Oracle SQL data types, including character types (fixed-length and Unicode), single- and multi-byte characters, numeric types with precision, and date-time types with time zones.

Learn to use the Oracle dual table to retrieve a single value and to compute expressions, such as 1 plus 10 plus 100, from dual.

Learn how Oracle SQL functions operate on values, such as computing the absolute value of a price column, and apply a function when grouping data.

Explore Oracle sql numeric functions, including how to use remainder and division to compute values, round numbers, and format salaries with simple examples.

Develop understanding of character functions returning character in Oracle SQL, mastering syntax for concatenating characters, case handling, and default behaviors with practical examples.

Learn how Oracle's character functions return numbers, use substring and position functions to find the first occurrence of a substring within a string, with example queries.

Explore Oracle SQL datetime functions to extract day, month, and year, format dates, compute intervals such as months_between, and truncate or round time components.

Explore the general comparison functions in Oracle SQL, focusing on greatest and least to compute maxima and minima from lists and apply their syntax effectively.

Master Oracle SQL conversion functions by using cast, to_char, and to_number to convert between data types, including dates and timestamps.

Explore encoding and decoding functions in Oracle SQL and learn the decode and size functions. Review the syntax with examples showing bytes per letter.

Learn how null related functions work in Oracle SQL, practice using expressions to compare values, replace results, and evaluate logical tests with or and not equal conditions.

Explore environment functions in Oracle SQL for beginners, demonstrating how to use select statements to identify sessions, users, and return appropriate data types.

Explore aggregate functions in Oracle SQL for beginners, applying group concepts to compute totals. Learn the syntax for sum and average, with examples on product prices.

Analytic functions extend aggregates by computing values for each row within a defined group, unlike aggregates that return a single value per group.

Explore basic Oracle SQL concepts including data types, time functions, gender comparison option, and environment functions, then create a structure with name, age, and salary columns and practice simple selections.

Learn how the group by clause creates grouped results with aggregate expressions, such as sum of salaries, to analyze department and city data.

Explore the having clause and its use with aggregate functions to filter groups, using a salary example to display sums greater than 1500 and group by department.

Follow chapters and lessons, complete an exercise to reinforce concepts, and practice class-based tasks, including evaluating numbers greater than 8 and creating five items.

Explore the database homepage and navigate objects like tables, sequences, indexes, constraints, and procedures within a schema. Learn to create and view objects, seed data, and understand privileges.

Learn how to create and use a database view to select columns like name and age from a table, hide unused columns, and understand naming conventions for views.

Learn to use sequences in Oracle SQL to generate primary key values and automate key creation by setting start, minimum, maximum, and increment options.

Explore creating and using synonyms in Oracle SQL to access tables from different schemas. Learn the syntax to create a synonym and reference the source object.

Explore how indexes on table columns optimize data access in Oracle SQL, including unique constraints, index naming, primary key implications, and how to verify index creation.

Explore other database objects in Oracle SQL, including functions, procedures, and packages, and learn how these programmable components group and execute code.

Explore a sample schema in live sql to understand tables, columns, and sequences, and learn basic object models and select operations for Oracle SQL beginners.

Learn basic Oracle SQL concepts including joining two tables, using the sequence, and applying simple policies for employees with the same name.

Learn how users connect to the Oracle database, how roles grant privileges, and how system and object privileges, such as create table and select, are assigned to users or groups.

Master how to grant and revoke privileges in Oracle SQL, including selecting data, creating foreign key constraints, and managing access for tables and views.

Explore how privileges and roles control access in Oracle SQL, and how licensing and access requirements determine who can perform actions.

Explore the case expression in Oracle SQL by building multi-branch when-then logic, using else clauses, and applying it to categorize values such as price ranges (0-9, 10-19, over 20).

Master subqueries in Oracle sql for beginners, uncovering fundamental query techniques and how the main query interacts with subqueries. See examples and practical uses highlighted for clarity.

Explore how exists operates in the where clause to filter records when selecting from the employees table, and understand related conditions and patterns in oracle sql.

Practice basic oracle sql queries on the students and classes tables, using case expressions, nested selects, and calculations like differences in marks and class size to extract name and class.