Below are the video training courses included in this Learning Path.
Presented by Guy Vaccaro3 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 Perry8 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. Date9 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 Vaccaro4 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 Blaha7 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. Date12 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. Date1 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. Date1 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. Date55 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. Date1 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.
Presented by C.J. Date1 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. Date10 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.