Mastering PostgreSQL: Learning By Real Examples

Focused View

Missak Boyajian

3:22:23

36 View

1 - Introduction

1 - Prerequisites.mp4

00:28

2 - Working Data.mp4

01:40

2 - Querying

3 - Select.mp4

01:16

4 - Select Multiple.mp4

01:01

5 - Select Constants.mp4

01:05

6 - Order By.mp4

02:12

7 - Limit and Offset.mp4

02:33

8 - Where Statement.mp4

01:54

9 - IS NULL.mp4

01:49

10 - OrAnd.mp4

01:57

11 - Not.mp4

02:01

12 - Between.mp4

01:19

13 - In.mp4

01:49

14 - AnySum.mp4

02:52

15 - Alias.mp4

02:47

16 - Exists.mp4

02:47

17 - Distinct.mp4

00:55

18 - Like.mp4

03:19

19 - Case When.mp4

01:27

3 - Querying Exercises

4 - String Operators

20 - Lower Upper.mp4

01:19

21 - Initcap.mp4

01:07

22 - Concat.mp4

01:23

23 - Left.mp4

00:57

24 - Right.mp4

00:58

25 - Substring.mp4

01:14

26 - Length.mp4

02:06

27 - Replace.mp4

01:12

28 - Cast.mp4

02:03

29 - Trim.mp4

02:21

30 - SplitPart.mp4

01:39

5 - Function Exercises

6 - Aggregates

31 - Introduction.mp4

01:06

32 - Min.mp4

01:09

33 - Max.mp4

00:39

34 - Sum.mp4

01:02

35 - Avg.mp4

00:37

36 - Count.mp4

01:24

37 - Filter.mp4

03:11

38 - Group By.mp4

02:33

39 - Group By Multiple Columns.mp4

02:15

40 - Having.mp4

02:11

41 - Over.mp4

01:59

7 - Aggregates Exercises

8 - Joins

42 - Union.mp4

02:06

43 - Union All.mp4

01:20

44 - Left Join.mp4

05:09

45 - Inner Join.mp4

02:22

9 - Joins Exercises

10 - Dates

46 - Current Datetime.mp4

01:22

47 - AT TIME ZONE.mp4

01:35

48 - EXTRACT.mp4

02:20

49 - DATEPART.mp4

01:10

50 - DATETRUNC.mp4

02:23

51 - Date Differences.mp4

03:30

52 - AGE.mp4

01:50

53 - TOCHAR.mp4

02:03

54 - TODATE.mp4

01:50

55 - INTERVAL.mp4

02:07

56 - makeinterval.mp4

03:00

11 - Working with JSON

57 - Inserting JSON as a Value.mp4

00:49

58 - Selecting a JSON Property.mp4

02:13

59 - Selecting a Sub Property.mp4

02:33

60 - Json Aggregate.mp4

02:54

61 - Json Build Object.mp4

03:36

12 - Working with Arrays

62 - Introduction.mp4

01:32

63 - UNNEST.mp4

01:53

64 - SLICING.mp4

02:06

65 - ARRAYAPPEND.mp4

00:58

66 - ARRAYLENGTH.mp4

01:53

67 - Searching an Array.mp4

02:30

68 - ARRAYAGG.mp4

02:12

69 - STRINGTOARRAY.mp4

01:43

13 - Window Functions

70 - Introduction.mp4

01:32

71 - ROWNUMBER.mp4

02:07

72 - PARTITION BY.mp4

02:40

73 - NTILE.mp4

02:51

14 - Schema and Data

74 - Introduction.mp4

01:06

75 - Database.mp4

02:33

76 - Tables.mp4

04:10

77 - Columns.mp4

03:01

78 - Columns Attributes DEFAULT.mp4

03:06

79 - Columns Attributes NOT NULL.mp4

02:19

80 - Columns Attributes UNIQUE.mp4

01:37

81 - Columns Attributes CHECK.mp4

02:00

82 - Primary Keys.mp4

03:02

