Using SQL Server SSMS and SQL Scripts
Free tutorial
Created by Bereket Wolde
English
What you’ll 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
Requirements
- Basic computer skill
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!
Who this course is for:
- 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
Show less
Course content
6 sections • 25 lectures • 2h 4m total lengthCollapse all sections
Introduction2 lectures • 10min
- Course Introduction06:23
- Introduction to database03:51
Introduction to SQL Server2 lectures • 11min
- Installing SQL Server05:28
- Navigating SQL Server05:44
Basic Database Concepts3 lectures • 12min
- What is Normalization?05:39
- Types of Normalization06:28
- Asking for a review00:07
Prepare the Database4 lectures • 24min
- Create database using SSMS08:21
- Introduction to Database Objects06:09
- Create tables09:42
- Practice what you learn in this section00:13
Data manipulation using SQL8 lectures • 35min
- Inserting data into table08:25
- Selecting data from a Table02:50
- Creating views04:14
- Asking for a review00:07
- Updating data in a Table07:48
- Deleting data from a Table03:23
- Creating Stored Procedures07:55
- Practice what you learn in this section00:18
Searching for data in database6 lectures • 32min
- Selecting Top N records04:12
- Sorting selected records from table03:56
- Narrowing down result set with WHERE clause07:55
- Apply 2nd Normal Form11:28
- Select data from multiple tables03:52
- Practice what you learn in this section00:11