5 Types of Essential SQL Commands That Empower Your Data Analysis

[{"selector":"#anim-b2822809-fa32-4a65-978a-fc5647b632c3","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-16a32e80-4040-4e00-829b-b9ee29debad7","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-aeaf6607-97e2-49e3-951c-d29c23008d19","keyframes":{"transform":["translate3d(-138.0117%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0ef60518-146d-408a-b18b-96033bf9f3b0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9d6ffb5e-1d12-4801-9de4-1e06bc0f7b2a","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-700b0a4f-de2a-4c33-97f1-71d0136c9e37","keyframes":{"transform":["translate3d(-126.53061%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-203dac0f-b552-4ffd-8c28-7ce42a2b0abc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-243e7feb-9a60-4c6c-8d7a-e649da0be8d9","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-7a3c808a-89b7-419f-951c-78a8258a1558","keyframes":{"transform":["translate3d(-128.38428%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8f0adddc-c8c0-4445-bc6b-01537837aa3f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ae0e3f7b-e92c-4ae6-bb2c-01d1e3c12e48","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-67897467-b815-41e4-a54b-83617850a911","keyframes":{"transform":["translate3d(-128.01724%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6de23509-3dd4-4af4-a7e7-500ecd6d2aab","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-aaf0d36f-4f17-43ab-8179-57a65ce027c4","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-32f0adc6-eebc-4acf-b3ff-338b4b888c10","keyframes":{"transform":["translate3d(-132.82829%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5c7e71c5-f2e2-4dfe-bd54-818019a2c977","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fcd19ff4-5acb-4e48-b56e-6855e0de1641","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] 5 Types of Essential SQL Commands That Empower Your Data Analysis Data Query Language Data Control Language Data Manipulation Language Transaction Control Language Data Definition Language

Data Definition Language

[{"selector":"#anim-25524933-cf41-4329-a1c4-add9ccc91f5e","keyframes":{"transform":["translate3d(-115.82278%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-da0f38a6-dc00-402e-9525-923b86a803f9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-987150d0-3d8d-4722-a374-b89d7e9c98fa","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-86dfd912-0dc5-43f0-876a-be28dcb6d617","keyframes":{"transform":["translate3d(-116.77631%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1b4e8fb7-5558-4297-83f8-84f4f9ee9ae8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6cc5b75a-d330-4de2-9c9a-57f6e04d93cb","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] DDL commands create, modify, and delete database structures, but not data. Some DDL commands are: · CREATE · DROP · ALTER · TRUNCATE · RENAME

Data Query Language

[{"selector":"#anim-6716aafd-e96b-425c-8c25-1cb479a8eda9","keyframes":{"transform":["translate3d(-115.82278%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fb0c4688-1727-4e0f-a8d8-0c0413cd2349","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eeb0ca72-8f6d-4ce0-bf3d-2235c6ff658d","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-5a4fbae4-318d-49cc-b8ae-6329f98efac5","keyframes":{"transform":["translate3d(-116.44736%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-753674b2-037c-431a-b31d-f611a6ccc810","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c49980ef-d2b0-4d02-bd59-58f13544bd8b","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] There is only one DQL command, SELECT, and it is used to select data from a database based on the query passed to it.

Data Control Language

[{"selector":"#anim-d8069fc8-a0e0-4883-8ed4-c892f75d2432","keyframes":{"transform":["translate3d(-115.82278%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ab00645f-4393-47d4-8558-7955e056f660","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e738921a-b705-4f32-b942-c4eb3929a137","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-3457af47-821a-47e4-bf91-76b467669336","keyframes":{"transform":["translate3d(-116.66666%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7bc4daac-07d1-4aef-929a-ed433535e643","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-757b8e4d-d3f0-4f1e-b538-8c9bc9fdbded","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] DCL commands are used to deal with rights, permissions, and other controls in the database system. DCL statements are grouped with DML statements (see the next page) to give, remove, or reset specific manipulation privileges. The primary DCL commands are: · GRANT · DENY · REVOKE

Data Manipulation Language

[{"selector":"#anim-9b56d546-8448-456d-8f90-df672440dc35","keyframes":{"transform":["translate3d(-115.82278%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-516b9a7e-b5fe-452a-8c52-07eb67f84f73","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8d9a0765-4449-4fe7-892a-e77b765838b6","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-2cdf174d-b9e4-4e86-a69d-5fe52a3738dc","keyframes":{"transform":["translate3d(-116.44736%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b520e42f-7a0b-4b92-a31d-881c366beef1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-23746bcd-a665-4bd3-86b7-bd04d6b576ec","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] DML commands manipulate the data in a database. The major DML commands are: · INSERT · UPDATE · DELETE · SELECT

Transaction Control Language

[{"selector":"#anim-11089deb-594f-41e9-8d7b-1fde021b68d1","keyframes":{"transform":["translate3d(-115.82278%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6cf45d7d-9370-4695-9e02-fada14af2d4c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f497a48a-802d-4a2a-a2c5-72c3bf09f6c9","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-c424ed7e-0022-48ff-bce0-4daf4ce1e53a","keyframes":{"transform":["translate3d(-116.44736%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fb3c498b-08e9-4a7d-aadc-684b1182625e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f290c937-ec51-430d-89ba-8061e80696c7","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Transactions combine several tasks into a single unit of execution. The major TCL commands are: · COMMIT · ROLLBACK · SAVEPOINT

2X faster app development!

[{"selector":"#anim-d0c57ff6-23ac-4df4-9c57-2ebcd2661755","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.33},{"transform":"scale(0.95)","offset":0.66},{"transform":"scale(1)","offset":1}],"delay":1,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] Syncfusion offers over 1,800 components and frameworks for WinForms, WPF, ASP.NET (MVC, Core), UWP, WinUI, .NET MAUI, Xamarin, Flutter, Blazor, JavaScript, Angular, Vue, and React that make developers’ work easier. No credit card required.