PostgreSQL Tutorial Full Course 2022

I provide here in this PostgreSQL tutorial a full course you can use to master PostgreSQL. Postgres is an object relational database that is just as fast as MySQL that adheres more closely to SQL standards and excels at concurrency. Postgres is also superior at avoiding data corruption.

TABLE OF CONTENTS
00:00 Intro
00:30 Why Use Postgres?
01:13 What is a Database
03:12 Change Database Theme
03:53 Create a Database
04:46 Design a Database
05:50 Turn Invoice into a Database
07:04 Make a Table
12:13 Data Types
16:36 Adding Data to Table
18:15 To See Data
18:25 SELECT
19:19 Create Custom Type
20:48 Change Column Data Type
22:58 Thinking About Tables
25:37 Breaking Up Tables
27:03  Primary & Foreign Keys
32:40 Foreign & Primary Keys
33:28 Altering Tables Many Examples
53:00 Getting Data from One Table
53:40 Where
54:30 Conditional Operators
55:48 Logical Operators
58:12 Order By
59:32 Limit
1:01:45 GROUP BY
1:03:11 Distinct
1:05:00 Getting Data from Multiple Tables
1:05:21 Inner Join
1:08:50 Join 3 Tables
1:13:15  Arithmetic Operators
1:13:45 Join with Where
1:14:55 Outer Joins
1:17:03 Cross Joins
1:18:16 Unions
1:19:27 Extract
1:21:05 IS NULL
1:22:03 SIMILAR LIKE & ~
1:29:25 GROUP BY
1:31:14  HAVING
1:32:18  AGGREGATE FUNCTIONS
1:34:22 WORKING WITH VIEWS
1:45:01 SQL Functions
1:49:00 Dollar Quotes
1:50:06 Functions that Return Void
1:52:38 Get Maximum Product Price
1:53:39 Get Total Value of Inventory
1:54:26 Get Number of Customers
1:56:15 Named Parameters
2:01:30 Return a Row / Composite
2:03:38 Get Multiple Rows
2:07:08 PL/pgSQL
2:11:35 Variables in Functions
2:15:55 Store Rows in Variables
2:19:17 IN INOUT and OUT
2:21:01 Using Multiple Outs
2:25:56 Return Query Results
2:33:42 IF ELSEIF and ELSE
2:38:48  CASE Statement
2:42:01 Loop Statement
2:45:20 FOR LOOP
2:48:34 Result Sets, Blocks & Raise Notice
2:51:11 For Each and Arrays
2:53:20 While Loop
2:54:54 Continue
3:01:34 Stored Procedures
3:09:35 Triggers
3:29:25 Cursors
3:39:45 Installation 

One of the more awesome things I like about being a .NET developer is LINQ. LINQ (Language Integrated Query) is a fluent query interface implemented in the .NET framework. It helps you query, sort and order any type of collection. This is a very neat way of querying arrays, lists, dictionaries, objects, etc. I’ve made 5 examples which run out of the box with Node.js (or io.js). You can also use the library for browser based JavaScript projects.

gts is Google's TypeScript style guide, and the configuration for our formatter, linter, and automatic code fixer. 

What’s new?

Here’s a sampling of the great new features and improvements in ASP.NET Core for .NET 7:

• Servers and runtime
  • Rating limiting: Limit the rate of handled requests using flexible endpoint configuration and policies.
  • Output caching: Configure output caching to reduce to more efficiently handle request.
  • Request decompression: Accept requests with compressed content.
  • HTTP/3: Built-in support for HTTP/3, the latest HTTP version based on the new QUIC multiplexed transport protocol.
  • WebSockets over HTTP/2: Use WebSockets over HTTP/2 connections.
  • WebTransport (experimental): Create streams and data grams over HTTP/3 with experimental support for WebTransport.
• Minimal APIs
  • Endpoint filters: Use endpoint filters to run cross-cutting code before or after a route handler.
  • Typed results: Return strongly typed results from minimal APIs.
  • Route groups: Organize groups of endpoints with a common prefix
• gRPC
  • JSON transcoding: Expand the reach of your gRPC services by also exposing them as JSON-based APIs
  • OpenAPI with JSON transcoding (experimenal): Use experimental support for generating OpenAPI specs for your gRPC JSON transcoded services.
  • gRPC health checks: Report and check the health of gRPC server apps.
  • gRPC client AddCallCredentials : Create clients that send authorized requests using bearer tokens.
• SignalR
  • Client results: Return client results to the server in response to requests from the server.
• MVC
  • Nullable view and page models: Nullable page and view models are now supported to improve the experience when using null state checking.
• Blazor
  • Custom elements: Build standard HTML custom elements with Blazor to integrate Blazor components with any JavaScript-based app.
  • Handle location changing events: Intercept location changing events to create custom user experiences when navigating.
  • Bind after/get/set modifiers: Run async logic after data binding and independently control how data binding gets and sets the data.
  • Dynamic authentication requests: Create dynamic authentication requests at runtime with custom parameters to handle advanced authentication scenarios in Blazor WebAssembly apps.
  • Improved JavaScript interop on WebAssembly: Optimize JavaScript interop call when running on WebAssembly using the new [JSImport]/[JSExport] support.
  • WebAssembly SIMD & exception handling: Improve performance with .NET WebAssembly ahead-of-time (AOT) compilation using WebAssembly SIMD and exception handling support. 

You don't need Axios, well, for most use cases. The web is maturing, and the days of Axios are ending. 

The Windows Subsystem for Linux in the Microsoft Store is now generally available on Windows 10 and 11 

his is the last preview for .NET 7 and the next version will be our first release candidate (RC). 

SVG is the standard format for storing vector graphics on the web like icons, charts, maps, infographics and illustrations