Welcome to this tutorial on creating and loading tables in Redshift! In this video, I'll be walking you through the process of creating the emp and dept tables in Redshift and uploading employee and department files to an S3 bucket. We'll then create the tables in Redshift and load the data from the S3 bucket into the newly created tables.
First, we'll create the tables in Redshift and then upload the employee.csv and department.csv files to an S3 bucket. Once we have our data files in place, we'll create the emp and dept tables in Redshift and load the data from the S3 bucket into the tables. By the end of this video, you'll have a clear understanding of how to create and load tables in Redshift, as well as how to work with data files in S3. So, let's get started and create some tables!
SQL Query:
1. Display all the columns from employee table where Job in ascending order and emp_no in descending order.
2. Display the emp_no, ename, dept_no, dept_name, loc, salary, bonus, Total Salary (salary + bonus) of all the employees.
3. Display dept_no, number of employees of those departments where at least two employees are working.
4. Display all the columns of employee table whose enames contain the letter ‘A’.
5. Display ename, job, salary, manager name and manager's salary of those employees whose salary is higher than managers salary.
------------------------------------------------------------------------------------------------------------------------------
lets connect on...
----------------------
LinkedIn: [ Ссылка ]
Instagram: [ Ссылка ]
My Blogsite : [ Ссылка ]
Twitter : [ Ссылка ]
--------------------------------------------------------------------------------------------------------------------------------------------
Day in life of Software Engineer : [ Ссылка ]
Pune Capgemini Tour : [ Ссылка ]
Hyderabad Capgemini : [ Ссылка ]
What is AWS : [ Ссылка ]
My journey as Software Engineer : [ Ссылка ]
PG tour in Hyderabad : [ Ссылка ]
How to Avoid Burnout : [ Ссылка ]
AWS Project : [ Ссылка ]
AWS Projects playlist : [ Ссылка ]
--------------------------------------------------------------------------------
**Must watch Movies** : [ Ссылка ]
**Books Reviews** : [ Ссылка ]
**Must watch Documentaries** : [ Ссылка ]
**Must Listen Podcast** : [ Ссылка ]
**Hashtags**
#AWSReshift
#awss3
#sqlquery
#Redshiftdatabse
![](https://s2.save4k.ru/pic/ZefK2Umc2ZA/maxresdefault.jpg)