Microsoft SQL Server for Beginners | ZERO to HERO

Understand what a database is, a collection of related information. Learn how relational database management systems use sql to store and retrieve data.

Master the four basic database operations—create, read (retrieve), update, and delete—and learn how they enable adding new entries, retrieving information, updating data, and removing entries.

Understand how a database management system creates and maintains databases to store and modify vast data, enabling secure access and Facebook login interactions.

Explore how a database management system mediates between a web application and its database, enabling create, read, update, and delete operations and secure data handling.

Compare relational SQL databases with non-relational (not just SQL) databases, and learn how data is organized into tables with rows, columns, and IDs.

Explore how relational sql databases organize data into tables with a unique id, name, and profession; compare job destination and user tables with real-world examples such as Facebook login data.

Explore how relational databases work with a relational database management system and SQL, covering tables, CRUD operations, backups, security patches, and common RDBMS examples.

Explore non-relational databases, including graph, document (json/xml), and key-value stores, as NoSQL alternatives to SQL. Learn that non-relational DBMS lack a standardized query language and implement system-specific CRUD languages.

Install and configure Microsoft SQL Server and SQL Server Management Studio on your computer, download the express edition, then connect to begin creating databases, tables, and queries.

Explore database queries and how sql code powers requests to a database via the management studio, contrasting code-based queries with gui-driven searches and topics cover creating, deleting, and altering databases.

Open SQL Server Management Studio in three ways, connect to the database engine, then create and run new queries with F5, and save your work.

Master beginner concepts of Microsoft SQL Server through practice questions, apply fundamentals, and build confidence with hands-on problem solving.

Learn to create and delete databases in Microsoft SQL Server, using create database and drop database commands. Follow naming practices, execute queries, and observe capitalization conventions for standard SQL.

Create a table in an existing database using the create table command and a primary key. Use data types such as int, decimal, blob, date, and timestamp.

Create a table named students with columns student_id as primary key, name as varchar, and cost using create table, then view with select * and drop it to see removal.

Learn to insert values into a table with an insert into statement, setting the primary key student id, name, and course, then read and verify the inserted rows.

Learn how to insert values into a table, specifying columns such as student id, name, and course, create multiple rows with unique primary keys, and handle duplicate key errors.

Update rows in a student table using set and where clauses to modify course values. Verify results with a select to see the changed records.

Delete data in sql server tables with delete from and a where clause to remove specific rows (id = 5 or by name and course), or delete the entire table.

Explore more complex sql statements using the Adventureworks dataset, learn how to download, restore, and load the sample database in sql server studio, and query multiple tables.

Master the SQL select statement to retrieve all columns or specific fields from the student table, and learn how to reference schemas, switch databases, and navigate Adventure Works databases.

Learn to use the select statement to query Adventureworks 2019 database. Select all columns or specific fields like business entity ID and national ID from the human resources.employee table.

Learn how to use the where clause to filter SQL results using comparison operators, combining conditions with and/or, and applying filters on employee data in the AdventureWorks 2019 database.

Explore numeric concatenation in SQL by adding subtotal and tax amount, create aliases like al total, and apply plus, minus, and divide with a where clause.

Learn how to concatenate non-numerical values in SQL by joining first, middle, and last names with the plus operator, adding spaces, and aliasing the result as full name.

Explore how to combine and and or operators in a where clause to filter rows by multiple conditions, such as marital status and gender or job title.

Master using the in operator to test multiple values efficiently and the between operator to define value ranges, including combining with and for SQL queries.

Explore the like operator in SQL Server to filter records with patterns using the where clause and wildcards percent and underscore, including examples that match last names and job titles.

Master the order by clause in SQL to sort results by one or more columns, such as city or names, in ascending or descending order, with practical examples.

Explore core SQL functions: count, average, sum, maximum, and minimum, applied to the business entity ID in a salesperson table with practical examples using select queries.

Explore the group by clause by grouping sales order IDs and aggregating unit prices, then apply sum, avg, max, min, and count to reveal grouped totals.

Learn how to use SQL Server string functions, including concat, length, left, right, and substring, to manipulate and analyze first, middle, and last names.

Learn to use SQL Server date functions to extract day, month, and year from sales order dates and to display the current timestamp.

Learn how to combine rows from multiple tables using union and union all in SQL Server; understand data type compatibility and how union removes nulls while union all preserves them.

Learn how inner join pairs the human resources employee and person tables on business entity ID, using aliases to select first name, last name, job title, and modified date.

Master inner join to combine three or more tables using purchasing order ID and business entity ID. Use aliases to resolve column references and display the order date.

Learn how the left join (left outer join) takes all records from the left table and matches from the right table, illustrated with employee and person tables.

Explore how the right join, or right outer join, performs the inner join plus remaining data from the right table, returning matches from the left and illustrating with table swaps.

Explore the full outer join in SQL Server, which returns all records from both tables with matching records, yielding nulls where there is no match.

Finish strong by revisiting database concepts, from relational databases and database management systems to creating databases, tables, and basic and advanced sql statements, with bonus materials and datasets for practice.