100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
C170 WGU ALREADY PASSED $5.49   Add to cart
Quickly navigate to
Preview
  2.  
  3. C170 WGU
  4.  
  5. C170 WGU

Exam (elaborations)

C170 WGU ALREADY PASSED
 0 view  0 purchase
  • Course
  • C170 WGU
  • Institution
  • C170 WGU

DML - IUDS, CR insert, update, delete, select commit, rollback INSERT - add new rows UPDATE - modify data of existing rows DELETE - delete some/all records from database can be rolled back COMMIT - permanently saves ROLLBACK - undo changes SELECT - data retrieval WHERE - limits rows retur...

[Show more]

Preview 2 out of 5  pages

Document information

  • November 29, 2023
  • 5
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers

Subjects

  • c170 wgu already passed

Written for

  • C170 WGU
All documents for this subject (44)

Seller

avatar-seller
Jessypeace

Content preview

C170 WGU ALREADY PASSED
DML - ✔✔IUDS, CR



insert, update, delete, select

commit, rollback



INSERT - ✔✔add new rows



UPDATE - ✔✔modify data of existing rows



DELETE - ✔✔delete some/all records from database



can be rolled back



COMMIT - ✔✔permanently saves



ROLLBACK - ✔✔undo changes



SELECT - ✔✔data retrieval



WHERE - ✔✔limits rows returned



used before group by



ORDER BY - ✔✔OC



sorts columns

, GROUP BY - ✔✔GR



groups rows



BETWEEN - ✔✔within range



IS NULL - ✔✔value is null



LIKE - ✔✔value matches string pattern



IN - ✔✔checks value if it matches given value list



EXISTS - ✔✔checks if subquery returns any rows



COUNT - ✔✔tally amount of NON-NULL values



SUM - ✔✔total sum for specified attribute



HAVING - ✔✔filters the groups subject to some condition



used after group by



inner join - ✔✔only rows that meet criteria selected



outer join - ✔✔matching rows and unmatched values for one/both tables



natural join - ✔✔returns ALL rows with matching values



deletes duplicate columns

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Jessypeace. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $5.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

77254 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$5.49
  • (0)
  Add to cart