Connect with us

Udemy

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

Published

on

Practical Database Administration and Engineering Step by Step.

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.
.
MongoDB uses dynamic schema. We can create collections without defining the structure,i.e. the fields or the types of their values, of the documents. You can change the structure of documents simply by adding new fields or deleting existing ones. Documents in a collection need unique set of fields.

READ ALSO:  Java For Beginners - 1st step towards becoming a Java Guru!

MongoDB database stores its data in collections  not in tables The collections are the rough equivalent of RDBMS tables.
A collection holds one or more documents, which corresponds to a record or a row in a relational database table, and each document  has one or more fields, which corresponds  to a column in a relational database table.

Advertisement

SQLite is a software library that provides a relational database management system. The lite in SQLite means light weight in terms of setup, database administration, and required resource.  SQLite does NOT require a server to run.

Because of the serverless architecture, you don’t need to “install” SQLite before using it. There is no server process that needs to be configured, started, and stopped. SQLite uses dynamic types for tables. It means you can store any value in any column, regardless of the data type.

READ ALSO:  SOLID Principles in Java Application Development

SQLite is self-contained means it requires minimal support from the operating system or external library. This makes SQLite usable in any environments especially in embedded devices like iPhones, Android phones, game consoles, handheld media players, etc.

SQLite is capable of creating in-memory databases which are very fast to work with.

Advertisement

SQLite database is integrated with the application that accesses the database. The applications interact with the SQLite database read and write directly from the database files stored on disk.

Who this course is for:

  • Beginners to database administration and engineering

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 into database
  • Updating existing records inside database
  • Deleting records from database
Enroll Now!

Requirements

  • Basic knowledge of excel will give you an idea of databases.
READ ALSO:  Web Designing Professionally: Real World Project
Join us on Telegram
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Trending

NaijaTechClan