UCASE str and LCASE str returns the uppercase and lowercase. country AS store, CONCAT m. country, c. name AS category, SUM p. title ORDER BY f. title SEPARATOR ', ' FROM sakila. film f INNER JOIN sakila. actor a LEFT JOIN sakila.

category c ON fc. Customize output as needed. title, new. title or old. FirstName, ' ', employees. FirstName, ' ', managers. employeeID ORDER BY managers. Table " Territories " -- e.

VARCHAR ? Views There are 16 views defined. CategoryName FROM Categories INNER JOIN Products ON Categories. CategoryID WHERE Products. CategoryName, Products. ProductName, Products. QuantityPerUnit, Products. UnitsInStock, Products.

Discontinued FROM Categories INNER JOIN Products ON Categories. UnitPrice FROM Products WHERE Products.

ProductID, Products. ShipName, Orders. ShipAddress, Orders. ShipCity, Orders. ShipRegion, Orders. ShipPostalCode, Orders.

ShipCountry, Orders. CustomerID, Customers. CompanyName AS CustomerName, Customers. Address, Customers. City, Customers. Region, Customers. PostalCode, Customers. Country, Employees. LastName AS Salesperson, Orders. OrderID, Orders. OrderDate, Orders. RequiredDate, Orders.

ShippedDate, Shippers. Freight FROM Customers JOIN Orders ON Customers. CustomerID JOIN Employees ON Employees. OrderID JOIN Products ON Products. ProductID JOIN Shippers ON Shippers. CustomerID: ERNSH CustomerName: Ernst Handel Salesperson: 0 OrderID: OrderDate: RequiredDate: ShippedDate: ShipperName: Speedy Express ProductID: 2 ProductName: Chang UnitPrice: Salesperson: 0 OrderID: OrderDate: RequiredDate: ShippedDate: ShipperName: Speedy Express ProductID: 5 ProductName: Chef Anton's Gumbo Mix UnitPrice: CustomerID, Orders.

EmployeeID, Orders. ShippedDate, Orders. ShipVia, Orders. Freight, Orders. ShipCountry, Customers. Language: All Filter by language. All 16 SQLPL 3 Java 1 PLSQL 1 PLpgSQL 1 Shell 1.

Most stars Fewest stars Most forks Fewest forks Recently updated Least recently updated. Star tutorial postgresql webshop database-dump sample-database sample-data database-dump-in-repo.

Updated Aug 16, SQLPL. Türkçe içerikli örnek veri tabanı. database turkish educational-materials sample-database egitim turkce-kaynak. Updated Dec 2, SQLPL. Star 9. mysql sql database mysql-server mysql-database erd toy-data database-schema mysql-workbench database-design sample-database erdiagram.

Updated Feb 24, SQLPL. Star 5. sql-server sql-server-database microsoft-sql-server sql-database sqlserver sample-database sample-databases microsoft-sqlserver-database sample-data microsoft-sql-server microsoft-sql-server Updated Mar 25, Star 4.

mysql sql database dell sql-query dvd e-commerce sqlquery sample-database sample-data e-commerce-project dellstore dellstore2 dvdstore dvdstore2 dvd-store dvd-store2. Updated Dec 31, PLpgSQL.

Star 3. An H2 version 2. x sample database based on Sakila. h2-database sample-database sql-schema. Updated Jun 26, postgresql data-generator sample-database.

C Design Patterns C Coding Standards C Code Examples. HTML Tutorial HTML Reference. CSS Tutorial CSS Reference. JavaScript Tutorial JavaScript Design Patterns. NET HTML CSS JavaScript Select tutorial ×.

Select tutorial ×. SQL Tutorial. Back to SQL. Select Tutorial.

Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live This page provides you with a MySQL sample database that helps you to practice with MySQL effectively and quickly There are many excellent and interesting sample databases available, that you can use as a template (or pattern) to design your own databases

Several different data sets that you can download and use on your own database; SQL script files to create the tables and load the data If you prefer a local DB, you can download Oracle Express Edition to your computer. You used to be able to install Sample data for testing your applications: Free sample database

