TutorialD for SQL Developers

سرفصل های دوره

What happens if we reimagine SQL from first principles?

1 - Introduction

1 - Robot Tshirt provided by.txt

1 - TutorialD Course Slides Online.txt

1 - Welcome to TutorialD for SQL Developers

2 - Setup ProjectM36

2 - Setup

3 - TutorialD with ProjectM36

3 - Why TutorialD

4 - TutorialD prompt

4 - Relation and Relvars

5 - Creating Our First Relation

6 - Relvars Storing Relation Results For Later

7 - Relvar Types And Ordering

5 - Restriction

8 - Filtering Results with Restriction

6 - Projection

9 - Projecting to Get the Attributes You Want

10 - Projecting On Inverted Attributes

7 - Relvar Updates

11 - Create a New Relvar

8 - Dealing with Duplicates and Tuples

12 - Duplicates

13 - Deleting Tuples

14 - Updating Tuples and Summary

9 - More Relational Operators

15 - Join

10 - Renaming Attributes

16 - Ensuring Uniqueness in Attributes with Renaming

11 - Outer Join Equivalent

17 - Getting Outer Join Data Without NULL

12 - Union

18 - Selfjoins and NULLs

19 - Union vs Insert

20 - x union x x

13 - Group and Ungroup

21 - Group

22 - Ungroup

23 - P7 is Missing

14 - Equality

24 - Relational Expression Equality True And False

25 - Does This Relvar Have Any Tuples

26 - Equality and Projection

27 - More Equality

15 - Aggregate Functions

28 - Aggregate Functions

29 - Aggregate Functions And Their Constituent Data

30 - Aggregate Functions Compared to SQL

16 - Database Constraints

31 - Database Constraints

32 - Database Constraints in SQL

33 - Inclusion Dependencies

34 - Inclusion Dependency Representation

35 - Uniqueness Constraints

17 - Dataframes

36 - SQL Tables Always Have An Ordering

37 - Getting Dataframes From Relational Expressions

38 - More Dataframe Features

18 - Transactions

39 - Transaction Graph Branching

40 - Transaction Isolation

19 - Good Riddance to Bad Nulls

41 - Quick Quiz

42 - How to Represent MissingUnrepresentable Data

20 - Wrapping it Up

43 - Wrapping it up

44 - New Optimizations

45 - Developer Understanding

46 - Data Type Impedance Fix

47 - Conclusion

47 - Darins Robot Tshirt Source.txt

47 - TutorialD Course Slides Online.txt

48 - Learn more about JUMPstartups.txt

48 - Thanks

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy