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

Database design and manipulation

Let’s move on to the part you’ve probably been waiting for: the part where we get to build a database! We already created the schema, but at the moment, we don’t have any tables. Let’s fix that first!

Creating a table

Right-click the schema, database_fun, which we created earlier, and click New | Table, as shown in Figure 11.19.

Figure 11.19: Right-click on the schema indicated by the arrow, then click New | Table

Figure 11.19: Right-click on the schema indicated by the arrow, then click New | Table

You’ll get a new window, as shown in Figure 11.20.

Figure 11.20: New window

Figure 11.20: New window

I had to stretch mine out a little to see it all, as shown in the figure. The next few steps will build our table. I went ahead and typed the table name in the Name field at the top. You can see what’s going on here. As before, with the schema creation DDL, PyCharm is building a DDL script in the preview at the bottom of the window. Right now, we have a red squiggly...