Complete SQL Tutorial / PostgreSQL Notes

 

🎀Welcome, To PostgreSQL Course

📑Complete PostgreSQL With Notes Basic (Step-By-Step) Advance By StudySphere

1️⃣.Introduction to SQL-What Is SQL & Database

2️⃣. Data Types, Primary-Foreign Keys & Constraints

🅰️. Install postgresql and pgadmin4

3️⃣. Create Table In SQL & Create Database

4️⃣. INSERT UPDATE, DELETE & ALTER Table

5️⃣. SELECT Statement & WHERE Clause with Example

6️⃣. How To Import Excel File (CSV) to SQL

7️⃣. Functions in SQL & String Function

8️⃣. Aggregate Functions – Types & Syntax

9️⃣. Group By and Having Clause

🔟. Time Stamp and Extract Function, Date Time Function

1️⃣1️⃣. SQL JOINS – Types & Syntax

1️⃣2️⃣. SELF JOIN, UNION & UNION ALL

1️⃣3️⃣. Subquery

1️⃣4️⃣. Window Function – Types & Syntax

1️⃣5️⃣. Case Statement/Expression with examples

1️⃣6️⃣. CTE- Common Table Expression with examples