Microsoft SQL Server For Beginners

Explore the basics of Microsoft SQL Server, including database fundamentals, installation steps, and an overview of SQL Server Management Studio.

Learn how SQL, ANSI standard structured query language, accesses and manipulates relational databases with tables, views, stored procedures, functions, and permissions, powered by the SQL Server database engine and SSMS.

Learn to install SQL Server 2017 from downloading the developer edition to configuring a named instance, authentication modes, and installing SQL Server Management Studio to connect to the server.

Learn to navigate SQL Server Management Studio, connect to a database engine, choose authentication, explore Object Explorer, and work with databases, tables, views, stored procedures, and queries.

Understand what SQL is, why databases matter, and learn Microsoft SQL Server basics, including SSMS, installation, database structure, and running queries.

Learn how to create, alter, and drop a database using SQL syntax and GUI, with practical guidance on database management tasks.

Learn to create, alter, and drop databases using SQL syntax with create database, alter database, and drop database commands, demonstrated on MyLearningDB and its rename to MyLearning.

Learn how to drop a database when it's in use by closing existing connections with single_user with rollback immediate, switching to master, and then executing drop database.

Create, rename, and delete databases using GUI in SQL Server Management Studio; right-click databases, enter a name, rename, and close existing connections when deleting, while practicing SQL syntax.

Learn to create, alter, and drop databases using SQL syntax and GUI, rename databases, and manage single-user and multi-user modes with rollback immediate.

Practice self practice exercises to create, rename, and delete a database using SQL syntax and the GUI for SchoolManagementDB and SchoolManagement. No answers are provided; revisit lessons if you're stuck.

Learn the fundamentals of tables in SQL Server, including what a table contains, and how to create, alter, and drop tables using SQL syntax and GUI.

Understand how SQL Server tables store data in columns and rows, with each column having a name and data type. Compare fixed width (char, nchar) to variable width (varchar, nvarchar).

Learn to create, alter, rename, and drop tables in SQL Server, add or modify columns, and choose varchar, nvarchar, or char data types.

Explore creating, altering, and dropping tables in SQL Server using the GUI; learn to add columns, change data types, and manage design mode permissions for production-safe changes.

Master creating, altering, and dropping tables in Microsoft SQL Server using SQL syntax or GUI, manage columns and data types, and rename objects with sp_rename.

Practice assignments in sql and gui: create a Students table with id and name, modify Address to accept numbers and text as StudentAddress, rename table to StudentInfo, and delete it.

Explore data manipulation language (DML) commands in SQL Server, learning how to insert, update, delete, and select data with simple queries.

Master the insert command in SQL Server for beginners. Use both column-list and value forms, insert from another table, and handle not null constraints.

Learn how to use the update command to modify existing records in a table, including multiple column updates, and always include a where clause to avoid updating all rows.

Learn to use delete and truncate commands to remove data, including delete with a where clause and truncate of a table, and compare their dml vs ddl and rollback implications.

Explore basic select statements and where filtering in SQL Server, using in, between, greater than, less than, union, exists, order by, top, distinct, group by, having.

Filter data in SQL Server using >=, <=, and between for age ranges, and apply like with wildcards and in with subqueries to retrieve related records.

Learn to embed subqueries in a column to compute total orders per product, using aliases to rename columns and tables. Explore how counts and aliases optimize queries, with practical examples.

Explore how to filter data with and, or, and not in the where clause, using country and city examples, and combine results with union and union all.

Use exists and not exists to test subqueries and control flow. Sort, top, distinct, group by, having, and manage null values in SQL queries.

Practice SQL on a sample database by running the students-table-data.sql script to manage the Students table. Execute selects, inserts, updates, and deletes to reinforce beginner SQL concepts.

Explore advanced table concepts like primary key, unique key, foreign key, and check constraint, with identity columns and updating records by customer id.

Learn how unique keys and primary keys enforce uniqueness on the country table's CountryId Char(2), handle not null versus null, and apply create, alter, and drop constraint operations.

Master advanced table concepts in SQL Server, including not null and foreign key constraints, default values with getdate and newid, and check constraints to enforce data integrity.

Practice self-paced SQL work by building students and products tables, adding a ratings table with referential integrity, rating 1–5, mandatory comments, and an isPublished flag defaulting to N until approved.