JSON/XML/SQL and MongoDB Tutorial

• Table of contents
  
  
  1. JSON | XML | SQL | MongoDB Playlist
  2. JSON Tutorial
  3. XML Tutorial
  4. SQL Tutorial
  5. MongoDB Tutorial
  6. MongoDB Atlas Tutorial
  7. All JavaEE viedos and code in Youtube | Facebook | Google plus | GitHub | BitBucket


• JSON | XML | SQL | MongoDB Playlist
  
  
  1. JSON Tutorial - Playlist
  2. XML Tutorial | What is XML? - Playlist
  3. SQL Tutorial For Beginners | Learn SQL | What is SQL? - Playlist
  4. MongoDB Tutorial for Beginners | MongoDB Tutorial - Playlist
  5. Data Modelling in MongoDB | MongoDB Data Modelling - Playlist


• JSON Tutorial
  
  
  1. JSON Crash Course | What is JSON? | JSON Tutorial For Beginners | JSON vs XML | JSON with Examples
  2. JSON Introduction
  3. How to store/retrieve JSON data to/from the browser local storage?
  4. JSON Syntax
  5. JSON uses JavaScript Syntax
  6. JSON Vs. XML
  7. JSON Data types
  8. How to use the parse() method of JSON?
  9. How to convert a JSON Array to Java Script Array?
  10. JSON - How to the parse the date?
  11. JSON - Parsing functions
  12. JSON - How to Stringify a JavaScript object?
  13. JSON - How to Stringify a JavaScript Array?
  14. What is JSON Objects and how to access the JSON Object values?
  15. JSON - How to loop an Object and get all the Keys and Values?
  16. Nested JSON Objects
  17. Online JSON Parser
  18. How to modify the values of Nested JSON Objects?
  19. How to delete object properties of Nested JSON Objects?
  20. What is JSON Arrays?
  21. How to use a for-in loop to get JSON Array values?
  22. How to use a for loop to get JSON Array values?
  23. How to modify the JSON Array?
  24. How to delete an item from the JSON Array?
  25. Nested Arrays in JSON Object


• XML Tutorial
  
  
  1. XML Tutorial for Beginners | What is XML? | Learn XML
  2. XML Introduction | What is XML?
  3. XML Tree Structure
  4. What is Entity References in XML?
  5. XML Syntax rules
  6. XML Elements
  7. Are XML Elements extensible?
  8. XML Attributes
  9. XML Namespaces


• SQL Tutorial
  
  
  1. SQL Introduction | What is SQL?
  2. What is RDBMS? | What Is Relational Database Management System?
  3. What are database tables?
  4. How to use SQL Select Statement?
  5. How to use SQL Select Distinct Statement?
  6. How to use the SQL WHERE clause?
  7. How to use SQL AND Operator?
  8. How to use SQL OR Operator?
  9. How to use SQL NOT Operator?
  10. How to combine AND, OR, and NOT Operators?
  11. How to use the ORDER BY keyword?
  12. How to use INSERT INTO Statement?
  13. What is NULL values in SQL?
  14. How to use SQL Update Statement?
  15. How to use SQL DELETE Statement?
  16. How to use the SQL TOP, LIMIT, or ROWNUM clause?
  17. How to use SQL MIN() and MAX() functions?
  18. How to use SQL COUNT(), AVG(), and SUM() functions?
  19. How to use SQL LIKE Operator?
  20. How to use the SQL IN Operator?
  21. How to use the SQL BETWEEN Operator?
  22. What is SQL aliases and how to use the SQL aliases?
  23. How to use the SQL GROUP BY Statement?
  24. How to use the SQL HAVING Clause?
  25. What is One to Many relationship?
  26. What is SQL Join and how to use the SQL Join?
  27. What are the different types of SQL Joins?
  28. What is SQL Inner Join and how to use the SQL Inner Join?
  29. What is SQL LEFT Join and how to use the SQL LEFT Join?
  30. What is SQL RIGHT Join and how to use the SQL RIGHT Join?
  31. What is SQL FULL OUTER Join and how to use the SQL FULL OUTER Join?
  32. What is SQL UNION Operator and how to use the SQL UNION Operator?
  33. What is SQL Comments?
  34. What is SQL CASE Statement and how to use the SQL CASE Statement?
  35. What is SQL EXISTS Operator and how to use the SQL EXISTS Operator?
  36. What is Null functions in SQL and how to use the Null functions?
  37. What is SQL ANY Operator and how to use the SQL ANY Operator?
  38. What is SQL ALL Operator and how to use the SQL ALL Operator?
  39. How to use the CREATE TABLE --- SELECT Syntax in SQL?
  40. How to use the CREATE DATABASE Statement in SQL?
  41. How to use the INSERT INTO SELECT Statement in SQL?
  42. What is Stored procedures in SQL? and how to use the Stored procedures?
  43. How to use the CREATE TABLE Statement in SQL?
  44. How to use the DROP TABLE Statement in SQL?
  45. How to use the DROP DATABASE Statement in SQL?
  46. How to use the ALTER TABLE Statement in SQL?
  47. What is SQL Constraints? and how to use the Constraints in SQL?
  48. How to use the NOT NULL Constraint in SQL?
  49. How to use the UNIQUE Constraint in SQL?
  50. How to use the Primary key Constraint in SQL?
  51. How to use the Foreign key Constraint in SQL?
  52. How to use the Check Constraint in SQL?
  53. How to use the Default Constraint in SQL?
  54. How to use the CREATE INDEX Statement in SQL?
  55. How to use the Auto-Increment Field in SQL?
  56. How to use Dates in SQL?
  57. What are SQL Views and how to use SQL Views?
  58. What is SQL Injection and how to avoid SQL Injection?
  59. What is SQL Hosting?


