Dart - Advanced Course

Learn to create and extract zip archives in Dart with the archive package, including installation, importing necessary modules, and building and decoding zip content.

Demonstrate implementing a stream cipher using salsa20, creating a key and initialization vector, and encrypting then decrypting data to show symmetric encryption with a Hello, world example.

Explore socket programming with a simple Dart TCP server that binds to 127.0.0.1:3000, listens for connections, decodes incoming data, and prints the remote address, port, and message.

Create a TCP client that connects to the server, sends data quickly, and closes the socket, while the operating system handles the data push.

Learn to fetch web pages with the Dart HTTP package by performing get requests, inspecting response status, and printing the response body, including handling 200 and 404 codes.

Learn to use the siecle tjokkie package in a Dart command-line setup to configure a connection pool to localhost:3306, perform select star from teachers, and print the resulting row count.

Learn to prepare reusable queries in Dart, insert data with prepared statements, execute inserts asynchronously, and verify inserted records by retrieving new IDs.

Learn how to use database transactions to chain inserts, updates, and deletes across multiple tables, commit on success, or roll back on failure.