Description
This program allows participants at the end of both Lessons to be able to use the Python programming language to operate databases, concurrency, and use protocols for data access.
Addressed to
- IT professionals from various disciplines who need to perform essential Linux administration tasks; These include installation, establishing network connectivity, physical storage management, and basic security administration
Duration
40 hours
Modalities
- Face-to-face
- Virtual live through digital platforms
- on site
Related Courses
- Programming with Python I
It includes
- 40 hours of training
- Trained instructors
- Participant manual in digital format
- Proof of participation
Temary
Lesson 1: Persistence and Databases
- Serialization (plain text and CSV)
- DBM Lessons
- Berkeley DB interface
- Python Database API (DBAPI) 2.0
- Using ETL
- Reading spreadsheet files
Lesson 2: Using Relational Databases
- Access to relational databases
- Extending Python DB-API
- Use of the Object Relational Mapper (ORM)
- Use of NoSQL databases
Lesson 3: Data exploration
- Advantages of using Python for data handling
- Jupyter Notebook
- pandas
- Data aggregation
- Plot with matplotlib
- Normalization, cleaning and ordering of data
Lesson 4: Execution Control
- Site and user customizations
- Termination functions
- dynamic execution and exec
- internal types
- Garbage Collection
Lesson 5: Threads and processes
- Threads in Python
- threading lesson
- lesson queue
- multiprocessing lesson
- concurrent.futures lesson
- Threaded program architecture
- process environment
- Running other programs
- mmap lesson
Lesson 6: Networks
- Network principles
- Berkeley socket interface
- Transport Layer Security (TLS, SSL)
Lesson 7: Asynchronous Alternatives
- Coroutine asynchronous architecture
- asyncio lesson
- lesson selectors
Lesson 8: Client Network Protocols Lessons
- email protocols
- HTTP client and URL
- Other Network Protocols
Lesson 9: Using HTTP
- WSGI
- Python Web Frameworks
- File recovery via FTP/SFTP, SSH/SCP and HTTPS
- Accessing data via APIs
- Structured file format: JSON and XML
- MIME and Email Headers
- Encoding binary data as ASCII
