Crash Course SQL Server 2019 for Beginners

person icon Joe Moore

Crash Course SQL Server 2019 for Beginners

Unleash the Power of Data: Crash Course SQL Server 2019 for Beginners

updated on icon Updated on Nov, 2023

language icon Language - English

person icon Joe Moore

architecture icon SQL Server

Lectures -40

Resources -1

Duration -1.5 hours


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 8,500+ top Tutorials Point courses anytime, anywhere.

Course Description

Welcome to the Crash Course SQL Server 2019 for Beginners! This comprehensive and hands-on course is designed for individuals who have little to no experience with SQL Server but are eager to learn and harness the power of one of the most popular relational database management systems in the world.

In this fast-paced, beginner-friendly course, you will be introduced to the fundamentals of SQL Server 2019, starting from the very basics and gradually building up your skills to work with databases efficiently and effectively


What will you learn in this course:

Key Learning Objectives:

  1. Introduction to SQL Server: Get acquainted with SQL Server 2019, its features, and its role in modern data management systems.
  2. Installing SQL Server: Learn how to install SQL Server 2019 on your system, configure the necessary components, and set up a sample database for hands-on practice.

  3. SQL Basics: Explore the fundamental concepts of SQL (Structured Query Language), including data manipulation (SELECT, INSERT, UPDATE, DELETE) and data definition (CREATE, ALTER, DROP) statements.

  4. Working with Tables and Data: Understand how to create and manage tables, define data types, and insert, update, and delete data from your database.

  5. Querying Data: Master the art of constructing powerful SQL queries to retrieve specific data from your database based on various conditions and criteria.

  6. Joins and Relationships: Learn about table joins and how to establish relationships between tables to query data across multiple entities effectively.

  7. Data Filtering and Sorting: Explore advanced SQL techniques to filter and sort data, making your queries more precise and efficient.

  8. Aggregate Functions and Grouping: Discover how to perform calculations on data using aggregate functions and group data based on specific criteria.


What are the prerequisites for this course?

some understanding of computers, installing software and comfortable in using the internet.

Crash Course SQL Server 2019 for Beginners


Check out the detailed breakdown of what’s inside the course

3 Lectures
  • play icon Introduction 00:29 00:29
  • play icon What you will learn in this course 01:07 01:07
  • play icon Course Resources
Installing SQL Server Express, SSMS and Connecting to SQL Server
3 Lectures
Section One
11 Lectures
Section Two
7 Lectures
Section Three
9 Lectures
Section Four
5 Lectures
Section Five
2 Lectures

Instructor Details

Joe Moore

Joe Moore

I am currently a Software and Database Developer working for an online travel agency in Cornwall. I have been involved with the IT industry for over 10+ years. I have worked for Medium and Large businesses.

I have vast amount of experience with Database Systems, Linux Systems and Software development along with Azure devops.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us