Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL Server Fundamentals - SQL Database for Beginners

Name: SQL Server Fundamentals - SQL Database for Beginners
Rating: 4.1 (66 reviews)

Master SQL Server Databases: Your Beginner's Guide to SQL Server on Windows and Linux Platforms

Created byArtemakis Artemiou

Last updated 11/2025

English

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.
How to import/export data in SQL Server.
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 use Azure Data Studio on both Windows and Linux.

Course content

11 sections • 77 lectures • 7h 26m total length

Welcome to the course!5:19
This is the introduction to the course. We will talk about what will you learn after completing this course.

Section Overview0:53
This lecture, is an overview of what you will learn in this section.
Relational Database Management Systems2:19
In this lecture, we will talk about what Relational Management Systems are (RDBMSs).
Databases, Tables, Queries, Views and Programmability Objects6:54
In this lecture, we will talk about databases, tables, queries, views and other SQL Server programmability objects.
SQL vs T-SQL: What’s the Difference?2:28
In this lecture, we will talk about SQL and T-SQL, and see script examples using these two languages.
Section Recap1:10
This lecture, summarizes what you've learned in this section.
Basic Database Principles

Section Overview0:43
This lecture, is an overview of what you will learn in this section.
What can you do with SQL Server?4:14
In this lecture, we will talk about what you can achieve by using SQL Server.
Main SQL Server Services5:16
In this lecture, we will talk about the main SQL Server services such as the SQL Server Database Engine, SQL Server Agent, and more.
Supported Operating Systems4:00
In this lecture, we will talk about the supported Operating Systems for the current versions of SQL Server.
SQL Server Installation Best Practices12:48
In this lecture, I share with you, useful tips and best practices, regarding the installation and setup of SQL Server. These best practices, will help you perform a more efficient installation of SQL Server.
Installing SQL Server19:14
In this lecture, we will talk about how we can install SQL Server.
Section Recap1:26
This lecture, is a summary on what you've learned in this section.
SQL Server Data Platform

Section Overview0:53
This lecture, is an overview of what you will learn in this section.
What is SQL Server Management Studio?2:07
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.
Downloading and Installing SQL Server Management Studio5:35
In this lecture, we will see how we can download and install the latest version of SQL Server Management Studio.
Connecting to the Database Engine and Navigating Through Database Objects5:26
In this lecture, we will talk about how we can connect to the SQL Server Database Engine, using SQL Server Management Studio.
Creating a Database and Other Objects17:09
In this lecture, we will see how we can create databases and other objects in SQL Server using SQL Server Management Studio.
Running Queries and Scripting to T-SQL17:33
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.
Importing and Exporting Data17:25
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.
Section Recap1:11
This lecture, is a summary of what you've learned in this section.
SQL Server Management Studio

Section Overview1:04
This lecture, is an overview of what you will learn in this section.
Logins and Database Users17:53
In this lecture, we will talk about SQL Server security, and most specifically, about SQL Server logins and database users.
Surface Area Configuration6:12
In this lecture, we will talk about SQL Server Surface Area, and how you can check which features are enabled by default.
Best Practices for Securing Data in Databases6:24
In this lecture, we will be discussing about some of the main best practices for securing data in databases.
Section Recap1:09
This lecture, is a summary of what you've learned in this section.
SQL Server Security

Section Overview0:47
This lecture, is an overview of what you will learn in this section.
What is Azure Data Studio?3:21
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.
Downloading and Installing Azure Data Studio3:27
In this lecture, we will see how we can download and install the latest version of Azure Data Studio.
Working with SQL Server using Azure Data Studio8:10
In this lecture, we will see how we can work with SQL Server using Azure Data Studio.
Section Recap1:26
This lecture, is a summary of what you've learned in this section.
Azure Data Studio

Section Overview1:09
This lecture, is an overview of what you will learn in this section.
How to Install SQL Server on Ubuntu Linux8:34
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 the SQL Server command-line tools on Ubuntu Linux5:27
In this lecture and demo, we will see how we can install the SQL Server command-line tools on Ubuntu Linux.
How to Access SQL Server on Ubuntu Linux using Azure Data Studio9:47
In this lecture and demo, we will see how we can access SQL Server 2019 on Ubuntu Linux, using Azure Data Studio.
How to Perform an Offline Installation of SQL Server 2019 on Ubuntu Linux11:35
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 Install SQL Server on CentOS Linux10:51
In this lecture and demo, we will see how we can install SQL Server on CentOS Linux version 8.
Section Recap0:58
This lecture, is a summary on what you've learned in this section.
SQL Server on Linux

