Learn SQL from Basic

Explore structured query language and its role in accessing and manipulating databases, and learn the basics of data organization and inserting records.

Learn how a database schema defines the logical structure of data, including tables such as albums and artists, and how ownership and authorization control access to schema objects.

Learn to create a database and its tables in SQL, define columns with data types, manage constraints, and use semicolons correctly, including dropping databases when needed.

Learn data types in sql, covering numbers, decimals and decimal points, booleans, and date and month values; examine storage rules, default values, and the role of time stamps in records.

Explore constraints in SQL, including default constraints and making a column mandatory to prevent invalid entries and enforce data integrity on tables.

Learn how SQL constraints work, including unique and primary constraints, and how to define constraints within a column.

Explore a practical SQL example using an employee table with a primary key and department relationships. Learn to query salaries and managers, enforce unique phone numbers, and perform inserts.

Create table in SQL by building a department and employee schema, defining fields like department id, department name, employee name, job, manager, salary, commission, email, and phone.

Learn how to insert date into the table in SQL, verify the insertion, and check data properties to ensure accurate records.

Learn how to delete data and update data in SQL using the primary key, and manage related department and salary records while maintaining data integrity.

Learn how to drop and alter tables in SQL, including deleting objects, adding, editing, and dropping columns, and modifying constraints to shape table structure.

Explore retrieving data from tables by joining department and employee data, filtering by department, and using pattern matching with underscores to find names.