Fundamentals of Database Management

Learn Database Management Basics with SQL Application

Programming Basics & Databases4.6(60)3h 22m18 lectures7 sections

What you'll learn

  • Understand database concepts
  • Get to know the ways of working with SQL
  • Use the commands of the SQL language
  • Write queries with the Select statement
  • Use the built-in functions
  • Manage databases
  • Control user permissions
  • Analyze an accounting application as a practical example

About this course

This course teaches the fundamentals of working with databases, with practice in the SQL language. You start with highlights from the course, then database concepts, meaning the tables, fields and the relationships that link them to retrieve information. After that you learn the ways of working with SQL and the commands of the SQL language, then go deeper into the Select statement across five lessons, and learn the built-in functions, database management and controlling user permissions. At the end there is a practical example based on studying and analyzing an accounting application. This course suits anyone who wants to learn databases and write queries, whether you are a beginner in programming, an employee who handles a lot of data, or someone interested in data analysis. It needs no previous experience, because the lessons start from the basic concepts. When you finish, you will be able to understand how a database is structured, write SQL queries to retrieve information, use the built-in functions, and manage the database and user permissions. The course relies on practical examples that make tables, relationships and queries easier to understand and closer to real life.

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.

Learner reviews

These reviews are from learners who bought the content and completed at least 50% of it — there are no reviews from anyone who hasn't gone through the material.
4.6
★★★★★
60 reviews
5★
35
4★
24
3★
1
2★
0
1★
0
  • ★★★★★حنان ت.·منذ 2 شهرشاهد 100٪

    شرح وافي و جميل لاساسيات التعامل مع قواعد البيانات شكراا لقد استفدت من الدورة

  • ★★★★★محمد ف.·منذ 5 شهرشاهد 94٪

    excellent explaining

تم عرض كل التقييمات (2)

Course content

1

Database Concepts

4 lectures
  1. Course HighlightsExcerpts on the importance of information systems and databases, that SQL is a set of commands rather than a programming language, its DDL, DML and DCL parts, with an example of creating, altering and dropping a table.11:42
  2. Database Concepts (1)Introduces the databases and SQL course for beginners and outlines its topics: database concepts, the SQL parts DDL, DML and DCL, the SELECT command, creating tables, and an accounting application example.5:17
  3. Database Concepts (2)Explains the importance of information systems and databases, database management systems such as Oracle, SQL Server, MySQL and Access, and database structure: tables, rows, records, columns and fields.15:34
  4. Database Concepts (3)Explains the primary key and why it forbids duplicate values, the foreign key, and the relationship between jobs and employees tables where one job has many employees, leading into Oracle.9:27
2

SQL Handling Methods

3 lectures
  1. Ways to Handle SQL (1)Sets up the working environment for practicing SQL: installing Oracle Database and a client tool, and running commands to create a user and the practice database so it is ready to use.11:02
  2. Ways to Handle SQL (2)Clarifies that SQL is a set of separate commands, not a programming language, divided into DDL, DML and DCL, and applies CREATE, ALTER and DROP to tables and indexes.16:20
  3. Ways to Handle SQLGives a quick tour of SQL parts: creating a user and granting privileges, then the INSERT command with rejection of duplicate primary keys, and deleting from a table, ahead of detailed lessons.11:25
3

SQL Language Commands

2 lectures
  1. SQL Language Commands (1)Explains DDL commands for defining data: creating a table with column types including date, modifying it by adding an email column with ALTER, plus a look at other database objects such as the index.13:08
  2. SQL Language Commands (2)Explains DML commands: INSERT for adding full rows, chosen columns or several rows at once, plus UPDATE and DELETE, COMMIT and ROLLBACK, and creating a table from a SELECT result.11:16
4

Select Statement

5 lectures
  1. Select Statement (1)Explains the SELECT statement for querying data: showing columns, creating a calculated column such as salary times a percentage with an alias, removing duplicate values, and ordering results by column name or number.13:52
  2. Select Statement (2)Explains the WHERE clause in SELECT and comparison operators, number ranges with BETWEEN, value lists with IN, text pattern search with LIKE, negating with NOT, and combining conditions with AND and OR.6:59
  3. Select Statement (3)Explains advanced SELECT uses: pulling data from several tables by joining on matching keys, giving tables short aliases, retrieving unmatched rows, and joining a table to itself such as employee and manager.14:34
  4. Select Statement (4)Explains group functions AVG, COUNT, MIN, MAX and SUM, using them on a whole table or with GROUP BY by department or job, the difference between WHERE before grouping and HAVING after, and ordering results.8:07
  5. Select Statement (5)Explains subqueries, a query inside a query, to fetch a value used as a condition, distinguishes direct from indirect queries, and uses IN when the subquery returns a set of values.7:29
5

Built-in Functions

1 lectures
  1. Built-in FunctionsExplains built-in functions that act on each value separately, unlike group functions, including changing letter case, measuring length, extracting characters, rounding and date functions, with a GROUP BY example.7:40
6

Database Management and User Permissions

2 lectures
  1. Database Management and User Permissions Control (1)Explains managing database users: creating a user, granting or revoking privileges such as connecting and working with tables, changing the password, and temporarily locking the account.9:40
  2. Database Management and User Permissions Control (2)Explains the Oracle data dictionary, tables holding information about the database objects themselves, querying it with conditions, then naming an aggregate query so it can be used as if it were a table.10:42
7

Practical Example: Study and Analysis of Accounting Application

1 lectures
  1. Practical Example: Study and Analysis of Accounting ApplicationGives a practical example of analyzing a business and turning it into an entity-relationship diagram, including the invoice-to-items relationship, then converting the diagram into a database and creating its tables.18: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.
68.8K views28 courses

This course is part of the diploma

Related courses