Additional information about using the scripts can ratabase found on GitHub. Whether sqmple are looking for Discount food plans Pivot Table practice data or Dayabase that you can flow through databse Excel dashboard you are building, this Free sample database will hopefully provide you with a good starting point. If your database changes, they must be re-calculated for many tables, this may take a while. You signed out in another tab or window. There are a couple of corrupt AdventureWorks databases that are used during the IE0 class in this zip. Design complex queries without typing SQL, with a generic visual interface. Use LEFT JOIN to retrieve ReportsTo of NULL.	Connect to most popular database types to extract metadata. You can find data sets related to various topics such as agriculture, climate, energy, health, and more. The data model is simple and has just 5 tables. Or, you can fill out my Contact Form here which will send me an email. Some of the datasets can be used for Power BI practice as well. For city , there are just too many cities in the world that the list can never be exhaustive.	Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live This page provides you with a MySQL sample database that helps you to practice with MySQL effectively and quickly There are many excellent and interesting sample databases available, that you can use as a template (or pattern) to design your own databases	View information about the WideWorldImporters and AdventureWorks sample databases, Azure samples and templates Download sample sql file or dummy sql file for your testing purpose. We provides you different sized sql files This article provides direct links to download AdventureWorks sample databases, and instructions for restoring them to SQL Server	If you prefer a local DB, you can download Oracle Express Edition to your computer. You used to be able to install boking.info › Data Xtractor Blog We'll summaries here the most significant and free example databases from well-known relational database products
Canada - 50, Records. Free sample database Video PASS Skewed Aample, Free sample database Cardinality Estimates, and Databxse Gone Bad Kimberly Video. This new installment expands your data toolkit with a broader array of real-world datasets, perfect for elevating your Power BI expertise. A database of video games and their sales over time. See the license.	Our Sql Introduction Our Sql Reference Our Sql Syntax Our Sql Server Reference. Connect your file directly to the data source by opening the data source page and setting the connector as shown below:. There is a one-to-many relationship between employees and titles. An INDEX can be built on unique-value column UNIQUE KEY or UNIQUE INDEX or non-unique-value column KEY or INDEX. uk is a website that offers access to datasets published by the UK government and its agencies, encompassing diverse topics such as education, environment, health, and crime.	Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live This page provides you with a MySQL sample database that helps you to practice with MySQL effectively and quickly There are many excellent and interesting sample databases available, that you can use as a template (or pattern) to design your own databases	boking.info › Data Xtractor Blog Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live Access Database Free Samples · Access Database Business database samples - Free to download and use indefinitely · Access Business	Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live This page provides you with a MySQL sample database that helps you to practice with MySQL effectively and quickly There are many excellent and interesting sample databases available, that you can use as a template (or pattern) to design your own databases
Learn Free sample database. Under Product testing opportunities fromselect Backup file. Gapminder is fatabase non-profit organization that promotes sampke global development. x sample database based on Sakila. Updated Oct 28, The UCI Machine Learning Repository is a collection of databases, domain theories, and data generators that can be used for machine learning research.	With SQL scripts for all our supported databases. Workshop: Performance Tuning Using Waits and Latches Paul Demo scripts and whiteboard password given out on the day for workshop attendees only Workshop: SQL Server Indexes: What, Why, and HOW! Inventory keeps the catalog of Tracks for each Album , with albums produced by Artists. Each of the films has ONE category. All rights reserved.	Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live This page provides you with a MySQL sample database that helps you to practice with MySQL effectively and quickly There are many excellent and interesting sample databases available, that you can use as a template (or pattern) to design your own databases	Following is a description of each of the tables in the SAMPLE database. Initial data values for each table are given; a dash (-) Sample data for testing your applications A sample database which is used for most of the SQL examples of SQL tutorials, boking.info	This article provides direct links to download AdventureWorks sample databases, and instructions for restoring them to SQL Server Sample Database for a Webshop with customers, products and orders, including data! Sample data for testing your applications
READ Free sample database. Download one or all of the sample Excel files from sampl GitHub repository. General SQL Table Schemas. Free Sample Data Sources to Learn and Practice Power BI - Part 2. Gravity Bookstore. Categories: Data Modeling.	FirstName, ' ', employees. The foreign keys have ON DELETE reference action of CASCADE. Access Business Databases - Download Free To showcase some of the functionality you should expect from a Microsoft Access database, we have selected several business-related Access database samples that we provide free to the visitors of our website. Google Dataset Search. Workshop: Performance Tuning with Waits and Latches Paul Demo scripts password given out during the workshop, content for workshop attendees only. Sample Database ERD.	Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live This page provides you with a MySQL sample database that helps you to practice with MySQL effectively and quickly There are many excellent and interesting sample databases available, that you can use as a template (or pattern) to design your own databases	Following is a description of each of the tables in the SAMPLE database. Initial data values for each table are given; a dash (-) Learn and practice Power BI with these free sources of sample data. Whether you're a beginner or an expert Sample data for testing your applications	Download sample sql file or dummy sql file for your testing purpose. We provides you different sized sql files Learn and practice Power BI with these free sources of sample data. Whether you're a beginner or an expert I've built extensive spreadsheet sample data on a variety of real-world topics. Each data table includes rows

