Learn Microsoft SQL Server

Learn and Master Database Creation and Integration

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.

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.
7,309 students28 courses

Related courses

  • Microsoft Access
    4.6|5,337|0h 0m

    Microsoft Access

    Learn to Create Databases and Reports

    Ahmed Hassan Khamis
    Ahmed Hassan Khamis
    $19.99
    Buy now
  • Key Logger Spyware Design
    4.5|5,026|0h 0m

    Key Logger Spyware Design

    Spyware Design Using C++ Language

    Eng. Mohamed Ali Mansour
    Eng. Mohamed Ali Mansour
    $19.99
    Buy now
  • Adobe Animate & Action Script
    4.7|6,962|16h 58m

    Adobe Animate & Action Script

    Learn to Create Cartoon Films and Interactive Games

    Ahmed Hassan Khamis
    Ahmed Hassan Khamis
    $19.99
    Buy now
  • Deep Learning
    4.5|5,162|12h 40m

    Deep Learning

    Simulating the Human Mind in Thinking

    Eng. Amr Abdel Fattah
    Eng. Amr Abdel Fattah
    $25.99
    Buy now