Topics

• Jobs and Processes
• Limit and Offset
• Backup using mysqldump
• Getting started with MongoDB
• Table Creation
• Error codes
• String operations
• DELETE
• VIEW
• Comment Mysql
• LOAD DATA INFILE
• ALTER TABLE
• TRIGGERS
• Create New User
• Group By

Examples

• Limit and Offset relationship
• Creating a backup of a database or table
• Restoring a backup of a database or table
• Basic table creation
• Table creation with Primary Key
• Table creation with Foreign Key
• Error code 1064: Syntax error
• Adding comments
• using LOAD DATA INFILE to load large amount of data to database
• Basic Trigger
• Create a MySQL User
• Group By Using MIN function
• DELETE vs TRUNCATE
• STR_TO_DATE - Convert string to date
• Change auto-increment value
• Changing the type of a primary key column
• Commenting table definitions
• Basic commands on mongo shell