Relational Database and Queries Course

41 Lessons
13 Students
Certificate of completion

Track:

Programming

A database query is either an action query or a select query. A select query is one that retrieves data from a database. An action query asks for additional operations on data, such as insertion, updating, deleting or other forms of data manipulation .

To Register in Course you have to watch at least 30 Second of any lesson

What You'll Learn

Master SQL select queries to efficiently retrieve data from relational databases for real-world applications
Design and implement action queries to manipulate data through insertion, updating, and deletion in relational databases
Apply filtering, sorting, and aggregation techniques to optimize database query performance and accuracy
Utilize joins and subqueries to combine and analyze data across multiple tables effectively
Create and modify database schemas to support complex data relationships and integrity constraints
Develop practical skills in writing complex SQL queries for data analysis and reporting tasks
Implement data validation and integrity rules within relational databases for reliable data management
Troubleshoot and optimize query performance to handle large datasets efficiently in relational databases

Course Content

41 Lessons • 5 h 56 m total

Database Course Introduction {قواعد بيانات بالعربى}

11:19

Relational Algebra Introduction {قواعد بيانات بالعربى}

2:36

Relational Algebra Selection Sigma Operator {قواعد بيانات بالعربى}

3:40

Relational Algebra Selection Sigma Operator Relax Implementation {قواعد بيانات بالعربى}

4:19

Relational Algebra Project Pi Operator {قواعد بيانات بالعربى}

4:27

Relational Algebra Project Pi Operator Implementation {قواعد بيانات بالعربى}

4:13

Relational Algebra Rename Rho Operator {قواعد بيانات بالعربى}

5:13

Relational Algebra Rename Rho Operator Implementation {قواعد بيانات بالعربى}

5:23

Relational Algebra Set Operators U n × {قواعد بيانات بالعربى}

8:43

Relational Algebra Set Operators U n × Implementation {قواعد بيانات بالعربى}

6:49

Relational Algebra Inner Join Operators theta equi natural {قواعد بيانات بالعربى}

7:19

Relational Algebra Examples Part 1

9:11

Relational Algebra Examples Part 2

8:11

Relational Algebra Divide by Operator {قواعد بيانات بالعربى}

5:33

Relational Algebra Divide by Operator Implementation and exercises {قواعد بيانات بالعربى}

18:25

Relational Algebra Outer Join left right full Operator l{قواعد بيانات بالعربى}

7:45

Relational Algebra Natural Outer Join Operator {قواعد بيانات بالعربى}

1:08

Relational Algebra Outer Union Operator {قواعد بيانات بالعربى}

2:16

Relational Algebra Semi and Anti Join Operator {قواعد بيانات بالعربى}

3:25

Relational Algebra Aggregate Functions and Grouping {قواعد بيانات بالعربى}

7:04

Recap {قواعد بيانات بالعربى}

4:11

Tuple Relational Calculas {قواعد بيانات بالعربى}

6:45

Tuple Relational Calculas 2 variables {قواعد بيانات بالعربى}

5:12

Tuple Relational Calculas Quantifiers variables {قواعد بيانات بالعربى}

9:36

DBMSs {قواعد بيانات بالعربى}

7:56

Setup SQLite {قواعد بيانات بالعربى}

6:44

SQL introduction {قواعد بيانات بالعربى}

9:07

SQLITE | First Database {قواعد بيانات بالعربى}

8:37

SQLITE | SQL DDL CREATE DROP ALTER TABLE {قواعد بيانات بالعربى}

21:43

SQLITE | SQL DDL CREATE DROP ALTER TABLE Implementation {قواعد بيانات بالعربى}

25:21

SQLITE | SQL DML INSERT DELETE UPDATE REPLACE TABLE {قواعد بيانات بالعربى}

16:53

SQLITE | SQL DML INSERT DELETE UPDATE REPLACE TABLE Implementation {قواعد بيانات بالعربى}

16:50

SQLITE | SQLite Studio {قواعد بيانات بالعربى}

8:46

SQLITE | Sample Database {قواعد بيانات بالعربى}

7:14

SQLITE | SQL DQL SELECT WHERE operators including IN and LIKE {قواعد بيانات بالعربى}

11:34

SQLITE | SQL DQL SELECT WHERE Operators IN BETWEEN LIKE Implementation {قواعد بيانات بالعربى}

9:47

SQLITE | SQL DQL Projection Columns Expressions Constants and alias {قواعد بيانات بالعربى}

5:41

SQLITE | SQL DQL JOIN Cross and Inner {قواعد بيانات بالعربى}

12:16

SQLITE | SQL DQL OUTER JOIN and self JOIN {قواعد بيانات بالعربى}

12:29

SELECT PROJECT JOIN Exercise

9:51

How to Get The Certificate

You must have an Account on the platform.
Complete all lessons.
Watch at least 50% of Lesson Duration.
Get your Certificate free 🎉 !

4.3 (23 reviews)

Overall rating

5.0 0%
4.0 0%
3.0 0%
2.0 0%
1.0 0%

Reviews

Hema b v

· 1yr ago

Good

Relational Database and Queries Course Description

A database query is either an action query or a select query. A select query is one that retrieves data from a database. An action query asks for additional operations on data, such as insertion, updating, deleting or other forms of data manipulation .

Focus on Learning, Not Ads

Experience the full power of Mindluster with Premium.
No distractions, just pure education.

Get Mindluster Premium

Cancel your subscription anytime