How to Create Tables in Redshift Database and Load Data from S3 | AWS redshift | AWS S3 | SQL query скачать в хорошем качестве

How to Create Tables in Redshift Database and Load Data from S3 | AWS redshift | AWS S3 | SQL query

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:   / mahir-jayswal-a4206413a   Instagram:   / mahir14_   My Blogsite : https://guiderboi.blogspot.com/ Twitter : https://twitter.com/Mahir96500019?t=O... -------------------------------------------------------------------------------------------------------------------------------------------- Day in life of Software Engineer :    • A day in life of software Engineer || Hyde...   Pune Capgemini Tour :    • Tour inside Capgemini, pune  | Hinjewadi p...   Hyderabad Capgemini :    • A day in life of software Engineer || Hyde...   What is AWS :    • What is Amazon Web services (AWS) ? | How ...   My journey as Software Engineer :    • Moving in New city As IT professional | Hy...   PG tour in Hyderabad :    • PG in Hyderabad | Financial District | Gow...   How to Avoid Burnout :    • How to avoid burnout   AWS Project :    • How to Build a Serverless Application with...   AWS Projects playlist :    • Amazon Web Service(AWS).   -------------------------------------------------------------------------------- *Must watch Movies* : https://guiderboi.blogspot.com/2023/0... *Books Reviews* : https://guiderboi.blogspot.com/2022/0... *Must watch Documentaries* : https://guiderboi.blogspot.com/2022/0... *Must Listen Podcast* : https://guiderboi.blogspot.com/2022/0... *Hashtags* #AWSReshift #awss3 #sqlquery #Redshiftdatabse