[To see links please register or login]

**AD-TEAM** · 01-08-2026, 11:45 PM

8.95 GB | 15min 9s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English

Files Included :
FileName :01 Introduction.mp4 | Size: (9.09 MB)
FileName :02 About this course.mp4 | Size: (9.32 MB)
FileName :04 A first outlook SQL.mp4 | Size: (26.97 MB)
FileName :01 Why PostgreSQL.mp4 | Size: (5.61 MB)
FileName :02 Installing PostgreSQL.mp4 | Size: (42.62 MB)
FileName :03 Connecting to PostgreSQL through pgAdmin 4.mp4 | Size: (67.25 MB)
FileName :04 What is a DBMS Creating a database.mp4 | Size: (23.24 MB)
FileName :06 Importing the data.mp4 | Size: (48.55 MB)
FileName :01 Querying the data (SELECT).mp4 | Size: (99.34 MB)
FileName :02 Introduction Interactive code exercises.mp4 | Size: (50.64 MB)
FileName :03 Filtering with WHERE.mp4 | Size: (73.56 MB)
FileName :04 Multiple SQL statements and comments.mp4 | Size: (16.58 MB)
FileName :05 Renaming columns with AS.mp4 | Size: (5.6 MB)
FileName :06 Aggregate functions in SQL.mp4 | Size: (26.85 MB)
FileName :07 Getting DISTINCT entries.mp4 | Size: (38.69 MB)
FileName :08 Filtering with LIKE.mp4 | Size: (85.36 MB)
FileName :09 The BETWEEN and IN clause.mp4 | Size: (45.14 MB)
FileName :10 The ORDER BY clause.mp4 | Size: (28.88 MB)
FileName :11 Specifying an offset and a limit.mp4 | Size: (21.78 MB)
FileName :12 Quotes in SQL.mp4 | Size: (29.58 MB)
FileName :13 Bonus Quotes in MySQL and MariaDB.mp4 | Size: (6.4 MB)
FileName :01 Overview changing data.mp4 | Size: (1.87 MB)
FileName :03 INSERTing data.mp4 | Size: (71.99 MB)
FileName :04 Updating data (UPDATE).mp4 | Size: (116.06 MB)
FileName :05 Updating multiple columns at once (UPDATE).mp4 | Size: (5.33 MB)
FileName :06 Removing entries (DELETE).mp4 | Size: (7.65 MB)
FileName :01 Overview.mp4 | Size: (5.73 MB)
FileName :02 The missing value NULL.mp4 | Size: (72.74 MB)
FileName :03 NULL and aggregate functions (MIN, MAX, COUNT, , ).mp4 | Size: (25.82 MB)
FileName :04 String functions (part 1).mp4 | Size: (48.35 MB)
FileName :05 String functions (part 2).mp4 | Size: (16.26 MB)
FileName :06 Working with NULL (COALESCE).mp4 | Size: (11.44 MB)
FileName :07 Type casting with CAST.mp4 | Size: (19.02 MB)
FileName :08 Important numeric functions.mp4 | Size: (80.1 MB)
FileName :09 The CASE WHEN block.mp4 | Size: (21.91 MB)
FileName :10 WHERE and brackets ( ).mp4 | Size: (9.03 MB)
FileName :01 Overview.mp4 | Size: (2.71 MB)
FileName :02 Creating a first table.mp4 | Size: (13.42 MB)
FileName :03 Changing a table (ALTER TABLE).mp4 | Size: (33.26 MB)
FileName :04 Text types (VARCHAR, CHAR, TEXT).mp4 | Size: (59.96 MB)
FileName :05 Numeric types (SMALLINT, INT, BIGINT).mp4 | Size: (68.75 MB)
FileName :06 Numbers with a decimal point (FLOAT, DECIMAL).mp4 | Size: (112.95 MB)
FileName :07 Disabling NULL for a column.mp4 | Size: (26.41 MB)
FileName :08 Boolean columns.mp4 | Size: (13.5 MB)
FileName :09 DEFAULT values.mp4 | Size: (29.41 MB)
FileName :10 The PRIMARY KEY.mp4 | Size: (138.91 MB)
FileName :11 Automatically generating a primary key.mp4 | Size: (88.88 MB)
FileName :12 Working with binary data (BYTEA).mp4 | Size: (41.37 MB)
FileName :13 TRUNCATE and DROP.mp4 | Size: (37.26 MB)
FileName :14 Managing the tables through pgAdmin4.mp4 | Size: (27.72 MB)
FileName :01 Overview.mp4 | Size: (8.48 MB)
FileName :02 Creating the artists table.mp4 | Size: (30.27 MB)
FileName :03 Creating the albums table.mp4 | Size: (39.04 MB)
FileName :04 Exercise creating tracks table.mp4 | Size: (10.01 MB)
FileName :06 Exercise solution.mp4 | Size: (49.74 MB)
FileName :07 One-to-One relationship.mp4 | Size: (73.74 MB)
FileName :08 Many-to-many relationship.mp4 | Size: (76.41 MB)
FileName :09 Bonus compound primary keys.mp4 | Size: (58.54 MB)
FileName :10 How to develop a good schema.mp4 | Size: (104.97 MB)
FileName :01 Introduction, first subselect.mp4 | Size: (44.72 MB)
FileName :02 Correlated subquery.mp4 | Size: (56.64 MB)
FileName :03 Renaming table with AS.mp4 | Size: (17.35 MB)
FileName :04 Self-correlated subquery.mp4 | Size: (26.24 MB)
FileName :05 Subqueries in a WHERE condition.mp4 | Size: (49.46 MB)
FileName :06 Subquery with EXISTS.mp4 | Size: (41.28 MB)
FileName :07 Combining queries with UNION.mp4 | Size: (48.7 MB)
FileName :01 Overview JOINs.mp4 | Size: (4.72 MB)
FileName :02 A first join (CROSS JOIN).mp4 | Size: (20.81 MB)
FileName :03 INNER JOIN.mp4 | Size: (48.71 MB)
FileName :04 LEFT JOIN, RIGHT JOIN, FULL JOIN.mp4 | Size: (35.01 MB)
FileName :05 Which to use (a subquery or a join).mp4 | Size: (23.25 MB)
FileName :01 A first GROUP BY clause.mp4 | Size: (17.47 MB)
FileName :02 More complex grouping.mp4 | Size: (12.27 MB)
FileName :03 Filter after grouping (HAVING).mp4 | Size: (13.8 MB)
FileName :04 How is a query executed.mp4 | Size: (12.33 MB)
FileName :01 Overview VIEWs.mp4 | Size: (4.85 MB)
FileName :02 Creating a first VIEW.mp4 | Size: (23.67 MB)
FileName :03 Common use cases for VIEWs.mp4 | Size: (69.57 MB)
FileName :04 Materialized views.mp4 | Size: (131.73 MB)
FileName :05 Updatable VIEWs.mp4 | Size: (14.01 MB)
FileName :01 Overview (transactions).mp4 | Size: (15.06 MB)
FileName :02 Create a first transaction.mp4 | Size: (99.95 MB)
FileName :03 Accessing data within a transaction.mp4 | Size: (9.49 MB)
FileName :04 SAVEPOINT in a transaction.mp4 | Size: (15.81 MB)
FileName :05 How transactions work, performance implications.mp4 | Size: (25.9 MB)
FileName :06 The ACID properties.mp4 | Size: (10.96 MB)
FileName :07 Transaction controls from pgAdmin 4.mp4 | Size: (11.26 MB)
FileName :01 Overview Indexes.mp4 | Size: (14.64 MB)
FileName :03 Importing and exploring the data.mp4 | Size: (35.68 MB)
FileName :04 EXPLAINing the query.mp4 | Size: (34.71 MB)
FileName :05 How to measure execution performance.mp4 | Size: (64.11 MB)
FileName :06 How does an index improve performance.mp4 | Size: (23.09 MB)
FileName :07 Creating an index (CREATE INDEX).mp4 | Size: (96.87 MB)
FileName :08 Investigating index problems.mp4 | Size: (58.87 MB)
FileName :09 Creating a UNIQUE index.mp4 | Size: (36.1 MB)
FileName :01 Overview.mp4 | Size: (44.52 MB)
FileName :03 Creating a UNIQUE constraint.mp4 | Size: (108.29 MB)
FileName :04 Unique constraint vs index.mp4 | Size: (54.93 MB)
FileName :05 Heads-up (STRPOS).mp4 | Size: (74.71 MB)
FileName :06 Creating a custom constraint (CHECK).mp4 | Size: (89.83 MB)
FileName :07 Foreign key constraints.mp4 | Size: (114.88 MB)
FileName :08 Changing the behavior (ON UPDATE, ON DELETE).mp4 | Size: (92.11 MB)
FileName :01 Overview.mp4 | Size: (4.39 MB)
FileName :02 TIME, DATE, TIMESTAMP.mp4 | Size: (30.13 MB)
FileName :03 Creating the data.mp4 | Size: (19.76 MB)
FileName :05 Extracting data from timestamps.mp4 | Size: (59.2 MB)
FileName :06 Calculating INTERVALs.mp4 | Size: (50.16 MB)
FileName :07 Timezones.mp4 | Size: (71.33 MB)
FileName :08 Keeping track of creation time of an entry.mp4 | Size: (61.01 MB)
FileName :01 Overview.mp4 | Size: (7.84 MB)
FileName :02 How to perform a migration.mp4 | Size: (56.21 MB)
FileName :03 Exercise refactoring data.mp4 | Size: (48.33 MB)
FileName :04 Sample solution (part 1).mp4 | Size: (65.09 MB)
FileName :05 Sample solution (part 2).mp4 | Size: (86.87 MB)
FileName :01 Overview Arrays.mp4 | Size: (25.72 MB)
FileName :02 Creating a first array.mp4 | Size: (20.31 MB)
FileName :06 How to access an array.mp4 | Size: (21.76 MB)
FileName :09 The ANY and ALL functions.mp4 | Size: (23.89 MB)
FileName :14 The UNNEST function in PostgreSQL.mp4 | Size: (84.58 MB)
FileName :17 Bonus, optimized search with an index.mp4 | Size: (112.27 MB)
FileName :20 Modifying an array.mp4 | Size: (20.17 MB)
FileName :25 When to use an array (best practices).mp4 | Size: (40.15 MB)
FileName :01 Overview.mp4 | Size: (10.16 MB)
FileName :03 Importing and exploring the data.mp4 | Size: (19.84 MB)
FileName :04 GROUPING SETS and GROUPING.mp4 | Size: (192.66 MB)
FileName :05 The ROLLUP function.mp4 | Size: (17.77 MB)
FileName :06 The CUBE function.mp4 | Size: (11.89 MB)
FileName :07 OVER and PARTITION BY.mp4 | Size: (129.51 MB)
FileName :08 GROUP BY vs OVER.mp4 | Size: (4.32 MB)
FileName :09 The ROW NUMBER function.mp4 | Size: (20.72 MB)
FileName :10 The LAG and LEAD functions.mp4 | Size: (156.42 MB)
FileName :11 The STRING AGG and ARRAY AGG functions.mp4 | Size: (75.35 MB)
FileName :12 Common Table Expressions (CTEs).mp4 | Size: (47.46 MB)
FileName :13 Temporary tables.mp4 | Size: (34.08 MB)
FileName :15 When to use what.mp4 | Size: (14.73 MB)
FileName :01 Overview.mp4 | Size: (20.91 MB)
FileName :03 Using a different collation.mp4 | Size: (174.42 MB)
FileName :04 Changing the collation of a column.mp4 | Size: (22.3 MB)
FileName :05 Collations and Indexes.mp4 | Size: (23.84 MB)
FileName :06 Language-specific collations.mp4 | Size: (19.16 MB)
FileName :01 Overview.mp4 | Size: (75.05 MB)
FileName :03 Creating a user, logging in as a user.mp4 | Size: (37.23 MB)
FileName :04 Granting permissions to roles.mp4 | Size: (68.78 MB)
FileName :05 Revoking permissions from roles.mp4 | Size: (7.8 MB)
FileName :06 Managing permissions through pgAdmin 4.mp4 | Size: (29.98 MB)
FileName :07 Using a VIEW with permissions.mp4 | Size: (39.25 MB)
FileName :01 Overview.mp4 | Size: (14.02 MB)
FileName :02 Creating a stored procedure.mp4 | Size: (26.2 MB)
FileName :03 What does the $$ mean.mp4 | Size: (26.76 MB)
FileName :04 Managing permissions on stored procedures - 1.mp4 | Size: (65.76 MB)
FileName :05 Managing permissions on stored procedures - 2.mp4 | Size: (32.54 MB)
FileName :01 Overview.mp4 | Size: (6.86 MB)
FileName :02 Writing a PLpgSQL script.mp4 | Size: (27.98 MB)
FileName :03 Variables in PLpgSQL.mp4 | Size: (21.97 MB)
FileName :04 Loops in PLpgSQL.mp4 | Size: (14.82 MB)
FileName :05 Conditionals in PLpgSQL.mp4 | Size: (12.3 MB)
FileName :07 Creating a trigger.mp4 | Size: (142.92 MB)
FileName :09 Refreshing data with a trigger.mp4 | Size: (179.65 MB)
FileName :11 Intercepting an SQL command with a trigger.mp4 | Size: (136.27 MB)
FileName :12 Triggers and permissions.mp4 | Size: (50.13 MB)
FileName :13 Triggers and the SQL standard.mp4 | Size: (13.95 MB)
FileName :01 Exporting data with PostgreSQL.mp4 | Size: (131.8 MB)
FileName :02 Full-text search in PostgreSQL.mp4 | Size: (156.96 MB)
FileName :03 Speeding up a full-text search.mp4 | Size: (51.22 MB)
FileName :04 Best practices - 1.mp4 | Size: (75.62 MB)
FileName :05 Best practices - 2.mp4 | Size: (40.64 MB)
FileName :06 Best practices - 3.mp4 | Size: (16.24 MB)
FileName :01 Overview.mp4 | Size: (7.76 MB)
FileName :03 Installing Python and VS Code.mp4 | Size: (67.82 MB)
FileName :04 Connecting to PostgreSQL.mp4 | Size: (220.93 MB)
FileName :05 Inserting data in PostgreSQL.mp4 | Size: (125.78 MB)
FileName :06 Passing parameters through dictionaries.mp4 | Size: (32.2 MB)
FileName :07 Preventing SQL injections.mp4 | Size: (253.66 MB)
FileName :08 Bonus Object Relational Mappers (ORMs).mp4 | Size: (132.42 MB)
FileName :01 Overview.mp4 | Size: (11.93 MB)
FileName :03 MySQL installation.mp4 | Size: (105.98 MB)
FileName :04 Using MySQL Workbench.mp4 | Size: (20.31 MB)
FileName :05 Differences between PostgreSQL and MySQL - 1.mp4 | Size: (95.33 MB)
FileName :06 Similarities between PostgreSQL and MySQL.mp4 | Size: (15.1 MB)
FileName :07 Differences between PostgreSQL and MySQL - 2.mp4 | Size: (52.43 MB)
FileName :08 Data types in MySQL.mp4 | Size: (70.03 MB)
FileName :09 The utf8 general ci collation.mp4 | Size: (31.65 MB)
FileName :01 Overview.mp4 | Size: (15.64 MB)
FileName :02 Installing DB Browser.mp4 | Size: (32.17 MB)
FileName :03 Differences between PostgreSQL and SQLite - 1.mp4 | Size: (82.3 MB)
FileName :04 Differences between PostgreSQL and SQLite - 2.mp4 | Size: (61.5 MB)
FileName :05 Data types in SQLite - 1.mp4 | Size: (52.62 MB)
FileName :06 Data types in SQLite - 2.mp4 | Size: (127.31 MB)
FileName :01 Closing Words.mp4 | Size: (7.77 MB)]
Screenshot
[Image: deOa2F01_o.jpg]