Learning SQL For Oracle

Sort query results by column names using the order by clause, placed at the end of the select statement, including multi-column sorting with ascending or descending options.

Display books with title, price, publication date, revenue, and publisher, city; filter where advance > 0 and order by title.

Sort Oracle SQL results by column position from the select list, using order by 1 and 1,2 with descending sorts, while recognizing that position-based ordering is cautioned for programming languages.

Learn how a foreign key links to a primary key to connect data across tables. See examples with book and publisher tables, and learn to retrieve related data with joins.

Learn how to join tables with the on clause, use table aliases to simplify multi-table joins, and explore using vs on with publisher–book and zip code examples.

Explore how joins and the order of processing in sql determine results, from joining publisher and book on publisher_id to filtering, sorting, and selecting name, title, price in advance.

Master aggregate functions in SQL, including sum, average, min, max, and count, with null handling and the rule against mixing detail with summaries.

Explore implementing many-to-many relationships using an intersection table between author and book, with primary and foreign keys, and learn how royalties and attributes fit the relationship.

Master SQL with Oracle by completing assignment 7 using Apex or Toad, writing a select statement to show book type averages above $30 and author sales between 5,000 and 10,000.

Explore assignment 8 by crafting SQL select statements in Oracle: list books with their authors starting with t, filter editors by salary, and find titles containing stressed.

Write select queries to join books and authors with left outer joins, filter titles starting with t, apply between for editor salaries, and find titles containing stressed case-insensitively.

Explore how subqueries work with the in operator to filter authors by states from publisher, using inner and outer queries, distinct lists, and nested selects.

Master subqueries with the in operator in Oracle SQL by building inner queries that return lists for the outer select, ensuring type-safe comparisons.

answer assignment 9 using sequel sql tool to create subqueries: books by sunshine publishers and teko sold over 5000; advances below average; authors in states where teko books are based.

Learn how normalization reduces data redundancy by transforming real estate data into first, second, and third normal forms, using primary keys and foreign keys.

Learn normalization guidelines from first through third normal form, breaking data into smallest parts, using primary and foreign keys, and designing non-redundant tables for scalable sql queries.

Create an entity relationship diagram using crow's foot notation and apply normalization to model company attributes, identify entities, and express tables with primary and foreign keys in relational notation.