Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

PacktPub Microsoft SQL Server Development for Everyone

Video Introducing this tutorial


Introduction:
Introduction to SQL Server and Databases
Download and Install SQL Server Express 2017

Manipulating Tables and Data:
Connecting to a Database Instance and Creating a Database
Dropping or Removing a Database
What is a Database Table?
Creating an SQL Database Table
Inserting Data into the Table Using an SQL Script
Inserting Data into the Table Using Management Studio
Selecting Data from the Table Using an SQL Script
Advanced Select Queries
Updating Data in the Table
Updating Data in the Table Using the Management Studio GUI
Deleting Data from the Table Using an SQL Script
Deleting Data from the Table Using the Management Studio GUI

Relationships and Foreign Keys:
What are Relationships, Foreign Keys, and Normalization?
Creating a Relationship in SQL Server
Inserting Records in Related Tables
Running Queries on Related Tables (Inner Join)
Left, Right, and Full Join

GROUP BY and Aggregate Functions:
Grouping Data using the SQL GROUP BY Clause
SQL AVG Aggregate Function
SQL COUNT Aggregate Function
SQL MAX and MIN Aggregate Functions
SQL SUM Aggregate Function

Advanced SQL Server Objects and Concepts:
Creating and Managing Views
Scalar Valued Functions
Inline Table-Valued Functions
Multi Statement Table-Valued Functions
Stored Procedures
Table Triggers
Database Scripting, Backup, and Restoring