Required Databases to be created before starting SQL journey with me

Dear SQLVersitians,

Please Execute the below script in your computer to set up the required databases in your server. I am going to use these databases in my future posts.

——————————————————————————————
— CopyRight @SQLVersity
——————————————————————————————
— This Database is used for having Demo on SQL, T-SQL Tutorials.
— SQL/T-SQL category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_1_SQL&T-SQL’) IS NOT NULL
DROP DATABASE [SQLVersity_1_SQL&T-SQL]
GO

CREATE DATABASE [SQLVersity_1_SQL&T-SQL]
GO
——————————————————————————————
— This Database is used for having Demo on Articles.
— Articles category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_2_Articles’) IS NOT NULL
DROP DATABASE [SQLVersity_2_Articles]
GO

CREATE DATABASE [SQLVersity_2_Articles]
GO
——————————————————————————————
— This Database is used for having Demo on SSIS Tutorials.
— SSIS category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_3_SSIS’) IS NOT NULL
DROP DATABASE [SQLVersity_3_SSIS]
GO

CREATE DATABASE [SQLVersity_3_SSIS]
GO
——————————————————————————————
— This Database is used for having Demo on SSRS Tutorials.
— SSRS category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_4_SSRS’) IS NOT NULL
DROP DATABASE [SQLVersity_4_SSRS]
GO

CREATE DATABASE [SQLVersity_4_SSRS]
GO
——————————————————————————————
— This Database is used for having Demo on SSAS Tutorials.
— SSAS category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_5_SSAS’) IS NOT NULL
DROP DATABASE [SQLVersity_5_SSAS]
GO

CREATE DATABASE [SQLVersity_5_SSAS]
GO
——————————————————————————————
— This Database is used for having Demo on Interview Q & As.
— Interview Q & A category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_6_InterviewQ&As’) IS NOT NULL
DROP DATABASE [SQLVersity_6_InterviewQ&As]
GO

CREATE DATABASE [SQLVersity_6_InterviewQ&As]
GO
——————————————————————————————
— This Database is used for having Demo on Errors & Solutions.
— Errors & Solutions category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_7_Errors&Solutions’) IS NOT NULL
DROP DATABASE [SQLVersity_7_Errors&Solutions]
GO

CREATE DATABASE [SQLVersity_7_Errors&Solutions]
GO
——————————————————————————————
— This Database is used for having Demo on Tips & Tricks.
— Tips & Tricks category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_8_Tips&Tricks’) IS NOT NULL
DROP DATABASE [SQLVersity_8_Tips&Tricks]
GO

CREATE DATABASE [SQLVersity_8_Tips&Tricks]
GO
——————————————————————————————
— This Database is used for having Demo on DB Tools
— DB Tools category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_9_DB_Tools’) IS NOT NULL
DROP DATABASE [SQLVersity_9_DB_Tools]
GO

CREATE DATABASE [SQLVersity_9_DB_Tools]
GO
——————————————————————————————
— This Database is used for having Demo on Forums
— Forums category in SQLVersity.com
——————————————————————————————
IF DB_ID(‘SQLVersity_10_Forums’) IS NOT NULL
DROP DATABASE [SQLVersity_10_Forums]
GO

CREATE DATABASE [SQLVersity_10_Forums]
GO
——————————————————————————————

Happy Journey with SQLVersity :)

Leave a Reply

Your email address will not be published. Required fields are marked *