• MongoDB Tutorial
  
  
  1. MongoDB Introduction
  2. MongoDB Overview | MongoDB Introduction
  3. MongoDB Primary key | MongoDB ObjectId
  4. Mapping Relational Databases to MongoDB
  5. Mapping Relational Databases to MongoDB_V2
  6. Difference between MongoDB & RDBMS
  7. SQL vs NoSQL Database: What's the difference? | Difference between SQL and NoSQL Database
  8. Difference between SQL and NoSQL Database | SQL vs NoSQL Database: What's the difference?
  9. MongoDB advantages over RDBMS
  10. What is NoSQL Database?
  11. How to install MongoDB on Windows Operating System? - Package zip
  12. How to install MongoDB on Windows Operating System? - MSI Package
  13. How to Install MongoDB 7 on Windows 11 | Complete Setup of MongoDB Server, Compass & Shell
  14. How to Install MongoDB 8 on Windows 11 | Complete Setup of MongoDB Server, Compass & Shell
  15. How to change the location that MongoDB uses to store its data? | Changing MongoDB datastore directory
  16. How to uninstall MongoDB on Windows Operating System?
  17. How to install and how to use Robo 3T MongoDB Client?
  18. How to install and how to use Studio 3T MongoDB Client?
  19. How to install and how to use MongoDB Compass Client?
  20. How to install and how to use Mongo Management Studio Client?
  21. Data Modelling in MongoDB | MongoDB Data Modeling
  22. How to Create a Database in MongoDB?
  23. How to Drop a Database in MongoDB?
  24. How to Create a Collection in MongoDB?
  25. How to Drop a Collection in MongoDB?
  26. How to Insert Document in a Collection in MongoDB using the Insert method?
  27. How to Insert Document in a Collection in MongoDB using the Save method?
  28. How to Update the Document in a Collection in MongoDB using the Update method?
  29. How to Update the Document in a Collection in MongoDB using the save method?
  30. How to query the Document in the Collection in MongoDB using the find method?
  31. MongoDB- Query Document [RDBMS Where clause equivalents in MongoDB]
  32. MongoDB- Query Document using Less than and Less than Equals operations
  33. MongoDB - Query Document using Greater than and Greater than Equals operations
  34. MongoDB - Query Document using Not Equals Operation
  35. MongoDB - Query Document using AND Operator
  36. MongoDB - Query Document using OR Operator
  37. MongoDB - Query Document using AND and OR Operators together
  38. How to delete the document from the Collection in MongoDB?
  39. MongoDB Projection With Example
  40. How to Limit Records in MongoDB ?
  41. How to Skip Records in MongoDB?
  42. How to Sort Records in MongoDB?
  43. MongoDB - $sum (aggregation) | Aggregation in MongoDB
  44. MongoDB - $avg (aggregation) | Aggregation in MongoDB
  45. MongoDB - $min and $max (aggregation) | Aggregation in MongoDB
  46. MongoDB - $first and $last(aggregation) | Aggregation in MongoDB
  47. Introduction of NoSQL Databases | What is the NoSQL Database?
  48. What is the NoSQL Database and When to use?
  49. Introduction of MongoDB | About MongoDB
  50. MongoDB Indexing Tutorial with Example | Indexing in MongoDB
  51. How to Create the Database and Collection in MongoDB?
  52. How to add multiple documents into the Collection using the insert method and Array?
  53. What is the Primary Key concept in MongoDB?
  54. What is Cursor in MongoDB?
  55. How to query the document using the find() function in MongoDB?
  56. MongoDB order with Sort() & Limit() Query with Examples
  57. MongoDB Count() Function with Example
  58. MongoDB Remove() Function with Examples
  59. MongoDB Update() Function with Examples
  60. MongoDB Indexing Tutorial - createIndex(), dropindex() Example
  61. MongoDB Indexing and How to create an Index using the ensureIndex() method?
  62. MongoDB Regular Expression (Regex) with Examples - Part1
  63. MongoDB Regular Expression (Regex) - Pattern matching with $options Example - Part2
  64. MongoDB Regular Expression (Regex) - Pattern matching without the regex operator with Example - Part3
  65. How to fetch last 'n' records from a collection in MongoDB?
  66. What is NoSQL (Not Only SQL) Database?
  67. What is the difference between RDBMS & MongoDB?
  68. How to configure MongoDB Server with configuration file?
  69. How to Insert a document in a collection using a JavaScript file in MongoDB?
  70. How to Insert an Array of documents in a collection using a JavaScript file in MongoDB?
  71. Updating the document in a Collection in MongoDB
  72. Query Operators - $in, $nin and $exists in MongoDB
  73. How to use distinct() and count() methods in MongoDB?
  74. Deleting documents from the Collection in MongoDB
  75. Understanding the impact of Indexes in MongoDB
  76. Understanding the impact of Indexes in MongoDB - How much execution time with and without Index?
  77. Data Modelling in MongoDB | MongoDB Data Modelling
  78. Data Modeling Introduction — MongoDB
  79. MongoDB - Data Model Design | Data Modelling in MongoDB
  80. Model One-to-One Relationships with Embedded Documents in MongDB | Data Modelling in MongoDB
  81. Model One-to-Many Relationships with Embedded Documents in MongoDB | Data Modelling in MongoDB
  82. Model One-to-Many Relationships with Document References in MongoDB | Data Modelling in MongoDB
  83. Model Tree Structures with Parent References in MongoDB | Data Modelling in MongoDB
  84. Model Tree Structures with Child References in MongoDB | Data Modelling in MongoDB
  85. Model Tree Structures with an Array of Ancestors in MongoDB | Data Modelling in MongoDB | MongoDB Tutorial for Beginners
  86. How to establish One-to-One Relationships in MongoDB? | Data Modelling in MongoDB | MongoDB Tutorial for Beginners
  87. How to establish One-to-Many Relationships in MongoDB? | Data Modelling in MongoDB | MongoDB Tutorial for Beginners
  88. How to establish Many-to-Many Relationships in MongoDB? | Data Modelling in MongoDB | MongoDB Tutorial for Beginners
  89. How to create the user and add the root role in MongoDB? | MongoDB Tutorial for Beginners
  90. How to create the user and add the role as userAdminAnyDatabase in MongoDB? | MongoDB Tutorial for Beginners
  91. How to create the user and add the role as userAdmin in MongoDB? | MongoDB Tutorial for Beginners
  92. How to create the user and assign multiple roles for a Single Database in MongoDB? | MongoDB Tutorial for Beginners
  93. How to drop the single user and all the users in MongoDB? | MongoDB Tutorial for Beginners
  94. What are the different Built-in roles in MongoDB? | MongoDB Tutorial for Beginners
  95. $natural Operator Sorting in MongoDB | MongoDB Tutorial for Beginners
  96. How to use the explain() method and parameter options in MongoDB | MongoDB Tutorial for Beginners
  97. How to use Group by using reduce function in MongoDB? | MongoDB Tutorial for Beginners
  98. What is Map-Reduce in MongoDB? | MongoDB Tutorial for Beginners
  99. What is Namespace in MongoDB? | MongoDB Tutorial for Beginners
  100. What is Replication in MongoDB? | MongoDB Tutorial for Beginners
  101. Understanding Replication Architecture in MongoDB | MongoDB Tutorial for Beginners
  102. Understanding Arbiter and Heartbeat in MongoDB | Replication in MongoDB | MongoDB Tutorial for Beginners
  103. Election for primary: Replica set elections in MongoDB | Replication in MongoDB | MongoDB Tutorial for Beginners
  104. What is Voting and not voting members in Replica Set in MongoDB? | Replication in MongoDB | MongoDB Tutorial for Beginners
  105. How to do single node Replica Set Setup in MongoDB? | Replication in MongoDB | Mongodb Master-Slave Setup | MongoDB Tutorial for Beginners
  106. How to do a multiple node Replica Set Setup in MongoDB? | Replication in MongoDB | MongoDB Master-Slave Setup | MongoDB Tutorial for Beginners
  107. How to convert from Replica set to a Standalone in MongoDB? | Replication in MongoDB | Mongodb Master-Slave Setup | MongoDB Tutorial for Beginners
  108. What is Replication and how to do Replica Set Setup in MongoDB? - Version 1 | Replication in MongoDB | MongoDB Master-Slave Setup | MongoDB Tutorial for Beginners
  109. What is Replication and how to do Replica Set Setup in MongoDB? - Version 2 | Replication in MongoDB | MongoDB Master-Slave Setup | MongoDB Tutorial for Beginners
  110. How to Download, Install MongoDB 6.0.5 on Windows 11|Complete Setup of MongoDB Server, Compass&Shell
  111. How to uninstall MongoDB 6 & MongoDB Compass on Windows 11? | MongoDB Tutorial for Beginners
  112. How to Connect to MongoDB using Java? | MongoDB with Java connection |MongoDB Tutorial for Beginners
  113. How to Get and Select a Collection and Insert a Document using Java Program? | MongoDB with Java
  114. How to Get and Select a Collection and Insert multiple Documents using Java? | MongoDB with Java
  115. How to Get and Select a Collection and Retrieving All the Documents using Java? | MongoDB with Java
  116. How to Get and Select a Collection and update one document in the collection using Java in MongoDB
  117. How to Get and Select a Collection and update many documents in the collection using Java in MongoDB
  118. How to Get and Select a Collection and Read a specific document using Java? | MongoDB with Java
  119. How to Get and Select a Collection and read a range of documents using Java? | MongoDB with Java
  120. How to read a range of documents using Java in MongoDB and add the docs into ArrayList or Consumer?
  121. How to update the document in the collection using the findOneAndUpdate method? | MongoDB with Java
  122. How to delete one document in the collection using Java? | MongoDB with Java | MongoDB with Java
  123. How to Select Collection and delete many documents in the collection using Java? | MongoDB with Java
  124. How to Connect to MongoDB and retrieve the list of databases using Java? | MongoDB with Java
  125. How to list all the Collections in a MongoDB database using Java?| MongoDB with Java connection
  126. How to delete a collection from MongoDB using Java? | MongoDB with Java connection


