Introduction to database concepts - SQL Server

Using SQL Server SSMS and SQL Scripts

4.62 (116 reviews)
Udemy
platform
English
language
Databases
category
instructor
Introduction to database concepts - SQL Server
4,619
students
2 hours
content
Nov 2022
last update
FREE
regular price

What you will learn

Basic database concepts

Basics of database objects

Creating a database using SSMS and SQL Script

Creating Table, View and Stored Procedure using SSMS and SQL Script

Populating a database using SSMS and SQL Script

Querying a database using SSMS and SQL Script

Updating a database using SSMS and SQL Script

Deleting a database using SSMS and SQL Script

Basics of database normalization

How to apply 1st and 2nd normal form

How to query data from multipe tables

Description

This course will teach you all the basic skills required to say 'I know database' by starting from installing the required software up to creating and manipulating a database including basic administration tasks.

We'll download and use the free trial version of Microsoft SQL Server and I'll teach you exactly how to use it well.

Databases are incredibly important in our modern world, and they remain a mystery to most people. But they're actually pretty easy to use if you know just a few things...and I'll teach you those things in this course.

If you are already familiar with SQL then you can skip this course. This course teaches you all the SQL you need to start using it with confidence This course won't go into advanced level SQL concepts. I strongly believe in short and simple courses that can get you ready in few hours as opposed to days.

However, if you ever get stuck or need something that I don't cover in this course then feel free to reach out to me or add a comment on the course we will reach out to you at the earliest.

When you get right down to it, using Databases with SQL is pretty easy, and actually a lot of fun.


Join me today and I'll see you inside!

Content

Introduction

Course Introduction
Introduction to database

Introduction to SQL Server

Installing SQL Server
Navigating SQL Server

Basic Database Concepts

What is Normalization?
Types of Normalization

Prepare the Database

Create database using SSMS
Introduction to Database Objects
Create tables
Practice what you learn in this section

Data manipulation using SQL

Inserting data into table
Selecting data from a Table
Creating views
Updating data in a Table
Deleting data from a Table
Creating Stored Procedures
Practice what you learn in this section

Searching for data in database

Selecting Top N records
Sorting selected records from table
Narrowing down result set with WHERE clause
Apply 2nd Normal Form
Select data from multiple tables
Practice what you learn in this section

Reviews

Munashe
March 20, 2023
The basic concepts are explained well and shortly. The examples help to understand the theory of the basic concepts. The course is a good starting point.
Yodit
January 20, 2023
The course design is really good, not too long while covering the basic concepts. The examples are easy to understand and relatable.
Tigist
December 8, 2022
The lectures were all very interesting and informative and I was constantly engaged for the full hours. I wish I could take more.
Yvette
December 4, 2022
Good day, I'm very thankful for your effort, it not easy to teach in a 2nd language. really appreciate your effort keep up in a few years I hope you will do better. Technically you are good. Let's proceed and see what have to offer.
Elsabet
November 27, 2022
Explained the concept in a very basic terms. Loved it! I noticed this could be his first course but the content is great.

Charts

Price

Introduction to database concepts - SQL Server - Price chart

Rating

Introduction to database concepts - SQL Server - Ratings chart

Enrollment distribution

Introduction to database concepts - SQL Server - Distribution chart
3744872
udemy ID
1/3/2021
course created date
11/30/2022
course indexed date
Bot
course submited by