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

Database Concepts

4 lectures

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

SQL Handling Methods

3 lectures

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

SQL Language Commands

2 lectures

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

Select Statement

5 lectures

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

Built-in Functions

1 lectures

Built-in Functions7:40

Database Management and User Permissions

2 lectures

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

Practical Example: Study and Analysis of Accounting Application

1 lectures

Practical Example: Study and Analysis of Accounting Application18:08

Instructor

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 is part of the diploma

4.8(77)|7
Diploma in Programming for Beginners
7 courses
$59.99
Build your future now

Related courses

4.9(76)|1,002|2h 42m
Microsoft Access
Learn to Create Databases and Reports
Ahmed Hassan Khamis
$19.99
Start your journey now
4.4(82)|715|16h 18m
Key Logger Spyware Design
Spyware Design Using C++ Language
Eng. Mohamed Ali Mansour
$19.99
Start your journey now
4.7(74)|2,667|17h 30m
Adobe Animate & Action Script
Learn to Create Cartoon Films and Interactive Games
Ahmed Hassan Khamis
$19.99
Start your journey now
4.4(90)|863|12h 40m
Deep Learning
Simulating the Human Mind in Thinking
Eng. Amr Abdel Fattah
$25.99
Start your journey now