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

Practical Database Administration and Engineering Step by Step

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I 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

Requirements

• Basic knowledge of excel will give you and idea of databases.

Target audience

• Beginners to database administration and engineering