Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
22
•
Activities:
0
•
Resources:
149
- 001 Data Roles and Responsibilities RYp3 gitir
- 002 Section Introduction 85X1 gitir
- 003 Database Servers and Clients jopI gitir
- 004 Local Set up Mac fwHQ gitir
- 005 Local Set up Windows WKSS gitir
- 006 Getting Familiar with pgAdmin aWYA gitir
- 008 Database and Schema kKPe gitir
- 009 Tables 6an0 gitir
- 010 Multiple databases and schemas krBG gitir
- 011 Creating a Database MhD5 gitir
- 015 Section Introduction yGTy gitir
- 016 Numeric Data Types i46D gitir
- 018 Character Data Types eWro gitir
- 019 Date and Time Data Types for9 gitir
- 020 Boolean Data Type Kvx9 gitir
- 021 Other Important Data Types zN4R gitir
- 022 Creating a Table l3hk gitir
- 023 Inserting Data into Table NETk gitir
- 029 Using Comments in SQL 76gj gitir
- 026 Section Introduction ihMP gitir
- 027 The SELECT statement GkD9 gitir
- 028 Common String Operators and Functions UbXM gitir
- 033 Section Introduction QqwW gitir
- 034 The WHERE Clause aEHs gitir
- 035 Comparison operators in WHERE Clause txQ0 gitir
- 036 Using WHERE with a List of Values FLpH gitir
- 037 Using WHERE within a specified range 9o4F gitir
- 038 Using WHERE with pattern matching Zd1z gitir
- 039 Compound WHERE Clause rkTd gitir
- 043 Section Introduction TtaS gitir
- 044 Updating Records in a Table wTHs gitir
- 045 Deleting Records from a Table vJ4z gitir
- 046 Dropping a Table from Database tv86 gitir
- 049 Section Introduction 5N86 gitir
- 050 One to Many and Many to One Relationships dM6p gitir
- 051 One to One and Many to Many Relationships Xgpy gitir
- 052 Primary Keys f4cI gitir
- 053 Foreign Keys FpNG gitir
- 054 Foreign Key Constraint on Delete 2C4l gitir
- 055 Foreign Key Constraint on Insert wkP5 gitir
- 056 Other Column Constraints DD50 gitir
- 057 Getting Table Schema Information b6yN gitir
- 060 Section Introduction cvOg gitir
- 061 Preparing Dataset Wch8 gitir
- 062 Why do we need Joins 82fU gitir
- 063 Inner Join RWHN gitir
- 064 Left Outer Join Hj4d gitir
- 065 Right Outer Join YzUB gitir
- 066 Full Outer Join veXb gitir
- 067 Exercise 1 2ia4 gitir
- 068 Table and Column Alias IVIU gitir
- 069 Exercise 2 lFF1 gitir
- 070 Exercise 3 rqa3 gitir
- 071 Exercise 4 9Qdm gitir
- 072 Join with Filter zUtM gitir
- 076 Section Introduction ICIi gitir
- 077 Aggregate Functions sHjZ gitir
- 078 Why do we group records ialQ gitir
- 079 Visualizing GROUP BY Operation iCHr gitir
- 080 Combining Grouping and Aggregation A9l0 gitir
- 081 Exercise Using Aggregation with Grouping V37u gitir
- 082 Filtering Groups RDMT gitir
- 083 Using WHERE and HAVING Together Hz4Z gitir
- 090 Limiting and Skipping Records 4MRo gitir
- 088 Section Introduction 3bxr gitir
- 089 Sorting Records 7xiY gitir
- 095 Section Introduction yWbK gitir
- 096 What is a Subquery jZ61 gitir
- 097 Where is a Subquery Used sqEx gitir
- 098 Subquery in SELECT Clause ejNp gitir
- 099 Subquery in FROM Clause uYbs gitir
- 100 Subquery in JOIN Clause XSyV gitir
- 101 Subquery in WHERE Clause P3So gitir
- 102 Correlated Subquery Lr66 gitir
- 107 Quick Recap uPaG gitir
- 108 Section Introduction r8GY gitir
- 109 Analytics Data Setup pW1G gitir
- 110 Exercise 1 Calculate the total revenue 7E8M gitir
- 111 Solution Exercise 1 5Rvo gitir
- 112 Exercise 2 Identify the top selling products ZpB2 gitir
- 113 Solution Exercise 2 GTBr gitir
- 114 Exercise 3 Calculate the Average Order Value AOV kwF4 gitir
- 115 Solution Exercise 3 LNK3 gitir
- 116 Exercise 4 Calculate the Customer Lifetime Value CLV r8O6 gitir
- 117 Solution Exercise 4 QGEg gitir
- 118 Exercise 5 Identify customers who have not made a purchase in a while MsdN gitir
- 119 Solution Exercise 5 kkpI gitir
- 120 Exercise 6 Show the most recent review for each product 6XHv gitir
- 121 Solution Exercise 6 1MoI gitir
- 122 Exercise 7 Identify the top rated products UVJM gitir
- 123 Solution Exercise 7 mGBR gitir
- 124 Exercise 8 Calculate discount based on order value g5Xj gitir
- 125 Solution Exercise 8 EB1t gitir
- 126 Section Introduction tYdI gitir
- 127 Explicit Type Casting hz2v gitir
- 128 Implicit Type Casting dOho gitir
- 130 Section Introduction 5JzV gitir
- 131 Current Date and Time MncA gitir
- 132 Time Zone Conversions Xhlb gitir
- 133 Truncating Date and Timestamp 6pz8 gitir
- 134 Example Truncating Date and Timestamp Z5h1 gitir
- 135 Extracting Parts of Date and Timestamp jyEg gitir
- 136 Formatting Date and Timestamp jSVk gitir
- 137 Date Math CHUo gitir
- 140 Section Introduction RffX gitir
- 141 What is an Array Ew8d gitir
- 142 Adding Columns of Array Data Type 5uwD gitir
- 143 Inserting Data into Array Columns FdQ4 gitir
- 144 Filtering Records Based on Array Values l4AX gitir
- 145 Array Indexing sOg4 gitir
- 146 Array Functions 6bQi gitir
- 147 Array Aggregation p8X3 gitir
- 148 Exercise Array Aggregation kWik gitir
- 149 Flattening of Arrays k9oQ gitir
- 151 Section Introduction Q7ik gitir
- 152 What is JSON fVSQ gitir
- 153 Adding Columns of JSON Data Type nJFo gitir
- 154 Inserting Data into JSON Columns WLEB gitir
- 155 Accessing JSON Fields BySI gitir
- 156 Filtering Records Based on JSON Fields fECy gitir
- 157 Constructing JSON Objects m6si gitir
- 158 JSON Aggregation cKZq gitir
- 160 Section Introduction btBB gitir
- 161 Data Setup uysP gitir
- 162 The RANK Window Function ZCwq gitir
- 163 The DENSE RANK Window Function pR5r gitir
- 164 The ROW NUMBER Window Function Nqm9 gitir
- 165 The LAG and LEAD Window Function qmVO gitir
- 166 LAG Function A Practical Use Case s5FH gitir
- 170 Section Introduction Y9v4 gitir
- 171 Common Table Expressions CTEs In Detail uxkS gitir
- 174 Section Introduction 4sdJ gitir
- 175 Data Setup mfU4 gitir
- 176 Handling Missing Values k9OR gitir
- 177 Handling Duplicates kpIQ gitir
- 178 Handling Outliers cLfk gitir
- 179 Standardizing Values in Categorical Columns 9xkM gitir
- 180 Standardizing Text Data mYBn gitir
- 181 Consistent Format for Numeric Data 47aJ gitir
- 183 Section Introduction scVD gitir
- 184 Importing Data From CSV to PostgreSQL Database ISS5 gitir
- 185 Exploratory Data Analysis EDA zj6q gitir
- 186 Identifying Sales Trends ICSS gitir
- 187 Date Dimension Table and Fact Table DbI2 gitir
- 188 A Generic and Reusable Date Dimension Table eRfe gitir
- 189 Top Business Categories By Sales fjZS gitir
- 190 Year over Year YoY Sales Analysis wzfs gitir
- 191 Quick Recap of the Key Concepts 5WAB gitir
- 198 Data Analyst Data Scientist Roadmap wZYj gitir