MySQL: Download Link for Sample Database (Sakila)

Beginners are always searching for sample database so, in this post, I am sharing an official download link to a MySQL Sakila sample database which we can use for our testing purpose. Sakila sample database is a DVD rental database. The database contains sample tables, views, SPs, Functions and Triggers. The MySQL beginner can install […]

April 1, 2019 MySQL

March 25, 2019

PostgreSQL: Script to convert User to Super User

March 18, 2019 5

SQL Puzzle: SQL Advance Query – Replace NULL with Previous Non Null value

March 11, 2019 5

SQL Puzzle: SQL Advance Query – Generate the data in the RANGE format

March 4, 2019 1

PostgreSQL: Bash Shell Script to execute psql command in UNIX / LINUX

February 25, 2019

PostgreSQL: Don’t take backup until your Database is changed

February 18, 2019

PostgreSQL: What is IMMUTABLE, STABLE, VOLATILE and COST of Function

February 11, 2019

PostgreSQL: join_collapse_limit to force join order laid out by explicit JOINs

February 4, 2019 1

Database Design: Please do not use DISTINCT

January 28, 2019

SQL Server: Auto Generate Database Detach and Attach Scripts

Older posts Newer posts

About Me!