Here is a compilation of earlier blog posts that were relevant to Sample datasets, Sample projects, and Sample assignments. For quick reference only.
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…
SQL Sample project
A simple project in SQL Server for beginners and intermediate levels It 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…
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 your skills. Practice and exercise problems are the easiest way to learn something. This has nothing to do with Microsoft exams or their pattern. This is just to…
SQL Assignment-2
This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature will undoubtedly aid in skill improvement. The simplest method of learning is through practice and exercise problems. This is unrelated to Microsoft examinations or their format. Simply put, I’m testing…
SQL Assignment-3
This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature will undoubtedly aid in skill improvement. The simplest method of learning is through practice and exercise problems. This is unrelated to Microsoft examinations or their format. Simply put, I’m testing…
SQL Assignment-4
There will be no complex stored procedures available anywhere if you look for them online since complexity arises when you have a requirement that leads to it. A sample database schema for information on mobile calls, their owners, mobile recharges, consumption, etc. is attached. The schema is created based on the following requirement. Customers exist,…
Answer to – SQL Assignment-2
The answer to assignment-2 is provided below. If you haven’t visited the post, please do so by clicking here. — Answer to 1st Question SELECT DName, LocationName, COUNT(*) FROM Emp JOIN DeptLocation ON DeptLocation.DeptLocationId = Emp.DeptLocationId JOIN Dept ON Dept.DeptNo = DeptLocation.DeptNo JOIN Locations ON Locations.LocationId = DeptLocation.LocationId GROUP BY DName, LocationName — Answer to…
Answer to – SQL Assignment-3
The answer to assignment-3 is provided below. If you haven’t visited the post, please do so by clicking here. Solution:1 ;WITH CTE AS (SELECT DName, EName, EmpNo, Sal = CASE WHEN DName = ‘SALES’ THEN (Sal + Sal * 0.10) WHEN DName = ‘RESEARCH’ THEN (Sal + Sal * 0.08) WHEN DName = ‘ACCOUNTING’ THEN…
Answer to – SQL Assignment-4
Below is an attachment with the assignment #4 solution. You can execute it all at once in the “dbCall” database that was built in Assignment-4 to retrieve the results, including the length and cost of each call, among other information. Happy learning!!!
Apache Hive – Assignment-2
The majority of the blog entries are written in a style that novices may understand. I will give some practice tasks to be completed using Apache Hive in order to develop learning abilities and to provide practical exposure and knowledge growth. There will be a set of assignments with data sets, but without solutions. Title…
Apache Hive – Assignment-1
The majority of the blog entries are written in a style that novices may understand. I will give some practice tasks to be completed using Apache Hive in order to develop learning abilities and to provide practical exposure and knowledge growth. There will be a set of assignments with data sets, but without solutions. Title…
Apache Hive – Assignment-3
The majority of the blog entries are written in a style that novices may understand. I will give some practice tasks to be completed using Apache Hive in order to develop learning abilities and to provide practical exposure and knowledge growth. There will be a set of assignments with data sets, but without solutions. Title…
Apache Hive – Assignment-4
The majority of the blog entries are written in a style that novices may understand. I will give some practice tasks to be completed using Apache Hive in order to develop learning abilities and to provide practical exposure and knowledge growth. There will be a set of assignments with data sets, but without solutions. Title…
Apache Hive – Assignment-5
The majority of the blog entries are written in a style that novices may understand. I will give some practice tasks to be completed using Apache Hive in order to develop learning abilities and to provide practical exposure and knowledge growth. There will be a set of assignments with data sets, but without solutions. Title…
Assignments To Prepare CCA159
Coming Soon..!!Study material / guide is under preparation. Since Cloudera has disapproved of me offering any sample questions or question patterns due to credibility concerns, I would only be able to provide some practice exercises. Please do follow via Email to get updates about Big Data sample projects and assignments.
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,…
Big Data & SQL 