SQL Assignment-1
For beginners to intermediate levels, this is a quick test / assignment to check how familiar they are with SQL. Such types of exercises will certainly help to improve skills. Practice and exercise problems are the easiest way to learn something.This has nothing to do with Microsoft exams or its pattern. This is just to…
SQL Sample project
A simple project in SQL Server for beginners and intermediate levelsIt is important to practice and thus apply the concepts in various situations in order to effectively understand each definition in SQL. This will give a better understanding of each function and how they can be manipulated to make your job easier!Hence, I have always…
Complete TSQL with Examples
Complete document on TSQL with multiple examplesI created a document on TSQL (Transact SQL) in Microsoft SQL Server. While I have written many of the pages and examples, I do not take all the credit as an author, as few blocks or pages or examples are copied from various web sources. This will give you…
Apache Hive – Quiz-1
Test your knowledge in Apache Hive.
Apache Hive – Quiz-2
Test your knowledge in Apache Hive.
Sample Datasets to Practice Complex Data Types
I’ve written a number of articles in this blog so far about complex data types (in Apache Hive). I frequently used the JPG format to display the datasets and results. The link to all the sample data files that were used in those cases is provided below. Sample Datasets for Complex Data Types Practice
SQL Server – Sample Schema – Tables – For Practice
Beginners can practice creating new tables, joining them together, using sub-queries, etc. with the schema below. I hope this will be useful to you as well. To see the whole code, scroll down. Simply copy, paste, and run it in your GUI. Here is the sample schema. Information about departments is stored in table “Dept.”…
Apache Hive – Avro Sample Schema & Data
While learning any technology, it is important to have some example datasets for practice, and if sample data is unavailable and practice is not done, the learning will be incomplete. I want to be of assistance to beginners and learners by providing sample data/datasets for practice.For practice, we’ve included an example Avro schema and Avro…
SQL Sample project
A simple project in SQL Server for beginners and intermediate levelsIt is important to practice and thus apply the concepts in various situations in order to effectively understand each definition in SQL. This will give a better understanding of each function and how they can be manipulated to make your job easier!Hence, I have always…
EMP and DEPT datasets for MongoDB
Since Oracle’s “EMP” and “DEPT” datasets are useful for practice, I’ve provided converted scripts for SQL Server and MySQL in previous articles. This tutorial will guide you through the process of creating an example dataset and practice adding entries into MongoDB. The table definition in SQL is as given below: –Table definition – Dept CREATE…
EMP and DEPT Datasets for MySQL
In several of the SQL Server and MySQL examples in my blogs, I used Oracle’s “EMP” and “DEPT” datasets. In other RDBMSs, creating such tables from scratch takes time. I’ve previously provided the SQL Server-converted script, and now I’m providing scripts that can be run in MySQL to generate example datasets for novices. –Creating DEPT…
Oracle SQL Emp and Dept Tables For SQL Server
Below are Oracle’s most popular “emp” and “dept” tables compatible with SQL Server. — Table definition – Dept CREATE TABLE Dept( DeptNo INT, DName VARCHAR(14), Loc VARCHAR(13), CONSTRAINT pk_Dept PRIMARY KEY (DeptNo) ); — Tabe Definition – Emp: CREATE TABLE Emp( EmpNo INT, EName VARCHAR(10), Job VARCHAR(9), Mgr INT, HireDate date, Sal INT, Comm INT,…
I feel this is among the so much important information for me.
And i am happy reading your article. However should
observation on some general things, The web site taste is ideal, the articles is truly nice :
D. Good activity, cheers
LikeLike