86 NoSQL courses

Uncover the secrets hidden within your data. In today's data-driven world, the ability to extract insights and build intelligent systems is a valuable asset. This comprehensive Diploma in Data Science Bundle equips you with the programming languages, statistical knowledge, and machine learning techniques needed to thrive in this exciting field. What can you expect from this Bundle? * Master the fundamentals: Build a strong foundation in programming languages like Python and R, essential tools for data manipulation and analysis. * Dive into Machine Learning: Explore various machine learning algorithms and techniques for predictive modelling, pattern recognition, and data-driven decision making. * Embrace Big Data: Learn how to handle and analyse massive datasets using tools like PySpark and Hadoop. * Become a data-driven professional: Develop the skills and knowledge to solve real-world problems and unlock the power of your data. Enrol now and become a data-driven problem solver and propel your career to new heights! Course List * R Programming for Data Science: * Master the fundamentals of R programming, a powerful language for data analysis and visualisation. * Learn how to import, clean, and manipulate data using R. * Data Science & Machine Learning with Python: * Gain proficiency in Python, a versatile language widely used in data science applications. * Explore core machine learning concepts and build basic prediction models using Python libraries. * Python Data Science: * Deepen your understanding of Python for data science, including data structures, libraries like NumPy and Pandas, and data wrangling techniques. * Learn how to implement data visualisation tools like Matplotlib and Seaborn to create compelling data stories. * SQL for Data Science, Data Analytics and Data Visualisation: * Master SQL, a crucial language for querying and retrieving data from relational databases. * Learn how to integrate SQL with other data science tools for efficient analysis. * Quick Data Science Approach from Scratch: * Gain a foundational understanding of the data science workflow, from data acquisition to model deployment. * Learn how to approach data science problems in a structured and efficient manner. * Computer Science With Python: * Build a solid foundation in computer science principles, including algorithms, data structures, and problem-solving techniques. * Learn how to apply these concepts to solve data science challenges using Python. * Big Data Analytics with PySpark Power BI and MongoDB: * Explore big data technologies like PySpark for distributed data processing and MongoDB for handling NoSQL databases. * Learn how to integrate these tools with Power BI for effective data visualisation and business intelligence. * SQL NoSQL Big Data and Hadoop: * Gain a comprehensive understanding of different database types, including SQL, NoSQL, and Big Data frameworks like Hadoop. * Learn how to choose the appropriate database technology for different data science projects. * Machine Learning Basics: * Demystify core machine learning concepts like supervised and unsupervised learning algorithms. * Learn how to evaluate and interpret the performance of machine learning models. * Machine Learning for Aspiring Data Scientists: Zero to Hero: * Progress from beginner to intermediate in machine learning, building more complex models and exploring advanced techniques. * Learn how to apply machine learning to solve real-world data science problems. * Business Intelligence and Data Mining: * Discover best practices for extracting valuable insights from data for business decision making. * Learn data mining techniques to uncover hidden patterns and trends in large datasets. * Deep Learning & Neural Networks Python - Keras: * Delve into the world of deep learning and artificial neural networks, a powerful technique for complex data analysis. * Learn how to implement deep learning models using popular libraries like Keras in Python. * Project on Deep Learning - Artificial Neural Network: * Apply your deep learning knowledge to solve a practical data science problem through a hands-on project. * Gain experience in building and deploying deep learning models. * Essential Training on Deep Learning Heuristic using R: * Explore deep learning concepts and implement algorithms using the R programming language. * Learn how to leverage R's capabilities for specific deep learning tasks. * Statistics & Probability for Data Science & Machine Learning: * Develop a strong foundation in statistical concepts essential for data analysis and machine learning models. * Learn how to interpret data, conduct hypothesis testing, and assess the reliability of your results. CPD 40 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? * Individuals with a passion for data and an interest in extracting insights. * Professionals seeking to upskill or transition into a data science career. * Anyone who wants to unlock the power of data for better decision-making. REQUIREMENTS This bundle has minimal entry requirements, requiring only access to a computer or mobile device with internet connectivity, basic computer literacy, proficiency in the English language, and a genuine eagerness to learn. We welcome learners from all backgrounds to join us in exploring new subjects and expanding their knowledge. CAREER PATH * Data Scientist * Machine Learning Engineer * Data Analyst * Business Intelligence Specialist * Data Visualisation Specialist CERTIFICATES DIGITAL CERTIFICATE Digital certificate - £9 HARD COPY CERTIFICATE Hard copy certificate - £15 A Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

This video course helps you explore a wide range of MongoDB concepts. From the basics, including the installation process, to advanced topics such as database sharding and replication, you'll learn it all with the help of engaging examples and activities.

Data Is The Language Of The Powerholders | Designed By Industry Specialists | Level 7 QLS Endorsed Career Objective Driven Data Science Courses | 10 QLS Endorsed Hard Copy Certificates Included | Lifetime Access | Installment Payment | Tutor Support

Are you interested in becoming a skilled SQL developer? Look no further than our SQL Developer Training bundle package! This 25-course package includes everything you need to become a master of SQL and set yourself up for a successful career in technology. Our courses cover all aspects of SQL programming, from beginner-level courses to advanced topics like NoSQL, Big Data, and Hadoop. You'll learn from expert instructors who have years of experience in the industry, and you'll get hands-on experience with real-world projects and assignments. In addition to the SQL-specific courses, you'll also receive five career-guided courses that will help you build a successful career in technology. These courses cover everything from creating a professional LinkedIn profile to acing the job interview. The SQL Developer Training bundle is designed for individuals who want to take their career in technology to the next level. Whether you're new to SQL or you're looking to advance your skills, this bundle has everything you need to succeed. So what are you waiting for? Enrol in our SQL Developer Training bundle today and take the first step toward becoming a skilled SQL developer! This 20-in 1 Ultimate SQL Developer bundle consists of the following Courses: * Course 01: SQL Programming Masterclass * Course 02: SQL Server for Beginners * Course 03: SQL NoSQL Big Data and Hadoop * Course 04: Microsoft SQL Server Development for Everyone * Course 05: Javascript Programming for Beginners * Course 06: Master JavaScript with Data Visualization * Course 07: jQuery: JavaScript and AJAX Coding Bible * Course 08: Kotlin Programming : Android Coding * Course 09: Quick Data Science Approach from Scratch * Course 10: Secure Programming of Web Applications * Course 11: A-Frame Web VR Programming * Course 12: Complete AutoLISP Programming * Course 13: Building Your Own Computer Course * Course 14: Neuro-linguistic Programming (NLP) Diploma * Course 15: Cyber Security Incident Handling and Incident Response * Course 16: Computer Networks Security * Course 17: IT Asset Department * Course 18: C# Programming - Beginner to Advanced * Course 19: AutoCAD Programming using C# with Windows Forms * Course 20: AutoCAD Programming using VB.NET with Windows Forms Additionally, you will get 5 other career-guided courses in this SQL Developer bundle: * Course 01: Career Development Plan Fundamentals * Course 02: CV Writing and Job Searching * Course 03: Interview Skills: Ace the Interview * Course 04: Video Job Interview for Job Seekers * Course 05: Create a Professional LinkedIn Profile So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this SQL Developer bundle. Learning Outcomes of SQL Developer bundle This career-oriented bundle will help you to * Gain the ability to excel in the role of SQL Developer * Know your responsibilities as SQL Developer and convey your experience to others * Gain excellent interpersonal and communication skills * Know the pros and cons of working as SQL Developer * Adhere to the regulations around this area * Gain time and risk management skills to ensure efficiency * Manipulate technological advancement to become more effective * Maintain moral standards and set an example for your peers CPD 250 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone from any background can enrol in this SQL Developer bundle. REQUIREMENTS This SQL Developer course has been designed to be fully compatible with tablets and smartphones. CAREER PATH Having this expertise will increase the value of your CV and open you up to multiple job sectors. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included CERTIFICATE OF COMPLETION Hard copy certificate - Included You will get the Hard Copy certificate for the title course (SQL Programming Masterclass) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

***24 Hour Limited Time Flash Sale*** Software and Web Development Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter How about launching your software engineering or web development career through comprehensive training across today's most in-demand programming languages? As technology reshapes industries across the UK, skilled coders are in short supply, with over 300,000 developer roles needed by 2025. This Software and Web Development bundle equips you with the skills to join this exciting field, whether you're a complete beginner or looking to upskill. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Software and Web Development bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Software and Web Development Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Software and Web Development Career Bundle: * Course 01: C++ Development: The Complete Coding Guide * Course 02: Basic C# Coding * Course 03: Computer Vision: C++ and OpenCV with GPU support * Course 04: Python Basic Programming for Absolute Beginners * Course 05: Python Programming for Everybody * Course 06: Data Science with Python * Course 07: Need Another ONE COURSE * Course 08: Basic Asynchronous JavaScript * Course 09: JavaScript Promises * Course 10: Learn to Use Python for Spatial Analysis in ArcGIS * Course 11: Higher Order Functions in Python - Level 03 * Course 12: Javascript Programming for Beginners * Course 13: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query * Course 14: SQL Programming Masterclass * Course 15: jQuery Masterclass Course: JavaScript and AJAX Coding Bible * Course 16: SQL NoSQL Big Data and Hadoop * Course 17: Root Cause Analysis * Course 18: Business Intelligence and Data Mining Masterclass * Course 19: JavaScript Foundations for Everyone * Course 20: Microsoft SQL Server Development for Everyone * Course 21: R Programming for Data Science * Course 22: Data Analytics with Tableau * Course 23: Intermediate Python Coding * Course 24: Google Data Studio: Data Analytics * Course 25: Introduction to Data Analysis * Course 26: Level-3 Machine Learning Course with Python * Course 27: Complete Google Analytics Course * Course 28: JavaScript Functions * Course 29: Quick Data Science Approach from Scratch * Course 30: JavaScript Masterclass: ES6 Modern Development With Software and Web Development, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. Learning Outcomes * Build robust applications and analyse data with confidence. * Uncover the secrets of image processing and analysis. * Craft interactive web experiences with JavaScript frameworks. * Utilise SQL and Python for data manipulation and visualisation. * Create dynamic dashboards with Excel formulas and VBA. * Understand the world of SQL, NoSQL, and Hadoop. Enrol in Software and Web Development today and take the first step towards achieving your goals and dreams. Why buy this Bundle? * Free CPD Accredited Certificate upon completion of Software and Web Development * Get a free student ID card with Software and Web Development * Lifetime access to the Software and Web Development course materials * Get instant access to this Software and Web Development course * Learn Software and Web Development from anywhere in the world * 24/7 tutor support with the Software and Web Development course. Start your learning journey straightaway with our Software and Web Development Training! The software and Web Development premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Software and Web Development is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Software and Web Development course. After passing the Software and Web Development exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? This Software and Web Development course is ideal for: * Students seeking mastery in Software and Web Development * Professionals seeking to enhance Software and Web Development skills * Individuals looking for a Software and Web Development-related career. * Anyone passionate about Software and Web Development REQUIREMENTS This Software and Web Development doesn't require prior experience and is suitable for diverse learners. CAREER PATH This Software and Web Development bundle will allow you to kickstart or take your career in the related sector to the next stage. * Software developer * Web developer * Data scientist * Database admin * Business analyst CERTIFICATES CPD ACCREDITED DIGITAL CERTIFICATE Digital certificate - Included CPD ACCREDITED HARD COPY CERTIFICATE Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

