دوره حضوری بانک های اطلاعاتی غیر رابطه ای 4 MongoDB
مدت دوره:
60 ساعت
پيش نياز:
آشنایی مختصر با مفاهیم پایه بانکهای اطلاعاتی به فهم بهتر دوره کمک خواهد کرد.
مخاطبین دوره بانک های اطلاعاتی غیر رابطه ای MongoDB 4
برنامهنویسان و یا تحلیلگران داده که میخواهند کار با MongoDB را شروع کنند و یا در حال حاضر با آن کار میکنند .
هر علاقهمندی که تمایل به کار با پایگاه دادههای NoSQL را دارد.
همه برنامه نویسان مبتدی و حرفهای بر روی MongoDB که تمایل به مرور مباحث سرفصل ارایه شده، دارند.
علاقهمندانی که نیاز به یادگیری مباحث راهبری (administrating MongoDB servers) دارند، توجه کنند که این دوره اطلاعات زیادی را در اختیار آنها قرار نمیدهد و تمرکز اصلی بر مباحث بر روی " commands/ queries" است.
سرفصل دوره بانک های اطلاعاتی غیر رابطه ای MongoDB 4
Chapter 1
Course Outline
Introduction
• What is MongoDB
• The Key MongoDB Characteristics (and how they differ from SQL Databases)
• Understanding the MongoDB Ecosystem
• Installing MongoDB
• Shell vs Drivers
• MongoDB Clients The Big Picture
Understanding the Basics CRUD Operations
• Module Introduction
• Understanding Databases, Collections & Documents
• The Shell MongoDB Drivers for Different Languages
• Creating Databases & Collections
• Understanding JSON Data
• Comparing JSON & BSON
• Create, Read, Update, Delete (CRUD) & MongoDB
• Finding, Inserting, Deleting & Updating Elements
• Understanding "insertMany()"
• Diving Deeper Into Finding Data
• "update" vs "updateMany()"
• Understanding "find()" & the Cursor Object
• Understanding Projection
• Embedded Documents & Arrays - The Theory
• Working with Embedded Documents
• Working with Arrays
• Accessing Structured Data
Schemas Relations How to Structure Documents
• Module Introduction
• Why Do We Use Schemas?
• Structuring Documents
• Data Types - An Overview
• Data Types in Action
• How to Derive your Data Structure – Requirements
• Understanding Relations
• One To One Relations – Embedded
• One To One - Using References
• One To Many – Embedded
• One To Many - Using References
• Many To Many – Embedded
• Many To Many - Using References
• Summarizing Relations
• Using lookUp() for Merging Reference Relations
• Understanding Schema Validation
• Adding Collection Document Validation
• Changing the Validation Action
Exploring The Shell The Server
• Module Introduction
• Finding Available Options
• Setting "dbpath" & "logpath"
• Exploring the MongoDB Options
• MongoDB as a Background Service
• Using a Config File
• Shell Options & Help
Using the MongoDB Compass to Explore Data Visually
• Module Introduction
• Exploring the MongoDB Compass
Diving Into Create Operations
• Module Introduction
• Creating Documents - An Overview
• Understanding "insert()" Methods
• Working with Ordered Inserts
• Understanding the "writeConcern"
• The "writeConcern" in Practice
• What is Atomicity?
• Importing Data
Read Operations - A Closer Look
• Module Introduction
• Methods, Filters & Operators
• Operators - An Overview
• Query Selectors & Projection Operators
• Understanding "findOne()" & "find()"
• Working with Comparison Operators
• Querying Embedded Fields & Arrays
• Understanding "$in" and "$nin"
• "$or" and "$nor"
• Understanding the "$and" Operator
• Using "$not"
• Diving Into Element Operators
• Working with "$type"
• Understanding Evaluation Operators – "$regex"
• Understanding Evaluation Operators – "$expr"
• Diving Deeper Into Querying Arrays
• Using Array Query Selectors – "$size"
• Using Array Query Selectors – "$all"
• Using Array Query Selectors – "$elemMatch"
• Understanding Cursors
• Applying Cursors
• Sorting Cursor Results
• Skipping Limiting Cursor Results
• Using Projection to Share our Results
• Using Projection in Arrays
• Understanding "$slice"
Update Operations
• Module Introduction
• Updating Fields with "updateOne()", "updateMany()" and "$set"
• Updating Multiple Fields with "$set"
• Incrementing & Decrementing Values
• Using "$min", "$max", and "$mul"
• Getting Rid of Fields
• Renaming Fields
• Understanding "upsert()"
• Updating Matched Array Elements
• Updating All Array Elements
• Finding & Updating Specific Fields
• Adding Elements to Arrays
• Removing Elements from Arrays
• Understanding "$addToSet"
Understanding Delete Operations
• Module Introduction
• Understanding "deleteOne()" & "deleteMany()"
• Deleting All Entries in a Collection
Chapter 2
Working with Indexes
• Module Introduction
• What Are Indexes? Why Do We Use Them?
• Adding a Single Field Index
• Understanding Index Restrictions
• Creating Compound Indexes
• Using Indexes for Sorting
• Understanding the Default Index
• Configuring Indexes
• Understanding Partial Filters
• Applying the Partial Index
• Understanding the Time-To-Live (TTL) Index
• Query Diagnosis & Query Planning
• Understanding Covered Queries
• How MongoDB Rejects a Plan
• Using Multi-Key Indexes
• Understanding Text Indexes
• Text Indexes & Sorting
• Creating Combined Text Indexes
• Using Text Indexes to Exclude Words
• Setting the Default Language & Using Weights
• Building Indexes
Working with Geospatial Data
• Module Introduction
• Adding GeoJSON Data
• Running Geo Queries
• Adding a Geospatial Index to Track the Distance
• Adding Additional Locations
• Finding Places Inside a Certain Area
• Finding Out If a User Is Inside a Specific Area
• Finding Places Within a Certain Radius
Understanding the Aggregation Framework
• Module Introduction
• What is the Aggregation Framework?
• Getting Started with the Aggregation Pipeline
• Using the Aggregation Framework
• Understanding the Group Stage
• Diving Deeper Into the Group Stage
• Working with "$project"
• Turning the Location Into a geoJSON Object
• Transforming the Birthdate
• Using Shortcuts for Transformations
• Understanding the "$isoWeekYear" Operator
• "$group" vs "$project"
• Pushing Elements Into Newly Created Arrays
• Understanding the "$unwind" Stage
• Eliminating Duplicate Values
• Using Projection with Arrays
• Getting the Length of an Array
• Using the "$filter" Operator
• Applying Multiple Operations to our Array
• Understanding "$bucket"
• Diving Into Additional Stages
• Writing Pipeline Results Into a New Collection
• Working with the "$geoNear" Stage
Working with Numeric Data
• Module Introduction
• Number Types - An Overview
• Understanding Programming Language Defaults
• Working with int32
• Working with int64
• Doing Math's with Floats, int32s & int64s
• What's Wrong with Normal Doubles
• Working with Decimal 128bit
MongoDB Security
• Module Introduction
• Understanding Role Based Access Control
• Roles – Examples
• Creating a User
• Built-In Roles - An Overview
• Assigning Roles to Users & Databases
• Updating & Extending Roles to Other Databases
• Adding SSL Transport Encryption
• Encryption at REST
Performance, Fault, Tolerancy & Deployment
• Module Introduction
• What Influences Performance?
• Understanding Capped Collections
• What are Replica Sets
• Understanding Sharding
• Deploying a MongoDB Server
• Using MongoDB Atlas
• Backups & Setting Alerts in MongoDB Atlas
• Connecting to our Cluster
Transactions
• Module Introduction
• What are Transactions?
• A Typical Usecase
• How Does a Transaction Work?
From Shell to Driver
• Module Introduction
• Splitting Work Between the Driver & the Shell
• Preparing our Project
• Installing Visual Studio Code
• Installing the Node.js Driver
• Connecting Node.js & the MongoDB Cluster
• Storing Products in the Database
• Storing the Price as 128bit Decimal
• Fetching Data From the Database
• Creating a More Realistic Setup
• Getting a Single Product
• Editing Deleting Products
• Implementing Pagination
• Adding an Index
• Signing Users Up
• Adding an Index to Make the Email Unique
• Adding User Sign In
Introducing Stitch
• Module Introduction
• What is Stitch?
• Preparations
• Start Using Stitch
• Adding Stitch to our App & Initializing It
• Adding Authentication
• Sending Data Access Rules
• Fetching & Converting Data
• Deleting Products
• Finding a Single Product
• Adding Products
• Updating Products
• Switching to User Email & Password Authentication
• Adding User Sign Up & Confirmation
• Adding User Login
• Rules & Real Users
• Functions & Triggers
NoSQL Data Modeling Essential Training
• The Basics
• Transforming the Conceptual Model
• Document Style Patterns
• Columnar Style Patterns
جزئیات سرفصل آموزشی دوره SQL Server 2017 Admin را از طریق لینک زیر دریافت کنید: