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

NitroFlare

https://nitroflare.com/view/6C7FDA405476971/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part01.rar
https://nitroflare.com/view/3F2775CA6155F3B/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part02.rar
https://nitroflare.com/view/C7607CFDCAD6163/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part03.rar
https://nitroflare.com/view/BBB515640971C19/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part04.rar
https://nitroflare.com/view/8845C2DC26F5812/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part05.rar
https://nitroflare.com/view/14AA184F546B9A7/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part06.rar
https://nitroflare.com/view/4BED09E951DDC7A/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part07.rar
https://nitroflare.com/view/EC4CC4910EE54FA/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part08.rar
https://nitroflare.com/view/BB98F11A1883DC4/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part09.rar

DDownload

https://ddownload.com/d87o875z8xw3/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part01.rar
https://ddownload.com/enjtmxzav7vc/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part02.rar
https://ddownload.com/yc3rhxfhmkoh/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part03.rar
https://ddownload.com/97f8ztxzsbzf/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part04.rar
https://ddownload.com/i8zycwsumrut/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part05.rar
https://ddownload.com/l76zwx1g3d1o/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part06.rar
https://ddownload.com/qcyxywetzg85/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part07.rar
https://ddownload.com/saf5h0a37mox/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part08.rar
https://ddownload.com/y6hko6so0l9v/Learn.SQL.The.Hands-on.Guide.with.interactive.exercises.part09.rar