easyT
  • Subscribe
Sign In
easyT
  • Diplomas
  • Courses
  • E-books
  • Instructors
  • Subscribe
Sign In

Browse

  • All courses
  • Diplomas
  • Subscribe
  • Instructors

Account

  • My courses
  • Purchases
  • Wishlist
  • Settings

Join us

  • Become an instructor
  • Affiliate program
  • About us

Get the app

Apps in development
All rights reserved © 2003-2026 · easyT.onlineTerms & conditionsPrivacy policyRefund policyContact usVerify a certificate

Learn Microsoft SQL Server

Learn and Master Database Creation and Integration

4.3(79)12h 3m38 lectures5 sections

What you'll learn

  • Manage and design databases
  • Master T-SQL query writing
  • Create tables and data relationships
  • Execute subqueries and analyze data
  • Manage users and permissions for security
  • Implement a practical project to apply concepts
Learn Microsoft SQL Server
$19.99
Start your journey now

About this course

SQL stands for Structured Query Language, a powerful tool for building robust and interconnected databases more effectively than any other programs or languages. It is a comprehensive database management system that operates in the background, relying on a Client/Server architecture, rather than independent files like MS Access. In this course, we will explore the intricate world of databases together and uncover its detailed aspects.

Expected outcomes

  • Master designing and managing databases using SQL Server.
  • Ability to write complex queries and analyze data professionally.
  • Effectively implement practical projects using SQL Server databases.
  • Enhance application performance through integrated database design.
  • Understand how to manage users and permissions to ensure data security.

Instructor

Eng. Azab Mohamed Azab

Eng. Azab Mohamed Azab

Lecturer at the Arab Academy for Science, Technology and Maritime Transport, and the Egyptian Ministry of Interior, specializing in technology and information.
3,945 students28 courses
This course$19.99
→
Subscription$19/moEvery course
Subscribe & save→

تقييمات المتدربين

التقييمات هنا من المتدربين الذين اشتروا الدورة وأكملوا50٪من المحتوى على الأقل — لا توجد تقييمات من شخص لم يطلع على المحتوى.
4.3
★★★★☆
79 تقييم
5★
27
4★
51
3★
1
2★
0
1★
0
    ★
    كن جزءا من تقييمات هذه الدورة

    كل تقييم هنا يساعد متدربا جديدا على الاختيار — شاركنا تجربتك بعد إكمال الدورة.

    Course content

    1

    Basic Skills

    20 lectures
    1. Course Highlights15:43
    2. Databases and Information Systems (1)6:57
    3. Databases and Information Systems (2)26:33
    4. Setting Up SQL Server23:32
    5. System Components34:03
    6. Basic Commands (1)18:43
    7. Basic Commands (2)14:36
    8. Functions for Single Value Handling13:40
    9. Tables Joining30:39
    10. Group Functions25:45
    11. Sub Queries14:04
    12. DML23:30
    13. Transaction9:43
    14. Creating Database Elements (1)22:33
    15. Creating Database Elements (2)16:38
    16. Stored Queries30:41
    17. Indexes10:23
    18. User Permissions Management (1)1:49
    19. User Permissions Management (2)8:01
    20. Database Backup19:08
    2

    Advanced Skills

    9 lectures
    1. Advanced Skills Overview6:53
    2. TSQL Programming Basics1:08:39
    3. Loops29:57
    4. Error Handling (1)11:33
    5. Error Handling (2)14:54
    6. Stored Procedures46:12
    7. Triggers25:51
    8. Cursor15:33
    9. Data Transfer Between Databases13:14
    3

    Creating an Employee Affairs Application

    6 lectures
    1. Employee Affairs Application (1)28:14
    2. Employee Affairs Application (2)14:46
    3. Employee Affairs Application (3)26:20
    4. Employee Affairs Application (4)11:19
    5. Employee Affairs Application (5)22:37
    6. Employee Affairs Application (6)20:42
    4

    Books

    2 attachments
    1. Learning Basic Skills Step by Step
    2. Learning Advanced Skills Step by Step
    5

    Add-ons

    1 attachments
    1. Download Attachments Here

    Related courses

    • Microsoft Access
      4.9(76)|1,002|2h 42m

      Microsoft Access

      Learn to Create Databases and Reports

      Ahmed Hassan Khamis
      Ahmed Hassan Khamis
      $19.99
      Start your journey now
    • Key Logger Spyware Design
      4.4(82)|715|16h 18m

      Key Logger Spyware Design

      Spyware Design Using C++ Language

      Eng. Mohamed Ali Mansour
      Eng. Mohamed Ali Mansour
      $19.99
      Start your journey now
    • Adobe Animate & Action Script
      4.7(74)|2,667|17h 30m

      Adobe Animate & Action Script

      Learn to Create Cartoon Films and Interactive Games

      Ahmed Hassan Khamis
      Ahmed Hassan Khamis
      $19.99
      Start your journey now
    • Deep Learning
      4.4(90)|863|12h 40m

      Deep Learning

      Simulating the Human Mind in Thinking

      Eng. Amr Abdel Fattah
      Eng. Amr Abdel Fattah
      $25.99
      Start your journey now