MYSQL FOR DEVELOPERS TRAINING COURSE DESCRIPTION This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. WHAT WILL YOU LEARN * Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. * Use advanced features of the MySQL Client. * Use advanced data types. * Manage the structure of databases and tables. * Manage and using indexes. * Write complex SQL query statements. * Use advanced SQL expressions. * Use advanced SQL functions. * Perform advanced Insert, Update, Delete, Replace and Truncate Operations. * Use user variable syntax and properties. * Import and export data from within MySQL. * Import and export data from the command line. * Perform complex joins to access multiple tables. * Perform complex subqueries. * Create, manage and us views. * Use prepared statements. * Create and use stored routines. * Create and use triggers. * Obtain database metadata. * Optimize queries. * Work with the main storage engines. * Debug MySQL applications. MYSQL FOR DEVELOPERS TRAINING COURSE DETAILS * Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. * Prerequisites: MySQL foundation * Duration 5 days MYSQL FOR DEVELOPERS TRAINING COURSE CONTENTS * Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. * Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server * The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program * Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types * Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers * Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases * Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes * Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data * SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions * Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data * Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. * Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata * Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging * Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins * Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries * Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views * Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting * User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements * Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines * Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic * Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic * Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters * Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions * Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers * Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations * More about indexes Indexes and joins Hands on Investigating indexes and joins

This course focuses on the beginner-level concepts of cloud computing in two different arenas. The first part is to explore the world of database technologies or DBaaS (Database as a Service) and the second part revolves around IaaS (Infrastructure as a Service) model.

