Topics

• Web Apps With Express
• Find
• Backup using mysqldump
• Inserting text
• DELETE
• Getting started with python-requests
• String Functions
• Installing Node.js
• String operations
• DELETE
• Getting started with grep
• Spread Operator
• Joins
• Create New User
• Indexes
• Data Types
• Spaceship Operator
• Collection Operators
• Safe Navigation Operator
• mysqlimport
• JSON
• MySQL client
• Functions
• Dealing with sparse or missing data

Examples

• Creating a backup of a database or table
• Specifying username and password
• Using Node Version Manager (nvm)
• Multi-Table Deletes
• Calling a method
• Serving static files
• Find text within a given directory, recursively
• Create a MySQL User
• Index Creation Basics
• Unique Index
• Basic usage
• Spaceship operator for custom sortings
• Reading the response
• Reading status codes
• INSTR
• LOWER() / LCASE()
• REPLACE()
• SUBSTRING()
• Iterate over a collection
• Create a new list using collect
• Filter a list with findAll
• Find the first element matching a condition
• Create maps with collectEntries
• Apply transformation to nested collections
• Flatten a nested list
• Remove duplicates
• Basic usage
• Concatenation of safe navigation operators
• Basic usage
• Using a custom field-delimiter
• Using a custom row-delimiter
• Handling duplicate keys
• Conditional import
• Import a standard csv
• UPPER() / UCASE()
• Parse a json string
• Parse a json file
• Write a json to string
• Pretty-print a json string
• Disable auto-indent to paste code
• LENGTH()
• CHAR_LENGTH()
• Filter the path
• Base login
• Execute commands
• Full Outer Join
• Base example
• Multiple outputs
• Working with columns containg NULL values
• nargin, nargout
• Specify the password