ع
Search for courses, vacancies, internships
Search for anything: courses, vacancies, internships
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.

Enroll now
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. 

Course content
19 lectures • 01h 13m
  • Lecture 1: Intro
    00:37 sec
  • Lecture 2: What is Database & What is SQL
    02:47 min
  • Lecture 3: Create and Host Microsoft SQL Server
    03:01 min
  • Lecture 4: More about Database
    12:34 min
  • Lecture 5: System Databases
    02:15 min
  • Lecture 6: Schema
    01:11 min
  • Lecture 7: Tables
    04:28 min
  • Lecture 8: Data Types and Constraints
    06:24 min
  • Lecture 9: Alter Table
    02:08 min
  • Lecture 10: Temporary Table
    02:18 min
  • Lecture 11: Select Statement
    03:47 min
  • Lecture 12: Where Condition
    06:30 min
  • Lecture 13: Order by
    01:25 min
  • Lecture 14: Aggregate Function
    01:22 min
  • Lecture 15: Group by
    01:54 min
  • Lecture 16: Select into Insert
    01:48 min
  • Lecture 17: Join Statement
    07:38 min
  • Lecture 18: Views
    04:59 min
  • Lecture 19: Data Manipulation Language
    06:17 min

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

Recorded Courses Subscription

Start watching our recorded courses in different fields with our great experts

1 Month
EGP 150
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now
3 Months
EGP 400
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now
1 Year
EGP 700
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now

Have Question? Get in touch!

We are happy to answer your question regarding our services and programs that we provide.

Contact us