3. SQL Statements to Create Table | Insert and Retrieve Data in SQL | Select | Where Query | RPA

👉 This Playlist Covers what additional Skills are required to work as an RPA developer The Skill we are talking here is knowledge of Databases.

► SQL Statements to Create Table
► Insert Data into SQL
► Read Data from Table SQL
► Query Database in SQL
► Insert Multiple Records
► Database Commands

►►►►►► This Video covers the Following ◀◀◀◀◀◀◀◀

► Timestamps ◀
0:00 Introduction
1:24 : Agenda
2:14 : What is a Table
4:58 : Common Data Types
8:16 : Create Table
9:51 : What is Primary Key
12:29 : Create Table in SSMS
15:24 : Select Statement in SQL
19:10 : Insert Into Table
24:35 : Insert Into Query Variances
27:50 : Insert Multiple Records at Once
33:19 : Where Clause in SQL
37:17 : Operators in Where Clause
41:52 : Summary

►►►►►► Links to Refer ◀◀◀◀◀◀◀◀

👉 How to Install Microsoft SQL Server 2019 | SQL Server Express on Windows | (Step-By-Step Tutorial)

👉 Complete SSMS Playlist

👉 Practice End to End Use Cases

Happy Automation!

►►►►►► Social Media Links ◀◀◀◀◀◀◀◀

#UiPath #RPA #Automation #mukeshkala #Discover #UiPathCommunity #uipathmvp

►►►►►► Tags ◀◀◀◀◀◀◀◀
Tutorials by Mukesh Kala
UiPath Tutorials by Mukesh Kala
uipath
mukesh kala
uipath tutorial
uipath projects
rpa tutorial for beginners
uipath tutorial for beginners
rpa interview questions and answers
rpa projects
ui path
uipath rpa
rpa uipath tutorial
uipath uipath tutorials
uipath sql database
uipath tutorial
uipath sql query
learn basic uipath
uipath sql server
uipath advance
uipath automation uipath videos
uipath training
uipath database activities
uipath execute query
database activity in uipath
rpa training
uipath sql
insert activity in uipath
start transaction in uipath
disconnect uipath

[Ye_timepagal]

In Assignment we have to create the temp table in tha same DB?

[tushar]

Thank you for this video please make some videos on SQL store procedures in UiPath 😊😊

[Priyesh]

Sir why have you used 255 in the datatype?
varchar(255)

[SyedAli-iqku]

Thannk you Mukesh,

select EmpId, EmpName from Employee
where
EmpId<150 And Location='America'

[prashantrai-rfbd]

insert into Company(EmpID, EmpName, Department, Locations)
select EmpID, EmpName, Department, Locations from employee;

Company is datatable where we want to insert data
employee is a datatable from where we take data

[aartijha]

select EmpId, EmpName from Employee where EmpId<4000 and Location='Chennai'

[prashantrai-rfbd]

Select EmpID, EmpName From employee

where EmpID<4000 and Locations='Chennai'

[viral]

Select eid, ename from employee where eid<4000 AND location='mumbai'

[nandinipeddoju]

Select EMPID, EMPNAME From Employee where EMPID<4000 and Location='Chennai'

[nagaviswanath]

Syntax:
Select EmpID, EmplName From Table_Name
Where
EmplID<4000 AND Location = 'Chennai'

[Priyesh]

SELECT EMPID, EMPNAME FROM EMPLOYEE
WHERE
EMPID < 4000
AND
Location = 'Chennai';

[bondshaik]

Select eid, ename from employee where eid<4000 AND location='mumbai'