Book Image

Hands-On Application Development with PyCharm - Second Edition

By : Bruce M. Van Horn II, Quan Nguyen
5 (1)
Book Image

Hands-On Application Development with PyCharm - Second Edition

5 (1)
By: Bruce M. Van Horn II, Quan Nguyen

Overview of this book

In the quest to develop robust, professional-grade software with Python and meet tight deadlines, it’s crucial to have the best tools at your disposal. In this second edition of Hands-on Application Development with PyCharm, you’ll learn tips and tricks to work at a speed and proficiency previously reserved only for elite developers. To achieve that, you’ll be introduced to PyCharm, the premiere professional integrated development environment for Python programmers among the myriad of IDEs available. Regardless of how Python is utilized, whether for general automation scripting, utility creation, web applications, data analytics, machine learning, or business applications, PyCharm offers tooling that simplifies complex tasks and streamlines common ones. In this book, you'll find everything you need to harness PyCharm's full potential and make the most of Pycharm's productivity shortcuts. The book comprehensively covers topics ranging from installation and customization to web development, database management, and data analysis pipeline development helping you become proficient in Python application development in diverse domains. By the end of this book, you’ll have discovered the remarkable capabilities of PyCharm and how you can achieve a new level of capability and productivity.
Table of Contents (24 chapters)
1
Part 1: The Basics of PyCharm
4
Part 2: Improving Your Productivity
9
Part 3: Web Development in PyCharm
15
Part 4: Data Science with PyCharm
19
Part 5: Plugins and Conclusion

Structured Query Language

E. F. Codd’s paper that defined relational algebra served as the basis for SQL. SQL is unlike any other coding language you will ever use because it is one of only a handful of languages that use a declarative paradigm. Most languages you use, including Python, use an imperative paradigm. In short, the language serves as a syntactical framework to give a computer instructions on what you want it to do. You are basically a micro-manager. You specify every input, every output and every step the program will take during the processing that happens to get the input to the output. You must be meticulous, as the computer will take you literally. If you leave out even a single detail, you are setting things up to malfunction.

Declarative programming, on the other hand, entails merely specifying the output you want from an implicit input. You have little to no control over the operations performed to derive the output from the input. Consider this SQL statement...