SQL Complete Bootcamp for Data Analytics 2025

Explore relational dbms, including how tables, rows, and columns enforce data integrity with primary keys and foreign keys, support transactions with acid properties, and manage orders and inventory with sql.

Explore the key features of relational database management systems, including tables, primary keys, and foreign keys, and learn how ACID transactions ensure data integrity with SQL.

Explore how primary keys uniquely identify records and foreign keys link related tables, ensuring referential integrity and enabling join queries across student and enrollment data.

Explore the types of relationships in relational database management systems, including one-to-many, many-to-many, and one-to-one, using a classroom enrollment scenario with students, courses, instructors, and assignments.

Explore numeric, string, date and time, binary, boolean, enum, and json or xml data types in relational database management systems, and learn how choosing the type affects performance and storage.

Explore SQL, a declarative language for managing relational databases, covering DDL, DML, and transaction control with commit, rollback, and savepoint to ensure data integrity and platform independence.

Explore SQL platform independence by examining PostgreSQL, Microsoft SQL Server, Oracle Database, IBM DB2, Amazon Aurora, SQLite, and MySQL, and highlight their features and typical use cases.

Load csv datasets into MySQL by creating sample_schema and importing student_information, course_data, and enrollment_data via the data import wizard, with utf eight mp4 and utf eight mp4 unicode ci settings.

Learn to create a database in MySQL using the create database command, name it sample_database, and run it in MySQL Workbench to see a green checkmark.

Select a database in MySQL Workbench using the use command to perform edits like altering or dropping a created database, demonstrated with a sample_database and a trailing semicolon.

Modify your database with the alter database command to adjust character set, collation, encryption, and read-only settings using specific option values.

Learn how to delete a database in MySQL Workbench using drop database, verify with show databases, and confirm the sample database is removed.

Use the distinct function with select to return only unique values from a column. It shows unique departments or genders from a table, instead of all values.

learn how to use alias in SQL to rename columns and tables, select columns with an alias using as, and derive data from multiple tables.

Learn to use the SQL where clause to filter data with conditions, applying operators such as equal to, greater than, less than, and not equal to select specific columns.

Learn how to create tables in MySQL with the create table syntax, define columns and data types like int, varchar(255), and float, and end with a semicolon.

Apply the not null constraint to SQL table creation to prevent null values, ensuring id integrity in sample_table_two and related tables.

Explore how to apply the unique constraint in create table commands to prevent duplicate values, ensure not null columns, and create a table with a unique id for each row.

Learn to insert data into table columns with insert into values in MySQL, including id, person names, age, and income, and verify results with a sample table using a select.

Learn to update specific values in a SQL table using the update statement, set syntax, and a where condition to target rows like id=2 in a sample table.

Learn how to delete a specific row from a table using MySQL by issuing delete from sample_table_three where person_names equals Azad.

Learn to delete all values from a table while keeping the table intact using truncate table in SQL. See a practical example on sample_table_three.

Drop the entire table using the drop table command in mysql, as demonstrated with sample_table_three and verification via show tables.

learn to use check constraints in SQL to limit column values, such as age >= 18 and city not equal to New York, within a create table statement.

learn to modify an existing table in MySQL using alter table and add to create a new column like course_code with integer data type, demonstrated on the courses_data table.

Modify a column data type using alter table and modify column to change course_code from integer to varchar(255), demonstrating practical SQL in data analytics.

Rename existing columns in MySQL using alter table and the rename column function, applying to course id, course name, and course level, and handle gaps with backticks or underscores.

Learn to delete a column from an existing table using alter table and drop column in structured query language (sql), with a practical example removing course_code from course_data.

Learn to assign a primary key in MySQL by using alter table and add constraint, with a practical example on enrollments_data and enrollment_id.

Learn to define a foreign key by using alter table, add constraint, and references to link enrollments and courses via course id, handling column naming and constraints.

Learn how to drop primary keys and foreign keys using alter table and drop primary key commands, with a practical example on an enrollments table.

Create a SQL index by turning the department column into an index on the student information table with a 255 key length.

Create a unique index to prevent duplicates using create unique index, specifying the index name, on, and the target table and column with backticks.

Learn to drop an index with alter table and drop index to remove the ID_unique index from the student information table, and verify the removal.

Learn how to identify and filter null values in MySQL tables using a where clause with is null to retrieve rows with missing addresses.

Filter out null values using is not null in a select from the customer information table, applying the where clause to display only exact addresses.