The easy way to store your data and retrieve it when you need it! Database training is vital for success if you want to work in the technology business. Companies are looking for experts who can use databases effectively and have a solid understanding of them. Our course can assist you in developing the skills and information required to flourish in the computer business. This well-designed course can teach you the fundamentals of database design, including creating and managing databases, manipulating data, and developing data-driven applications. You'll gain knowledge of several database types, including relational, object-oriented, distributed, and NoSQL. Along with measures to protect data security, you will learn about database performance and optimisation. Our course is a fantastic method to get started in the profession or obtain expertise for a present position. Many businesses are looking for candidates with good database knowledge and effective usage skills. You may differentiate yourself from the competition by enrolling in a course and gaining the skills and knowledge you need. Along with this Database Course, you will get 11 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. So, don't wait up. Enrol now! This Database Bundle Consists of the following Premium courses: Courses are included in this Database Bundle? * Course 01: Microsoft SQL Server Development for Everyone * Course 02: SQL Programming Masterclass * Course 03: SQL NoSQL Big Data and Hadoop * Course 04: Python Programming for Everybody * Course 05: Data Science with Python * Course 06: JavaScript Foundations for Everyone * Course 07: C# Programming - Beginner to Advanced * Course 08: R Programming for Data Science * Course 09: Three.js & WebGL 3D Programming Course for Beginners * Course 10: Basic Google Data Studio * Course 11: Data Analytics with Tableau Learning Outcomes * Have a fundamental understanding of database design, implementation, and upkeep. * Be able to query databases and learn the SQL language. * To preserve data, use security procedures and backup procedures. * Examine database performance and note any enhancements. * Be familiar with approaches for database normalisation and optimisation. * Create web services and database applications. * Use DBMS software for managing and storing data. * Identify technologies and trends in databases. These 11 courses cover programming and data science topics such as SQL, Python, JavaScript, C#, R, Three.js, WebGL, Google Data Studio, and Tableau. They teach skills in database management, data analysis, manipulation, visualization, and reporting for beginners to advanced learners. The bundle incorporates skills to shed some light on your way and boost your career. Hence, you can strengthen your Database Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: * PDF Certificate: Free (Previously it was £6*11 = £66) * Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 120 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? * Individuals interested in learning programming and data science skills * Professionals seeking to enhance their knowledge and skill set * Entrepreneurs or business owners wanting to understand and manage data effectively * Students or graduates in computer science, data science, or related fields * Anyone looking to start a career in programming or data science * Data analysts, data scientists, or data engineers looking to expand their skill set REQUIREMENTS There is no time limit for completing this course; it can be studied in your own time at your own pace. CAREER PATH People tend to pursue their careers in the following professions in the database sector * Database Administrator * Database Developer * Database Architect * Database Analyst * Database Designer The salary range for a Database Professional in the UK is typically between £25,000 and £50,000 per annum. CERTIFICATES CERTIFICATE OF COMPLETION Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Microsoft SQL Server Development for Everyone) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. CERTIFICATE OF COMPLETION Digital certificate - Included

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. INTRODUCTION TO MONGODB BASIC * Architecture and Installation * Differentiate database categories * Learn MongoDB design goals * List MongoDB tools * Describe JSON and BSON * 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? * Graph Database * 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 Handson) and using various MongoDB tools available in the MongoDB Package MONGODB ADMINISTRATION * Take database backup and restore MongoDB© * Export and import data from/ to a MongoDB© instance * Check server status and DB status * Monitor various resource utilization of a mongod instance * Understand various optimization strategies * Administration concepts in MongoDB * Monitoring issues related to Database * Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB * Database Profiling, Locks, Memory Usage, No of connections, page fault etc., * Backup and Recovery Methods for MongoDB * Export and Import of Data to and from MongoDB * Run time configuration of MongoDB * Production notes/ best practices * Data Managements in MongoDB (Capped Collections/ Expired data from TTL), * TTL Collection Features * GridFS * Memory-Mapped Files * Journaling Mechanics * Storage Engines * Power of 2-Sized Allocations * No Padding Allocation Strategy * Diagnosing Performance Issues * Optimization Strategies for MongoDB * Configure Tag Sets for Replica Set. Optimize Query Performance * Monitoring Strategies for MongoDB . MongoDB Utilities * MongoDB Commands * MongoDB Management Service (MMS) * Data Backup Strategies in MongoDB * Copying Underlying Data Files * Backup with MongoDump * Fsync and Lock * MongoDB Ops Manager Backup Software * Security Strategies in MongoDB * Authentication Implementation in MongoDB . Authentication in a Replica set * Authentication on Sharded Clusters * Authorization * End-to-End Auditing for Compliance USER MANAGEMENT * Create a User Administrator. * Add a User to a Database. * Create/Assign User a Role. * Verify/Modify a User Access/Privileges. * Change a User?s Password MONGODB SECURITY * Knowing security concepts in MongoDB * Understand how Authentication and Authorisation works * Security Introduction * Security Concepts * INDEXES * Index Introduction, * Index Concepts, * Index Types * Index Properties * Index Creation and Indexing Reference * Introduction to Aggregation * Aggregation Approach to Aggregation sort Order * Pipeline Operators and Indexes * Text Indexes * Aggregate Pipeline Stages * Text Search * MapReduce * Index Creation * Aggregation Operations * Index Creation on Replica Set * Remove, Modify, and Rebuild Indexes * Listing Indexes * Measure Index Use * Control Index Use * Index Use Reporting * Geospatial Indexes * MongoDB?s Geospatial Query Operators * GeoWith Operator BACKUP & RECOVERY * Import and Export MongoDB Data * Restore and recovery of MongoDB(Including point in time Recovery) * Restore a Replica Set from MongoDB Backups * Recover Data after an Unexpected Shutdown * Backup and Restore with Filesystem Snapshots * Back Up and Restore with MongoDB Tools * Backup and Restore Sharded Clusters HIGH AVAILABILITY (REPLICATION ) * Understand the concept of Replication in MongoDB© ? Create a production like Replica Set * Introduction to Replication (High Availability), Concepts around Replication * What is Replica Set and Master Slave Replication? * Type of Replication in MongoDB * How to setup a replicated cluster & managing replica sets etc., * Master-Slave Replication * Replica Set in MongoDB * Automatic Failover * Replica Set Members * Write Concern * Write Concern Levels * Write Concern for a Replica Set * Modify Default Write Concern * Read Preference * Read Preference Modes * Blocking for Replication * Tag Set * Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns * Oplog File * Replication State and Local Database, Replication Administration DIAGNOSTICS & TROUBLESHOOTING * Troubleshoot slow queries * Diagnose connectivity problems * Understand diagnostic tools * Learn common production issues * Learn fixes and solutions. ADDITIONAL COURSE DETAILS: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to MongoDB for DBAs (TTDB4680) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.