Creating the Sample Database for this Section3:33
In this lecture we will create our sample database, against which we will be performing all data import/export operations for this course.
Using the Import Flat File Wizard in SSMS4:43
In this lecture and demo, you will learn how you can import flat files in SQL Server, by using the Flat File Wizard in SQL Server Management Studio.
Using the BULK INSERT T-SQL Statement4:36
In this lecture and demo, you will learn how you can import data in SQL Server, using the BULK INSERT T-SQL command.
Using the OPENROWSET Function4:02
In this lecture and demo, you will learn how you can import data in SQL Server, using the OPENROWSET function.
Using the SQL Server Import and Export Wizard10:09
In this lecture and demo, you will learn how you can import and export data in SQL Server, using the Import and Export Wizard in SQL Server Management Studio.
Using the BCP Utility5:27
In this lecture and demo, you will learn how you can import and export data in SQL Server, using the BCP utility.
Using SQL Server Integration Services (SSIS)12:02
In this lecture and demo, you will learn how you can import and export data in SQL Server, using SQL Server Integration Services (SSIS).

About Special Topics0:13
A few words about the "Special Topics" section.
Understanding the SQL Server Security Hierarchy (New)2:29
In this lecture, we’ll cover the SQL Server security hierarchy — one of the most important, yet often misunderstood, concepts. A solid understanding of this structure helps you assign permissions correctly, avoid common mistakes, and build secure, well-managed environments.
Benefits of Primary Keys in Database Tables5:36
In this special topic, you will learn about the benefits of using primary keys in database tables and see relevant examples.
The Importance of Database Indexes1:06
In this special topic, you can learn more about indexes in SQL Server and why they so important.
Difference Between SQL and SQL Server0:49
In this special topic, you can learn what is the difference between SQL and SQL Server.
What are SQL Server Always On Availability Groups?0:57
Learn what Always On Availability Groups are exactly in SQL Server and how they contribute to the high availability offerings of SQL Server.
SQL Server Database Restore and Compatibility Levels0:48
In this special topic, you will learn about SQL Server compatibility levels.
SQL Server Versions Currently Supported and their Extended Support End Dates0:41
In this lecture, we discuss about the currently supported SQL Server versions. Also, you can download a relevant infographic with useful information.
How to Retrieve Useful SQL Server Instance Info via T-SQL0:19
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 Install SQL Server 2019 Express and the Latest SSMS Version38:54
In this lecture, we will talk about SQL Server Express Edition, its characteristics and limitations, and how you can download it and install it on a new Windows environment, along with installing the latest version of SQL Server Management Studio (SSMS).
What are Temporary Tables in SQL Server?7:39
In this video lecture, you will learn about local temporary tables in SQL Server (defined with #), as well as about global temporary tables (defined with ##). You will learn what their characteristics and differences are, and we are going to see a live demonstration, with these two types of temporary tables in SQL Server.
Introducing Transparent Data Encryption (TDE) in SQL Server14:14
In this special topic, you will learn more about Transparent Data Encryption (TDE) in SQL Server, which is used for encrypting data-at-rest.
Frequently Asked Questions about SQL Server TDE6:34
In this lecture, I will be answering frequently asked questions about SQL Server Transparent Data Encryption (TDE), which is the technology used for encrypting data at rest.
What is SQL Server In-Memory OLTP?5:09
This lecture, is a quick introduction to SQL Server In-Memory OLTP, a powerful built-in engine in SQL Server, that helps you achieve significant performance improvements, mainly for OLTP workload types, using In-Memory optimization.
How to Write to a Flat File Using SQL in SQL Server5:03
Via this special topic, you will learn how to write to a flat file, using SQL scripts in SQL Server.
How to Read from a Flat File Using SQL in SQL Server3:19
Via this special topic, you will learn how to read from a flat file and import the data in SQL Server tables, using SQL scripts.
How to Model Database Creation with the Model System Database in SQL Server4:43
Via this special topic, you will learn how to model database creation in SQL Server, using the Model system database.
Compatibility Levels Supported by Different SQL Server Versions3:27
Via this special topic, you will learn all about SQL Server compatibility levels.
About Backup Compression in SQL Server2:56
Via this special topic, you will learn more about backup compression in SQL Server.
Differences Between Batch and Streaming Data3:00
In this lecture, we will be discussing about the differences between batch and streaming data.
Benefits of Using Stored Procedures in Databases4:08
In this lecture, we will be discussing about the benefits of using stored procedures in databases.
How to Find the Version of a SQL Server Instance11:15
Via this lecture and live demonstration, you will learn how to easily retrieve version information about your SQL Server instances.
What are T-SQL Snippets in SSMS?5:34
Via this lecture and live demonstration, you will learn all about T-SQL snippets in SSMS.
How to Retrieve SQL Server's Version Name with T-SQL1:06
Learn how to retrieve SQL Server's version name with a T-SQL script.
SQL Server Database Backup and Recovery Guide7:20
In this lecture, we will be discussing about the basic knowledge you need to know about SQL Server database backup and recovery, including best practices and techniques for data security.
SQL Server Performance Tuning Basics6:53
In this lecture, we cover the basics of SQL Server performance tuning. Performance tuning is crucial for maintaining efficient and responsive databases.
Data Warehousing vs. Data Lakes: Key Differences Explained3:48
In this lecture, you'll understand Data Warehouses versus Data Lakes, along with exploring their unique structures, use cases, and benefits for data management.
Overview of Index Types and Uses in SQL Server2:29
In this lecture, we’ll start by covering the basics of clustered and non-clustered indexes, then delve into advanced types like columnstore, filtered, and full-text indexes.
Common Pitfalls in SQL Development2:54
In this special topic, we'll look at some of the most common mistakes SQL developers make—often without realizing it.
Privileged Access Management (PAM) for SQL Server (New)3:59
In this lecture, we'll explore Privileged Access Management, or PAM, in SQL Server, since privileged accounts, like sysadmin logins, are powerful but also pose the highest security risks if they’re misused or compromised.

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

Welcome to SQL Server Fundamentals! This course is designed to provide you with a solid foundation in SQL Server database management and administration. Whether you're a beginner or have some experience with databases, this course will equip you with the knowledge and skills needed to work confidently with SQL Server.

What sets this course apart is its comprehensive approach. We'll cover everything from basic database principles to advanced topics like data import/export, security, Azure Data Studio, SQL Server on Linux, and much more. You'll gain practical experience through hands-on exercises and real-world examples, ensuring you're ready to tackle SQL Server projects.

Key Course Features:

In-depth coverage of relational database management systems and SQL Server data platform.
Step-by-step guidance on installing and using SQL Server Management Studio.
Thorough exploration of SQL Server security concepts and best practices.
Comprehensive overview of Azure Data Studio and its integration with SQL Server.
Practical tutorials on installing and utilizing SQL Server on Linux.
Techniques for importing and exporting data in SQL Server.
Detailed discussions on special topics, including primary keys, indexes, compatibility levels, and more.
Engaging wrap-up section with a practice test to reinforce your learning.
Bonus lecture to guide you towards further learning resources.

Prerequisites:

No prior knowledge of SQL Server is required. This course is designed for beginners who are new to SQL Server and want to learn the fundamentals of SQL database management.
While not mandatory, having a basic understanding of database-related concepts, such as the concepts of a database and a table, would be helpful. However, we will cover these concepts in the course to ensure everyone can follow along, regardless of their prior knowledge.
The most important prerequisite for this course is a willingness and excitement to learn. We believe that with a positive attitude and a desire to expand your skills, you'll be able to grasp the concepts and excel in SQL Server database management.

This Course Contains/Offers:

7+ hours of high-quality video lectures
Many useful downloadable resources
Live demonstrations and guides illustrating basic concepts, functions, and tasks in SQL Server
Quizzes for testing your knowledge after each section
A practice test at the end of the course
Ability to ask the instructor questions via the Q&A section
Certificate upon course completion

What Leaners Say:

"Just the kind of introduction I needed for the topic (get into it quickly already with some background on databases)!"
"Highly interesting topic. The updated version of the course is highly informative and comprehensive."
"I have enjoyed the updated version of the course. It now contains more elaborate information and new live demonstrations."
"A useful course for beginners."

By the end of this course, you'll have the skills and confidence to manage SQL Server effectively, troubleshoot issues, and optimize database performance.

Enroll now and take your SQL Server expertise to the next level!

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.
Learners that want to start using SQL Server and need guidance to learn the basics.
Technology enthusiasts that want to explore new technology topics!
Programmers curious about databases and SQL Server

SQL Server Fundamentals - SQL Database for Beginners

What you'll learn

Explore related topics

Course content

Introduction to the Course1 lecture • 5min

Basic Database Principles5 lectures • 14min

SQL Server Data Platform7 lectures • 48min

Using SQL Server Management Studio8 lectures • 1hr 7min

Basic SQL Server Security Concepts5 lectures • 33min

Using Azure Data Studio5 lectures • 17min

SQL Server on Linux7 lectures • 48min

Importing and Exporting Data in SQL Server7 lectures • 45min

Special Topics (Updated)30 lectures • 2hr 37min

Wrap-Up1 lecture • 4min

Requirements

Description

Who this course is for: