TechnicsPub | Database Series Relational Algebra and Relational Calculus

Prom3th3uS

Moderator
Staff member
Forum Moderator
+Lifetime VIP+
Contributor
Oct 21, 2018
444
342
43
Unknown
Credits
8,360


By: Muhammad Faheem
Publisher: Technics Publications
Released: November 2019
ISBN: 9781634627078
Torrent Contains: 38 Files, 1 Folders
Course Source: https://www.oreilly.com/library/view/database-series-relational/9781634627078/

Description

Develop a foundation in relational algebra and relational calculus, and then apply these concepts using MariaDB in this comprehensive course. Become proficient in how procedural query languages align with relational algebra, and how non-procedural query languages align with relational calculus. These 32 topics will explain these essential math and database concepts:

• Course Introduction. Learn about this entire database series course in this first topic in the Relational Algebra and Relational Calculus series.
• Database Query Languages. Be able to explain database query language in this second topic in the Relational Algebra and Relational Calculus series. A query language is a language which is used to retrieve information from a database. Know the difference between both procedural and non-procedural query languages.
• Relational Algebra. Be able to explain the concepts of relational algebra in this third topic in the Relational Algebra and Relational Calculus series.
• Relational Algebra Operations. Be able to explain the five fundamental relational algebra operations in this fourth topic in the Relational Algebra and Relational Calculus series. These include selection, projection, Cartesian project, union, and set operations.
• Install the Xampp Server and Sublime Editor. Install the Xampp server and sublime editor in this fifth topic in the Relational Algebra and Relational Calculus series.
• Unary Operations: Concept. Know the math behind unary operations in this sixth topic in the Relational Algebra and Relational Calculus series. Understand the Select operation.
• SQL Unary Operations: In Practice. Practice performing unary operations using SQL in this seventh topic in the Relational Algebra and Relational Calculus series.
• Unary Operations: In Practice. Practice using unary operations in this eighth topic in the Relational Algebra and Relational Calculus series.
• Union Operation: Concept. Know the math behind the union operation in this ninth topic in the Relational Algebra and Relational Calculus series. This is the first type of set operation we will cover.
• Union Operation: In Practice. Practice using the union operation in this tenth topic in the Relational Algebra and Relational Calculus series.
• Set Difference Operation: Concept. Know the math behind the set difference operation in this 11th topic in the Relational Algebra and Relational Calculus series.
• Set Difference Operation: In Practice. Practice using the set difference operation in this 12th topic in the Relational Algebra and Relational Calculus series.
• Intersection: Concept. Know the math behind the intersection operation in this 13th topic in the Relational Algebra and Relational Calculus series.
• Intersection: In Practice. Practice applying examples of intersections in this 14th topic in the Relational Algebra and Relational Calculus series.
• Cartesian Product: Concept. Know the math behind the Cartesian product in this 15th topic in the Relational Algebra and Relational Calculus series.
• Combining Unary and Set Operations. Combine unary and set operations in this 16th topic in the Relational Algebra and Relational Calculus series.
• Theta Join: Concept and In Practice. Know the math behind theta joins and practice applying theta joins in this 17th topic in the Relational Algebra and Relational Calculus series.
• Equijoin: Concept and In Practice. Know the math behind equijoins and practice applying equijoins in this 18th topic in the Relational Algebra and Relational Calculus series.
• Natural Join: Concept and In Practice. Know the math behind natural joins and practice applying natural joins in this 19th topic in the Relational Algebra and Relational Calculus series.
• Outer Joins and Left Outer Join: Concept and In Practice. Know the math behind outer joins and left outer joins and practice applying outer joins and left outer joins in this 20th topic in the Relational Algebra and Relational Calculus series.
• Right Outer Joins: Concept and In Practice. Know the math behind right outer joins and practice applying right outer joins in this 21st topic in the Relational Algebra and Relational Calculus series.
• Full Outer Join: Concept and In Practice. Know the math behind full outer joins and practice applying full outer joins in this 22nd topic in the Relational Algebra and Relational Calculus series.
• Semi Join: Concept and In Practice. Know the math behind semi joins and practice applying semi joins in this 23rd topic in the Relational Algebra and Relational Calculus series.
• Joining Operations In Practice. Practice performing all of the different types of joins in this 24th topic in the Relational Algebra and Relational Calculus series.
• Division Operations: Concept and In Practice. Know the math behind the division operation and practice applying the division operation in this 25th topic in the Relational Algebra and Relational Calculus series.
• Aggregate Functions: Concept and In Practice. Know the math behind aggregate functions and practice applying aggregate functions in this 26th topic in the Relational Algebra and Relational Calculus series.
• Grouping Functions: Concept and In Practice. Know the math behind grouping functions and practice applying grouping functions in this 27th topic in the Relational Algebra and Relational Calculus series.
• Introducing Relational Calculus. Know the concepts behind relational calculus in this 28th topic in the Relational Algebra and Relational Calculus series.
• Tuple Relational Calculus: Concept and In Practice. Know the math behind tuple relational calculus and practice applying tuple relational calculus in this 29th topic in the Relational Algebra and Relational Calculus series.
• Existential and Universal Quantifiers: Concept and In Practice. Know the math behind existential and universal quantifiers and practice applying existential and universal quantifiers in this 30th topic in the Relational Algebra and Relational Calculus series.
• Domain Relational Calculus: Concept and In Practice. Know the math behind domain relational calculus and practice applying domain relational calculus in this 31st topic in the Relational Algebra and Relational Calculus series.
• Course Summary. The key messages for this course are reinforced and summarized in this 32nd topic in the Relational Algebra and Relational Calculus series.