Book Image

Microsoft SQL Server Development for Everyone [Video]

By : Trevoir Williams
5 (1)
Book Image

Microsoft SQL Server Development for Everyone [Video]

5 (1)
By: Trevoir Williams

Overview of this book

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-
Table of Contents (9 chapters)
Chapter 2
Environment Setup
Content Locked
Section 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.