IT & Tech

Introduction to Microsoft SQL

In this course you will learn:

-What is the database.

-What is SQL.

-What is schema and how to use it.

-The difference between Microsoft management studio and Azure data studio.

-How to insert, edit, and search in tables.

-Different constraints and how they can control your data.

-What are temporary tables and how to create them.

-How to use order by condition.

-How to use the where function to look for your data.

-The function of select condition.

-How to join data.

-How to use the group by condition.

This course for a person who is interested in IT and Tech and wants to learn how to create and manage databases using Microsoft SQL.

Intro

37 seconds
What is Database & What is SQL

2 minutes 47 seconds
Create and Host Microsoft SQL Server

3 minutes 1 second
More about Database

12 minutes 34 seconds
System Databases

2 minutes 15 seconds
Schema

1 minute 11 seconds
Tables

4 minutes 28 seconds
Data Types and Constraints

6 minutes 24 seconds
Alter Table

2 minutes 8 seconds
Temporary Table

2 minutes 18 seconds
Data Manipulation Language

6 minutes 17 seconds
Select Statement

3 minutes 47 seconds
Where Condition

6 minutes 30 seconds
Order by

1 minute 25 seconds
Aggregate Function

1 minute 22 seconds
Group by

1 minute 54 seconds
Select into Insert

1 minute 48 seconds
Join Statement

7 minutes 38 seconds
Views

4 minutes 59 seconds

Meet your instructor

Mohamed Elmenoufy

Experienced Full Stack Web Developer in HTML, CSS, JS, PHP, MySQL, WordPress more than 14 years.
Experienced Information Technology Manager with a demonstrated history of working in the events services industry. Skilled in Research, Microsoft Excel, Customer Service, Microsoft Word, and Microsoft PowerPoint. Strong information technology professional with a Bachelor's degree focused in Management Information Systems, General from High institute for tourism, hotels and computers

Visit Linkedin

Beginner