Keep Calm and Study On - Unlock Your Success - Use #TOGETHER for 30% discount at Checkout
Testprep Training

Microsoft SQL Server Online Course

Microsoft SQL Server Development for Everyone

Do you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data? This video will help you learn about Microsoft SQL Server 2017, including the features and functionalities that are needed to design and develop reliable database systems.

The course starts with an introduction to SQL Server and databases and takes you through the installation of SQL Server Express 2017. Once you are ready with the set-up, you will learn to connect to a database instance and create a database and tables inside the database. As you advance, you will learn to run queries against tables to manipulate tables and data and create relationships in the SQL Server with foreign keys and normalization. Later, you will be able to perform mathematical operations using aggregate functions, such as AVG, COUNT, MAX, and SUM. Finally, you will get to grips with advanced SQL Server objects and concepts, such as views, triggers, stored procedures, database scripting, and more.

By the end of this course, you will be well-versed with SQL Server 2017 and have developed the skills to write SQL queries for manipulating databases.


Course Curriculum

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

Tags: Microsoft SQL Server Online Course