Basic Operations

Section Introduction:

This section explains how to run basic operations that all beginners will need to learn and understand how to use when developing a database management system. The subsections: “Coding SQL Queries in Python”and “Important SQL Queries”, assume that the user will be using the sqlite driver to connect to the database and thus will be coding in the SQL language in the Pycharm software which is a Python environment. The subsections will discuss how to connect two languages, Python and SQL, into an effective code that will successfully create, modify and delete tables as necessary. The SQL code for the most common queries that work to create modify and delete the tables in the system are also discussed in the subsections.