Introduction to Relational Database and SQL

Explore the entity relationship model and its role in logical design. Define entities, attributes, and relationships with shorthand and qualified representations, and learn functional dependencies, keys, and relationship types.

Explore physical design in relational databases, mapping relations to two-dimensional tables with primary keys, attributes, and data types, including one-to-many merges and a PostgreSQL example.

Master normalization to improve relational database design by eliminating repeating groups and data duplication. Decompose tables through first to third normal forms and BCNF to enhance data integrity.

Explore 2.5 normal forms from first to Boyce-Codd, using decomposition to achieve atomic values, remove partial and transitive dependencies, and discuss denormalization trade-offs.

Explore entity relationship diagrams (ERDs) for modeling entities and relationships, using crowfoot notation to show one-to-many and many-to-many, including relationship attributes like registration.

Learn sql, the standard language for relational databases, covering ddl and dml statements such as create, alter, insert, update, delete, select, and drop. See Oracle LiveSQL in action.

Introduce PostgreSQL and its architecture, and outline how to install the PostgreSQL service on your local machine. Explore dbms basics; use pgAdmin to run a test SQL.

install and configure PostgreSQL on a local windows machine, including downloading the installer, setting up postgres super user, using pgadmin to create a database, and running basic sql queries.

Learn how to create and drop tables in SQL for relational databases, define columns with data types and primary keys (single and multi-column), and avoid common syntax errors.

Master Oracle Live SQL naming conventions, including the 30-character limit and rule that names start with a letter. See a hands-on demo creating tables to illustrate valid and invalid names.

Demonstrate PostgreSQL naming conventions, including a 31-character limit and allowed characters, and show how quoted names enable case sensitivity in pgAdmin 4 demo, with Oracle parallels.

Learn how to insert data into a table and retrieve it with select statements, using insert into with column lists or without, and understand column order and primary key uniqueness.

Explore how int and decimal define column values, how precision and scale work, and how char and varchar handle text, quotes, and storage in relational databases.

Learn that NULL represents a missing or unknown value, not zero or an empty string, and apply NOT NULL constraints to key fields like primary keys and emergency contacts.

Explore single table select statements, using aliases for computations, apply where filtering, distinct values, and order by sorting, with practical examples in Oracle Live SQL.

Explore row level functions that apply to every row, including date format conversion with to_date, string operations like upper, lower, length, and concatenation, with sysdate as an example.

Explore aggregation functions like sum, avg, max, min, and count, and distinguish count star, count column, and count distinct. Learn how nulls affect calculations.

Learn to correct table data with insert, delete, and update statements, using where clauses, bulk inserts, and insert-select operations, plus inline calculations like a 10 percent tuition increase.

Learn how to change table structure with alter table to add or modify columns, handle not null constraints, distinguish drop table, delete, and drop column in Oracle and other DBMS.

Explore the where clause in select, delete, and update statements, applying filtering conditions with comparison and logical operators. Learn between...and, inclusive bounds, and common pitfalls with examples.

Compare strings in where clauses by ASCII order and case. Use the like operator with percent and underscore wildcards, applying upper or lower for case insensitive search.

Explore how null values affect where clauses, why NULL equals NULL is false, and how to use IS NULL and IS NOT NULL to test for missing data.

Learn how to use where with in and subqueries, properly quote each value with single quotes, and apply all and any with aggregates to compare against subquery results.

Review the basics of SQL and the data lifecycle, covering CRUD operations, relational models, and normalization to third normal form through an insurance claim invoice scenario.

Explore how to normalize a relational design to first, second, and third normal form, remove repeating groups, and map entities to sql with create table statements and inserts.

learn to build tables, insert data, and answer mid-term project part II sql questions in oracle live sql, covering select, where, is null, update, alter, not null, delete, and subqueries.

Explore how to group data by color or student, apply aggregations (sum, average, min, max, count), and format results with order by in SQL.

Learn how to apply where and having filters in a group by, distinguish original table vs aggregated data, and follow the execution order with sum aggregations.

Explore set operations in sql, blending data from two tables with union, union all, intersect, and minus to manage distinct or all rows.