In this video, we will discuss the most important and most frequently used concept as a Data Engineer. i.e. Date Time formatting in building data pipelines. we will be more regularly converting given dates into different formats and required data will be extracted from the given dates.
#sql #dataengineers #sqlserver #dataanalytics
Here are create and insert statements:
-------------------------------------------------------------
create table employee (
Employeeid int,
EmployeeName varchar(30),
Department varchar(20),
JoiningDate date time,
salary int
)
insert into Employee values(
(1, 'Mahendra', 'Sales', '2023-01-15 09:30:00', 45000),
(2, 'Mahi', 'Marketing', '2022-06-23 10:00:00', 43200),
(3, 'Sai', 'IT', '2021-11-01 11:15:00', 45000),
(4, 'Ravi', 'HR', '2020-09-30 08:45:00', 36000),
(5, 'Suresh', 'Finance', '2019-08-19 14:30:00',54000),
(6, 'Ramesh', 'Operations', '2018-07-10 09:00:00',48000),
(7, 'Lalitha', 'Customer Service', '2023-02-01 13:20:00', 60000),
(8, 'Anil', 'Engineering', '2021-04-15 15:45:00',63360),
(9, 'Vijay', 'Product', '2022-05-21 10:30:00',60000),
(10, 'Krishna', 'Support', '2020-10-05 16:00:00',52800);
You can get more information like data analysis projects and important information from my medium and github pages.
Here are
My medium blogs: / mahendraee204
My github: github.com/mahendra204
15 июн 2024