Microsoft SQL Server Development for Everyone

By: Trevoir Williams

Write A Review

eText | 30 October 2020 | Edition Number 1

At a Glance

Format
PDF

eText

$221.09

or 4 interest-free payments of $55.27 with

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

With the help of a school management database system, you will learn how to work with SQL Server to manipulate data and databases.

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

Book 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.

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

Who this book is for

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.