PostgreSQL and Oracle SQL for beginners

Install PostgreSQL and pgAdmin, download from the PostgreSQL website, configure ports and password, connect to a database, and run SQL queries in the query tool.

Celebrate reaching the milestone in PostgreSQL and Oracle SQL for beginners, stay motivated to complete the course, and explore upgraded resources, Q&A, and certificate access.

Install and configure Oracle Express Edition and Oracle SQL Developer, create and test a database connection, and explore basic setup steps for beginners.

Create a test database in pg admin, then design tables—customers, products, and transactions—using create table with columns, data types, and constraints like not null, primary key, and foreign key.

Connect to existing schemas in Oracle express edition, create a connection with a predefined user, and use create table to add tables within those schemas (no database creation).

Create a database named classroom and use the query tool to create a table named science class with three columns: enrollment number integer, name varchar, and signs marks integer.

Learn to insert data in PostgreSQL using insert into, with or without column lists; insert single or multiple rows and verify results in pgAdmin, while respecting not null constraints.

Learn to insert data in Oracle SQL with insert into, with or without column names, handle nulls, and use unions and dual for multiple rows and virtual values.

Learn how to import data into a PostgreSQL table from CSV and text files using the copy command, including handling delimiters and headers, and compare with insert into.

Import data into Oracle SQL Developer from CSV or text files, specifying UTF-8 encoding, comma delimiter, and header handling; map columns to the customer table and complete the import.

Insert three student scores into the science class table using insert into, then import eight more scores from the attached student CSV into the same table.

Learn how to retrieve data from a table using the select command, choosing specific columns or all columns with the wildcard, and view results as result sets.

Learn to use the select statement in OracleSQL to query the customer table, select specific columns like first name or last name, or all columns with a star.

Use the distinct keyword in PostgreSQL to fetch unique values by selecting distinct on one or more columns from the customer table, removing exact duplicates while acknowledging case differences.

Explore how to remove duplicates with select distinct in OracleSQL, retrieving unique first names or unique combinations of first name and age from a customer table.

Master the where clause in PostgreSQL to filter rows by numeric and text conditions, select specific columns, and use distinct results.

Use the where clause to filter rows in Oracle SQL, selecting customers by age equals 25 or greater than 25, and by string conditions on last name.

Learn to apply multiple conditions in PostgreSQL using and, or, and not. See how age between 20 and 30 and not age = 25 demonstrates combining conditions.

Learn to use and, or, and not in OracleSQL to filter customers, including ages between 20 and 30 and excluding specific values.

Practice selecting data with where clauses and logical operators on a science class table. Retrieve names with scores over 60 and those over 35 but under 60, plus remaining students.

Update records in PostgreSQL with the update statement, set, and where. Update a customer's age and last name by id, and emails for G.

Discover updating data in Oracle SQL with the update command, using set to change age and last name in the customer table under specific conditions, including case-sensitive email updates.

Discover how to delete data in PostgreSQL with delete from table and a where clause, including single, multiple, and all-row deletions using practical examples on the customer table.

Delete records in OracleSQL via delete from, using a where clause to target customer_id = 6 or age > 25, or delete all rows when no condition is given.

Learn how to alter a table in PostgreSQL by adding, deleting, or renaming columns, changing data types, and applying constraints and indexes using the alter table command.

Learn to alter tables in PostgreSQL to add not null and check constraints, drop constraints, and define primary and foreign keys, with inserts and deletes enforcing data integrity.

Explore how to alter Oracle tables: add, drop, modify, and rename columns; set constraints (not null, check, primary key, foreign key); and manage indexes and data types.

Practice updating a record in a table, deleting a row by name, and renaming a column from name to student_name to reflect the new schema.

Learn to back up and restore a supermarket database, including three tables—customer, product, and sales—and practice querying with select statements in the restored environment.

Troubleshoot PostgreSQL restoration by creating a new database and using compatible tar, backup, SQL, or directory formats, while configuring the correct binary path in pgAdmin.

Create the supermarket database by building customer, product, and sales tables and loading data from CSV files with the copy command in PostgreSQL.

Back up the student database to a tar file, drop the science class table by mistake, and then restore the database from the backup.

Import csv data into Oracle sql developer without creating tables, using utf-8 encoding, comma delimiter, and underscores for valid identifiers, then verify with a select query.

Discover how the in condition simplifies queries in PostgreSQL and Oracle SQL, replacing many or clauses with a single in (values) filter in the where clause.

Learn how to use the between condition in PostgreSQL to retrieve values within a range, with inclusive lower and upper bounds, for numbers and dates, including not between ranges.

Learn how to use or and in to filter with city lists, then apply between for age and ship date ranges, including not between and date examples in Oracle SQL.

Master the like condition in PostgreSQL for pattern matching with wildcards, percent and underscore, using not like, distinct, and escape characters to handle literal patterns.

Use like in Oracle SQL for pattern matching with percent and underscore wildcards to filter names, explore case sensitivity, and match starting and internal patterns.

Learn using in, between, and like in where clauses to filter data: retrieve distinct cities in north or east regions, orders between 100 and 500, and four-character last names.

Learn how to annotate SQL queries with comments, using multi-line comments (/* ... */) and single-line comments (--), to keep notes without affecting execution.

Learn how to use order by in PostgreSQL to sort query results by one or more columns, in ascending or descending order, including non-text columns and column numbers.

Master limiting result sets in PostgreSQL with the limit clause, using order by age desc or asc and optional where conditions to fetch the top or lowest rows.

Learn how to order query results in Oracle SQL using order by with ascending or descending order, by column name or index, and apply fetch first to limit results.

Sort the result set by discount values in descending order, display orders with a discount greater than zero, and limit to the top ten for maximum discounts.

Learn how to use the as keyword to alias columns and tables in PostgreSQL, with examples like serial number and quoted names.

Learn how to alias columns and tables in PostgreSQL and Oracle SQL, including using as for columns, direct table aliases in Oracle, and quoting rules for string aliases.