Description

This course covers the essential topics necessary for working with Microsoft SQL Server. You will understand the various scenarios and techniques to write queries and build and administer databases, along with delving into advanced SQL topics that are in great demand in the industry.

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. All the resources and supportive files are available at:
https://github.com/PacktPublishing/Microsoft-SQL-Server-Development-for-Everyone-

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.

Approach

This practical course will help you get started with the fundamentals of database design and development using Microsoft SQL Server. Featuring examples, real-world scenarios, exercises, and more, it will help you get hands-on experience in developing Microsoft SQL databases and querying.

Key Features

Understand basic and advanced database operations and become familiar with SQL Server * Explore best practices in database development using SQL Server Express * Learn how to craft flawless SQL queries based on real-world scenarios

Github Repo

https://github.com/PacktPublishing/Microsoft-SQL-Server-Development-for-Everyone-

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.

Course Outline

1. Introduction

1. Introduction to SQL Server and Databases

This video provides an introduction to SQL Server and databases.

2. Understanding Types of Data and Storage

This video helps you with understanding different types of data and storage.

2. Environment Setup

1. Download and Install SQL Server Express (Windows)

This video demonstrates how to download and install SQL Server Express on Windows machines.

2. Download and Install SQL Server Express on Mac and Linux

This video demonstrates how to download and install SQL Server Express on Mac and Linux machines.

3. Understanding the Toolset

1. Explore SQL Server Management Studio

This video helps you explore SQL Server Management Studio (SSMS).

2. Explore Azure Data Studio

This video demonstrates and explores Azure Data Studio.

3. Explore Draw.io

This video takes a tour of Draw.io.

4. Creating and Manipulating Databases

1. Section Overview

This video provides an overview of the section.

2. Create a Database Using Management Studio

This video explains how to create a database using Management Studio.

3. Create a Database Using SQL Script

This video explains how to create a database using SQL Script.

4. How to Remove a Database

This video demonstrates how to remove a database.

5. How to Change Database Name

This video explains how to change the database name.

6. Section Review

This video helps you with the section review and conclusion.

5. Managing Tables and Data

1. What Is a Database Table?

This video explains the database table and its application.

2. Create Entity Data Model

This video explains how to create the Entity Data model.

3. Create a Database Table Using Management Studio

This video explains how to create a database table using Management Studio.

4. What Is SQL?

This video talks about SQL in detail.

5. Create a Database Table Using SQL Script

This video explains how to create a database table using SQL Script.

6. Review Table Creation

This video demonstrates how to review table creation.

7. Insert Data into the Table Using Management Studio

This video helps you with inserting data into the table using Management Studio.

8. Insert Data into the Table Using SQL Scripts

This video focuses on inserting data into the table using SQL Scripts.

9. Select Data from Tables - Simple Queries

This video explains how to select data from tables; we will focus on simple queries.

10. Select Data from Tables - Adding Filtering

This video explains how to select data from tables; we will focus on adding filtering.

11. Select Data from Tables - Exporting Data

This video explains how to select data from tables; we will focus on exporting data.

12. Update Data in Tables

This video explains how to update data in tables.

13. Delete Data from the Tables

This video explains how to delete data from the tables.

14. SQL Transactions

This video explains SQL transactions in detail.

15. Review CRUD Operations

This video explains how to review CRUD operations.

6. Normalization, Relationships, and Foreign Keys

1. What Are Relationships, Foreign Keys, and Normalization?

This video talks about relationships, foreign keys, and normalization in a database.

2. Normalizing Our Database

This video is about normalizing our database.

3. Creating a Relationship in SQL Server

This video demonstrates how to create a relationship in the SQL Server.

4. Inserting Records in One-to-Many Related Tables

This video helps you with inserting records in one-to-many related tables.

5. Inserting Records in Many-to-Many Related Tables

This video helps you with inserting records in many-to-many related tables.

6. Using Inner Joins to Read Related Data

This video explains how to use inner joins to read related data.

7. Understanding Left, Right, and Full Joins

This video helps you in understanding left, right, and full joins.

8. Foreign Key Cascade Options

This video explains the foreign key cascade options.

9. Section Review

This video focuses on the section review and conclusion.

7. GROUP BY and Aggregate Functions

1. Grouping Data Using the SQL GROUP BY Clause

This video explains how to group data using the SQL GROUP BY clause.

2. SQL COUNT Aggregate Function

This video explains the SQL COUNT aggregate function.

3. SQL AVG Aggregate Function

This video focuses on the SQL AVG aggregate function.

4. SQL MAX and MIN Aggregate Functions

This video explains the SQL MAX and MIN aggregate functions.

5. SQL SUM Aggregate Function

This video talks about the SQL SUM aggregate function.

6. Filtering on Aggregate Values

This video explains how to filter on aggregate values.

8. Advanced SQL Server Objects and Concepts

1. Section Overview

This video provides an overview of the section.

2. Creating and Managing Views

This video explains how to create and manage views.

3. Scalar Valued Functions

This video explains the scalar valued functions.

4. Inline Table-Valued Functions

This video focuses on the inline table-valued functions.

5. Multi-Statement Table-Valued Functions

This video explains the multi-statement table-valued functions.

6. Stored Procedures

This video focuses on stored procedures.

7. Table Triggers

This video talks about the table triggers and their application.

8. Generating Database Scripts

This video helps in generating database scripts.

9. Database Backup and Restoring

This video sheds light on database backup and restoration.

9. SQL Server Security

1. Section Overview

This video provides an overview of the section.

2. Create a SQL User Login

This video explains how to create a SQL user login.

3. Add Windows Authenticated Login

This video explains how to add Windows authenticated login.

4. Add Server Logins with Script

This video explains how to add server logins with script.

Course Images

Microsoft SQL Server Development for Everyone

By Packt

Booking options

Highlights

Description

Course Content

About The Provider

Tags

Reviews