Introduction to database concepts - SQL Server

Install SQL Server engine and SQL Server Management Studio using express edition, a free relational database management system, and learn to open SQL Server, connect to engine, and navigate basics.

Navigate SQL Server with the management studio, connect to the database engine, access object explorer, and run SQL queries in new query windows while understanding server basics and system databases.

Explore database normalization and its purpose, focusing on first normal form, where a unique column such as a student id uniquely identifies records to simplify search, update, and insert operations.

Learn the second normal form by splitting student and course data, using a unique student ID to relate records, and apply these normalization concepts in SQL Server.

Create a database using SQL Server Management Studio or SQL query, naming training database, with a primary data file and a log file, and observe their default paths and extensions.

Explore basic database objects including tables, views, and stored procedures, and learn how they organize, view, and manipulate data across databases.

Create tables in SQL Server Management Studio and SQL queries, defining a student table with id, full name, gender, and birthdate, setting data types and a primary key.

Insert data into tables using SQL Server Management Studio or SQL queries, handle data types, enforce primary key constraints, and resolve duplicate key errors, then verify records.

Learn to read data from a database with sql queries, using select star to view all columns or specify columns like student id and full name from the student table.

Create views in SQL Server to simplify data reading, selecting specific columns from a table, and preview results with generated SQL queries.

Update data in SQL Server tables using the update statement, with set and where clauses to target specific rows. See examples updating student IDs and genders to illustrate safe changes.

Delete records from a SQL Server table using a where clause on the student ID. Explore the four database operations insert, select, update, and delete, and preview a stored procedure.

Learn how to create a simple stored procedure in SQL Server that inserts, updates, and selects data within a student table, and understand its role in encapsulating business logic.

Learn to retrieve the top n records in SQL Server, with examples from a students table and a preview that sorting will be covered in the next lesson.

Learn to sort records in SQL Server by gender using order by, choose top five male or female records, and switch between ascending and descending orders to refine results.

Learn how to narrow data with the where clause, filter by gender, sort by birth date, and select the top three youngest male students in SQL Server.

applies the second normal form to a sql server database by splitting student and course data into separate tables and introducing a student_course table linked by student id.

Create a view to select data from multiple tables, linking students and their courses by student id to display student details alongside course information.