[NEW] The Complete SQL BootCamp for Beginners 2024

Define database and relational database concepts, explain database management systems, and show SQL as the language to interact with open source relational databases like MySQL, with upcoming practical exercises.

Download and install MySQL Workbench by selecting your operating system, then set a password and launch the local instance on port 3303.

Create a database named person, show all databases, then use the person database and finally drop it. Learn to execute create, show, use, and drop statements to manage databases.

Explore how sql uses tables to store data in rows and columns, create and drop tables, and perform basic operations with a sample employee database.

Create and use the employee database, then design the employees table with name, age, and country. Insert multiple rows into the table and practice selecting all data or specific columns.

Learn to use the delete command to remove specific rows with a where condition, distinguish it from drop, and clear all data without dropping the table.

Learn how to rename a table in SQL to a more relevant name using the rename table command, with a practical example renaming employees to employees_new and verifying the change.

Learn to alter a table by adding single or multiple columns with the add command. See examples like id, salary, and department; new columns start as null until populated.

Truncate table removes all data from a table while preserving its structure, delivering faster performance than delete. Drop table removes the table entirely, while truncate cannot use a where clause.

Master the SQL select statement to query data from tables and views, retrieve specific columns, apply conditions, and use distinct values in practice.

Learn to use the sum function in SQL to total an expression, selecting from the student table to sum all ages and ages of students over 20, with an alias.

Master SQL querying with the where clause to filter student data, select specific fields such as name and percentage, and apply greater than, less than, and equals conditions.

Learn how to apply and and or conditions in SQL to filter student data using where clauses, combining grade and address criteria for precise results.

Explore SQL data types, including integer, bit, float, double, and string types such as varchar and char, plus binary and text storage options. Learn to define a date data type for fields like graduation, set size, and apply proper date formats.

Learn how to declare integers and strings, use inverted commas for text, insert data into a student table with date and graduation year values, and view results.

Sorts student data by a specified column using the order by clause in SQL, enabling ascending or descending ordering by name or percentage.

Master updating data in sql tables with the update statement, using set values and where clauses to modify records in a students table.