• MongoDB Atlas Database Tutorial
  
  
  1. Getting Started with MongoDB Atlas Database | MongoDB Atlas Database Tutorial
  2. Introduction to MongoDB Atlas Database | MongoDB Atlas Database Tutorial
  3. MongoDB vs MongoDB Atlas: What’s the Difference? | MongoDB Atlas Database Tutorial
  4. MongoDB vs MongoDB Atlas: Comprehensive Comparison | MongoDB Atlas Database Tutorial
  5. MongoDB Atlas Setup Tutorial: Get Started with Your Cloud Database (Beginner Friendly)
  6. MongoDB Atlas Java Integration Made Easy | Java + MongoDB Atlas: Building Scalable Applications
  7. How to Connect MongoDB Atlas with Java | Connecting MongoDB Atlas to Your Java Application
  8. Spring Boot MongoDB Atlas CRUD Operations | Spring Boot MongoDB Atlas Integration
  9. MongoDB Atlas: How to Safely Delete a Project and Database


• All JavaEE viedos and code in Youtube | Facebook | Google plus | GitHub | BitBucket
  
  
  1. All JavaEE Viedos Playlist
  2. All JavaEE Viedos
  3. JavaEE - Facebook Page
  4. JAVA & JAVA EE - Facebook Group
  5. Java - Google Plus Page
  6. JavaEE By Ram - Google Community
  7. GitHub
  8. BitBucket

