In J2EE enterprise applications, the performance of the database queries significantly impacts the application’s efficiency. Slow or poorly performed queries delay the response to the end user, decrease productivity, and eventually lead to business loss. There are various techniques that are used for SQL query optimization. In this article, we will learn about SQL optimization… Read More »
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 »
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 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 »