No video

Learn SQL Commands DDL DML DCL TCL

  Рет қаралды 542

Informatica Interview

Informatica Interview

3 жыл бұрын

DDL
DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.
CREATE - to create database and its objects like (table, index, views, store procedure, function and triggers)
ALTER - alters the structure of the existing database
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
COMMENT - add comments to the data dictionary
RENAME - rename an object
DML
DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.
SELECT - retrieve data from the a database
INSERT - insert data into a table
UPDATE - updates existing data within a table
DELETE - Delete all records from a database table
MERGE - UPSERT operation (insert or update)
CALL - call a PL/SQL or Java subprogram
EXPLAIN PLAN - interpretation of the data access path
LOCK TABLE - concurrency Control
DCL
DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.
GRANT - allow users access privileges to database
REVOKE - withdraw users access privileges given by using the GRANT command
TCL
TCL is short name of Transaction Control Language which deals with transaction within a database.
COMMIT - commits a Transaction
ROLLBACK - rollback a transaction in case of any error occurs
SAVEPOINT - to rollback the transaction making points within groups
SET TRANSACTION - specify characteristics for the transaction.
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials.
Got any questions about informatica interview? Ask me in the comment section below.
------------------------------
Why should you watch my channel?
Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10+ years in North Carolina, USA and want to help and share realtime and scenario based tutorial to prepare for interview.
Who should watch this video?
If you are fresher or already working but looking to refresh SQL, Informatica, ETL, Data warehousing concepts for interview.
For more Information:
Please visit my other platforms.
Website: www.informaticainterview.com
LinkedIn: www.linkedin.com/in/informatica-interview-prep
Or contact me by email: informaticainterviewhelp@gmail.com

Пікірлер: 1
@ibrahima9123
@ibrahima9123 2 жыл бұрын
great explanation
What is SQL? [understand in 4.5 minutes for beginners]
4:27
Informatica Interview
Рет қаралды 101
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,5 МЛН
Box jumping challenge, who stepped on the trap? #FunnyFamily #PartyGames
00:31
Family Games Media
Рет қаралды 30 МЛН
Doing This Instead Of Studying.. 😳
00:12
Jojo Sim
Рет қаралды 32 МЛН
Why Is He Unhappy…?
00:26
Alan Chikin Chow
Рет қаралды 101 МЛН
SQL- DML Command and Syntax
7:06
Informatica Interview
Рет қаралды 315
Types of SQL Commands (DDL, DQL, DML, DCL, TCL) - SQL Tutorial #5
4:50
Data with Baraa
Рет қаралды 3,2 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 189 М.
ER vs Dimensional Simplified Under 10 minutes
6:59
DataValley Technologies
Рет қаралды 6 М.
Conceptual, Logical & Physical Data Models
13:45
DataAcademy.in
Рет қаралды 470 М.
Database Languages and Software
12:14
Neso Academy
Рет қаралды 51 М.
DCL Commands in SQL and its execution  1,  BY IT SWAPNA.S.BHAVSAR
11:51
PESMCOE YouTubeChannel
Рет қаралды 15 М.
How I use SQL as a Data Analyst
15:30
Luke Barousse
Рет қаралды 819 М.
Box jumping challenge, who stepped on the trap? #FunnyFamily #PartyGames
00:31
Family Games Media
Рет қаралды 30 МЛН