Spring boot Tutorial 21 - Spring boot and layered architecture [Controller, Service and Repository layers] - Playlist

Spring boot Tutorial 21 -  Spring boot and layered architecture [Controller, Service and Repository layers] - Playlist:
https://www.youtube.com/watch?v=mp0NlY1y3vY&list=PLmCsXDGbJHdin9sHatS6Xv4VxsMEPE5kf

How to create an employee using Spring boot layered architecture and JdbcTemplate?

Different layers in spring boot application | Spring boot layered architecture

Springboot + Thymeleaf - Send user information from UI to controller | Spring Boot Tutorial

Using JdbcTemplate with Spring Boot and Thymeleaf | Spring Boot Tutorial

SpringBoot Configure DataSource Using JNDI with Example using Tomcat 9 Server

🚀 Master Advanced Spring Boot!

Join Ram N Java for professional tutorials on server configuration and Java development!

SUBSCRIBE TO THE CHANNEL

Spring Boot JNDI DataSource Configuration

In enterprise environments, managing database connections through JNDI (Java Naming and Directory Interface) is a standard practice. It allows the server to manage the connection pool, making your application more portable and secure. This guide reveals the "secrets" of setting up a JNDI DataSource in Spring Boot when deploying to Tomcat 9.

Step 1: Configure Tomcat's context.xml

