Learn SQL With MySQL & Microsoft SQL Server for Beginners

Connect to the MySQL server with MySQL Workbench, explore the main interface, and learn to create schemas and SQL tabs, plus basic database concepts.

Learn to delete a MySQL database using both the graphical interface and SQL commands, including drop schema and drop database, executing scripts, and saving the query for later use.

Create a database in Microsoft SQL Server using SQL script or the graphical interface, execute the command, refresh the database list, and explore objects like tables and views.

Create a table in Microsoft SQL Server by selecting the target database, defining department_id as identity (seed 100, increment 2) primary key, and department_name as not null varchar(255).

Drop tables in Microsoft SQL Server using SQL script or the graphical interface. Resolve foreign key constraints, such as department referenced by employee, by removing the link before deleting.

Create a DSG database in MySQL and Microsoft SQL Server, and build independent tables department, location, institute, and project with primary keys, auto increment starts, and basic table creation.

Create the DSG database in Microsoft SQL Server, build tables such as department, location, institute, and project, then add dependent tables with foreign keys using Management Studio and identity-based keys.

Learn to modify a table by dropping employee_name and adding first_name, last_name, and job_title as not null columns in MySQL and Microsoft SQL Server.

Drop the employee name column from employee_a and add first name, last name, and job title as not null varchar columns. Use designer to reorder after employee ID and save.

Learn to insert data into MySQL tables like department, location, institute, and project, using auto increment keys, column lists, and multi-row inserts, then verify results with selects.

Learn how to delete data from a MySQL table using delete from department where department name equals marketing, selecting the database and disabling safe update mode in the SQL editor.

Learn to use the where condition in select queries to filter results, applying greater-than and equals criteria on budgets and project numbers.

Master and or operators to refine SQL queries, narrowing results by conditions like job title or birth date greater than a threshold, with practical MySQL and SQL Server examples.

Learn how to use top and limit operators to fetch the top records by budget in SQL Server and MySQL, ordering by budget descending.

Learn how the distinct operator retrieves non-duplicated values from a specific column in SQL, as shown with select distinct budget from project.

Compute the number of employees per department where date of birth is greater than 1981, using SQL code that mirrors the MySQL approach and validates results on SQL Server.