Tag Archives: SQL

How to configure multiple database in Spring Boot

In Enterprise applications, we may be required to have multiple databases for storing different kinds of information. For example, in an e-commerce application, it may be required to keep the user’s information in a different database, product-related information in a different database, and payment-related information in a separate database. In this tutorial, we will configure… Read More »

How to generate one million records in SQL

SQL stands for Structured Query Language. It is used for designing and maintaining structured data in a relational database management system (RDBMS). Structured data are the data that is stored in the form of a table with a structure of rows and columns. SQL allows us to create, access, and manipulate data and the database… Read More »

MySQL Workbench – How to make database schema in MySQL Workbench?

MySQL Workbench is an integrated development environment tool for designing and modeling database architecture. It is a unified visual tool for database architects, developers and DBAs(Database Administrators). MySQL Workbench comes along with various integrated tools which can be easily used for administrating purposes of server configurations, executing SQL queries, complex database schema designing and management,… Read More »