SQL Server Fundamentals (SQL Database for Beginners)
4.4 (12 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.
29 students enrolled

SQL Server Fundamentals (SQL Database for Beginners)

The ultimate beginners guide that helps you get started with SQL Server, SSMS and Azure Data Studio fast and easy!
4.4 (12 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.
29 students enrolled
Last updated 3/2019
English
Current price: $11.99 Original price: $79.99 Discount: 85% off
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 3 articles
  • 11 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 Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn what is SQL Server and what you can do with it.
  • Learn about basic database principles.

  • Learn how to get started with SQL Server.

  • Learn about the available editions of SQL Server. What is free and what is not.
  • Learn how to download and install SQL Server.
  • Learn about SQL Server security such as: logins, database users, surface area configuration and more.
  • Learn how to use SQL Server Management Studio for connecting to SQL Server and working with it.
  • Learn how to create databases, tables, views, functions and stored procedures.
  • Learn how to import/export data in SQL Server.
  • Learn how to use Azure Data Studio.
Course content
Expand all 24 lectures 01:58:23
+ Introduction to the Course
1 lecture 02:35

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

Preview 02:35
+ Basic Database Principles
3 lectures 09:17

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

Preview 02:05

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

Preview 05:02

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

Preview 02:10

Test your knowledge on basic database principles!

Basic Database Principles
4 questions
+ SQL Server Data Platform
4 lectures 26:38

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

What can you do with SQL Server?
01:05

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:07

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

Supported Operating Systems
03:00

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

Installing SQL Server
17:26

Test your knowledge on SQL Server Data Platform!

SQL Server Data Platform
4 questions
+ SQL Server Management Studio
6 lectures 45:29

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:52

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
04:37

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:49

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
11:40

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
08: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
11:58

Test your knowledge on SQL Server Management Studio!

SQL Server Management Studio
4 questions
+ SQL Server Security
2 lectures 12:18

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

Logins and Database Users
09:50

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

Surface Area Configuration
02:28

Test your knowledge on SQL Server Security!

SQL Server Security
4 questions
+ Azure Data Studio
3 lectures 14:40

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.

What is Azure Data Studio?
03:47

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
04:25

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
06:28

Test your knowledge on Azure Data Studio!

Azure Data Studio
4 questions
+ Special Topics (New)
3 lectures 03:30

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:27

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

The Importance of Database Indexes
01:07

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

Difference Between SQL and SQL Server
00:55
+ Wrap-Up
1 lecture 01:49

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

What We've Learned in this Course
01:49

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

Practice Test of SQL Server Fundamentals
15 questions
+ Learning More
1 lecture 02:19

Bonus lecture, with next steps on learning more about SQL Server.

Bonus Lecture: My eBooks, Blogs and a Free Checklist
02:19
Requirements
  • No 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!
Description

Hi there! My name is Artemakis Artemiou and I'm a Senior SQL Server & Software Architect with over than 15 years of experience on SQL Server administration, development, performance tuning and architecture, as well as on .NET development (C#).  Moreover, I'm a former Microsoft Data Platform MVP (2009-2018). I love talking about SQL Server, .NET, data access, and related topics, and make it easy for all to understand, by using a simple and understandable language as well as analytical guides.


WHAT IS THIS COURSE ALL ABOUT?

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

In this course, you will learn everything you need to get started with SQL Server Database, SQL Server Management Studio, and Azure Data Studio fast and easy.


AFTER THE COURSE:

  • You will know the basic database principles

  • You will know how to download, configure and install SQL Server

  • You will know the basics of SQL Server security

  • 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!


100% MONEY-BACK GUARANTEE

This course comes with a 30-day money back guarantee. If you're not satisfied with this course, you can ask for a refund.


THIS COURSE CONTAINS/OFFERS:

  • 2 hours of high-quality video

  • 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

  • 30-day money back guarantee

  • Certificate on course completion


Also: This course is being updated with new material on a regular basis (check the "Special Topics" section for more info!)


SOME OF THE COURSE'S REVIEWS:

  • "Very understandable, flowing, to the point. Excellent stuff.", Doros Demetriou

  • "Clear, elaborate and to the point!", Giannis Hadj

  • "Clear and concise explanations. Excellent examples with helpful screenshots. Very good for beginners", Andreas Nestorides

  • "Fantastic course. We are looking forward for the next SQL course !!!", Andreas Josephides


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