SQL - Zero to Hero: The Complete SQL Bootcamp

Install PostgreSQL on Mac OS by downloading the interactive installer from postgresql.org, then configure a superuser password and connect using Pgadmin four or SQL shell to access databases.

Install PostgreSQL and PgAdmin on Windows by downloading the installer, configuring the data directory, and setting a memorable password. Use Stack Builder for optional tools.

Explore how a database schema acts as a blueprint, organizing data into tables and relationships to support data integrity, security, and efficient queries, with multiple schemas per database.

Explore how database tables use rows as single data entries and columns as attributes, with data types defining allowed values for efficient storage.

Explore data types, from integers and decimals to text types like char and varchar, date/time, boolean, and binary, and learn how they ensure data integrity, optimize storage, and improve performance.

Explore Pgadmin for managing PostgreSQL databases, learn about databases and schemas, and use the SQL query tool to create, refresh, and drop databases and schemas, noting this cannot be undone.

Create the base tables product focus, customer, and orders using the provided SQL script, then insert records and verify table creation and row counts in the environment.

Learn to add new records with the insert into statement, specifying the target table, columns, and values; use multi-row inserts for efficiency and understand when to omit the column list.

Create an employee table, define columns like employee id, name, and phone number, then insert single and multiple records, and verify counts to master SQL basics.

Explore fundamental sql queries by inserting records and selecting data from an employee table, including handling special characters like double and single quotes with backslash escaping.

Learn to create and drop tables in SQL by building an employee table with an int primary key, varchar name, and numeric phone, then verify and drop it safely.

Create a PostgreSQL table using pgadmin's GUI, define columns (E_id integer, E_name text, E_salary numeric, is_active boolean), and save the table without writing SQL queries.

Define and manage the structure of database objects using data definition language, a subset of SQL. Create tables, indexes, views, and schemas; alter, drop, and truncate objects as needed.

Explore the SQL select statement as the gateway to data, learning to retrieve specific columns from the product table, such as name and category, for efficient results.

Discover how databases organize data in tables of rows and columns, and practice fetching specific columns with select queries on PostgreSQL via PgAdmin.

Learn that sql keywords are case-insensitive and you can format queries across lines; only table and column names matter, demonstrated by selecting product name and price from the product table.

Explore selecting data with select star from product, navigate the left panel to view tables in the public schema, and verify column names by drilling into the product table.

Explore selecting without tables by querying a literal value, performing arithmetic such as 15 times 2 and 15 minus 2, and using the now function to retrieve date and time.

Practice applying mathematical functions in select queries, using literals and table columns; perform addition, multiplication, modulo, and power, and observe computed results in the product table.

Discover the distinct keyword in SQL to remove duplicates and return unique values, including single columns and unique name and active status combinations from the product table.

Learn how the distinct keyword removes duplicates in sql queries, using select distinct on category from product, and how to count distinct categories and rows.

Explore the distinct keyword through hands-on experiments, selecting distinct categories, combining category and product name, and counting unique records to understand how row uniqueness works.

Learn to use SQL aggregate functions to analyze product data, computing count, min, max, and average prices with simple queries like select average(price) from table.

Explore the upper and lower functions in SQL to standardize text and enable case-insensitive comparisons. The lesson demonstrates practical queries on product names, using upper, lower, and combined results.

Explore the split part function and replace function to manipulate text data, split product names by spaces, and replace spaces with underscores for clean, structured results.

Learn how the SQL concat function joins text values into a single output and how to insert separators for readable product names, categories, or labels with prices in reports.

Explore how the length function counts characters, including spaces, to validate input, optimize column sizes, and analyze data size, with examples using product name lengths and maximum length.

Learn to control the number and starting point of query results using limit and offset, with examples that select from product and start at different rows.

Master SQL aliases to rename columns and tables using the as keyword. Apply aliases to single or multiple columns and even constants to simplify queries.

Explore how the where clause filters rows with comparison, logical, range, membership, and search operators, improving query performance by using indexes to return smaller result sets.

Master SQL filtering with comparison operators—equal to, not equal to, greater than, greater than or equal to, less than, and less than or equal to.

Explore SQL logical operators and, or, and not to combine multiple conditions into precise filters; and creates an intersection, or creates unions for selecting product data.

Learn to filter data with the where clause, using equals, not equals, greater than, and less than, and combine conditions with and or on stock and price.

Master filtering string columns with the where clause in SQL, learning equals, not equals, and, or across product name and category in a sample product table.

Learn how range operators filter data using between in SQL, including inclusive boundaries for numbers and dates. Apply not between for exclusions and write clear, efficient queries.

Learn how to filter results by date with the where clause, including equals, not equal to, and, or, greater than, and less than, using the order date.

Filter boolean columns with the where clause to retrieve active records. Explore true values, including one as true, and combine is active and category using and or.

Learn to filter with multiple values using the sql in clause, replacing or conditions with a where stock in (15, 0); this method also works with string data.

Explore the in function to filter sql results by multiple values on integer and string columns, such as price and category, and combine with is_active conditions to refine results.

Master the between operator in SQL by filtering results within a numeric price range and a date range, including endpoints, with practical examples from product and orders tables.

Explore how the where clause filters string columns in sql using the like operator, with patterns defined by % and _ to match starts, ends, and in-between letters.

Explore the like keyword in SQL using underscore and percent wildcards to match product names and find letters in specific positions or containing k.

Learn to create an employees table, store salary as text, and use cast to convert salary from string to float and then to integer, handling decimals.

Learn how SQL handles date data types, cast between date and text with formatting methods, and format order dates using now() and various date formats.

Master casting string data to numeric types in SQL using double colon syntax and the cast function, convert decimals to integers, and run select queries that reveal numeric results.