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.

Go to Course

Who takes this Course

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. 

Content

19 Lectures • 1 hour 13 minutes

  • Lecture 1: Intro

    37 seconds

  • Lecture 2: What is Database & What is SQL

    2 minutes 47 seconds

  • Lecture 3: Create and Host Microsoft SQL Server

    3 minutes 1 second

  • Lecture 4: More about Database

    12 minutes 34 seconds

  • Lecture 5: System Databases

    2 minutes 15 seconds

  • Lecture 6: Schema

    1 minute 11 seconds

  • Lecture 7: Tables

    4 minutes 28 seconds

  • Lecture 8: Data Types and Constraints

    6 minutes 24 seconds

  • Lecture 9: Alter Table

    2 minutes 8 seconds

  • Lecture 10: Temporary Table

    2 minutes 18 seconds

  • Lecture 11: Data Manipulation Language

    6 minutes 17 seconds

  • Lecture 12: Select Statement

    3 minutes 47 seconds

  • Lecture 13: Where Condition

    6 minutes 30 seconds

  • Lecture 14: Order by

    1 minute 25 seconds

  • Lecture 15: Aggregate Function

    1 minute 22 seconds

  • Lecture 16: Group by

    1 minute 54 seconds

  • Lecture 17: Select into Insert

    1 minute 48 seconds

  • Lecture 18: Join Statement

    7 minutes 38 seconds

  • Lecture 19: Views

    4 minutes 59 seconds

Meet your instructor

Mohamed Elmenoufy

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