Language: English | Size: 1.28 GB | Duration: 3h 22m
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
Requirements
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.
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1 - Introduction/1 - Prerequisites.mp4
2.4 MB
~Get Your Files Here !/1 - Introduction/2 - Working Data.mp4
8.9 MB
~Get Your Files Here !/10 - Dates/46 - Current Datetime.mp4
8.5 MB
~Get Your Files Here !/10 - Dates/47 - AT TIME ZONE.mp4
10.3 MB
~Get Your Files Here !/10 - Dates/48 - EXTRACT.mp4
15.2 MB
~Get Your Files Here !/10 - Dates/49 - DATEPART.mp4
8.5 MB
~Get Your Files Here !/10 - Dates/50 - DATETRUNC.mp4
17.6 MB
~Get Your Files Here !/10 - Dates/51 - Date Differences.mp4
24 MB
~Get Your Files Here !/10 - Dates/52 - AGE.mp4
11.4 MB
~Get Your Files Here !/10 - Dates/53 - TOCHAR.mp4
12.5 MB
~Get Your Files Here !/10 - Dates/54 - TODATE.mp4
11.5 MB
~Get Your Files Here !/10 - Dates/55 - INTERVAL.mp4
12.2 MB
~Get Your Files Here !/10 - Dates/56 - makeinterval.mp4
20.6 MB
~Get Your Files Here !/11 - Working with JSON/57 - Inserting JSON as a Value.mp4
5.4 MB
~Get Your Files Here !/11 - Working with JSON/58 - Selecting a JSON Property.mp4
14.6 MB
~Get Your Files Here !/11 - Working with JSON/59 - Selecting a Sub Property.mp4
16.5 MB
~Get Your Files Here !/11 - Working with JSON/60 - Json Aggregate.mp4
17.6 MB
~Get Your Files Here !/11 - Working with JSON/61 - Json Build Object.mp4
22.6 MB
~Get Your Files Here !/12 - Working with Arrays/62 - Introduction.mp4
8.6 MB
~Get Your Files Here !/12 - Working with Arrays/63 - UNNEST.mp4
12.9 MB
~Get Your Files Here !/12 - Working with Arrays/64 - SLICING.mp4
12.8 MB
~Get Your Files Here !/12 - Working with Arrays/65 - ARRAYAPPEND.mp4
6 MB
~Get Your Files Here !/12 - Working with Arrays/66 - ARRAYLENGTH.mp4
11.4 MB
~Get Your Files Here !/12 - Working with Arrays/67 - Searching an Array.mp4
17.3 MB
~Get Your Files Here !/12 - Working with Arrays/68 - ARRAYAGG.mp4
16.3 MB
~Get Your Files Here !/12 - Working with Arrays/69 - STRINGTOARRAY.mp4
10.9 MB
~Get Your Files Here !/13 - Window Functions/70 - Introduction.mp4
10.3 MB
~Get Your Files Here !/13 - Window Functions/71 - ROWNUMBER.mp4
14.2 MB
~Get Your Files Here !/13 - Window Functions/72 - PARTITION BY.mp4
18.3 MB
~Get Your Files Here !/13 - Window Functions/73 - NTILE.mp4
19.7 MB
~Get Your Files Here !/14 - Schema and Data/74 - Introduction.mp4
6.2 MB
~Get Your Files Here !/14 - Schema and Data/75 - Database.mp4
17.2 MB
~Get Your Files Here !/14 - Schema and Data/76 - Tables.mp4
27.4 MB
~Get Your Files Here !/14 - Schema and Data/77 - Columns.mp4
19.5 MB
~Get Your Files Here !/14 - Schema and Data/78 - Columns Attributes DEFAULT.mp4
20.3 MB
~Get Your Files Here !/14 - Schema and Data/79 - Columns Attributes NOT NULL.mp4
15.6 MB
~Get Your Files Here !/14 - Schema and Data/80 - Columns Attributes UNIQUE.mp4
9.2 MB
~Get Your Files Here !/14 - Schema and Data/81 - Columns Attributes CHECK.mp4
14.2 MB
~Get Your Files Here !/14 - Schema and Data/82 - Primary Keys.mp4
19.3 MB
~Get Your Files Here !/14 - Schema and Data/83 - Primary Keys Multiple.mp4
16.7 MB
~Get Your Files Here !/14 - Schema and Data/84 - Foreign Keys.mp4
39.9 MB
~Get Your Files Here !/14 - Schema and Data/85 - Foreign Keys On Delete.mp4
36 MB
~Get Your Files Here !/14 - Schema and Data/86 - Indexes.mp4
10.6 MB
~Get Your Files Here !/14 - Schema and Data/87 - IF NOT EXISTS.mp4
9.7 MB
~Get Your Files Here !/14 - Schema and Data/88 - Rows.mp4
18.7 MB
~Get Your Files Here !/14 - Schema and Data/89 - Rows Insert Multiple.mp4
5.8 MB
~Get Your Files Here !/14 - Schema and Data/90 - Rows Handle onConflict.mp4
19.5 MB
~Get Your Files Here !/14 - Schema and Data/91 - Transactions.mp4
22.3 MB
~Get Your Files Here !/15 - Extras/92 - GreatestLeast.mp4
5.8 MB
~Get Your Files Here !/15 - Extras/93 - Nested Queries.mp4
9.4 MB
~Get Your Files Here !/15 - Extras/94 - Coalesce.mp4
9 MB
~Get Your Files Here !/15 - Extras/95 - Except.mp4
9.6 MB
~Get Your Files Here !/15 - Extras/96 - CTE.mp4
18.9 MB
~Get Your Files Here !/15 - Extras/97 - Generate Series.mp4
24.5 MB
~Get Your Files Here !/16 - Conclusion/98 - Where To Go Next.mp4
6 MB
~Get Your Files Here !/2 - Querying/10 - OrAnd.mp4
12.2 MB
~Get Your Files Here !/2 - Querying/11 - Not.mp4
15 MB
~Get Your Files Here !/2 - Querying/12 - Between.mp4
7.7 MB
~Get Your Files Here !/2 - Querying/13 - In.mp4
10.7 MB
~Get Your Files Here !/2 - Querying/14 - AnySum.mp4
19.7 MB
~Get Your Files Here !/2 - Querying/15 - Alias.mp4
17.5 MB
~Get Your Files Here !/2 - Querying/16 - Exists.mp4
17.3 MB
~Get Your Files Here !/2 - Querying/17 - Distinct.mp4
5.2 MB
~Get Your Files Here !/2 - Querying/18 - Like.mp4
19.3 MB
~Get Your Files Here !/2 - Querying/19 - Case When.mp4
9.1 MB
~Get Your Files Here !/2 - Querying/3 - Select.mp4
8.2 MB
~Get Your Files Here !/2 - Querying/4 - Select Multiple.mp4
7.1 MB
~Get Your Files Here !/2 - Querying/5 - Select Constants.mp4
6.9 MB
~Get Your Files Here !/2 - Querying/6 - Order By.mp4
17.5 MB
~Get Your Files Here !/2 - Querying/7 - Limit and Offset.mp4
16.3 MB
~Get Your Files Here !/2 - Querying/8 - Where Statement.mp4
11.3 MB
~Get Your Files Here !/2 - Querying/9 - IS NULL.mp4
12 MB
~Get Your Files Here !/4 - String Operators/20 - Lower Upper.mp4
8.4 MB
~Get Your Files Here !/4 - String Operators/21 - Initcap.mp4
6.3 MB
~Get Your Files Here !/4 - String Operators/22 - Concat.mp4
8.1 MB
~Get Your Files Here !/4 - String Operators/23 - Left.mp4
5.4 MB
~Get Your Files Here !/4 - String Operators/24 - Right.mp4
6.1 MB
~Get Your Files Here !/4 - String Operators/25 - Substring.mp4
7.6 MB
~Get Your Files Here !/4 - String Operators/26 - Length.mp4
13.9 MB
~Get Your Files Here !/4 - String Operators/27 - Replace.mp4
6.7 MB
~Get Your Files Here !/4 - String Operators/28 - Cast.mp4
13 MB
~Get Your Files Here !/4 - String Operators/29 - Trim.mp4
14.2 MB
~Get Your Files Here !/4 - String Operators/30 - SplitPart.mp4
8.6 MB
~Get Your Files Here !/6 - Aggregates/31 - Introduction.mp4
7.3 MB
~Get Your Files Here !/6 - Aggregates/32 - Min.mp4
6.4 MB
~Get Your Files Here !/6 - Aggregates/33 - Max.mp4
3.9 MB
~Get Your Files Here !/6 - Aggregates/34 - Sum.mp4
6 MB
~Get Your Files Here !/6 - Aggregates/35 - Avg.mp4
4 MB
~Get Your Files Here !/6 - Aggregates/36 - Count.mp4
8.3 MB
~Get Your Files Here !/6 - Aggregates/37 - Filter.mp4
18.3 MB
~Get Your Files Here !/6 - Aggregates/38 - Group By.mp4
15.5 MB
~Get Your Files Here !/6 - Aggregates/39 - Group By Multiple Columns.mp4
15.8 MB
~Get Your Files Here !/6 - Aggregates/40 - Having.mp4
13.2 MB
~Get Your Files Here !/6 - Aggregates/41 - Over.mp4
12.9 MB
~Get Your Files Here !/8 - Joins/42 - Union.mp4
12.3 MB
~Get Your Files Here !/8 - Joins/43 - Union All.mp4
9.1 MB
~Get Your Files Here !/8 - Joins/44 - Left Join.mp4
39.6 MB
~Get Your Files Here !/8 - Joins/45 - Inner Join.mp4