Database Engineer/DBA – (MySQL, MongoDB, SQLite)
Practical Database Administration and Engineering Step by Step
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
Requirements
-
Basic knowledge of excel will give you and idea of databases.
Who this course is for:
- Beginners to database administration and engineering
