Database Engineer/DBA – (MySQL, MongoDB, SQLite)

Database Engineer/DBA – (MySQL, MongoDB, SQLite)

What you’ll learn

• Creating Databases
• Creating Tables
• Creating Views
• Creating Stored Procedures
• Using subqueries
• Managing users and privileges
• Performing backups and restore
• Perform table  joins
• Perform aggregate functions
• Attaching Sample Database
• Querying data from all columns in a table
• Querying data from specific columns in a table
• Sorting data using ORDER BY clause
• Removing duplicate records
• Identifying NULL values
• Filtering data
• Inserting data unto database
• Updating existing records inside database
• Deleting records from database