SQL Server Fundamentals (SQL Database for Beginners)
3.8 (28 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.
74 students enrolled

SQL Server Fundamentals (SQL Database for Beginners)

A beginners guide that helps you get started with SQL Server Database and its client tools on both Windows and Linux.
3.8 (28 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.
74 students enrolled
Last updated 7/2020
English
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 8 articles
  • 12 downloadable resources
  • 1 Practice Test
  • 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
  • What is SQL Server and what you can do with it.
  • How to download, install and get started with SQL Server on both Windows and Linux.
  • How to create databases, tables, views, functions, stored procedures and run queries.
  • Basic database principles of RDBMSs.
  • Available editions of SQL Server. What is free and what is not.
  • Basic SQL Server security concepts such as: logins, database users, surface area configuration and more.
  • How to use SQL Server Management Studio for connecting to SQL Server and working with it.
  • How to run basic data import/export operations in SQL Server.
  • How to use Azure Data Studio on both Windows and Linux.
Course content
Expand all 49 lectures 04:07:08
+ Introduction to the Course
1 lecture 04:40

This is the introduction to the course. We will talk about what will you learn after completing this course.

Preview 04:40
+ Basic Database Principles
5 lectures 13:44

This lecture, is an overview of what you will learn in this section.

Section Overview
00:53

In this lecture, we will talk about what Relational Management Systems are (RDBMSs).

Preview 02:19

In this lecture, we will talk about databases, tables, queries, views and other SQL Server programmability objects.

Databases, Tables, Queries, Views and Programmability Objects
06:54

In this lecture, we will talk about SQL and T-SQL, and see script examples using these two languages.

Preview 02:28

This lecture, summarizes what you've learned in this section.

Section Recap
01:10

Test your knowledge on basic database principles!

Basic Database Principles
4 questions
+ SQL Server Data Platform
6 lectures 34:50

This lecture, is an overview of what you will learn in this section.

Section Overview
00:43

In this lecture, we will talk about what you can achieve by using SQL Server.

Preview 04:14

In this lecture, we will talk about the main SQL Server services such as the SQL Server Database Engine, SQL Server Agent, and more.

Main SQL Server Services
05:16

In this lecture, we will talk about the supported Operating Systems for the current versions of SQL Server.

Supported Operating Systems
03:57

In this lecture, we will talk about how we can install SQL Server.

Installing SQL Server
19:14

This lecture, is a summary on what you've learned in this section.

Section Recap
01:26

Test your knowledge on SQL Server Data Platform!

SQL Server Data Platform
4 questions
+ Using SQL Server Management Studio
8 lectures 01:07:19

This lecture, is an overview of what you will learn in this section.

Section Overview
00:53

In this lecture, we will talk about SQL Server Management Studio, which is Microsoft's well-established Integrated Environment for working with SQL Server on premises and on cloud.

What is SQL Server Management Studio?
02:07

In this lecture, we will see how we can download and install the latest version of SQL Server Management Studio.

Downloading and Installing SQL Server Management Studio
05:35

In this lecture, we will talk about how we can connect to the SQL Server Database Engine, using SQL Server Management Studio.

Connecting to the Database Engine and Navigating Through Database Objects
05:26

In this lecture, we will see how we can create databases and other objects in SQL Server using SQL Server Management Studio.

Creating a Database and Other Objects
17:09

In this lecture, we will see how we can run queries against SQL Server using SQL Server Management Studio, as well as how we can script different wizard-based procedures to T-SQL code.

Running Queries and Scripting to T-SQL
17:33

In this lecture, we will talk about the available methods for importing and exporting data in SQL Server, using SQL Server Management Studio and other related tools.

Importing and Exporting Data
17:25

This lecture, is a summary of what you've learned in this section.

Section Recap
01:11

Test your knowledge on SQL Server Management Studio!

SQL Server Management Studio
4 questions
+ Basic SQL Server Security Concepts
4 lectures 26:23

This lecture, is an overview of what you will learn in this section.

Section Overview
01:04

In this lecture, we will talk about SQL Server security, and most specifically, about SQL Server logins and database users.

Logins and Database Users
17:53

In this lecture, we will talk about SQL Server Surface Area, and how you can check which features are enabled by default.

Preview 06:17

This lecture, is a summary of what you've learned in this section.

Section Recap
01:09

Test your knowledge on SQL Server Security!

SQL Server Security
4 questions
+ Using Azure Data Studio
5 lectures 17:11

This lecture, is an overview of what you will learn in this section.

Section Overview
00:47

In this lecture, we will talk about Azure Data Studio, which is Microsoft's cross-platform tool, for working with SQL Server on premises and on cloud.

Preview 03:21

In this lecture, we will see how we can download and install the latest version of Azure Data Studio.

Downloading and Installing Azure Data Studio
03:27

In this lecture, we will see how we can work with SQL Server using Azure Data Studio.

Working with SQL Server using Azure Data Studio
08:10

This lecture, is a summary of what you've learned in this section.

Section Recap
01:26

Test your knowledge on Azure Data Studio!

Azure Data Studio
4 questions
+ SQL Server on Linux
7 lectures 48:21

This lecture, is an overview of what you will learn in this section.

Section Overview
01:09

In this lecture and demo, we will see step by step, how we can install SQL Server 2019 CTP 3.0 on Ubuntu Linux 19.04.

How to Install SQL Server on Ubuntu Linux
08:34

In this lecture and demo, we will see how we can install the SQL Server command-line tools on Ubuntu Linux.

How to Install the SQL Server command-line tools on Ubuntu Linux
05:27

In this lecture and demo, we will see how we can access SQL Server 2019 on Ubuntu Linux, using Azure Data Studio.

How to Access SQL Server on Ubuntu Linux using Azure Data Studio
09:47

In this lecture and demo, we will see step by step, how we can perform an offline installation of SQL Server 2019 (CTP 3.1) on Ubuntu Linux.

How to Perform an Offline Installation of SQL Server 2019 on Ubuntu Linux
11:35

In this lecture and demo, we will see how we can install SQL Server on CentOS Linux version 8.

How to Install SQL Server on CentOS Linux
10:51

This lecture, is a summary on what you've learned in this section.

Section Recap
00:58

Test what you have learned in this section!

SQL Server on Linux
4 questions
+ Special Topics
11 lectures 25:22

A few words about the "Special Topics" section.

Preview 00:13

In this lecture/live demonstration, we create a sample database called "SampleDB1" in order to be used for all the demos in the "Special Topics" section.

Create the Sample Database for Special Topics Demos
03:35

In this lecture/live demonstration, we import data into our sample database, using the OPENROWSET function.

Importing Data in SQL Server Using the OPENROWSET Function
03:58

In this lecture/live demonstration, we import and export data in SQL Server, using SQL Server Integration Services (SSIS).

Importing & Exporting Data Using SQL Server Integration Services (SSIS)
11:31

In this special topic, you can learn more about the benefits of using primary keys in database tables.

Benefits of Primary Keys in Database Tables
01:22

In this special topic, you can learn more about indexes in SQL Server and why they so important.

The Importance of Database Indexes
01:06

In this special topic, you can learn what is the difference between SQL and SQL Server.

Difference Between SQL and SQL Server
00:49

Learn what Always On Availability Groups are exactly in SQL Server and how they contribute to the high availability offerings of SQL Server.

What are SQL Server Always On Availability Groups?
00:57

In this special topic, you will learn about SQL Server compatibility levels.

About SQL Server Compatibility Levels
00:48

In this lecture, we discuss about the currently supported SQL Server versions. Also, you can download a relevant infographic with useful information.

SQL Server Versions Currently Supported and their Extended Support End Dates
00:41

This lecture, provides information on how you can retrieve useful information about your SQL Server instances. Moreover, it provides a T-SQL script as a downloadable resource, that can help you with this task.

How to Retrieve Useful SQL Server Instance Info via T-SQL
00:19
+ Wrap-Up
1 lecture 03:42

This lecture, is a recap of what we've learned in this course.

What We've Learned in this Course
03:42

Test your knowledge on what you've learned in this course!

Practice Test of SQL Server Fundamentals
15 questions
+ Learning More
1 lecture 05:36

Bonus lecture.

Bonus Lecture
05:36
Requirements
  • No prior knowledge of SQL Server is required.
  • It would be helpful to know some basic database-related concepts (i.e. what is a database, a table, etc.) but is not a prerequisite, since we will talk about it as well.
Description

In this beginner-level course which has been updated for 2020, you will learn how to install SQL Server Database on both Windows and Linux, and how you can start doing basic tasks in SQL Server, using its free client tools SQL Server Management Studio, and Azure Data Studio. 


WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

  • "Highly interesting topic. The updated version of the course is highly informative and comprehensive."

  • "I actually find the updated version of this course to be more interesting!!"

  • "I have enjoyed the updated version of the course. It now contains more elaborate information and new live demonstrations."

  • "A useful course for beginners."


MORE ABOUT THE COURSE:

SQL Server is one of the world's leading Data Platforms. By learning SQL Server, you get a competitive advantage when applying for different technical job positions, since knowing how to use an enterprise DBMS is a major plus.

With many live demonstrations and step by step guides, via this course, you will easily understand the main concepts in SQL Server and be able to install, configure and start using it.


AFTER THE COURSE:

  • You will know the basic database principles.

  • You will know how to download and perform a basic installation of SQL Server on Windows and Linux.

  • You will know the basic SQL Server security concepts such as surface area configuration, logins and authentication modes.

  • You will be able to connect and work with SQL Server using SQL Server Management Studio (SSMS) and Azure Data Studio.

  • You will be able to import and export data in SQL Server.

  • You will get a free checklist with the top 10 Tasks a SQL Server DBA must perform every day in order to maintain a healthy SQL Server instance.


PREREQUISITES:

  • No prior knowledge of SQL Server is required.

  • It would be helpful to know some basic database-related concepts (i.e. what is a database, a table, etc.) but is not a prerequisite, since we will talk about it as well.

  • Willingness and excitement to learn!


THIS COURSE CONTAINS/OFFERS:

  • 4 hours of high-quality video

  • May downloadable resources

  • Live demonstrations and guides that illustrate the basic concepts and functions and how to perform different tasks in SQL Server

  • Useful quizzes for testing your knowledge on each section

  • A practice test in the end of the course

  • Ability to ask the instructor questions via the Q&A section

  • Certificate on course completion


Also: This course is being updated with new material on a regular basis.

Who this course is for:
  • IT Professionals that just started using SQL Server, either for development or administration.
  • IT Professionals that want to enhance their technical skills and knowledge and enrich their resume.
  • People that want to start using SQL Server and need guidance to learn the basics.
  • Technology enthusiasts that want to explore new technology topics!