DEV Community

Linh Truong Cong Hong
Linh Truong Cong Hong

Posted on

Basic SQL Programming

MySQL Database Programming
Interacting with Relational Database Management Systems (RDBMSs) is a necessary skill for everyone who want to learn about web development, software development, data analysis...

To make it easier for entry-level developers to get familiar with SQL language in general and MySQL in particular, I prepared a brief summary of knowledge related to MySQL database programming at:

https://github.com/linhtch90/learn-MySQL-database-programming

This summary includes 10 main sections covering topics:

  1. Introduction to Relational Database Management Systems (RDMS)
  2. Understanding Data Types
  3. Indexing and Data Integrity
  4. Querying a Single Table
  5. Querying Multiple Tables
  6. Modifying Data and Table Structures
  7. Transactions
  8. Grouping and Summarizing Data
  9. Advanced Querying Techniques
  10. Programmable Objects

I hope this could be a good reference material to build up a solid background for anyone who want to start learning database programming.

If you think this material is useful, please give it a Github star for my effort.

Top comments (0)