PostgreSQL | Learn T-SQL Using PostgreSQL with Real Examples

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

PostgreSQL - Learn Relational Database and PostgreSQL Database Administration with PostgreSQL and become Postgres master

1. Introduction to PostgreSQL

1. What is PostgreSQL

2. Basic Architecture Of PostgreSQL

3. PostgreSQL Project Files.html

4. Quiz.html

2. Basic SQL Language

1. Relational-Model Concepts Database-Table RowColumn

2. Normalization

3. Tables And Foreign Keys

4. Adding And Manipulating Data Into Table

5. Querying data - Basic Select Statement

6. Querying data - Like Operator And Basic Pattern Searching

7. Querying data - Retrieve Records Sorted

8. Querying data - LIMIT OFFSET and FETCH Keywords

9. Join Tables

10. Distinct Keyword and Grouping Results

11. Window Functions

12. Views - Simple Views

13. Views - Updateable Views

14. Views - Recursive Views

15. Views - Materialized Views

16. Transactions

17. Quiz.html

3. SQL In More Detail

1. SQL Basics -Lexical Structure

2. SQL Basics -Identifiers And Keywords

3. SQL Basics -Constants

4. SQL Basics -Operators

5. SQL Basics -Comments

6. Sequence

7. Data Definition - Table Basics

8. Data Definition - Default Values

9. Data Definition - Generated Columns

10. Data Definition - System Columns

11. Data Definition -Constraints

12. Data Definition - Check Constraint

13. Data Definition - Not null constraint

14. Data Definition - Unique Key Constraint

15. Data Definition - Primary key

16. Data Definition - Foreign Key

17. Data Definition - Exclusion Constraint

18. Data Definition - Modifying Table

19. Data Definition - Privileges

20. Data Definition - Row Security Policies

21. Data Definition - Schemas

22. Data Definition - Inheritance

23. Table Partitioning

24. Data Definition - Dependency Tracking

25. Queries - Join Types

26. Queries - Subqueries

27. Queries - Combining Queries

28. Queries - Group By And Having Clauses

29. Queries - Grouping Sets, Cube And Rollup

30. Queries - With Queries Common Table Expressions

31. Queries - Recursive With Queries

32. Data Types - Numeric Types

33. Data Types - Monetary Types

34. Data Types - Character Types

35. Data Types - Binary Data Types

36. Data Types - Datetime Types

37. Data Types -Boolean Types

38. Data Types - Enumerated Types

39. Data Types - Network Address Types

40. Data Types - Bit String Types

41. Data Types - UUID Types

42. Data Types - XML Type

43. Data Types - JSON Type

44. Data Types - Arrays

45. Quiz.html

4. Extra

1. PostgreSQL - Learn T-SQL Using PostgreSQL with Real Examples.html

189,000 تومان

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

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

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

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