Learn Microsoft SQL Server
4.3 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
13 students enrolled

Learn Microsoft SQL Server

Learn about Microsoft's most popular database platform, become an expert in managing and querying data.
4.3 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
13 students enrolled
Created by Fiach Reid
Last updated 3/2020
English
English, French, 3 more
  • German
  • Portuguese
  • Spanish
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will learn how to use the Microsoft SQL server database platform
Requirements
  • Students will require a Windows PC that meets the minimum specifications for installing Microsoft SQL server
Description

Microsoft SQL server is the most popular database platform for Windows, and with this course, we will take you from absolute beginner to expert in just under six hours of hands-on experience.

We begin by teaching you how to install your own free copy of SQL server on your own machine, or if you prefer, to host SQL server on the cloud with Amazon Web Services or Microsoft Azure.

Following on, we teach you how to create tables, insert rows, update and delete them, and read them back. You'll quickly learn how to write queries to filter and sort data, to group and summarize data, to run statistical queries on the data.

Once you've mastered the basics, we show you how to create database triggers, to manage transactions, and how to wrap up complex code as simpler code using stored procedures and user defined functions.

But, it's not all about database development, we also teach you about database adminstration, how to backup and restore your database, and more importantly, transfer your backups to the cloud, like AWS S3 or Azure Blob storage.

We also teach you about database tuning, how to make your queries run faster, and make your system more performant, and about database security, how to protect your data, and comply with data protection laws like GDPR and CCPA.

And to wrap up, we teach you how to connect to SQL server from four different programming languages, Microsoft C# .NET Core, Node JS, Python and Java.

Who this course is for:
  • Students interested in learning about the Microsoft SQL server database platform
Course content
Expand 12 lectures 05:45:33
+ Introduction
12 lectures 05:45:33

This introduction to Microsoft SQL server will take you though the process of installing SQL server on your own computer, and also how to set up SQL server in a cloud environment, like Microsoft Azure or Amazon Web Services (AWS).

Step-by-step, we will you how to:

  • Download Microsoft SQL Server Express for free

  • Download and Install Microsoft Management Studio for SQL server

  • How to log in to SQL server

  • How to create your first database

  • Create a database in the cloud with Microsoft Azure

  • Create a database in the cloud with Amazon AWS

Preview 14:56

The primary purpose of a database is to store data, read back that data, and be able to update and delete that data when it is no longer needed. This first hands-on lesson will step you though these basic operations.

In this lesson we will learn;

  • An introduction to the data types of SQL server

  • Creating a table

  • Inserting a record into a table

  • Reading back data stored in a table

  • Updating data stored in SQL server

  • Deleting data from SQL server


Preview 26:46

When you are modelling a real world scenario in a database, then related sets of data naturally emerge. Be it customers and accounts in a bank, or students and books in a library. This lesson introduces the concept of relationships, and how they are represented and used within SQL server.

The key learning objectives are;

  • Understanding database diagrams.

  • One-To-One relationships

  • One-To-Many relationships

  • Many-To-Many relationships

  • Introduce joins in SQL server



Preview 38:20

When you start developing a real-world application using SQL server, you will need to know how to perform sorting and filtering operations on your data. This lesson will gradually introduce you to more advanced SQL queries.

The key objectives of this lesson will be to teach you;

  • Comparison queries (more than, less than, and like)

  • Ordering results

  • Date operations

  • Subqueries - queries within queries

  • Union - combining results of queries.

Preview 25:11

Summarizing and grouping data is a very common operation that is required of SQL server. Here we will introduce the concept of aggregate data, and how grouping can be used to sumarize data.

We will introduce the following SQL server operations;

  • Counting records in a group.

  • Averaging and summing the values of records in a group

  • Finding the minimum, maximum and standard deviation of values

  • Filtering on aggregate results

Grouping - understanding aggregate queries
12:18

Triggers are operations that happen in response to another action, such as an insert, update or delete.

Transactions are a means of ensuring the atomicity of related actions, such as a debit from one account, and a credit in another.

In this lesson, we introduce both of these concepts in detail, or more specificially;

  • Update, Insert and Delete triggers

  • How to enable and disable triggers

  • Demonstrate how a database transaction works.

  • Rolling back a failed transaction.

Triggers and transactions
24:00

As your database becomes more complex, you will need ways of encapsulating complex queries and actions in more simple actions, so that users of your database can operate it at a higher level, without needing to know the nitty-gritty of underlying operations.

We introduce in this lesson three key features of SQL server that allow complex SQL statments to be encapsulated in more simple structures.

Firstly, we learn about stored procedures, which allow compex SQL statments to be written in one line, as well as optimizing the statements for performance at the same time.

Secondly, we are introduced to user defined functions, which are a way to encapsulate complex operations into one simple operation that can be used within queries or stored procedures.

And finally, we learn about views, which are a SQL feature that allow complex SQL select statments be treated as if they were a simple table.

The learning objectives of this lesson are;

  • Learning about temporary tables

  • How data can be transferred to temporary tables.

  • Creating a view to demonstrate their use and functionality

  • An introduction to Stored procedures, and how they are used.

  • Writing a User Defined Function, to understand it's use

  • Using the in-built stored procedures sp_help and sp_helptext

Stored procedures, User defined functions and views
28:37

Your database will likely be connected to the operation of a website, or software application at some point, and the responsiveness of the website or software will likely depend substantially on the performance of your database. Making sure your database operates at maximum performance is of utmost importance.

Although you can always make your database operate faster by putting more RAM or CPU power into the underlying hardware, there are some very important optimisations that you should be aware of, that can offer magnitudes of performance improvement.

Here we introduce the lesson with a quick set up of a large database, and show three key performance optimisations that could make all the difference in your application

The learning objectives of this lesson are:

  • Using CSV import to create a larger database from a flat file

  • Using Indexes to optimise query performance

  • Learning three top query optimisation tricks and tips.

  • Demonstration of SQL server profiler

Performance - Making your database respond faster.
33:15

Your database will undoubtedly hold important data that may be irreplaceable, and it is extremly important for a database administrator to ensure that your data is keep safe and secure.

In this lesson, we will step you through backing up and restoring a database, and going beyond the basics, we explain how to transfer your data off your database server, and store it on the cloud, either AWS or Azure.

The learning objectives of this lesson are;

  • Backing up your database

  • Restoring your database from backup

  • Shrinking and re-indexing data

  • Maintenance plans

  • Detaching and reattaching database files

  • Exporting data to other formats

  • Zipping your data

  • Transferring to Amazon Web Services S3 Storage

  • Transferring to Microsoft Azure Blob storage


Maintenance - Making sure you don't loose your data
49:38

When you want to perform an operation on your database on a fixed schedule, like a nightly update of records, then you can use SQL server jobs to schedule this work.

The learning objectives of this lesson are;

  • Introduction to SQL server jobs

  • Viewing Job history

  • Understanding SQL server agent


Jobs - scheduling operations on your database
09:02

Keeping your data secure keeps private information out of the hands of illicit parties, and also helps you comply with international data privacy regulations, such as GDPR.

We introduce this lesson with a description of the SQL server login system, and how you can use it to allow more granular access to your data, so that certain users can only see certain data. 

Following this, we look at how to lock down access to SQL server, by using a firewall, hashed passwords, and data-at-rest encryption.

We give a very brief overview of international data privacy regulations that may apply to your data, such as GDPR and CCPA.

The learing objectives of this lesson are:

  • Learning the difference between SQL server and Windows Authentication

  • Setting up granular access to your data by using users, logins and roles.

  • Securing remote access to your SQL server, using Window Firewall

  • How to securely store passwords in your database using Hashing

  • Learn about data privacy regulations like GPPR and CCPA

  • Apply data-at-rest encryption using TDE.



SQL server security
33:08

As a final lesson in this course, we shall teach you how to connect to SQL server using four different  programming languages.

The learning objectives of this lesson are;

  • Connecting to SQL server using Microsoft C# .NET Core

  • Connecting to SQL server using Node JS

  • Connecting to SQL server using Python

  • Connecting to SQL server using Java

Connecting to SQL Server from Code
50:22