SQL Server Database Fundamentals

Start your Database Developer journey by learning the Basics of SQL Server Databases

4.50 (23 reviews)
Udemy
platform
English
language
Other
category
instructor
54
students
4.5 hours
content
Aug 2023
last update
$64.99
regular price

What you will learn

Fundamentals of Relational Databases such as the different types of databases, database management systems, and how data is stored.

Core Database Concepts such as normalization, constraints, and keys.

Query Relational Databases and manipulate Data using T-SQL.

Fundamentals of Creating Database Objects such as Tables, Views, Functions, Stored Procedures and Indexes.

Database Administration Fundamentals such as securing a SQL Server Database and Database Recovery.

Description

Are you looking for a course to jumpstart your database developer or database administration career, then look no further!

In this database course, I'll be taking you from the basic understanding of database concepts to writing your own T-SQL queries, to select, and modify data, as well as creating and altering database structures. Along the way, I'll explain the key concepts such as database normalization, database keys, and constraints, demonstrate the syntax, and give you an opportunity to test out the skills you have acquired during this course.

The course is designed to be completed at your own pace and consists of video presentations, video demonstrations, resources, and external links to text-based resources.

The first three sections include video presentations that cover the theory needed to understand how databases work in a nutshell, while the other sections mostly include demonstrations that cover the practical part of this course.

Once you have finished this course, you'll receive a certificate you can show to your employer and colleagues that you have the fundamental skills to develop and administer SQL Server databases.

This course can also be used as a reference for the Microsoft Technology Associate (MTA) 98-364 Database Fundamentals Exam and covers all exam objectives.

Content

Introduction

Welcome to this Course!
Introduction
SQL Server 2019 DE Quick Installation Guide

Core Database Concepts

Introduction to Databases
Types of Databases

Relational Database Concepts

Normalization
Constraints
Keys

Querying and Manipulating Data

Introduction to T-SQL
SQL Server Data Types
Introduction to SQL Server Management Studio
Querying Databases
Querying Data - Aliasing
Querying Data - Filtering
Querying Data - Ordering
Querying Data - Aggregate Functions
Querying Data - Grouping
Querying Data - Joins
Querying Data - SET Operators
Manipulating Data - Insert Data
Manipulating Data - Update Data
Manipulating Data - Delete Data

Creating Database Objects

Tables
Views
Functions
Triggers
Stored Procedures
Introduction to Indexes

Database Administration Fundamentals

Securing a SQL Server Database
Backing up and Restoring a SQL Server Database

Assessment

Knowledge Assessment
Develop a small library database solution
MTA 98-364 Exam Practice Questions

Screenshots

SQL Server Database Fundamentals - Screenshot_01SQL Server Database Fundamentals - Screenshot_02SQL Server Database Fundamentals - Screenshot_03SQL Server Database Fundamentals - Screenshot_04

Reviews

Francis
February 10, 2023
Hi, Francis from calabar Nigeria. I enjoy the course and the presentation of each model. I could not follow up with the practical aspect which is very important in this course because my Management studio refuse to install after trying all options.
Pieter-Jan
January 11, 2023
Was a great course there are a few errors here and there but nothing major, there is a few things in the coding that are inserted without knowing what they do like the 'go' statement and also I wish the presentations are uploaded that you can easily revise them. The coding assessment also did work so I could not have tested my solutions.

Charts

Price

SQL Server Database Fundamentals - Price chart

Rating

SQL Server Database Fundamentals - Ratings chart

Enrollment distribution

SQL Server Database Fundamentals - Distribution chart
4613514
udemy ID
3/25/2022
course created date
4/22/2022
course indexed date
Bot
course submited by