Chapter 9

1. The term data source indicates a given method of accessing a database from a server. You can connect to a data source in PyCharm by adding it via the Database panel, downloading any missing driver files, and selecting an appropriate schema.
2. Within the Database panel, you can manage different data sources for a project (viewing, adding ,and/or removing), configure the underlying database system and driver files, examine the structure of a given database, and open the database console.
3. Structured Query Language, or SQL, is the most common tool developers and data engineers use to interact with databases, as well as being the standard language for relational database management systems. With SQL queries, you can retrieve data from and submit changes to a database table.
4. PyCharm allows us to write, edit, and run SQL commands within a console. In addition to being able to...