About the customer
THWS, the Technical University of Applied Sciences in Würzburg-Schweinfurt, Germany, is one of the largest universities of applied sciences in Bavaria. Established in 1971, the university has educated countless students, with a focus on high-tech fields and business analytics, business intelligence, and business administration. The goal of the university is to provide students with the best possible preparation for professional challenges.
9000+
students
240+
professors
18
master's degree programs
Country
Germany
Product used
Challenges faced
The courses offered at THWS aim to educate students in data literacy and other subjects. An important aspect is data management, and students have to study databases, though many of them aren't computer scientists. Still, they have to use databases in daily work. This presents a significant challenge for Professor Butscher.
01
Provide the students with real-world examples to support the database theory
02
Get a generic tool that non-informatics specialists will find easy to work with
03
Cover all database tasks with a single integrated solution
Professor Butscher tried several third-party tools before opting for dbForge Studio for MySQL. He chose it for its user-friendliness for beginners, comprehensive GUI, and powerful visualization capacities.
"The highest benefit was to have to use only ONE tool for all important database tasks."
Professor
Results achieved
dbForge Studio for MySQL is an essential tool for instructors teaching data management courses. Its ability to quickly generate test data greatly aids in designing and testing data models. The user-friendly interface and visualization of SQL queries and their execution results make it easier for students to learn and manage databases.
Key features Professor Butscher is excited about
Data Generator
The tool generates realistic test data quickly and efficiently with over 200 predefined data generators and the ability for users to create their own. It is capable of producing any volume of data with a wide range of column data types. Additionally, data population scripts can be executed manually, scheduled, or saved for future use.
Visual Query Builder
This advanced tool allows users to easily create SQL queries of any complexity using a visual drag-and-drop interface. This speeds up query building, reduces errors, and does not require SQL knowledge. The tool automatically generates SQL code for the query in a text editor, making the process more efficient and user-friendly.
Database Designer
The Designer simplifies the database schemas construction with visual diagrams and drag-and-drop functionality. It eliminates the need for writing complex scripts and saves time while ensuring accuracy. A database diagram can be saved or converted into an executable SQL script. Additionally, the database model is synchronized with the server in real time, allowing for both forward and reverse engineering.
Get extra benefits with Devart for Enterprise
Grow your business with Devart - become our Enterprise client and get a customized package of MySQL management software, tailored to your business needs and demands.
-
Bonuses for corporate clients
These may include fast and effective deployment, corporate budget optimization, and a number of special deals.
-
Dedicated manager
We will save your time by providing a dedicated manager to consult you and guide you through all the purchasing and licensing processes.
Similar stories
More success stories
SharingAlpha
"We needed a way to compare database schemas and your tool was the best on the market by all accounts..."
dbForge Studio for MySQL
Creative Memories
"We became 25% more efficient as we saved 2 FTE hours per day and re-allocated them to project work."
dbForge Studio for MySQL
MACROPAGE
"I got all that in a single tool. dbForge Studio is — for me — the best MySQL client on this planet!"
dbForge Studio for MySQL