MongoDB : A Complete Database Administration Course

Set up a mongodb lab by installing oracle virtualbox and extension pack, importing a centos virtual image, configuring networking, retrieving the vm ip with ifconfig, and connecting via putty.

Install mongodb enterprise edition on linux by configuring a repository, then using yum to install and manage the service with systemctl, enabling startup and verifying port 27017.

Start the MongoDB server, verify it runs with netstat and systemctl, then connect with the mongo shell using host and port, and view version and databases.

MongoDB creates a database implicitly when you use a database name, and you can list databases with show dbs; make it non-empty by creating a collection.

Learn how to create collections in MongoDB using the create collection method or by inserting documents, including implicit collection creation and options for capped and non-cap collections.

Master MongoDB index management by creating single and compound indexes, listing indexes with get indexes, and naming them, while understanding explain plans and the default ID index.

Create and manage MongoDB indexes with practical steps for single-field, compound, and unique indexes, including named indexes and the default _id index.

Learn to drop MongoDB indexes using dropIndex and dropIndexes, including removing a single named index, or multiple indexes via an array, while preserving the default _id index. Verify with getIndexes.

Understand capped collections in MongoDB, fixed-size buffers that overwrite oldest documents when full, limited by max size or max documents, created with db.createCollection and cap options.

Learn how to insert documents into a MongoDB collection using insert one, insert many, or insert, and understand how MongoDB creates a unique object id when no id is provided.

Learn how to read and select documents in a MongoDB collection using find and find one, with filtering conditions and field projections to display or hide fields.

Learn to update documents in MongoDB using updateOne and updateMany, with a matching criteria and the $set operator to update one or more fields, creating fields if needed.

Learn to update MongoDB documents using update one and update many, modify single or multiple fields, verify results with find, and handle field creation and typos in practical examples.

Learn how to delete documents in a MongoDB collection using deleteOne and deleteMany, with filter documents such as id, title, or type, and see practical examples.

Secure MongoDB by enabling authentication and authorization, and create an administrator user with proper roles before starting the server with authentication.

Enables authentication in MongoDB by starting without auth, creating an admin user with root role, and restarting with --auth, then connecting with credentials to access databases and collections.

Create a regular user in MongoDB by supplying a username, password (or password prompt), and an array of roles across databases using the db.createUser command in the chosen authentication database.

Explore MongoDB built-in roles, including database user roles (read, readWrite), database admin roles (dbAdmin, dbOwner, userAdmin), cluster admin roles, backup/restore, and all database roles such as read, readWrite, and root.

Learn practical techniques to list built-in and user-defined MongoDB roles with db.getRoles in the admin database, display privileges, and filter results using show privileges and show built in roles.

Create user defined roles in MongoDB by defining privileges and inherited roles, granting privileges to roles, and assigning roles to users across admin database, movies database, and students database.

Learn to assign and manage user roles in MongoDB using grantRolesToUser and updateUser, including adding roles, replacing all roles, and revoking roles on databases like admin, students, and movies.

MongoDB 4.0 requires creating a user-defined role to grant privileges, then assigning that role to the user. Use a read-only role with insert and find privileges on the movie database.

Create a custom role with change on password and change on custom data privileges in the admin database, then grant that role to users to enable password changes.

Enable MongoDB auditing via command line or config, selecting destinations such as syslog, console, or json/bson files, and log CRUD, authentication, authorization, and replica set or sharded cluster activities.

Start a MongoDB server from the command line using dbpath, port, and log path, with default values (dbpath /data/db, port 27017), and run in foreground or fork for background.

Binds the mongod server to an IP address to enable remote connections, using the --bind_ip option or network.bindIp in the config; demonstrates connecting via mongo --host and --port.

Learn to start MongoDB using a configuration file by copying the default config, modifying the db path, log path, port and bind IP, and launching with -f or --config.

Explore MongoDB backup and recovery utilities, including mongo export and mongo import for collections with json or csv outputs. Learn when to use mongo dump and mongo restore for databases.

Learn to back up a MongoDB collection using mongoexport, including JSON and CSV outputs, with authentication, database and collection specification, and optional query filters.

Restore a MongoDB collection with mongo import, pairing with mongo export for backups; specify the database, collection, and data file, and use drop to replace data.

Learn how to import CSV data into MongoDB using mongoimport, specifying CSV format, fields, and header line, with optional collection drop.

Export Oracle data to csv with SQL Developer. Copy to MongoDB, drop the collection, and import via mongoimport into a new database and collection using a header line.

Discover how to back up and restore MongoDB databases and collections using mongodump and mongorestore. Learn dump structure, options like --db, --collection, --exclude, --ns include, and dry-run.

Learn how to back up MongoDB data using the mongodump utility, dumping all databases, a single database, or a specific collection, with authentication, output options, and collection exclusions.

Learn to restore databases with mongo restore using the dump directory, the drop option, and namespace include to restore all databases, a single database, or a single collection.

Refresh a MongoDB database by backing up production data to a refresh folder and restoring to a development server with two separate mongod processes and nsFrom and ns2 restore options.