The Complete Microsoft SQL Server Course: From A to Z

Relational databases use SQL, store data in tables of rows and columns, offer vertical scalability, and complex queries. Non-relational databases store data in graphs or key-value forms and scale horizontally.

Database management systems act as the middleman between users and databases, enabling commands and tasks to run through applications, and relational databases connect tables via primary and foreign keys.

Understand how tables organize data into columns and rows, with the primary key uniquely identifying records for books and employees. Learn about data relationships and normalization in database design.

Explore one-to-one relationships in SQL, using employee and salary tables to show unique links, foreign keys, and the security benefits of separating data.

Explore one-to-many relationships by separating employee and phone numbers into two tables, linking via keys like primary key and employee ID, illustrating atomic cells and normalization.

Explore many-to-many relationships in SQL by building a junction table with foreign keys, illustrated by employees and skills, and differentiate one-to-many from many-to-many in practical database design.

Create and modify tables in SQL Server by defining primary keys, varchar and int columns, and using alter table to add or drop columns, with database and table creation workflows.

Explore sql numeric data types, including bit, tinyint, smallint, int, bigint, decimal/numeric, real/float, and money, and learn how to match data values to appropriate storage and precision.

Master SQL string data types, from fixed-length char to variable-length varchar and nvarchar, and learn when to use binary and varbinary, with Unicode support and storage up to two gigabytes.

Learn about common SQL Server date and time data types, including datetime, datetime2, smalldatetime, date and time, datetimeoffset, and timestamp, and their use for time zones and concurrency.

Create a new table book_detail with id as primary key, title, year, and platform. Insert sample rows using insert into and display results with select.

Learn to use the select query in SQL to fetch data from tables, view specific columns, filter with top and distinct, and run queries on sales and book details.

Explore calculating max, min, and average values in SQL using the amount column, aliasing results, and applying arithmetic such as dividing amounts by 3 or 10 in the sales table.

Apply the where clause and SQL operators to filter data, compare IDs, ages, and amounts, and combine conditions with and for precise results.

Learn how to use the order keyword in SQL to sort data ascending or descending by a single column, such as customer name, and understand limitations on multiple columns.

Learn how to use the update statement to modify records, including replacing null values, and how to delete data, columns, and tables with drop and delete statements.

Master the like operator and its wild and light forms to pattern-match customer names using %, _ and the starts with, ends with, and contains rules in SQL Server.

Learn how wildcard operators extend logic patterns in SQL to find records, using percent, underscore, square brackets, circumflex, and dash ranges in like queries.

Explore sql constraints by using not null, unique, check, and default to enforce data validity in table design. See practical examples like age over 18 and unique usernames.

Learn how to define a primary key and a foreign key, create related tables, insert and query data, and manage table relationships with foreign keys in Microsoft SQL Server.

Explore joins in SQL, including join, left join, and right join, and full join. See how primary keys and foreign keys enable data from two tables to combine.

Apply normalization to reduce data redundancy and anomalies by using first, second, and third normal forms, separating entities, and employing bridge tables and foreign keys for one-to-many and many-to-many relationships.

Design a database from scratch by modeling suppliers, customers, products, and orders, using Lucid chart to map one-to-one, one-to-many, and many-to-many relationships and export SQL Server scripts.

Discover how to use union, union all, intersect, and except to merge and compare data across tables, including common names across celebrity, sales, and school.

Explore how SQL indexes speed data retrieval by creating clustered and non clustered indexes, and understand their relation to primary keys and updates.

Review SQL concepts from querying and sorting data with select queries to filtering, joining, and grouping tables, and understand modifying and deleting data, dropping databases, and recognizing constants and expressions.