Learn SQL From Scratch No Experience Required

Eliminate multi-value fields to enforce first normal form and atomic values. Break definite fields like name and address into separate columns and remove indefinite multi-value fields such as phones.

Learn how to choose a primary key from candidate keys by evaluating uniqueness and existence, comparing social security number with a composite key of first name, last name, and email.

Learn how second normal form builds on first normal form by removing partial dependencies, splitting into course and student tables with keys, ensuring non-key attributes fully depend on the keys.

Explore extended one-to-one relationships by modeling supertype and subtype tables, enforcing referential integrity with primary and foreign keys, using a subtype discriminator for post types like standard and supreme.

Learn how to model one-to-many and zero-or-many relationships in an ERD. Identify minimum and maximum cardinalities and how foreign keys link department to employees and professor to courses.

Learn self-referencing relationships in an erd by modeling employees and managers with a manager_id foreign key and zero-to-one or one-to-many cardinalities, and category hierarchies with zero or one parent category.

Complete the design phase and transition to the implementation phase, applying solid database design to real-life projects and case scenarios as you begin implementation.

Create a customer table in Oracle SQL Developer to implement a database design, and learn the basics of structured query language, its key keywords, and the four SQL command categories.

Learn how to insert data into a customer table using insert statements, specifying columns and values. Understand how primary key uniqueness, data types, and proper quoting affect successful inserts.

Apply the where clause to filter data in a select statement. Query the customer table by customer_id, primary key, or other columns like age or first_name to identify matching records.

Learn how the or operator combines conditions to return customers whose first name is Mike or Lisa, using SQL queries on the customer table.

Learn how to use the sql equal and not equal operators to filter customers by id, with examples like select star from customer where customer_id = 100.

Explore on delete cascade in the HR schema by linking regions to countries through inserts and deletes, illustrating how deleting Europe cascades to affected countries.

Learn to format dates in SQL by extracting year, month, and day with system dates and using to_char to display hire dates in various formats.

Explore aggregate functions such as max, min, sum, average, and count to analyze employee salaries, format results with to_char, and understand non-null counting across the employees table.

Learn the difference between aggregate and scalar functions in SQL, using length and salary examples, ordering results by id and salary to identify figures beyond five digits.

Learn to use case when and decode to classify salaries into high, mid, and entry level income, with aliases for readable headers.

Learn how to use left and right outer joins in SQL to join countries and regions, revealing unmatched rows such as Australia and Asia and filtering nulls.

Use a subquery to determine the year of Jonathan Taylor's hire, then use an outer query to list all employees hired that same year.

Discover how to extract unique job titles from the employees table using the distinct keyword after select, removing duplicates and revealing only distinct values.

Learn how the information schema stores every table, column, and constraint in the data dictionary. Explore querying user objects and constraints to inspect tables, and note Oracle versus MySQL terminology.

Learn to create reusable PL/SQL functions that take numeric parameters and return yes or no for commission status, and understand how create or replace enables easy reusability.

Explore PL/SQL procedures, create a procedure with an in parameter to delete an employee by id, run it with execute, and distinguish procedures from functions, including dbms_output messaging.

Learn to set up an Oracle environment, create a training user and schema, and complete four hands-on sql exercises on employees, foods, and human resources schema, matching snapshot results.

Explore real-world web development exercises by designing a database for a web app from wireframes to Oracle sequel server, and writing sequenced statements to connect data and application.