83 - Primary Keys Multiple.mp4

02:06

84 - Foreign Keys.mp4

05:31

85 - Foreign Keys On Delete.mp4

05:21

86 - Indexes.mp4

01:30

87 - IF NOT EXISTS.mp4

01:36

88 - Rows.mp4

03:01

89 - Rows Insert Multiple.mp4

00:59

90 - Rows Handle onConflict.mp4

02:57

91 - Transactions.mp4

03:31

15 - Extras

92 - GreatestLeast.mp4

01:03

93 - Nested Queries.mp4

01:26

94 - Coalesce.mp4

01:31

95 - Except.mp4

01:36

96 - CTE.mp4

03:07

97 - Generate Series.mp4

03:24

16 - Conclusion

98 - Where To Go Next.mp4

01:05

17 - Easy Exercises

18 - Medium Exercises

19 - Hard Exercises

Description

A Comprehensive Guide to Practical PostgreSQL

What You'll Learn?

Learn SQL Concepts with PostgreSQL.
Write SQL queries to retrieve data.
Gain a comprehensive understanding of PostgreSQL, including topics such as window functions, aggregates, and joins.
Understand how to perform date-related calculations and manipulations in PostgreSQL
Learn how to work with Arrays and JSON in PostgreSQL
Learn how to create databases, tables, columns and data using PostgreSQL
Learn by solving more than 50 exercises!

Who is this for?

Backend Engineers

Data Scientists

Data Analysts

Software Engineers

Full Stack Engineers

What You Need to Know?

SQL experience is not needed.

You need a PC, Mac, or a Desktop Computer

Make sure you have PostgreSQL Installed locally in your computer or in a docker image.

Make sure to install tools such as pgAdmin, DBeaver, or Datagrip to help you write queries.

More details

Description
This is a course intended for software engineers and data analysts that want to learn more about Relational Databases and SQL It covers both basic and advanced SQLÂ concepts and theories. The course is intended for both Junior and Senior Level Engineers and is purely focused on SQL and writing queries.
PostgreSQL will be used in this course. But the theories you learn can be applied in any Relational Database such as SQLÂ Server or MySql
All the sections are explained by one or more examples. I used a sample database that had students, courses, registrations and instructors records. Learning by doing examples is a much better technique than just studying a theory.

This course contains quizzes and exercises. You'll get immediate practice on all of the different topics and features that you learn!
You will learn about:
Selecting Data
Aggregate Functions
Built in Functions
Joins
Dates
Schema and Data
CRUDÂ Operations
Transactions
Arrays in Postgres
JSONs in Postgres
And More!

Data is the core of an application. Any application that you see on your phone or on your website uses some storage somewhere. Having a good database design and queries is very crucial for any application. This course focuses mainly on the querying part.
At the end of the course, you should be able to:
Master basic query syntax and functionality: Students will learn the syntax of basic SQL queries, including SELECT, FROM, WHERE, GROUP BY, and ORDER BY. They will also gain an understanding of how to filter and sort data, and how to use basic functions and operators.
Develop proficiency in advanced querying techniques: Students will learn how to write more complex queries, including subqueries, inner and outer joins, and aggregations. They will also learn how to use advanced functions and operators such as CASE statements, window functions, and regular expressions.
Optimize queries for performance: Students will learn how to optimize queries for faster execution, including indexing strategies, query planning and execution, and common performance issues to avoid.
Apply queries to real-world scenarios: Students will learn how to apply their query skills to solve real-world problems. They will also explore best practices for data modeling and query design to ensure their queries are accurate and efficient.
Who this course is for:
Backend Engineers
Data Scientists
Data Analysts
Software Engineers
Full Stack Engineers

User Reviews

Rating

average 0

Total votes0

Focused display

I have been working in the software industry for the past 10 years, building large scale enterprise applications, leading and mentoring small to medium sizes team in all over the World. I Had the privilege to work and lead the development of many products in Healthcare, Accounting/Stocks, CRM, and Payments industries.

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.