9.48 GB | 24min 13s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English
Files Included :
1 Data Roles and Responsibilities.mp4 (32.45 MB)
1 Section Introduction.mp4 (1.11 MB)
2 Database Servers and Clients.mp4 (128.18 MB)
3 Local Set up - Mac.mp4 (101.21 MB)
4 Local Set up - Windows.mp4 (50.67 MB)
5 Getting Familiar with pgAdmin.mp4 (46.12 MB)
1 Database and Schema.mp4 (16.32 MB)
2 Tables.mp4 (16.88 MB)
3 Multiple databases and schemas.mp4 (40.19 MB)
4 Creating a Database.mp4 (55.89 MB)
1 Section Introduction.mp4 (16.81 MB)
2 Numeric Data Types.mp4 (35.6 MB)
4 Character Data Types.mp4 (40.54 MB)
5 Date and Time Data Types.mp4 (21.27 MB)
6 Boolean Data Type.mp4 (6.53 MB)
7 Other Important Data Types.mp4 (27.56 MB)
8 Creating a Table.mp4 (30.24 MB)
9 Inserting Data into Table.mp4 (107.74 MB)
1 Section Introduction.mp4 (5.35 MB)
2 The SELECT statement.mp4 (25.91 MB)
3 Common String Operators and Functions.mp4 (122.49 MB)
4 Using Comments in SQL.mp4 (29.58 MB)
1 Section Introduction.mp4 (5.69 MB)
2 The WHERE Clause.mp4 (44.03 MB)
3 Comparison operators in WHERE Clause.mp4 (35.02 MB)
4 Using WHERE with a List of Values.mp4 (25.83 MB)
5 Using WHERE within a specified range.mp4 (32.72 MB)
6 Using WHERE with pattern matching.mp4 (38.97 MB)
7 Compound WHERE Clause.mp4 (27.85 MB)
1 Section Introduction.mp4 (5.54 MB)
2 Updating Records in a Table.mp4 (47.45 MB)
3 Deleting Records from a Table.mp4 (36.81 MB)
4 Dropping a Table from Database.mp4 (19.81 MB)
1 Section Introduction.mp4 (98.66 MB)
2 One-to-Many and Many-to-One Relationships.mp4 (50.55 MB)
3 One-to-One and Many-to-Many Relationships.mp4 (44.98 MB)
4 Primary Keys.mp4 (128.47 MB)
5 Foreign Keys.mp4 (102.82 MB)
6 Foreign Key Constraint on Delete.mp4 (104.42 MB)
7 Foreign Key Constraint on Insert.mp4 (28.53 MB)
8 Other Column Constraints.mp4 (120.29 MB)
9 Getting Table Schema Information.mp4 (77.95 MB)
1 Section Introduction.mp4 (11.4 MB)
2 Preparing Dataset.mp4 (115.36 MB)
3 Why do we need Joins.mp4 (20.44 MB)
4 Inner Join.mp4 (91.66 MB)
5 Left Outer Join.mp4 (109.81 MB)
6 Right Outer Join.mp4 (69.1 MB)
7 Full Outer Join.mp4 (67.34 MB)
8 Exercise 1.mp4 (107.9 MB)
9 Table and Column Alias.mp4 (25.98 MB)
10 Exercise 2.mp4 (47.13 MB)
11 Exercise 3.mp4 (93.11 MB)
12 Exercise 4.mp4 (74.04 MB)
13 Join with Filter.mp4 (57.2 MB)
1 Section Introduction.mp4 (34.42 MB)
2 Aggregate Functions.mp4 (114.06 MB)
3 Why do we group records.mp4 (66.1 MB)
4 Visualizing GROUP BY Operation.mp4 (107.07 MB)
5 Combining Grouping and Aggregation.mp4 (121.59 MB)
6 Exercise Using Aggregation with Grouping.mp4 (79.87 MB)
7 Filtering Groups.mp4 (79.6 MB)
8 Using WHERE and HAVING Together.mp4 (124.49 MB)
1 Section Introduction.mp4 (7.33 MB)
2 Sorting Records.mp4 (52.54 MB)
3 Limiting and Skipping Records.mp4 (73.36 MB)
1 Section Introduction.mp4 (8.11 MB)
2 What is a Subquery.mp4 (33.33 MB)
3 Where is a Subquery Used.mp4 (34.73 MB)
4 Subquery in SELECT Clause.mp4 (106.75 MB)
5 Subquery in FROM Clause.mp4 (101.78 MB)
6 Subquery in JOIN Clause.mp4 (143.78 MB)
7 Subquery in WHERE Clause.mp4 (118.58 MB)
8 Correlated Subquery.mp4 (150.13 MB)
1 Quick Recap!.mp4 (40.18 MB)
2 Section Introduction.mp4 (28.9 MB)
3 Analytics Data Setup.mp4 (47.42 MB)
4 Exercise 1 Calculate the total revenue.mp4 (26.15 MB)
5 Solution - Exercise 1.mp4 (27.97 MB)
6 Exercise 2 Identify the top selling products.mp4 (51.06 MB)
7 Solution - Exercise 2.mp4 (78.85 MB)
8 Exercise 3 Calculate the Average Order Value (AOV).mp4 (87.96 MB)
9 Solution - Exercise 3.mp4 (36.26 MB)
10 Exercise 4 Calculate the Customer Lifetime Value (CLV).mp4 (44.56 MB)
11 Solution - Exercise 4.mp4 (78.49 MB)
12 Exercise 5 Identify customers who have not made a purchase in a while.mp4 (40.94 MB)
13 Solution - Exercise 5.mp4 (70.25 MB)
14 Exercise 6 Show the most recent review for each product.mp4 (67.13 MB)
15 Solution - Exercise 6.mp4 (117.34 MB)
16 Exercise 7 Identify the top rated products.mp4 (33.41 MB)
17 Solution - Exercise 7.mp4 (49.97 MB)
18 Exercise 8 Calculate discount based on order value.mp4 (26.33 MB)
19 Solution - Exercise 8.mp4 (37.82 MB)
1 Section Introduction.mp4 (18.98 MB)
2 Explicit Type Casting.mp4 (48.1 MB)
3 Implicit Type Casting.mp4 (29.63 MB)
1 Section Introduction.mp4 (11.96 MB)
2 Current Date and Time.mp4 (34.22 MB)
3 Time Zone Conversions.mp4 (80.58 MB)
4 Truncating Date and Timestamp.mp4 (41.89 MB)
5 Example Truncating Date and Timestamp.mp4 (100.14 MB)
6 Extracting Parts of Date and Timestamp.mp4 (47.66 MB)
7 Formatting Date and Timestamp.mp4 (35.77 MB)
8 Date Math.mp4 (42.93 MB)
1 Section Introduction.mp4 (26.83 MB)
2 What is an Array.mp4 (32.56 MB)
3 Adding Columns of Array Data Type.mp4 (32.34 MB)
4 Inserting Data into Array Columns.mp4 (34.74 MB)
5 Filtering Records Based on Array Values.mp4 (55.5 MB)
6 Array Indexing.mp4 (33.55 MB)
7 Array Functions.mp4 (56.83 MB)
8 Array Aggregation.mp4 (117.39 MB)
9 Exercise Array Aggregation.mp4 (61.29 MB)
10 Flattening of Arrays.mp4 (25.25 MB)
1 Section Introduction.mp4 (27.81 MB)
2 What is JSON.mp4 (91.08 MB)
3 Adding Columns of JSON Data Type.mp4 (32.92 MB)
4 Inserting Data into JSON Columns.mp4 (45.24 MB)
5 Accessing JSON Fields.mp4 (141.82 MB)
6 Filtering Records Based on JSON Fields.mp4 (156.83 MB)
7 Constructing JSON Objects.mp4 (64.25 MB)
8 JSON Aggregation.mp4 (59.78 MB)
1 Section Introduction.mp4 (7.4 MB)
2 Data Setup.mp4 (9.99 MB)
3 The RANK() Window Function.mp4 (256.38 MB)
4 The DENSE RANK() Window Function.mp4 (81.8 MB)
5 The ROW NUMBER() Window Function.mp4 (71.42 MB)
6 The LAG() and LEAD() Window Function.mp4 (134.52 MB)
7 LAG() Function - A Practical Use Case.mp4 (48.13 MB)
1 Section Introduction.mp4 (38.16 MB)
2 Common Table Expressions (CTEs) In Detail.mp4 (170.37 MB)
1 Section Introduction.mp4 (128.45 MB)
2 Data Setup.mp4 (19.76 MB)
3 Handling Missing Values.mp4 (138.83 MB)
4 Handling Duplicates.mp4 (147.09 MB)
5 Handling Outliers.mp4 (67.63 MB)
6 Standardizing Values in Categorical Columns.mp4 (46.55 MB)
7 Standardizing Text Data.mp4 (42.31 MB)
8 Consistent Format for Numeric Data.mp4 (59.54 MB)
1 Section Introduction.mp4 (31.47 MB)
2 Importing Data From CSV to PostgreSQL Database.mp4 (122.97 MB)
3 Exploratory Data Analysis (EDA).mp4 (145.61 MB)
4 Identifying Sales Trends.mp4 (138.21 MB)
5 Date Dimension Table and Fact Table.mp4 (151.37 MB)
6 A Generic and Reusable Date Dimension Table.mp4 (165.01 MB)
7 Top Business Categories By Sales.mp4 (133.14 MB)
8 Year-over-Year (YoY) Sales Analysis.mp4 (131.39 MB)
9 Quick Recap of the Key Concepts.mp4 (55.38 MB)
1 Data Analyst Data Scientist Roadmap.mp4 (91.17 MB)]
Screenshot
DDownload
https://ddownload.com/trktbfliio5e https://ddownload.com/vz97f00dlaej https://ddownload.com/hikysupv8k48 https://ddownload.com/rw8cf0dx5mzh https://ddownload.com/uqxd6exzd0gm https://ddownload.com/chumfo2jkm8x https://ddownload.com/egrnptaiffl5 https://ddownload.com/ixlruift47dc https://ddownload.com/pabeg19d1ulk
https://rapidgator.net/file/ea3b4d20a392325cc887e587b9dbd487/ https://rapidgator.net/file/5a03327ee5cfc54a2457c4cfc82f1c2c/ https://rapidgator.net/file/6b051f058f7524aef6b375fccafc834c/ https://rapidgator.net/file/1477cba5cf0a92e96f1248edc4871926/ https://rapidgator.net/file/a445dce7e285fac0bf5fd5025c4b0f93/ https://rapidgator.net/file/63d2082a052b38adaab76b4325332c7e/ https://rapidgator.net/file/c570adf574d9e970ea8a294ae3e76abd/ https://rapidgator.net/file/1f67adcdcb18ed0f56d868e8ee6b0877/ https://rapidgator.net/file/a23f641451007ad5fe593330e5ede21d/
NitroFlare
https://nitroflare.com/view/B22CDF46FADB4B9/ https://nitroflare.com/view/1A2FC7F88553AF9/ https://nitroflare.com/view/3A204BF2C8385EC/ https://nitroflare.com/view/8D34B8344CDC2EE/ https://nitroflare.com/view/5BF9C277E6636DC/ https://nitroflare.com/view/F1CB71D71FE677E/ https://nitroflare.com/view/8DA6B13710A01F8/ https://nitroflare.com/view/7EA8C165289C20C/ https://nitroflare.com/view/ECF3B89759C9A40/
