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

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.

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

التقييمات هنا من المتدربين الذين اشتروا الدورة وأكملوا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

    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.
    14.7K students28 courses