Plan Szkolenia
Introduction
- Overview of PostgreSQL features and architecture
- Python programming fundamentals
- Advantages of Python PostgreSQL
Getting Started
- Installing PostgreSQL
- Installing Python, Django or Flask
- Installing psycopg2
- Connecting to PostgreSQL with Python
Python and SQL Operations
- The basics of SQL language
- Database schema and tables
- Writing a Python query
- Creating tables
- Inserting data
- Manipulating data
- Using limit clause
- Joining tables
- Full-text search
- Working with SQLite
- Examples of Python applications
Advanced PostgreSQL with Python
- Table inheritance
- Nested transactions
- User-defined types
- VIEWS, HAVING, DISTINCT
- Working with dates and times
- Multi-version concurrency control (MVCC)
- Charts, graphs, and reports using matplotlib
Administration and Security
- PostgreSQL data safety
- Restricting access using whitelist
- Implementing replication
- Database migration
- Backup and restore
- Monitoring queries
- Performance tuning
- Preventing SQL injection attacks
Troubleshooting
Summary and Next Steps
Wymagania
- Experience with PostgreSQL
- Python programming experience
Audience
- Developers
- Administrators
Opinie uczestników (6)
Zadania do zrealizowania samodzielnie oraz późniejsze wspólne rozwiązywanie
Katarzyna Kopysc-Falenta - CapGemini
Szkolenie - Data Analysis with Python, Pandas, and Numpy
Przekazanie wiedzy praktycznej oraz doświadczeń trenera.
Rumel Mateusz - Pojazdy Szynowe PESA Bydgoszcz SA
Szkolenie - GUI Programming with Python and PyQt
Przetłumaczone przez sztuczną inteligencję
Examples/exercices perfectly adapted to our domain
Luc - CS Group
Szkolenie - Scaling Data Analysis with Python and Dask
Trener był bardzo dostępny, aby odpowiedzieć na wszystkie pytania, które zadałem
Caterina - Stamtech
Szkolenie - Developing APIs with Python and FastAPI
Przetłumaczone przez sztuczną inteligencję
It was a though course as we had to cover a lot in a short time frame. Our trainer knew a lot about the subject and delivered the content to address our requirements. It was lots of content to learn but our trainer was helpful and encouraging. He answered all our questions with good detail and we feel that we learned a lot. Exercises were well prepared and tasks were tailored accordingly to our needs. I enjoyed this course
Bozena Stansfield - New College Durham
Szkolenie - Build REST APIs with Python and Flask
As I was the only participant the training could be adapted to my needs.