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

  • Python Database and File and Directory Handling: Download Supplemental Materials
    LearnSmart_Course Orientation
    1:54
    Chapter 2 - 5: 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 2 - Database Access *Chapter 3 - Database Access - Connection to a Database *Chapter 4 - Database Access - Operation Table Demos *Chapter 5 - Database Access - Dictionaries
    Chapter 6 - 11: 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 6 - File and Directory Handling - File Handling *Chapter 7 - File and Directory Handling - Working Within Files *Chapter 8 - File and Directory Handling - Temporary Files *Chapter 9 - File and Directory Handling - Compression *Chapter 10 - File and Directory Handling - Paths *Chapter 11 - File and Directory Handling - Archiving
    Chapter 12 - 14: 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 12 - Threads and Concurrency in Python *Chapter 13 - Threads and Concurrency - Multiprocessing *Chapter 14 - Threads and Concurrency - Threading
  • Database Access
    Introduction
    2:22
    Objects in RDBMS
    1:51
    Database APIs
    5:47
  • 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
  • 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
  • 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