The first step happens outside your application. You need to define the Resource in Tomcat's context.xml file. Here, you specify the driver class, database URL, username, password, and pooling parameters. This makes the DataSource available to any application running on the server.

Step 2: Update application.properties

Spring Boot needs to know where to look for the JNDI resource. Instead of providing database credentials in your properties file, you simply provide the JNDI name using spring.datasource.jndi-name. This keeps your application configuration clean and environment-independent.

Step 3: Creating the DataSource Bean

In your Spring configuration class, you can programmatically define the DataSource bean. By using JndiDataSourceLookup, Spring can fetch the pre-configured DataSource from the Tomcat container seamlessly during the application startup process.

Step 4: Handling the "java:comp/env" Prefix

One common pitfall is the JNDI prefix. Depending on your configuration, you might need to prepend java:comp/env/ to your resource name. Understanding how Tomcat namespaces these resources is key to a successful connection.

Step 5: Verify the Connection

Run your application on the external Tomcat server. If configured correctly, Spring Boot will successfully acquire the connection from the server's pool. You can verify this by checking your logs for the successful initialization of the Hikari or Tomcat connection pool.

Advanced Tomcat & Spring Boot Guides:

• Modify Default Context Path in Spring Boot
• Spring Boot Deployment to External Tomcat
• External Tomcat Deployment Made Easy

JSON Tutorial - Playlist

JSON Tutorial - Playlist:
https://www.youtube.com/watch?v=tUwQE8oYx-c&list=PLmCsXDGbJHdh6VOM6TiHWfrjnsCwHZXqH

Spring boot Tutorial 20 - Spring boot JdbcTemplate Tutorial - Playlist

Spring boot Tutorial 20 -  Spring boot JdbcTemplate Tutorial - Playlist:
https://www.youtube.com/watch?v=gxtvR-MwhIQ&list=PLmCsXDGbJHdgdwJ2YpJ977jVYJvKkPuGn

JSON Data types | JSON Tutorial

JSON Vs. XML | JSON Tutorial

JSON uses JavaScript Syntax | JSON Tutorial

JSON Syntax | JSON Tutorial

How to store/retrieve JSON data to/from the browser local storage? | JSON Tutorial

JSON Introduction | JSON Tutorial

How to use parallelSort(long[] a, int fromIndex, int toIndex) method of Java.util.Arrays Class?

How to use parallelSort(char[] a) method of Java.util.Arrays Class?

How to use parallelSort(byte[] a) method of Java.util.Arrays Class?

How to use parallelSort(short[] a) method of Java.util.Arrays Class?

How to Configure Multiple Data Sources(Databases) in a Spring Boot Application?

How to delete the record from the database using JdbcTemplate with Spring Boot? | Spring Boot

How to update the record in the database using JdbcTemplate with Spring Boot? | Spring Boot Tutorial

How to get all records from the database using JdbcTemplate with Spring Boot? | Spring Boot Tutorial

How to get a record from the database using JdbcTemplate with Spring Boot? | Spring Boot Tutorial

How to insert a record in the database using JdbcTemplate with Spring Boot? | Spring Boot Tutorial