Free sample database - We'll summaries here the most significant and free example databases from well-known relational database products Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live This page provides you with a MySQL sample database that helps you to practice with MySQL effectively and quickly There are many excellent and interesting sample databases available, that you can use as a template (or pattern) to design your own databases

Workshop: Statistics4Performance: Internals, Analysis, and Solutions Kimberly Demo scripts password given out during the workshop, content for workshop attendees only Session: Performance Troubleshooting Using Wait Statistics Paul Demo scripts Session: Troubleshooting Query Plans: Part 1 — Caching Problems Kimberly Demo scripts Session: Troubleshooting Query Plans: Part 2 — Statistics Problems Kimberly Demo scripts.

Workshop: SQL Server Indexes: What, Why, and HOW! Kimberly Demo scripts password given out on the day for workshop attendees only Workshop: Performance Tuning Using Waits and Latches Paul Demo scripts password given out on the day for workshop attendees only Session: Introduction to Performance Troubleshooting Using Wait Statistics Paul Demo scripts Session: Index Fragmentation: Internals, Analysis, and Solutions Paul Demo scripts Session: Understanding SQL Server Backups and Restores Tim Demo scripts Session: Troubleshooting Query Plans: Part 1 — Root Cause Analysis and Caching Problems Kimberly Demo scripts Session: Troubleshooting Query Plans: Part 2 — Statistics Problems Kimberly Demo scripts Session: Statistics: Internals, Analysis, and Solutions Kimberly Demo scripts Session: Five Things I Wish Developers Knew about SQL Server Jonathan Demo scripts.

Workshop: Performance Tuning with Query Store in SQL Server Erin Demo scripts password given out on the day for workshop attendees only Workshop: Bigger Hardware or Better Code and Design?

Jonathan Demo scripts Session: Understanding Execution Plans Erin Demo scripts Session: Eliminating Anti-Patterns and RBAR for Faster Performance Jonathan Demo scripts. Workshop: Performance Tuning Using Waits and Latches Paul Demo scripts and whiteboard password given out on the day for workshop attendees only Workshop: SQL Server Indexes: What, Why, and HOW!

Kimberly Demo scripts and whiteboard password given out on the day for workshop attendees only Workshop: Performance Tuning and Optimization for Modern Workloads Tim Demo scripts password given out on the day for workshop attendees only Workshop: Zero-to-Hero: Faster SQL Query Performance Jonathan Demo scripts Session: Introduction to Performance Tuning Using Wait Statistics Paul Demo scripts Session: Troubleshooting Query Plans: Parts 1 and 2 Kimberly Demo scripts.

Workshop: Stop Tuning Queries and Start Tuning Your Workload Erin Demo scripts password given out on the day for workshop attendees only. Workshop: Modernize Your Workloads With Azure SQL Database and Managed Instance Tim Materials Demo scripts passwords given out on the day for workshop attendees only.

That is, user can efficiently search all the words in title and description columns. FULLTEXT search is supported in MyISAM engine only, not the InnoDB engine. A FULLTEXT index is build on columns title, description. Table " inventory " The company could have many copies of a particular film in one store or many stores.

Table " rental " Rental rate is kept in the film table. Table " payment " An rental can have multiple payments? Table " address " It is unlikely that two persons share the same address.

Table " country " Having a country table may facilitate the creation of pull-down menu. Views A VIEW is a virtual table without data that provides an alternate way to look at the data.

address AS address, a. phone AS phone, city. city AS city, country. country AS country, s. country AS country, IF cu. title AS title, film. description AS description, category. name AS category, film.

length AS length, film. LENGTH str returns the length of the string. SUBSTR str , fromIndex , length returns the substring from index of length index begins at 1.

UCASE str and LCASE str returns the uppercase and lowercase. country AS store, CONCAT m. country, c. name AS category, SUM p. title ORDER BY f. title SEPARATOR ', ' FROM sakila.

film f INNER JOIN sakila. actor a LEFT JOIN sakila. category c ON fc. Customize output as needed. title, new. title or old. FirstName, ' ', employees. FirstName, ' ', managers. employeeID ORDER BY managers. Table " Territories " -- e. VARCHAR ? Views There are 16 views defined.

CategoryName FROM Categories INNER JOIN Products ON Categories. CategoryID WHERE Products. CategoryName, Products. ProductName, Products. QuantityPerUnit, Products. UnitsInStock, Products. Discontinued FROM Categories INNER JOIN Products ON Categories.

