SQL Basics for Beginners

Learn to create a SQL database table using the create table syntax, define columns with integer and character limits, and view the new table in the database.

Learn how to insert records into a SQL table using insert into syntax with column names and values, including handling integers and strings with quotes, and verify results with select.

Learn to update existing records using the update statement, setting column values and filtering with where clauses. Explore examples updating hospitals and customers, correcting specialties and countries by id.

Delete a row from a database table using delete from table where, demonstrated on the employees table, and verify the change with a select showing the updated record count.

Learn how to delete a database table using the drop table syntax, with a practical example of removing the shipper's table and confirming it is deleted.

Use the and operator to combine conditions in a where clause, filtering products table by supplier_id 1, price greater than 10, not equal to 18, and product name like chang.

Explore how the or operator filters data by returning records when any condition is true, demonstrated with country filters for UK, India, and UAE.

Master the in operator to filter a column by multiple values in sql, using in ('city1','city2','city3') to pull records for those cities.

Explore using the like operator in a where clause to filter a column by pattern, employing % wildcards to match beginnings or endings of the contact name.

apply between and not between operators to filter data by price ranges and retrieve records, such as selecting prices between 100 and 200.

Learn how the order by operator sorts data in ascending or descending order using one or more columns, as sorting by country with default ascending and using desc to reverse.

Learn to query data across multiple tables with a select statement, pulling product details and category names from products and categories using category id.

Learn how to use subqueries to filter data and retrieve max, min, and average quantities from the order details table, including practical examples with order id and product id.

Learn how to use SQL join techniques, including inner join, outer join, and full outer join, to combine faculty and department data using department ID.