Take this
course

Software Development / Programming Languages

Python Database and File and Directory Handling

Cover programming interfaces in Python, how to read the properties of files, manipulate paths in a portable way, and create temporary files.

Description

Python is a cross-platform, object-oriented programming language that supports writing database client applications. 


In this Python Database and  File and Directory Handling course, we will cover programming interfaces in Python and how to read the properties of files, manipulate paths in a portable way, and creating temporary files. You will also be introduced to a lot of concepts related to threads and concurrency, and will view a number of demos showcasing how some of the modules and methods work.

Full details

Curriculum

  • Database Access
    Introduction
    2:22
    Objects in RDBMS
    1:51
    Database APIs
    5:47
    Chapter 1 - 4: Supplemental Materials
    Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for our "Database Access" focus: *Chapter 1 - Database Access *Chapter 2 - Database Access - Connection to a Database *Chapter 3 - Database Access - Operation Table Demos *Chapter 4 - Database Access - Dictionaries
  • Database Access - Connection to a Database
    Connection and Cursor Objects
    2:39
    Forming Queries
    1:30
    Type Objects
    1:19
    Error Handling
    1:25
    Multithreading
    1:04
    Connecting to Databases
    1:01
  • Database Access - Operation Table Demos
    Checking the Connection Demo
    2:14
    Create a Table Demo
    1:46
    Operations on Tables
    0:51
    Insert Operation Demo
    1:47
    Basic Operations on Tables
    1:13
    Read Records from a Table Demo
    1:40
    Update Records to a Table Demo
    1:54
    Delete Operation Demo
    1:56
  • Database Access - Dictionaries
    Mapping Results into Dictionaries
    1:00
    Database API Extensions
    1:56
    DBM-Style Database Modules
    3:58
    Conclusion
    1:33
  • File and Directory Handling - File Handling
    Introduction
    1:12
    File Handling in Python
    3:29
    File Object Methods Demo
    3:15
    OS Object Methods
    1:14
    OS Object Methods Demo
    2:44
    Chapter 5 - 10: Supplemental Materials
    Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for our "File and Directory Handling" focus: *Chapter 5 - File and Directory Handling - File Handling *Chapter 6 - File and Directory Handling - Working Within Files *Chapter 7 - File and Directory Handling - Temporary Files *Chapter 8 - File and Directory Handling - Compression *Chapter 9 - File and Directory Handling - Paths *Chapter 10 - File and Directory Handling - Archiving
  • File and Directory Handling - Working Within Files
    Accessing Text Lines
    4:16
    File and Directory Operations
    1:27
    Pathlib Module Demo
    1:33
    Stat Module Demo
    1:30
    File and Directory Comparison
    1:30
    Filecmp Module Demo
    1:49
  • File and Directory Handling - Temporary Files
    Knowing File and Path Attributes
    1:06
    Temporary Files and Directories
    1:56
    Tempfile Module Demo
    1:25
  • File and Directory Handling - Compression
    Compression
    0:48
    Lzma Module Demo
    3:31
    Gzip Module Demo
    4:01
  • File and Directory Handling - Paths
    Filename Expansion
    0:51
    Pure Paths
    2:56
    Pure and Concrete Paths Demo
    1:12
    Common Manipulations
    1:18
  • File and Directory Handling - Archiving
    Archiving
    1:41
    ZIP Archives
    1:25
    Conclusion
    1:20
  • Threads and Concurrency in Python
    Introduction
    1:06
    Basic Concepts
    1:30
    Process with Time Interval Demo
    1:54
    Parent and Current Processes Demo
    2:15
    Threads
    2:03
    Concurrent Programming
    2:02
    Chapter 11 - 13: Supplemental MaterialsUntitled Lesson
    Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for our "Threads and Concurrency" focus: *Chapter 11 - Threads and Concurrency in Python *Chapter 12 - Threads and Concurrency - Multiprocessing *Chapter 13 - Threads and Concurrency - Threading
  • Threads and Concurrency - Multiprocessing
    Multiprocessing
    1:59
    Interprocess Communication
    2:04
    Queues Demo
    1:47
    Pipes Demo
    2:02
    Process Pools
    0:57
    Pool Demo
    1:58
    Shared Data and Synchronization
    1:52
    Synchronization Demo
    1:18
    Shared Memory Demo
    1:45
    Server Process Demo
    1:43
    Connections
    1:23
  • Threads and Concurrency - Threading
    Threading
    1:32
    Synchronizing Threads
    1:43
    Semaphore and Events
    1:53
    Conditions Variables and Thread Termination
    2:16
    Deadlocks Demo
    2:01
    Programming with Threads
    1:06
    Queues with Threads Demo
    1:51
    Coroutines and Microthreading Demo
    1:20
    Tips for Multiprocessing
    0:52
    Conclusion
    1:08

Skills

  • Database Management
  • Python

Similar Courses

More Courses by this Instructor