SQL and Relational Databases

SQL and Relational Databases

Video Training

Set theory, nullology, the closed world assumption…the finer concepts of relational theory are both subtle and challenging to learn. This Learning Path will give you a deep and thorough understanding of SQL and relational databases. You’ll learn from respected instructors, including C.J. Date, one of the founding fathers of relational database theory.

Below are the video training courses included in this Learning Path.


Learning SQL

Presented by Guy Vaccaro 3 hours 22 minutes

Begin your study of Structured Query Language or SQL by learning how to manage data held in relational databases. You’ll use SQL to select and filter data from a database, including sorting the data, filtering date columns, and working with null or empty values. Then you’ll work with common SQL functions, such as text manipulation, and how to group and summarize. By the end of this course, you’ll understand what SQL is and how to apply it to different database types.


Learning SQL For Oracle

Presented by Steve Perry 8 hours 53 minutes

This course will teach you about the Oracle SQL graphical interface. You’ll review basic SQL select statements, including mathematical and text expressions, and sort the results using column names. Then you’ll learn to restrict data, join tables, and summarize data. Other topics covered include creating tables and manipulating data, single-row functions, creating and using views, database management, and legacy SQL techniques.


Relational Theory for Computer Professionals

Presented by C.J. Date 9 hours 57 minutes

All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. In this course, C.J. Date shows you what a truly relational product would be like, and how and why it would be so much better than what’s currently available. You’ll explore database systems as programming systems and get a precise and detailed understanding of the relational model.


SQL: Beyond the Basics

Presented by Guy Vaccaro 4 hours 18 minutes

You’re ready to dive deeper into SQL and advanced techniques. In this course, you’ll learn a variety of useful skills, including how to convert datatypes, create a temporary table, and declare and use variables. Other topics include sub queries, the CASE statement, and numbering and ranking. Finally, you’ll learn about stored procedures, loop with WHILE and IF, and how to dynamically build SQL statements.


Learning Data Modeling

Presented by Michael Blaha 7 hours 57 minutes

In this course, you’ll learn how to create your own data models. You’ll start with an introduction to the data modeling development process, then jump into basic and advanced data modeling. As the course progresses, you’ll learn about the different kinds of data models, database design, data modeling patterns and even dive into database reverse engineering.


Time and Relational Theory

Presented by C.J. Date 12 hours 14 minutes

Two recent trends—the plummeting cost of storage and the widespread adoption of data warehouse technology—have led to an increasing interest in temporal databases. Indeed, the ability to deal properly with the time dimension in databases has become an increasingly important practical problem. This course provides the foundation you need to understand temporal databases and their inherent problems while it lays the groundwork for solving those problems.



Presented by C.J. Date 1 hour 4 minutes

Nullology is the study of the empty set. Sets per se crop up all over the place in the relational world; the question is—and it’s a crucial one—what happens if the set under consideration happens to be empty? There are some interesting aspects to consider that are probably unfamiliar to most database professionals. In this intriguing course, you’ll look at the effect of “empty solutions” on the operators of relational algebra, the topic of relations with no attributes, and the impact of nullological thinking on keys and functional dependencies.


The Closed World Assumption

Presented by C.J. Date 1 hour 34 minutes

The Closed World Assumption (CWA) is an extremely important concept in the database world, despite the fact that it isn’t usually spelled out explicitly. Basically it says that everything stated by the database, either explicitly or implicitly, is true; everything else is false. In this course you’ll learn about the CWA in detail and why it’s preferred over its rival, The Open World Assumption (OWA).


An Introduction to Set Theory

Presented by C.J. Date 55 minutes

The relational model is founded on logic and set theory, and moreover it derives much of its strength, rigor, and robustness from those solid foundations. Few database professionals can claim to be familiar with logic or set theory, however, even though an elementary knowledge of those disciplines is critical to successful use of a relational DBMS. This course covers the basic concepts of set theory, showing both their relationship to predicate logic and their direct applicability to a variety of database issues.


Nulls, Three-Valued Logic, and Missing Information

Presented by C.J. Date 1 hour

The logic on which the relational model is based is a two-valued logic (2VL). In its attempt to deal with the so-called “missing information” problem, however, SQL—more specifically, SQL’s support for “nulls”—is based on a three-valued logic (3VL). This course explains in detail why any such approach is doomed to failure. More specifically, it shows why 3VL (a) doesn’t solve the problem, (b) isn’t useful, and (c) can actually be dangerous.


View Updating

Presented by C.J. Date 1 hour 8 minutes

Ever since the relational view concept was first invented, view updating has been a contentious issue. Support in today’s SQL products is ad hoc and meager at best. The SQL standard is even more impenetrable in this area than it usually is. This practical course describes a way of looking at the problem that appears to be logically correct, is certainly not ad hoc, and works for all kinds of views. The overall message is: Views in general are just as updatable as “base tables” are!


Normal Forms and All That Jazz Master Class

Presented by C.J. Date 10 hours 9 minutes

If you want to build databases that are robust, flexible, and accurate, you have to come to grips with design theory. But this theory is riddled with difficult terms and concepts that don’t seem to have much to do with design in practice. This step of your Learning Path—a master class by renowned expert C.J. Date—bridges the gap by introducing design theory in ways practitioners can understand.