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
RapidGator
NitroFlare
Feel free to post your Complete SQL for Data Analytics and Business Intelligence Free Download, torrent, subtitles, free download, quality, NFO, Dangerous Complete SQL for Data Analytics and Business Intelligence Torrent Download, free premium downloads movie, game, mp3 download, crack, serial, keygen.