Notes for 'Database and SQL for Data Science'

"Coursera"

Posted by XL on September 9, 2019

Notes

This posts records all my notes for the online course - Python for Database and SQL for Data Science - on Coursera.com.

New notes will be added on the top of the older ones.

Week 2

Week 1

  • DDL (Data Definition Language) statements:
    • Define, change, or drop data
  • DML (Data Manipulation Language) statements:
    • Read and modify data
  • 5 basic SQL commands
    • create
    • insert
    • select
    • update
    • delete
  • RDBMS
    • Relational databasded management system
  • SQL
    • Structured Query Language