SQL

Sopheary Rin
Jan 28, 2024

--

What is Database?

  • Database is a collection of data stored in a format that can easily be accessed.
  • To manage the database we use a software called DBMS

In Operator:

Between Operator:

→ updated to

Order By

Inner Join

Aggregate function:

Group By: group data one or more Columns

Having: We use having to filter data after the group of the row

Complex Query:

Store Procedures:

--

--

Sopheary Rin
Sopheary Rin

No responses yet