Fundamentals of Database Management

Learn Database Management Basics with SQL Application

3h 22m18 lectures7 sections

What you'll learn

  • Understand database fundamentals
  • Learn about SQL
  • Master SELECT queries
  • Learn database management
  • Analyze data effectively
  • Practical application of SQL

About this course

The concept of a database is similar to that of an employee data record in the HR department. It consists of logically interconnected tables through logical relationships written in a specific programming language. Each table comprises several fields logically linked to facilitate the retrieval and querying of information from the database using programming commands. In this course, you will find a comprehensive explanation of database concepts with practical SQL applications.

Expected outcomes

  • Acquire practical skills in database management.
  • Master basic and advanced queries using SQL.
  • Efficiently manage databases and user permissions.
  • Perform data analysis using practical examples.
  • Advanced understanding of query creation and data usage professionally.

Course content

1

Database Concepts

4 lectures
  1. Course Highlights11:42
  2. Database Concepts (1)5:17
  3. Database Concepts (2)15:34
  4. Database Concepts (3)9:27
2

SQL Handling Methods

3 lectures
  1. Ways to Handle SQL (1)11:02
  2. Ways to Handle SQL (2)16:20
  3. Ways to Handle SQL11:25
3

SQL Language Commands

2 lectures
  1. SQL Language Commands (1)13:08
  2. SQL Language Commands (2)11:16
4

Select Statement

5 lectures
  1. Select Statement (1)13:52
  2. Select Statement (2)6:59
  3. Select Statement (3)14:34
  4. Select Statement (4)8:07
  5. Select Statement (5)7:29
5

Built-in Functions

1 lectures
  1. Built-in Functions7:40
6

Database Management and User Permissions

2 lectures
  1. Database Management and User Permissions Control (1)9:40
  2. Database Management and User Permissions Control (2)10:42
7

Practical Example: Study and Analysis of Accounting Application

1 lectures
  1. Practical Example: Study and Analysis of Accounting Application18:08

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

This course is part of the diploma

  • Diploma in Programming for BeginnersDiploma
    4.8|7|40 h

    Diploma in Programming for Beginners

    7 courses
    $59.99
    Buy now

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