Mongodb online Training course Agenda

Goal: In this module, you will get an understanding of NoSQL databases, design goals, requirement of NoSQL database/ MongoDB, MongoDB® architecture and introduction to JSON and BSON among others. This module will also cover the installation of MongoDB® and associated tools.

Skills

Understand NoSQL databases and advantages

Install MongoDB on Windows and Linux platform

Security Enable and high availability

Objectives

After completing this module, you will be able knowledge ed on

SQL and noSQL Database usages and difference between these

MongoDB design and architecture

MongoDB GUI tools

Describe JSON and BSON

Install MongoDB on Windows, Linux, MAC OS etc.

Setup MongoDB environment

Topics

• Understanding the basic concepts of a Database

• Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS

• Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property

• CAP Theorem, implementing NoSQL and what is MongoDB?

• Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools

• Understanding the following: Collection, Documents and Key/ Values, etc.,

• Introduction to JSON and BSON documents

• Environment setup (live Hands-on) and using various MongoDB tools available in the MongoDB Package

• Case study discussion

Hands-on/Demo/Use-case

• MongoDB Installation

Comments

About MySQL - Database history Support and Versioning

About MySQL: MySQL was created by a Swedish company. David Axmark (left) and Michael "Monty" Widenius, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995. It was initially created for personal usage from mSQL based on the low-level language ISAM, which the creators considered too slow and inflexible. They created a new SQL interface, while keeping the same API as mSQL. By keeping the API consistent with the mSQL system, many developers were able to use MySQL instead of the (proprietarily licensed) mSQL antecedent. Support: The MySQL server software itself and the client libraries use dual-licensing distribution. They are offered under GPL version 2, or a proprietary license. MySQL AB owns the copyright to the MySQL source code. This means that MySQL AB can distribute MySQL under several different l...

MySQL thread error code of 1032- Translate binlog completely to avoid error

Could not execute Update_rows event on table db.table; Can't find record in 'table', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.262297, end_log_pos 1983208 As of my knowledge the causing stop of slave SQL thread error code of 1032, due to lack of sync between Master - Slave. In our case, slave got an Update event form master, but that particular record was not available in the slave. (Of course, that was deleted on Master n Slave separately) You would get this error only if the binlog_format is set to ROW_BASED or MIXED mode. So, now check that particular binlog at that position where replication stopped with this error. When you convert the binlog with mysqlbinlog command, you may see some junk characters where you were expecting some DMLs which caused the error(In our case its an Update statement). So you can use below command to translate binlog completely: mysqlbinlog --base64-output=DECO...

MySQL Architecture -Client Server Architecture

Client/Server Overview The MySQL database system operates using a client/server architecture. The server is a central program that manages database contents, and client programs connect to the server to retrieve or modify the data. MySQL also includes non-client utility programs and scripts. MySQL Server: This is the mysqld program that manages database and tables. Most users choose binary MySQL distribution that includes a server ready to run with the capabilities they need, but it's also possible to compile MySQL from source. Client Programs: These are programs that communicate with the server by sending requests to it over a network connection. The server acts on each request and returns a response to the client. For example you can use the mysql client to send queries to the server, and the server returns the query results. A client program can connect locally to a server running on the same machine or remotely to a server running on a different mac...

Mr.K.Subrahmanyeswarao

Search This Blog