Завершен

SQL PROJECT

/*

Q1: Write the SQL to create a stored procedure to UPDATE the BeginDate column in the

-- STUDENT_DORMROOM table. USE THROW error-handling if variable is NULL.

*/

/*

Q2: Write the SQL to create a stored procedure to DELETE a row in the STUDENT_DORMROOM table.

-- USE RAISERROR error-handling if any variable is NULL.

*/

/*

Q3: Write the SQL to create a stored procedure to INSERT a row in the DEPARTMENT table.

USE THROW error-handling if variable is NULL.

*/

/*

Q4: Write the SQL to create a stored procedure to UPDATE the EndDate column in the DEPARTMENT table.

Use RAISERROR method of error-handling if variable is NULL

*/

/*

Q5: Write the SQL to create a stored procedure to DELETE a row in the DEPARTMENT table.

*/

/*

Q6: Write the SQL query to determine which classes meet all of the following conditions:

1) have associate professors that taught a philosophy class in the last 7 years

2) are part of department that have more than 3 students living in a double dorm room type.

*/

Навыки: SQL, Oracle, Управление базами данных, Программирование баз данных, MySQL

О клиенте:
( 2 отзыв(-а, -ов) ) Shoreline, United States

ID проекта: #33526365

Поручен:

(62 отзывов(-а))
6.1

35 фрилансеров(-а) готовы выполнить эту работу в среднем за $37

urmate

Hi there I have excellent programming skills related to your project. I have read your project descriptions and consider myself the best fit for this job. I can provide a quality solution for your project. Thanks Far Больше

$50 USD за 2 дней(-я)
(464 отзывов(-а))
7.3
Truonggiang86

Hello there, i've been working with Oracle for 12 years and i think your 6 questions i can handle in a couple of hours. Pls share me your database and data so we can proceed. Waiting for your response if interested. Th Больше

$60 USD за 1 день
(53 отзывов(-а))
5.9
Zohaib748

Hello Dear...! Alert: I will give you 20% discount on my bid rate also give on my All Services. So grabs this special offer is limited. Let’s get to the point. I came to know that your Looking a developer which hav Больше

$10 USD за 1 день
(40 отзывов(-а))
6.0
(106 отзывов(-а))
5.8
(24 отзывов(-а))
5.8
Sugidev

Hi there, I can answer all the questions with 100% accuracy. I am expert in sql, please check my reviews. I am available, please ping me. Thanks Sugi

$55 USD за 1 день
(25 отзывов(-а))
5.0
(30 отзывов(-а))
5.1
(12 отзывов(-а))
4.8
(33 отзывов(-а))
5.0
(19 отзывов(-а))
4.7
(35 отзывов(-а))
4.4
(7 отзывов(-а))
4.4
bizmanas

Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress development, power bi. programming using python and c#. I will be able to help you with the project. Please ping me offl Больше

$77.78 USD за 1 день
(10 отзывов(-а))
4.1
akhilvl1302

"Hi, I am an expert in Mysql. Can create procedures based on your requirement Skills: PHP, Python, Node, Mysql Please message me for further discussions. Thanks!"

$35 USD за 1 день
(19 отзывов(-а))
4.1
techriverr

Hello, I hope you have a good day. I can write those stored procedures for you right now I'm an expert in MySql and other RDBS I only have one question which database server are you using right now? I have over ten Больше

$40 USD за 1 день
(5 отзывов(-а))
4.1
fastlabindia

Greetings!. I checked your Database Design requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in MySQL , MS ACCESS, MS SQL, Oracle , No SQL and other DBMS software, Queries, Re Больше

$10 USD за 2 дней(-я)
(16 отзывов(-а))
4.5
merinsinha

Senior SQL Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this p Больше

$50 USD за 1 день
(27 отзывов(-а))
4.0
shashilal

I am indivisual software developer having 9 + years exp in Php,cake,codiegnator and wp,I have completed many web based project in all areas like edu,real estate,insurance,ecommerce. etc.

$32 USD за 1 день
(24 отзывов(-а))
3.6
(5 отзывов(-а))
2.8
majid3ma

Hello I can create your 5 store producers with error handling and also I'll create your Q6 select query in in less than an hour Kind Regards,

$20 USD за 1 день
(1 отзыв)
2.8