PAC | The Complete Python And PostgreSQL Developer Course (2019 EN)

Discussion in 'Programming' started by Kanka, Jul 12, 2019.

  1. Kanka

    Kanka Well-Known Member Loyal User

    Messages:
    16,086
    Likes Received:
    446
    Trophy Points:
    83
    [​IMG]

    Company: Packt Publishing
    Author: Rob Percival, Jose Salvatierra
    Full Title: The Complete Python And PostgreSQL Developer Course
    Year: 2019
    Language: English
    Genre: Educational: Web Development
    Skill Level: -
    Price: €112.99
    -
    Files: MP4
    Time: 21:32:50
    Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 750 kbps
    Audio: AAC at 124 Kbps, 2 channels, 48.0 KHz



    Build 9 projects and master two essential and modern technologies: Python and PostgreSQL.

    This course will take you on a journey where you will learn and understand software and programming with Python from beginning to end. This course will take you from an absolute Python and PostgreSQL beginner to an experienced software developer. Python and SQL are used by many technology companies, small and large. That's because they are powerful, yet extremely flexible. Python is used in the industry for purposes such as embedded software, web development, desktop applications, and even mobile apps. PostgreSQL allows your applications to become even more powerful by storing, retrieving, and filtering large data sets easily.

    Style and Approach:
    This course adopts a practical approach whereby you'll learn about the core concepts of Angular and Laravel by building a real-world web application.


    Learn:
    ✓ Understand software and programming with Python from beginning to end
    ✓ Create Python applications ranging from beginner-level, basic applications to advanced, useful, and engaging applications
    ✓ Learn how to extend Python applications by using professional data storage: PostgreSQL
    ✓ Understand advanced concepts, such as data structures and algorithms, that are extremely useful in jobs and interviews

    Features:
    ✓ Learn to build projects in Python and PostgreSQL
    ✓ Learn to extend Python applications by using professional data storage: PostgreSQL.


    Lessons:
    1. Installing Python
    01. Introduction
    02. Installing Python on Windows
    03. Installing Python on Mac
    2. Python 101
    04. The Python interactive shell (IDLE)
    05. Numbers and Strings in Python
    06. Variables in Python
    07. The str() method to convert to Strings
    08. Running a Python file from the IDLE
    09. Getting user input in Python
    10. The int() method to convert to Integers
    11. The format() method to simplify String formatting
    3. Magic Numbers in Python
    12. Lists in Python
    13. The for loop in Python
    14. Boolean expressions, True and False
    15. If statements in Python
    16. The 'in' keyword to check whether a list contains an element
    17. Giving the user multiple chances in our program
    18. Generating random integers in Python
    19. Defining our own methods in Python
    20. Returning values from our methods in Python
    4. A Lottery app
    21. The String split() method
    22. List comprehension in Python
    23. Python Sets - what is a Set?
    24. Set comprehension in Python
    25. Creating our lottery numbers
    26. Calculating the lottery winnings
    5. More complex applications: a student registration system
    27. Installing PyCharm, a professional Python tool
    28. Setting up PyCharm on Mac
    29. Setting up PyCharm on Windows
    30. Dictionaries in Python
    31. Advanced Dictionary usage in Python
    32. Methods returning dictionaries
    33. Appending to a list in Python
    34. Adding marks to our student data structure
    35. The sum() method in Python
    36. Iterating over a dictionary's keys and values
    37. Creating the application menu
    6. Object-Oriented Programming: a movie rental system
    38. What are classes Classes in Python
    39. The Movie Class
    40. The User Class (and the __repr__ method)
    41. The filter() method in Python
    42. More Movie operations and methods
    43. Writing to a file in Python
    44. Saving CSV files with our data
    45. Loading our data from CSV files
    46. Saving JSON files with our data
    47. Loading our data from JSON files
    48. Argument unpacking in Python (the two asterisks)
    49. Creating the menu for our application
    7. Introduction to PostgreSQL
    50. Introduction to databases
    51. Installing PostgreSQL on Windows
    52. Using PostgreSQL on Windows
    53. Executing SQL queries on Windows
    54. Installing PostgreSQL on Mac
    55. Using PostgreSQL on Mac
    56. Executing SQL commands on Mac
    57. Using the sample data provided
    58. SQL: The SELECT command
    59. SQL: filtering with WHERE
    60. SQL: LIMIT for limiting the number of results
    61. SQL: UPDATE data in a table
    62. SQL: DELETE data from a table
    63. SQL: Wildcards for filtering unknowns
    64. What is a JOIN?
    65. SQL: JOINs and JOIN examples
    66. SQL: GROUP BY for aggregation of data
    67. SQL: ORDER BY for sorting data
    68. SQL: CREATE TABLE
    69. SQL: INSERT INTO for adding data to a table
    70. SQL: SEQUENCE for auto-incrementing fields
    71. SQL: CREATE INDEX and advanced information about indexes
    72. SQL: DROP TABLE for deleting tables and data
    8. Advanced PostgreSQL
    73. SQL: VIEWs and what they are used for.mp4
    74. SQL: built-in functions and the HAVING construct
    75. Dates in SQL: an old problem
    76. Other data types in SQL (including JSON in PostgreSQL)
    77. Nested SELECT statements for complex queries
    78. The PostgreSQL SERIAL type
    9. Python and PostgreSQL
    79. Installing psycopg2 on Windows (2018 update)
    80. Installing psycopg2 on Windows (older versions)
    81. Installing psycopg2 on Mac
    82. Verifying everything works—don't proceed if it doesn't!
    83. Mac OS X: Fixing psycopg2 'library not loaded' error
    84. What is a virtual environment?
    85. psycopg2 on a virtualenv on Windows (2018 update)
    86. Psycopg2 on a virtualenv on Windows (older versions)
    87. Setting up the app structure, pip, and requirements.txt
    88. Recap on classes and object-oriented programming
    89. Saving to database from Python
    90. Loading from the database from Python
    91. Removing some duplicate code from our app
    92. Connection pooling and why it is important
    93. Creating the ConnectionPool class
    94. Creating the ConnectionFromPool class
    95. Obtaining a cursor from the ConnectionFromPool class
    96. The Database class and selective initialisation
    97. Cleaning up the Database class
    98. End of section review
    10. Python Web and APIs
    099. What is an API??
    100. Making requests in Python
    101. What is OAuth?
    102. Creating a Twitter app
    103. Setting up Twitter login
    104. Getting the OAuth request token
    105. More on the Python debugger—an essential tool
    106. Getting authorization by the user
    107. Getting the OAuth access token
    108. Performing Twitter requests: getting images
    109. Reusing code from the last section to save users
    110. Creating users in our app
    111. Retrieving users in our app
    112. Cleaning up the code—extremely important!
    113. Introduction to Flask and Python Web Development
    114. Adding a Twitter login endpoint
    115. Creating the user profile
    116. The Flask before_request decorator
    117. Checking if a user is already logged in
    118. Searching tweets and displaying them
    119. Searching for different things
    120. What is Bootstrap?
    121. Writing our own CSS
    122. Allowing users to perform custom searches
    123. Adding sentiment analysis with another API
    11. Introduction to Git and GitHub
    124. What is Git?
    125. Installing Git on Mac and Windows
    126. Introduction to the UNIX terminal
    127. The VIM text editor, a powerful terminal editor
    128. Dealing with files in the UNIX terminal
    129. What is a Git repository?
    130. git init — create a Git repository
    131. git add and git commit — staging and committing
    132. git log — viewing past commits
    133. Creating a repository on GitHub
    134. git remote — managing remote repositories
    135. Adding your SSH key to GitHub
    136. What is a README file? Introduction to Markdown
    137. git pull — pulling other's changes
    12. Advanced Python
    138. OOP Inheritance
    139. OOP: Multiple Inheritance in Python
    140. OOP: What is composition?
    141. OOP: What is encapsulation?
    142. Introduction to Exceptions in Python
    143. Creating our own Exceptions
    144. Some of the available built-in Exceptions
    145. Python built-in methods
    146. Assertions in Python
    147. Lambda expressions in Python
    148. More uses of lambda expressions
    149. Lambda expressions in the wild
    150. Introduction to unit testing with unittest
    13. Data Structures and Algorithms
    151. What are data structures?
    152. What is a Linked List?
    153. Introduction to Linked List Assignment
    154. Programming our own Linked List in Python
    155. Creating a Queue
    156. Introduction to Queue Assignment
    157. Programming our own Queue in Python
    158. Creating a Stack
    159. Introduction to Stack Assignment
    160. Programming our own Stack in Python
    161. Creating a Binary Tree
    162. Introduction to Binary Tree Assignment
    163. Programming our own Binary Tree in Python


    -------------