Learn SQL with 80 Interactive Exercises The Hands-on Guide (12 2024)

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

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

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm