Microsoft SQL Server Development for Everyone

Microsoft SQL Server Development for Everyone

by Trevoir Williams
Released January 2023
Publisher(s): Packt Publishing
ISBN: 9781801078559

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Do you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data? This course will help you learn about Microsoft SQL Server, 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. Once you are ready with the setup, 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 in using SQL Server and have developed the skills to write SQL queries for manipulating databases.

What You Will Learn

  • Install SQL Server and SQL Server Management Studio
  • Create, manipulate, and connect databases
  • Export data to Excel using SQL Server Management Studio
  • Create and manage database views
  • Explore custom functions, table views, and stored procedures
  • Find techniques to back up and restore databases

Audience

This course is for beginner- and intermediate-level database developers and administrators who are looking to create, manipulate, and connect databases using Microsoft SQL Server.

This course is for the individual who is already comfortable with fundamental database operations.

There are no prerequisites for this course as it provides you with fundamental SQL Server training.

About The Author

Trevoir Williams: Trevoir Williams is a software engineer and part-time lecturer. With a master’s degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration.

He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.

Table of contents

  1. Chapter 1 : Introduction
    1. Introduction to SQL Server and Databases
    2. Understanding Types of Data and Storage
  2. Chapter 2 : Environment Setup
    1. Download and Install SQL Server Express (Windows)
    2. Download and Install SQL Server Express on Mac and Linux
  3. Chapter 3 : Understanding the Toolset
    1. Explore SQL Server Management Studio
    2. Explore Azure Data Studio
    3. Explore Draw.io
  4. Chapter 4 : Creating and Manipulating Databases
    1. Section Overview
    2. Create a Database Using Management Studio
    3. Create a Database Using SQL Script
    4. How to Remove a Database
    5. How to Change Database Name
    6. Section Review
  5. Chapter 5 : Managing Tables and Data
    1. What Is a Database Table?
    2. Create Entity Data Model
    3. Create a Database Table Using Management Studio
    4. What Is SQL?
    5. Create a Database Table Using SQL Script
    6. Review Table Creation
    7. Insert Data into the Table Using Management Studio
    8. Insert Data into the Table Using SQL Scripts
    9. Select Data from Tables - Simple Queries
    10. Select Data from Tables - Adding Filtering
    11. Select Data from Tables - Exporting Data
    12. Update Data in Tables
    13. Delete Data from the Tables
    14. SQL Transactions
    15. Review CRUD Operations
  6. Chapter 6 : Normalization, Relationships, and Foreign Keys
    1. What Are Relationships, Foreign Keys, and Normalization?
    2. Normalizing Our Database
    3. Creating a Relationship in SQL Server
    4. Inserting Records in One-to-Many Related Tables
    5. Inserting Records in Many-to-Many Related Tables
    6. Using Inner Joins to Read Related Data
    7. Understanding Left, Right, and Full Joins
    8. Foreign Key Cascade Options
    9. Section Review
  7. Chapter 7 : GROUP BY and Aggregate Functions
    1. Grouping Data Using the SQL GROUP BY Clause
    2. SQL COUNT Aggregate Function
    3. SQL AVG Aggregate Function
    4. SQL MAX and MIN Aggregate Functions
    5. SQL SUM Aggregate Function
    6. Filtering on Aggregate Values
  8. Chapter 8 : Advanced SQL Server Objects and Concepts
    1. Section Overview
    2. Creating and Managing Views
    3. Scalar Valued Functions
    4. Inline Table-Valued Functions
    5. Multi-Statement Table-Valued Functions
    6. Stored Procedures
    7. Table Triggers
    8. Generating Database Scripts
    9. Database Backup and Restoring
  9. Chapter 9 : SQL Server Security
    1. Section Overview
    2. Create a SQL User Login
    3. Add Windows Authenticated Login
    4. Add Server Logins with Script

Product information

  • Title: Microsoft SQL Server Development for Everyone
  • Author(s): Trevoir Williams
  • Release date: January 2023
  • Publisher(s): Packt Publishing
  • ISBN: 9781801078559