a black and white logo
a blue and black logo

SQL

Relational databases | Oracle | SQL Server | Postgres | MySQL
SQL (Structured Query Language) is a database language used to structure, store and query data in relational databases. It is mainly used to query and manipulate data from relational database management systems (RDBMS).

SQL is often used in combination with other technologies such as PHP, Java or C# to create dynamic websites and applications based on databases. Some examples of applications that use SQL include customer management systems, e-commerce platforms, and financial management tools.

There are many different RDBMSs that support SQL, including MySQL, Oracle, Microsoft SQL Server, and PostgreSQL. There are also many tools and applications that support SQL, including database development platforms such as MySQL Workbench and SQL Server Management Studio.

BITS experts have used SQL in a wide range of projects. A selection of case studies and references can be found below.

Migration of a Java business application to Docker as well as startup within a Kubernetes cluster

In this project, the task was to migrate a hotel management software consisting of Java backend, relational database and Angular frontend from a native server environment to a Kubernetes cluster. At the same time, the Kubernetes cluster was designed, rebuilt and put into operation.

Cost savings by reducing the amount of memory consumed by SAP systems, establishing monitoring and increasing performance

The goal of the SAP project was to reduce existing storage consumption and thereby save costs in the seven-digit range per year, both in the short term and in the long term.

Development of a web application and a mobile app to improve breast cancer patient follow-up.

Together with Apps in Medicine GmbH, AOK Bayern, DAK Gesundheit and Siemens Betriebskrankenkasse (SBK), under the direction of the Klinikum rechts der Isar of the Technical University of Munich (MRI), BITS participated in the PRISMA study as a consortium partner for the technical infrastructure.

Connection of production machines of a medium-sized manufacturer to the Industry 4.0 OEE solution of BITS for monitoring and optimization of production

The task of BITS was to monitor and control production machines with the help of an OEE solution in order to optimize quality, capacity utilization and costs.

Development and operation of the DACH wide Internet e-commerce platform www.getraenkedienst.com

Together with drink now GmbH, a specialist in beverage sales, BITS GmbH has set up and operates the Internet e-commerce platform www.getraenkedienst.com as a strategic IT partner successful to this day.