Skip to main content
NMC Learning Management System (Moodle)
  • Library
  • Online Learning Orientation
  • College Syllabus
  • Online Tutoring
  • Class Cancellations
  • Student Services
    Academic & Career Advising Academic Success Coaching My Success Tutoring Center Writing & Reading Center
  • Help
    Student Knowledgebase Faculty Knowledgebase Keep Learning Keep Teaching Submit a Ticket
  • More
Close
Toggle search input
You are currently using guest access
Log in
NMC Learning Management System (Moodle)
Library Online Learning Orientation College Syllabus Online Tutoring Class Cancellations Student Services Collapse Expand
Academic & Career Advising Academic Success Coaching My Success Tutoring Center Writing & Reading Center
Help Collapse Expand
Student Knowledgebase Faculty Knowledgebase Keep Learning Keep Teaching Submit a Ticket
  1. Home
  2. NMC Community
  3. Teaching SOLUTIONS
  4. CIT178 Sample
  5. IT Specialist 201 Database Exam Information and Resources
  6. 4. Data Manipulation using DML

4. Data Manipulation using DML

4.1 Construct and analyze INSERT statements • INSERT INTO SELECT, INSERT INTO VALUES

4.2 Construct and analyze UPDATE statements • Update data in a single table

4.3 Construct and analyze DELETE statements • Delete data from a single table


    • Data Manipulation Language (DML) statements (Transact-SQL).pdfData Manipulation Language (DML) statements (Transact-SQL).pdf
    • How to_ Delete Rows From the Database _ Microsoft Docs.pdfHow to_ Delete Rows From the Database _ Microsoft Docs.pdf
◄ 3. Data Retrieval
5. Troubleshooting ►
Contact site support
You are currently using guest access (Log in)
Get the mobile app
Powered by Moodle

Copyright © Northwestern Michigan College (2025). All rights reserved.