TutorialD for SQL Developers

Focused View

30:56

0 View

1 - Introduction

1 - Robot Tshirt provided by.txt

1 - TutorialD Course Slides Online.txt

1 - Welcome to TutorialD for SQL Developers.mp4

00:38

2 - Setup ProjectM36

2 - Setup.mp4

00:30

3 - TutorialD with ProjectM36

3 - Why TutorialD.mp4

00:44

4 - TutorialD prompt.mp4

00:20

4 - Relation and Relvars

5 - Creating Our First Relation.mp4

01:08

6 - Relvars Storing Relation Results For Later.mp4

01:57

7 - Relvar Types And Ordering.mp4

00:15

5 - Restriction

8 - Filtering Results with Restriction.mp4

00:09

6 - Projection

9 - Projecting to Get the Attributes You Want.mp4

00:15

10 - Projecting On Inverted Attributes.mp4

00:14

7 - Relvar Updates

11 - Create a New Relvar.mp4

00:30

8 - Dealing with Duplicates and Tuples

12 - Duplicates.mp4

00:24

13 - Deleting Tuples.mp4

00:12

14 - Updating Tuples and Summary.mp4

00:29

9 - More Relational Operators

15 - Join.mp4

00:45

10 - Renaming Attributes

16 - Ensuring Uniqueness in Attributes with Renaming.mp4

00:20

11 - Outer Join Equivalent

17 - Getting Outer Join Data Without NULL.mp4

02:04

12 - Union

18 - Selfjoins and NULLs.mp4

01:33

19 - Union vs Insert.mp4

00:09

20 - x union x x.mp4

00:32

13 - Group and Ungroup

21 - Group.mp4

00:47

22 - Ungroup.mp4

00:37

23 - P7 is Missing.mp4

01:08

14 - Equality

24 - Relational Expression Equality True And False.mp4

01:10

25 - Does This Relvar Have Any Tuples.mp4

00:09

26 - Equality and Projection.mp4

00:38

27 - More Equality.mp4

00:40

15 - Aggregate Functions

28 - Aggregate Functions.mp4

00:44

29 - Aggregate Functions And Their Constituent Data.mp4

00:46

30 - Aggregate Functions Compared to SQL.mp4

00:44

16 - Database Constraints

31 - Database Constraints.mp4

00:19

32 - Database Constraints in SQL.mp4

00:22

33 - Inclusion Dependencies.mp4

00:37

34 - Inclusion Dependency Representation.mp4

00:42

35 - Uniqueness Constraints.mp4

01:11

17 - Dataframes

36 - SQL Tables Always Have An Ordering.mp4

01:05

37 - Getting Dataframes From Relational Expressions.mp4

00:17

38 - More Dataframe Features.mp4

00:29

18 - Transactions

39 - Transaction Graph Branching.mp4

01:09

40 - Transaction Isolation.mp4

00:18

19 - Good Riddance to Bad Nulls

41 - Quick Quiz.mp4

00:38

42 - How to Represent MissingUnrepresentable Data.mp4

00:41

20 - Wrapping it Up

43 - Wrapping it up.mp4

00:22

44 - New Optimizations.mp4

00:25

45 - Developer Understanding.mp4

00:12

46 - Data Type Impedance Fix.mp4

00:35

47 - Conclusion.mp4

00:50

47 - Darins Robot Tshirt Source.txt

47 - TutorialD Course Slides Online.txt

48 - Learn more about JUMPstartups.txt

48 - Thanks.mp4

00:13

Description

What happens if we reimagine SQL from first principles?

What You'll Learn?

Understand how SQL does not faithfully represent the relational algebra
Learn to use an alternative to SQL: TutorialD
Examine an alternative relational database management system: Project:M36
Understand the value of adhering to mathematical principles in the software space

Who is this for?

Programmers who are curious about alternatives to SQL

What You Need to Know?

basic SQL knowledge

More details

Description
Have you been bitten by the odd quirks of SQL and wondered if there could be something better? There is- it's called "TutorialD" which strictly adheres to the mathematics of the relational algebra.
This course answers questions such as:
is it possible to design a database without NULLs?
how does SQL deviate from the relational algebra?
what would an SQL alternative look like and why?
what do we gain by replacing SQL with a different language?
TutorialD is not merely a hypothetical language, but one implemented by Project:M36, a relational algebra engine, which is open-source software which can be downloaded and used for free. Using Project:M36, you will be able to experiment with the new TutorialDÂ language and build real databases of your own. Docker is required to run Project:M36.
By the end of this course, you will be aware of the flaws in SQL and how such flaws can reduce the confidence in your query results. At the same time, you will understand how SQL's flaws and historical baggage are not essential complexity of database systems, as proven by the alternative language: TutorialD.
This course is recommended for technologists already familiar with basic SQL who are curious about alternative database languages.

Who this course is for:
Programmers who are curious about alternatives to SQL

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.