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

Short Description

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

This course includes:

  • 17.5 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Requirements

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

Description

The MySQL is the world’s most popular open source database.This course will teach you  a lot to  start using this incredibly popular MySQL database and gain useful skills in the process.  In learning about MySQL you will also gain an understanding of relational databases in general.  Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.

MongoDB is a document-oriented DBMS, with JSON-like  objects comprising the data model, rather  than RDBMS tables. MongoDB does not support joins nor transactions. However, it features  secondary indexes, an expressive query language,atomic writes on a per-document level, and fully-consistent reads. MongoDB uses JSON, a binary object format similar to, but more expressive than JSON.

Do check: Power BI

Get 3 course worth $129 for FREE

RECENT COURSE

CHECKOUT