Introduction to database concepts SQL Server

Introduction to database concepts – SQL Server, available at Free, has an average rating of 4.75, with 23 lectures, based on 131 reviews, and has 5154 subscribers.

Free Enroll Now

You will learn about 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 This course is ideal for individuals who are Beginner database developers or Programmers who want to learn DB basics or Database developers who wanted to learn SQL Server basics or Anyone who wants to learn database concepts It is particularly useful for Beginner database developers or Programmers who want to learn DB basics or Database developers who wanted to learn SQL Server basics or Anyone who wants to learn database concepts.

Enroll now: Introduction to database concepts – SQL Server

Summary

Title: Introduction to database concepts – SQL Server

Price: Free

Average Rating: 4.75

Number of Lectures: 23

Number of Published Lectures: 23

Number of Curriculum Items: 23

Number of Published Curriculum Objects: 23

Original Price: Free

Quality Status: approved

Status: Live

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

Who Should Attend

Beginner database developers

Programmers who want to learn DB basics

Database developers who wanted to learn SQL Server basics

Anyone who wants to learn database concepts

Target Audiences

Beginner database developers

Programmers who want to learn DB basics

Database developers who wanted to learn SQL Server basics

Anyone who wants to learn database concepts

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: Introduction to database

Chapter 2: Introduction to SQL Server

Lecture 1: Installing SQL Server

Lecture 2: Navigating SQL Server

Chapter 3: Basic Database Concepts

Lecture 1: What is Normalization?

Lecture 2: Types of Normalization

Chapter 4: Prepare the Database

Lecture 1: Create database using SSMS

Lecture 2: Introduction to Database Objects

Lecture 3: Create tables

Lecture 4: Practice what you learn in this section

Chapter 5: Data manipulation using SQL

Lecture 1: Inserting data into table

Lecture 2: Selecting data from a Table

Lecture 3: Creating views

Lecture 4: Updating data in a Table

Lecture 5: Deleting data from a Table

Lecture 6: Creating Stored Procedures

Lecture 7: Practice what you learn in this section

Chapter 6: Searching for data in database

Lecture 1: Selecting Top N records

Lecture 2: Sorting selected records from table

Lecture 3: Narrowing down result set with WHERE clause

Lecture 4: Apply 2nd Normal Form

Lecture 5: Select data from multiple tables

Lecture 6: Practice what you learn in this section

Instructors

Bereket Wolde
Solution Architect

Rating Distribution

1 stars: 2 votes

2 stars: 3 votes

3 stars: 16 votes

4 stars: 45 votes

5 stars: 65 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!