UnitPrice FROM Products WHERE Products. ProductID, Products. ShipName, Orders. ShipAddress, Orders. ShipCity, Orders. ShipRegion, Orders. ShipPostalCode, Orders. ShipCountry, Orders. CustomerID, Customers. CompanyName AS CustomerName, Customers. Address, Customers.

City, Customers. Region, Customers. If there are any errors when running the scripts, you should be able to rerun only that file to drop and create the tables again.

Coming soon : a how-to guide on creating a Pull Request to request an update to these files. Sample Data for SQL Databases. Are you looking for some sample data sets to practice your SQL? Table of Contents Toggle. A database of movies, cast and crew, production information, genres, and more.

Sample Database ERD and Explanation SQL Scripts on GitHub. Video Games. A database of video games and their sales over time. Olympic Games. A database of Olympic games, competitors, events, and results. A database of superheroes from several sources, their powers, and their attributes.

Free sample database - We'll summaries here the most significant and free example databases from well-known relational database products Download our script and create your own database + data. Supports SQL Server , , , and Alternatively, use the live This page provides you with a MySQL sample database that helps you to practice with MySQL effectively and quickly There are many excellent and interesting sample databases available, that you can use as a template (or pattern) to design your own databases

There are many sample reports on the Microsoft Power BI Community website in the Data Stories Gallery section where you can download the PBIX files like these items:.

Goleno Pizza Dashboard Meat, to eat or not to eat? Narrative statistics Estimate Electricity Energy Usage and Cost Property developer's sales analytics. Kaggle is a popular platform for data science and machine learning competitions. They have a large collection of sample datasets that you can use for Power BI practice.

You can also set the filesize for each source:. Currently, this site has more than , data sources available 95, CSV, 16, JSON, SQlite files. The data. world is a social network for data people. They have a collection of open data sets that you can use for Power BI practice.

The site provides access to more than , data sets. The site allows you to set some filters to find the data source that has the data you are looking for, for instance, you can find good data sources for Power BI maps. Power BI Desktop has a certified connector for this site, all you need is the Owner's name and Dataset ID, which can be found on the site.

Connect your file directly to the data source by opening the data source page and setting the connector as shown below:.

Google Dataset Search is a search engine designed to help researchers, analysts, and data enthusiasts discover datasets that are freely available on the internet. The platform indexes datasets from a wide range of sources including government agencies, research institutions, and non-profit organizations.

Users can search for datasets by entering keywords related to their research interests, as well as filter results by file type, data format, or topic. To search for files on Google Dataset Search, you can use the following steps:.

Go to the Google Dataset Search website. In the search bar, type in the keywords related to the dataset you are looking for e. To filter your search results to only show Excel or tabular format files, click on the "Download Format" dropdown menu and select "Tabular" from the list.

You can further refine your search by selecting relevant filters, such as data source, publication date, or geographic location. Once you have found a dataset you are interested in, click on the title to view more details about the dataset and download the Excel file if it is available. Read this article for more info about this search engine:.

gov is the home of the US government's open data. You can find data sets related to various topics such as agriculture, climate, energy, health, and more. Set some filters on the right-side panel to find CSV 21, files , Excel 7, files , JSON 14, files , or Text format.

You can also set some filters on Topics, Categories, Organizations , Publishers, and Tags. World Cities Database: This website offers a variety of datasets with geographical data such as maps, city, county, and zip code data, as well as location-based datasets like store locations and population statistics.

They offer both free and paid datasets in various formats, including CSV, Excel, JSON, and SQL. The website also provides tools for creating custom maps and visualizations based on their datasets.

Many of their datasets include latitude and longitude information, which can be used to create maps in Power BI or other data visualization tools. OpenFlights Airports Database: This dataset contains information on airports around the world, including latitude and longitude information for each airport.

SGS Earthquake Data : This dataset contains information on earthquakes around the world, including latitude and longitude information for each event. Chinook is inspired from the classic Sakila sample database from MySQL. But while Sakila keeps DVDs with movies, Chinook is a back-end database of a fictional music DVD store.

Most data was collected by the author from iTunes. There are two main areas: inventory and billing. Inventory keeps the catalog of Tracks for each Album , with albums produced by Artists. MediaType and Genre act like categories.

Tracks can be also grouped within Playlists. Invoice is the main billing table, with order details kept in InvoiceLine. The table below shows a large enough number of records in Invoice and InvoiceLine for billing , and Tracks for inventory with many of them saved in Playlists :.

