Dummy Data For DB Developers

Short Description :What is Inside the Package? 1. The Employee Management Schema (production_employees & maintenence_employees) This schema models a classic human resources or company directory system with two related tables. Its perfect for practicing joins and understanding foreign key relationships in a familiar context. maintenence_employees table: Serves as the parent table. It contains core employee details (name, age, department, job) and uses a me_code as its primary key. production_employees table: A more detailed child table. It includes all the fields from the parent table plus additional financial and personal data (salary, SSN, phone, email). It links back to the maintenence_employees table via a foreign key (pe_code references me_code). 2. The Generic Test Schema (test_data & test_data_two) This is a robust, all-purpose schema designed for testing a wide variety of SQL features and application functionalities. It includes a diverse set of column data types. test_data table: Acts as the parent table with a mix of string, numeric, and boolean fields. It uses a td_code as its business primary key. test_data_two table: The child table that extends test_data. It includes advanced data types like TIMESTAMP, DATE, and DECIMAL, making it ideal for testing date arithmetic, financial calculations, and complex queries. Why This Data is Incredibly Useful Real-World Relational Design: The data isnt just a collection of columns. It features real primary keys, foreign key constraints, and realistic table relationships. This is crucial for practicing essential JOIN operations and understanding how relational databases work. Dual-Database Ready: Get the same logical schema for both PostgreSQL (using serial, text, money) and MySQL (using AUTO_INCREMENT, VARCHAR, DECIMAL). Perfect for comparing syntax or ensuring your application works across different databases. Rich Data Types: Practice with a wide array of data types: Text: VARCHAR, TEXT, CHAR Numbers: INT, SERIAL/AUTO_INCREMENT, NUMERIC/DECIMAL, MONEY (in PostgreSQL) Date/Time: DATE, TIMESTAMP (with and without time zone in PG) Other: BOOLEAN, SSN and phone formats Ready-to-Import SQL Dumps: Simply run the provided .sql files in your database client to create the tables instantly. Perfect For: Mastering INNER JOIN, LEFT JOIN, and other relational queries. Testing application CRUD operations without risk to production data. Experimenting with database migrations, indexing, and performance tuning. Learning the nuances between PostgreSQL and MySQL syntax and data types. How to Get Started in Less Than a Minute Download the ZIP File, Get the SQL files (for Postgresql and MySQL). Choose Your Database: Start your local PostgreSQL or MySQL server. Import the Data: For PostgreSQL: Run the production.txt file in your psql client or GUI tool to create the employee tables. For MySQL: Run the test_data and test_data_two CREATE statements from the file in your MySQL client (e.g., MySQL Workbench, command line). Start Querying! Open your favorite database tool and begin exploring. Download the Dummy Data