Closed

SQL and NoSQL ( HBasae)

Job Description:

Select the problem / Define the problem.

Create Tables with constraints

Design a Schema based on tables and explain the schema.

Create primary keys, foreign keys.

Create Procedures.

Create functions.

Create Views

Create Index

Use of the following Clauses:

Example : order by, between, group by, having, order by,

AND, OR, with

Use Aggregate Functions

Use of nested queries, Scalar Subquery.

Part 2 has to be done in HBASE

Create Tables – 4 tables with Column family and columns

Column family - 5 column families: Make sure have different parameter. Ex: versions

Minimum 4 Columns in each Column family

Insert records

Delete records

Perform basic queries like your assignment1

Try to extract data using timestamp

Insert partial data in a row

Describe table.

Check table status – enabled or disabled

Use count command to count the number of rows in a tables

Alter tables

etc.

Skills: SQL, Database Programming, MySQL, Database Administration, NoSQL

About the Client:
( 4 reviews ) Bayonne, United States

Project ID: #35379616

33 freelancers are bidding on average $145 for this job

nyarOnyari

Hello, I have read your project description about Database Design. I am an expert in database systems and I have developed many database systems including but not limited to a database system for a School, County Burs More

$140 USD in 2 days
(36 Reviews)
5.0
noureen23

Hi There, I hope you having good day. I am glad to offer my services for "SQL and NoSql project". I have extensive experience in Databases and SQL programming . My experience makes me confident to assure you 100 perce More

$140 USD in 5 days
(23 Reviews)
4.4
saminakiran2

Hello Mate! If the project is deleted please open my portfolio link and hire me through my profile and lets discuss your project details . "https://www.freelancer.com/u/saminakiran2?w=f" You need assistance with SQL More

$100 USD in 1 day
(3 Reviews)
4.2
Hammad8475

Greetings, I am a professional and experienced in providing high-quality Full-stack WordPress, and PHP designing, developing, and Swift services. I am highly interested in your project. Please contact me so I may shar More

$120 USD in 6 days
(3 Reviews)
4.0
artemsergiev96

★★★ I can start immediately and finish it within 1 day★★★ Hi I have read your job description and understood what you want. I'm a senior  developer and have been working over 10 years. I have completed many projects an More

$140 USD in 7 days
(3 Reviews)
4.0
ashinnd84

Hi there, we are expert in SQL, MySQL, NoSQL. Database Administration, Database Programming. Please, send the details.

$300 USD in 12 days
(8 Reviews)
3.9
umg536

Hi there, I'm bidding on your project "SQL and NoSQL ( HBasae)" I am expert in assignment and powerpoints, and can get it done for you efficiently. please leave a message on my chat so we can discuss the budget and de More

$250 USD in 3 days
(2 Reviews)
3.4
veselidevelop

Hello there Syed H., Good evening! As you can see in my profile I am professional web software engineer not just a normal developer with skills including SQL, MySQL, NoSQL, Database Programming and Database Administra More

$30 USD in 5 days
(3 Reviews)
3.1
Actisoft2017

Hey I am expertise in this and I have done similar work in the past . as per my skills , I am the right one for this project and I will provide u with much better service and timely support . Message me for further di More

$140 USD in 7 days
(5 Reviews)
3.2
TFComplex

Hi, Greetings from Zuhair Muhammad. I'm interested in doing your work so finally would like to start work now. I'm ready for an interview and feel free if you have any queries and contact me anytime 24*7 will be availa More

$35 USD in 7 days
(4 Reviews)
2.8
ihorkuzn

Hello. I am a web developer with 7+years of experience. Your project requirements attracted my attention. You can check my skill set from my profile. Here comes what I can provide you. -Excellent overall look of websit More

$120 USD in 7 days
(2 Reviews)
2.7
tsmcguinness

Hi, I am very glad to bid on your job posting. I am not only talented programming developer, but also SQL expert. I can contact with you anytime you want and I can work for you as a full time developer. It's my pleasur More

$140 USD in 2 days
(1 Review)
2.3
mkastukevich

Hi, there. As you can see my profile, I have much experience in Mysql and Nosql management. One thing, I am motivative and innovative person so that I can work in difficult situation that involove bad news. So I would More

$200 USD in 1 day
(2 Reviews)
2.4
ArturDurg75

Hello I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am a senior developer and I have 15+ years in this field. Now I am very interesting your job and More

$140 USD in 7 days
(1 Review)
2.0
pratik123

HI I am sql database ,Big Data professional who has industry extensive experience in several databases. I can give training , support, in any project and resolve your work asap. Hope to meet you soon. Thank you.

$225 USD in 7 days
(1 Review)
1.6
anthonyroo

"I am a Full stack web front-end /back-end Developer here for you" Hello, Warm Greetings !! Yes, This job matches my skill set.I would like to let you know that I have experts and commercial experience in this catego More

$150 USD in 7 days
(1 Review)
1.4
ianm62118

Greetings! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can c More

$150 USD in 3 days
(0 Reviews)
0.0
konanhenry1111

⭐⭐I can start now and I am confident that I can do it ⭐⭐ I did many designs and I can show u some of it. I have 10 years of experience in this field and I have these skills (SQL, Database Programming, Database Administ More

$30 USD in 2 days
(0 Reviews)
0.0
stairovic940

Hi, I am MySQL, Google Cloud SQL, SQLite expert developer. I have deep knowledge in MySQL language and data structure. If you choose me as a developer , you will get perfect result . Please contact me for our project. More

$140 USD in 7 days
(1 Review)
0.0
valeevalex

Hello I expect you to prefer Americans like me. I can finish this job in a day as a full-stack web developer. If you give me the assignment, I will satisfy you with good results. Please do share more details via chat f More

$200 USD in 7 days
(1 Review)
0.6