Learn SQL With MySQL & Microsoft SQL Server for Beginners

Explore what a relational database management system is, how it links tables with primary and foreign keys, enforces data integrity and security via permissions, and compares Oracle, MySQL, SQL Server.

Install SQL Server Express 2017 on Windows and then install SQL Server Management Studio, following download center steps, basic installation, and setup completion.

Launch SQL Server Management Studio, connect to your server using Windows authentication, and open a new query to switch from the master database to your data database for analysis.

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

Explore what SQL is and the five command types: DDL, DML, DCL, DTL, and DQL, including how they create and manage database objects, manipulate data, control access, and query data.

Clarify how database and schema relate in MySQL and Microsoft SQL Server, showing schema in MySQL and database in SQL Server as interchangeable concepts.

Create a new database in MySQL using SQL commands and the graphical workbench, including the create database <name>; syntax and semicolon, then verify with refresh.

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.

Learn to drop or delete a database in Microsoft SQL Server using SQL script or a graphical interface, including disconnecting before dropping and refreshing the database list.

Explore core data types in MySQL and SQL Server, including string types char and varchar, common numeric types such as tinyint, int, bigint, float, and date/time types.

Explore SQL constraints and how they enforce business rules by limiting data in columns, covering not null, unique, primary key, and foreign key, plus check, default, and index.

Learn to create a database and a department table in mysql, using use database and create table commands, with department_id as integer primary key and department_name as varchar.

Create a MySQL table using the GUI by naming the table, adding columns with integer, varchar, and date types, setting primary key and not null, and applying changes.

Learn how to drop a table in MySQL using both a script and a graphical interface, including handling foreign key constraints and reviewing the SQL.

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).

Create a table in Microsoft SQL Server via GUI by defining employee ID as the primary key, adding first name, last name, date of birth, and department ID foreign key.

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 MySQL by building tables in order, defining primary and foreign keys, and using bridge tables like project team and degree to link employees and projects.

Create bridge tables project team and degree in MySQL, define primary and foreign keys referencing project, employee, city, location, and institute, then execute to verify no errors for SQL Server.

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.

Create employee A and employee B tables with an identity primary key and non-null fields, and define foreign keys linking city of birth to location and department id to department.

Create two bridge tables, project team and degree, to link projects, employee A, location city code, and institute in SQL Server part 3.

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.

Create a degree reference table with degree ID and degree name, and link it to employee and institute tables via keys to unify names in MySQL and SQL Server.

Create a new table in MySQL with a primary key and convert degree_id into a foreign key referencing a degree reference table, including column drops and additions.

Create the reference and degree tables in SQL Server, define primary and foreign keys, and link to the employee and institute tables.

Master inserting data into tables with insert into, specifying columns in order and matching values, and learn about foreign keys, auto increment, and string quoting in MySQL and SQL Server.

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.

Insert data into MySQL tables with foreign keys, including auto incremented employee IDs, and insert 19 rows to maintain referential integrity across departments and employees.

Insert data in MySQL part 3 shows adding project team records with auto-incremented IDs and foreign keys, plus inserting degree references from employee, institute, and degree, avoiding duplicates.

Delete data from a table using delete from <table> where <condition> in Microsoft SQL Server; the lesson inserts sample departments and deletes marketing, then verifies with top 1000 rows.

Insert data to show duplicate rows, then delete from table where project number > 2008 to remove the duplicated projects inserted by mistake.

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 remove duplicate records in a project table by using a simple delete with a where clause, targeting rows with project number greater than 2008, then preview results.

Learn to update data in tables with the update statement, using where clauses to target rows, and run updates in MySQL and Microsoft SQL Server.

Complete the homework by updating the table to insert employee 19's termination date using Microsoft SQL Server and MySQL.

Update the termination date for employee 19 in SQL Server, then run a select top 1000 rows to verify the change shows the correct termination date.

Learn how to use the select statement to retrieve data from tables in MySQL and Microsoft SQL Server, choosing all columns or specific columns like project name and budget.

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 to sort retrieved data with the order by statement, using ascending or descending for numbers and alphabetic order for strings (a to z or z to a).

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

Explore the between operator in Microsoft SQL Server to filter data by a range, such as project numbers between 2000 and 2005, and learn how not between excludes that range.

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

Learn to filter data using the in and not in operators in SQL, selecting or excluding values with practical examples in MySQL and SQL Server.

Learn how to use like and not like with wildcards in SQL to filter employees by last name patterns—starts with, ends with, or contains C—using MS SQL Server.

Explore wildcards in SQL using the like operator to match patterns with percentage, underscore, and square brackets, supported by practical examples of filtering names and cities.

Learn to join tables in SQL to retrieve data from multiple tables using inner, left outer, right outer, full outer, and self joins, with customers and orders linked by customer_id.

Explore joining location and employee tables in SQL Server using inner, left, and right joins to list cities and employees born there, with nulls for unmatched cities.

Learn to join three tables—employee, project team, and project—using aliases and inner joins in MySQL to display employee names with their project names.

Explore self join by pairing two aliased views of the employee table to find pairs sharing the same city of birth, retrieving their first names and sorting by city.

Explore SQL aggregate functions such as count, sum, average, max, and min on the project table, using aliases and syntax shared by MySQL and Microsoft SQL Server.

Use the group by statement to aggregate values per a column, counting employees per department and ordering by department counts, with alias syntax differences between MySQL and SQL Server.

Learn to use the having clause in MySQL to filter groups after applying aggregate functions, using where and group by to count employees per department and order results.

Analyze departmental headcounts by applying a where filter on birth dates after 1980-01-01 and a having clause to return departments with more than three employees using SQL Server.

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.

Explore sql date functions, including getting the current date with getdate in sql server and now in mysql. Extract year, month, and day from a date of birth.

Use the date diff function to compute each employee's age from their date of birth, using now or get date, demonstrated in SQL Server and MySQL with aliases.

Learn how to use the dateadd function in Microsoft SQL Server to add years or months to end dates, including filtering non-null values and creating aliases.

Learn the MySQL date_add syntax to add intervals like one year or two months to dates, and compare outcomes with Microsoft SQL Server.

Explore data types conversion functions, including cast and convert, for on-the-fly, temporary type changes in SQL Server to enable concatenation of integer and character columns, with practical examples.

Explore how the concat function in MySQL and Microsoft SQL Server merges project name and budget into a column, handling different data types and inserting a space via select statement.

Learn how to create a view in SQL, a virtual table saved from a select query, to secure data and simplify complex joins for beginners.

Create a view in Microsoft SQL Server from a select query to show number of employees per department, grouping by department name, removing conditions and order by, query the view.

Learn how commit and rollback work in SQL, using begin transaction in Microsoft SQL Server and start transaction in MySQL to confirm or revert changes on a project table budget.