SportsDB is an open-source database with real statistical data for different sports baseball, American football, ice hockey, tennis, basketball etc , licensed under Creative Commons GNU GPL. You can download either the SQL script files for MySQL or PostgreSQL, or a detached Microsoft SQL Server MDF database file.

The SQL script is over 15MB in size, so attaching and using rather the SQL Server database could be more practical. The database has over tables, many of them isolated, with no relationships and foreign keys. The group below shows a bunch of related tables as collapsed shapes.

This is a database small in size, but with many tables. It could be interesting to find associations between related tables and data.

And drill-down on different events. Sean Lahman , former sports reporter and columnist, created a freely available database of baseball statistics. The database contains batting and pitching statistics from to , plus other statistical real data. The work is licensed under a Creative Commons Attribution-ShareAlike 3.

You can download the archived files with either a MDB Microsoft Access database to load directly in Data Xtractor , a Microsoft SQL Server bak file or compressed CSV Comma-Separated Values files.

The database has 24 tables with no referential integrity set, i. no foreign keys defined. We kept just a few tables expanded here below:. This is a large database in size, with 70MB for the decompressed MDB Access file. Beginning SQL Queries was written by Clare Churther in , and published by Apress.

The SQL scripts and an ACCDB Microsoft Access database file are shared on Github. The database is very small in size, with just a few records per table. But this makes it also ideal for practice and to learn SQL, whether you buy the book or not. The database has 14 tables and one view, and we called it Waterfalls.

This original repository contains an inventory with a few waterfalls across the US. An INDEX can be built on unique-value column UNIQUE KEY or UNIQUE INDEX or non-unique-value column KEY or INDEX.

Indexes greatly facilitates fast search. However, they deplete the performance in INSERT , UPDATE and DELETE. Generally, relational databases are optimized for retrievals, and NOT for modifications.

Junction table to support between many-to-many relationship between employees and departments. A department has many employees. An employee can belong to different department at different dates, and possibly concurrently.

The foreign keys have ON DELETE reference action of CASCADE. If a record having a particular key-value from the parent table employees and departments is deleted, all the records in this child table having the same key-value are also deleted. There are two reference actions: ON DELETE and ON UPDATE.

The ON UPDATE reference action of is defaulted to RESTRICT or disallow. It is more meaningful to set ON UPDATE to CASCADE , so that changes in parent table e. join table to support between many-to-many relationship between employees and departments.

There is a one-to-many relationship between employees and titles. One employee has many titles concurrently or at different dates.

Similar structure to titles table. One-to-many relationship between employees and salaries. It is a complex database with 16 tables. It also illustrates features such as Views, Stored Procedures and Triggers. This is probably the best sample available for studying MySQL databases.

All the tables have DEFAULT CHARSET of utf8 for internationalization support. For UTF8 support, we could set the DEFAULT CHARSET at the database level as follows:. There are 6 records for this table, i. Junction table between actor and film to support the many-to-many relationship.

Junction table to support many-to-many relationship between film and category. There are records for this table. The company could have many copies of a particular film in one store or many stores. Each copy is represented by an inventory record.

It is unlikely that two persons share the same address. Address is often a required field for a rental transaction. So it is probably better to store directly inside the customers table. Having a country table may facilitate the creation of pull-down menu.

Alternatively, you could consider using an ENUM number of countries may exceed ENUM 's limit. For city , there are just too many cities in the world that the list can never be exhaustive. Probably better to keep inside the address table.

A VIEW is a virtual table without data that provides an alternate way to look at the data. It could be a consolidated set of columns from multiple table, or include derived column such as total price.

The GROUP BY aggregate function SUM applies to each group of c. name , i. For MS SQL Server, you can download the Northwind database from " Northwind and Pubs Sample Databases for SQL Server ".

Run the downloaded ". The SQL statements are kept in " instnwnd. sql ". There are various MySQL ports available. To load this table with the sample data provided, you need to move the second record as the first record and hardcode the employeeID.

There are 9 records for this table. The photos are included as hex data. To list the worker names under the manager names, you need to join the employee table to itself. Use LEFT JOIN to retrieve ReportsTo of NULL.

There are 4 records for this table 'Eastern' , 'Western' , 'Northern' , 'Southern'. There are 49 records for this table. Each employee has more than one territories. There are 8 tables, with no stored objects view, procedure, function, trigger and event defined. You need to index the productLine column of the products table to use the column as a foreign key here.

This payment table does not reflect the order paid?! Could also provide a VIEW for invoices. TABLE OF CONTENTS HIDE. This is a rather simple database with 6 tables but with millions of records.

Video