Fundamentals of Database Management

Learn Database Management Basics with SQL Application

4.6(59)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.
14.7K students28 courses