Microsoft SQL Server 2017 Database Training For Beginners

Explore an introduction to Microsoft SQL Server, database concepts, SQL Server installation, and an overview of SQL Server Management Studio.

Learn how SQL, the structured query language and ANSI standard, lets you access and manipulate relational databases, create and drop databases and tables, insert, update, delete records, and set permissions.

Learn to install SQL Server 2017 from the Microsoft site, choose custom media, set mixed authentication, name your instance SekharSQL, and install and connect with SQL Server Management Studio.

Learn to use SQL Server Management Studio to connect to a database engine, choose authentication, explore object explorer, and work with databases, tables, views, and new queries.

Explore sql basics, sql server, ssms, and sql server 2017 installation; learn database structure, locating databases, tables, stored procedures, functions, and how to execute and switch queries.

Learn how to create a SQL server instance in the cloud using AWS and Microsoft Azure, introducing cloud database concepts for beginners.

Discover how Amazon RDS for SQL Server deploys, backs up, and scales SQL Server in the cloud, with editions from Express to Enterprise and a free usage tier.

Set up a Microsoft Azure free account, access credits and always-free services, and create and connect to an Azure SQL database with firewall rules and basic pricing.

Explore create, alter, and drop database operations using SQL syntax and GUI in SQL Server 2017 for beginners.

Create, alter, and drop databases using SQL syntax in SQL Server 2017, with examples like MyLearningDB and the commands that show command(s) completed successfully.

Learn how to drop a database that is in use by switching to master, forcing single-user mode with rollback immediate, and closing existing connections before retrying the drop.

Create, rename, and drop databases using SQL Server Management Studio's GUI, including handling backups and connections. Practice SQL syntax for interview readiness and production environments.

Learn to create, alter, and drop databases using SQL syntax and GUI, including renaming OrganizationDB, handling in-use errors, and switching between single-user and multi-user modes with rollback immediate.

Practice creating, renaming, and deleting the SchoolManagement database using SQL syntax and the GUI; no answers are provided—review the lessons for solutions.

Explore tables in SQL Server 2017: learn what a table is, what it contains, and how to create, alter, and drop tables using both SQL syntax and GUI.

Explore how tables in SQL Server store data as columns and rows, define column data types, compare char and nchar with varchar and nvarchar, and note the maximum 1024 columns.

Learn to create, alter, and drop tables in SQL Server using practical syntax, including adding, renaming, and changing column data types, and deleting tables.

Create, alter, and drop a table using the SQL Server GUI, adding columns like student id and country, while noting design mode limits and the need for SQL queries.

Create, alter, and drop tables with SQL syntax or GUI. Rename columns or tables; Unicode with nchar or nvarchar; max 1024 columns per table and unlimited rows.

Practice self-paced sql tasks by creating and modifying a students table, fix the address data type to accept text, rename to StudentAddress and StudentInfo, and repeat the steps via gui.

Learn data manipulation language (DML) for SQL Server to insert, update, delete, and select data using simple queries.

Learn the insert command and insert into syntax to add records, with or without column lists, and how to insert from another table, including not null handling.

Master the update command to modify existing records using update table_name set column=value with a where condition, including updating multiple columns and avoiding updating all rows.

Learn how to delete specific records with where clauses, compare delete and truncate commands, and understand locks, triggers, and rollback implications in SQL Server.

Master the select statement and where clause, and apply in, between, greater than, and less than operators. Explore union, exists, order by, top, distinct, group by, having, and null values.

Filter customer data using greater than or equal, less than or equal, and between operators to target age ranges. Use like, in, and subqueries to search names and countries.

Use subqueries in a column to count orders per product, with table aliases that improve readability, and understand COUNT performance versus using count(*) in SQL Server.

Learn how to combine conditions with and, or, and not in the where clause, compare values with like and !=, and merge results using union and union all.

Master select command techniques such as exists and not exists, order by, top, distinct, group by with having, and handling null values.

Download the students-table-data.sql file and run it in SQL Server Management Studio to create the Students table. Practice selecting, inserting, updating, deleting, and filtering by name or violations.

Explore advanced table concepts—primary key, foreign key, unique key, and check constraints—with practical examples and identity columns using seed, increment, and identity_insert for updating by customer id.

Explore how to enforce data integrity in SQL Server by using unique keys and primary keys on a country table, preventing duplicates, handling nulls, and understanding index behavior.

Explore how null values and not null constraints enforce mandatory fields, primary key and foreign key relationships, and default and check constraints for data integrity in SQL Server 2017.

Practice building a SQL Server database by creating students and products tables with auto generated ids, and a product ratings table with foreign key checks, rating 1–5, and mandatory comment.

Learn how to use line comments and block comments in SQL Server to explain queries and temporarily disable code, using -- and /* */, with practical examples.

Learn how to use joins to combine rows from two or more tables based on a related column, and explore inner, left outer, right outer, full outer, cross, and self joins.

Master inner join syntax to retrieve matching records from two tables using a common column. See examples with employee and department, and understand aliasing and null behavior.

Learn how left outer join returns all records from the left table and matched records from the right table, with nulls when no match.

Explains right outer join syntax, returning all records from the right table and matched data from the left table, with nulls for unmatched left rows, using department and employee examples.

Explore full outer join, which returns all records from both tables, including unmatched rows, by mixing inner, left outer, and right outer joins.

Perform a cross join to produce the Cartesian product of two tables, yielding 50 rows from 10 rows in the employee table and 5 in the department table.

Learn how to perform a self join by joining the employee table to itself using aliases, to display each employee with their manager’s name.

Practice self-guided SQL tasks in SQL Server 2017 by creating a database, loading product-rating-data.sql, and querying categories with products, mobile category ratings and comments, and users with parent names.

Learn to create, alter, and drop stored procedures in SQL Server, with and without parameters, and execute them. Use conditional logic and case statements for flexible customer searches.

Explore dynamic sql in stored procedures, building runtime queries with optional parameters, using sp_executesql and nvarchar for safe execution, and the 1=1 technique to compose flexible where clauses.

Practice time: download and run the product-rating-data.sql file to create the database and tables. Build and refine stored procedures for insert, update, delete, and search, including dynamic queries.