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

Practical Database Administration and Engineering Step by Step

4.15 (219 reviews)
Udemy
platform
English
language
Databases
category
Database Engineer/DBA  -  (MySQL,  MongoDB,  SQLite)
25,787
students
17.5 hours
content
Nov 2021
last update
$64.99
regular price

What you will 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

Why take this course?

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.

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.

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.

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.

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.



Reviews

Chilumula
March 14, 2022
if a keyword or statement or operator in sql is explaining then at least different examples or needed for freshers, which is missing in this content. what vital here is more examples and interactions. overall its a so so classes.
Ujjwal
September 15, 2021
I am seeking for the oportunity in a software engineering field as a Database Engineer but i did not have the proper knowledge of Database and its related terminologies. So i was looking for the online course which can teach me basics and advance of database or its terminologies.Then i found this course. Thanks to you and the whole team behind this amazing course. Thanks.
Ivan
June 6, 2021
Muy buena la explicación del instructor a pesar de estar en idioma Ingles logre subtitular lo a español, mucha gracias Udemy y muchos éxitos
Srikanth
May 19, 2021
In this course the Instructor is explaining clearly and i understand the way of explanation. Thank you.
krishnan
May 19, 2021
Great course and I am absolutely recommending this to my friends, learned a lot during this course. The concepts were very well explained with clear examples. The instructor also replied in a fast and clear way. Terrific course

Charts

Price

Database Engineer/DBA  -  (MySQL,  MongoDB,  SQLite) - Price chart

Rating

Database Engineer/DBA  -  (MySQL,  MongoDB,  SQLite) - Ratings chart

Enrollment distribution

Database Engineer/DBA  -  (MySQL,  MongoDB,  SQLite) - Distribution chart
4048256
udemy ID
5/14/2021
course created date
5/17/2021
course indexed date
Angelcrc Seven
course submited by