FreeTutorials us the complete python postgresql developer course | FEAA81BD98FE376CD06EE0676C913F290DFF139F

FreeTutorials us the complete python postgresql developer course

Name	[FreeTutorials.us] the-complete-python-postgresql-developer-course	DOWNLOAD Copy Link
Total Size	3.8 GB
Total Files	212
Hash	FEAA81BD98FE376CD06EE0676C913F290DFF139F

/01 Installing Python/
001 Introduction.mp4	7.2 MB
002 Installing Python on Windows.mp4	7.1 MB
003 Installing Python on Mac.mp4	4.2 MB
/02 Python 101/
004 My private letter to you as you start learning programming.html	0.6 KB
005 The Live Chat for QA.html	1.2 KB
006 The Python interactive shell IDLE.mp4	7.1 MB
007 Numbers and Strings in Python.mp4	10.4 MB
008 Variables in Python.mp4	11.9 MB
009 The str method to convert to Strings.mp4	8.0 MB
010 Running a Python file from the IDLE.mp4	12.3 MB
011 Getting user input in Python.mp4	11.0 MB
012 The int method to convert to Integers.mp4	5.7 MB
013 The format method to simplify String formatting.mp4	15.5 MB
014 Age Program Code.html	0.8 KB
/.../004 My private letter to you as you start learning programming/
private-letter.pdf	47.8 KB
/.../014 Age Program Code/
section2-age-program.zip	0.6 KB
/quizzes/
001 Section 2 Final Quiz.html	14.1 KB
/03 Magic Numbers in Python/
015 Lists in Python.mp4	10.4 MB
016 The for loop in Python.mp4	7.3 MB
017 Boolean expressions True and False.mp4	11.5 MB
018 If statements in Python.mp4	9.9 MB
019 The in keyword to check whether a list contains an element.mp4	10.4 MB
020 Giving the user multiple chances in our program.mp4	20.4 MB
021 Generating random integers in Python.mp4	20.3 MB
022 Defining our own methods in Python.mp4	17.7 MB
023 Returning values from our methods in Python.mp4	13.0 MB
024 Magic Numbers Code.html	0.8 KB
/.../024 Magic Numbers Code/
section3-magic-numbers.zip	0.6 KB
/quizzes/
002 Section 3 Final Quiz.html	14.3 KB
/04 A Lottery app/
025 The String split method.mp4	7.8 MB
026 List comprehension in Python.mp4	13.8 MB
027 Python Sets what is a Set.mp4	15.4 MB
028 Set comprehension in Python.mp4	12.5 MB
029 Creating our lottery numbers.mp4	18.7 MB
030 Calculating the lottery winnings.mp4	16.6 MB
031 Lottery App Code.html	0.8 KB
/.../031 Lottery App Code/
section4-lottery.zip	0.8 KB
/quizzes/
003 Section 4 Final Quiz.html	5.7 KB
/05 More complex applications a student registration system/
032 Installing PyCharm a professional Python tool.mp4	11.4 MB
033 Setting up PyCharm on Mac.mp4	34.3 MB
034 Setting up PyCharm on Windows.mp4	14.6 MB
035 Dictionaries in Python.mp4	23.0 MB
036 Advanced Dictionary usage in Python.mp4	19.6 MB
037 Methods returning dictionaries.mp4	19.3 MB
038 Appending to a list in Python.mp4	14.7 MB
039 Adding marks to our student data structure.mp4	23.0 MB
040 The sum method in Python.mp4	22.2 MB
041 Iterating over a dictionarys keys and values.mp4	18.3 MB
042 Creating the application menu.mp4	44.8 MB
043 Student Registration System Code.html	0.7 KB
/.../043 Student Registration System Code/
section5-students.zip	1.7 KB
/quizzes/
004 Section 5 Final Quiz.html	12.6 KB
/06 Object-Oriented Programming a movie rental system/
044 What are classes Classes in Python.mp4	37.8 MB
045 The Movie Class.mp4	28.3 MB
046 The User Class and the __repr__ method.mp4	17.4 MB
047 The filter method in Python.mp4	25.1 MB
048 More Movie operations and methods.mp4	19.1 MB
049 Writing to a file in Python.mp4	11.7 MB
050 Saving CSV files with our data.mp4	27.6 MB
051 Loading our data from CSV files.mp4	37.5 MB
052 Saving JSON files with our data.mp4	19.8 MB
053 Loading our data from JSON files.mp4	25.2 MB
054 Argument unpacking in Python the two asterisks.mp4	17.1 MB
055 Creating the menu for our application.mp4	50.7 MB
056 Movie Rental System Code.html	0.7 KB
/.../056 Movie Rental System Code/
section6-movie-system.zip	9.0 KB
/quizzes/
005 Section 6 Final Quiz.html	12.0 KB
/07 Introduction to PostgreSQL/
057 Introduction to databases.mp4	25.1 MB
058 Installing PostgreSQL on Windows.mp4	12.1 MB
059 Using PostgreSQL on Windows.mp4	16.7 MB
060 Executing SQL queries on Windows.mp4	5.7 MB
061 Installing PostgreSQL on Mac.mp4	13.4 MB
062 Using PostgreSQL on Mac.mp4	19.3 MB
063 Executing SQL commands on Mac.mp4	4.0 MB
064 Using the sample data provided.mp4	8.9 MB
065 SQL The SELECT command.mp4	15.0 MB
066 SQL filtering with WHERE.mp4	8.9 MB
067 SQL LIMIT for limiting the number of results.mp4	4.2 MB
068 SQL UPDATE data in a table.mp4	11.3 MB
069 SQL DELETE data from a table.mp4	9.7 MB
070 SQL Wildcards for filtering unknowns.mp4	10.2 MB
071 What is a JOIN.mp4	27.3 MB
072 SQL JOINs and JOIN examples.mp4	20.0 MB
073 SQL GROUP BY for aggregation of data.mp4	18.8 MB
074 SQL ORDER BY for sorting data.mp4	10.3 MB
075 SQL CREATE TABLE.mp4	21.8 MB
076 SQL INSERT INTO for adding data to a table.mp4	18.9 MB
077 SQL SEQUENCE for auto-incrementing fields.mp4	13.3 MB
078 SQL CREATE INDEX and advanced information about indexes.mp4	22.1 MB
079 SQL DROP TABLE for deleting tables and data.mp4	12.2 MB
/.../064 Using the sample data provided/
sql-database.zip	2.6 KB
/quizzes/
006 Section 7 Final Quiz.html	12.4 KB
/08 Advanced PostgreSQL/
080 SQL VIEWs and what they are used for.mp4	38.4 MB
081 SQL built-in functions and the HAVING construct.mp4	22.8 MB
082 Dates in SQL an old problem.mp4	26.7 MB
083 Other data types in SQL including JSON in PostgreSQL.mp4	20.5 MB
084 Nested SELECT statements for complex queries.mp4	19.1 MB
085 The PostgreSQL SERIAL type.mp4	6.9 MB
/.../082 Dates in SQL an old problem/
important-sql-date-facts.pdf	75.7 KB
/quizzes/
007 Section 8 Final Quiz.html	11.1 KB
/09 Python and PostgreSQL/
086 Installing psycopg2 on Windows.mp4	42.0 MB
087 Installing psycopg2 on Mac.mp4	10.8 MB
088 Verifying everything worksdont proceed if it doesnt.mp4	8.0 MB
089 Mac OS X Fixing psycopg2 library not loaded error.mp4	12.6 MB
090 What is a virtual environment.mp4	84.9 MB
091 Psycopg2 on a virtualenv on Windows.mp4	17.4 MB
092 Setting up the app structure pip and requirements.txt.mp4	12.1 MB
093 Recap on classes and object-oriented programming.mp4	25.6 MB
094 Saving to database from Python.mp4	51.3 MB
095 Loading from the database from Python.mp4	48.2 MB
096 Removing some duplicate code from our app.mp4	15.9 MB
097 Connection pooling and why it is important.mp4	43.4 MB
098 Creating the ConnectionPool class.mp4	32.0 MB
099 Creating the ConnectionFromPool class.mp4	31.7 MB
100 Obtaining a cursor from the ConnectionFromPool class.mp4	27.5 MB
101 The Database class and selective initialisation.mp4	60.0 MB
102 Cleaning up the Database class.mp4	22.2 MB
103 End of section review.mp4	14.1 MB
104 Keep thinking Section 9.html	0.5 KB
/.../104 Keep thinking Section 9/
keep-thinking-document.pdf	42.9 KB
/quizzes/
008 Section 9 Final Quiz.html	6.4 KB
/10 Python Web and APIs/
105 What is an API.mp4	54.2 MB
106 Making requests in Python.mp4	31.0 MB
107 What is OAuth.mp4	18.1 MB
108 Creating a Twitter app.mp4	12.1 MB
109 Setting up Twitter login.mp4	15.9 MB
110 Getting the OAuth request token.mp4	49.2 MB
111 More on the Python debuggeran essential tool.mp4	20.3 MB
112 Getting authorization by the user.mp4	28.0 MB
113 Getting the OAuth access token.mp4	25.4 MB
114 Performing Twitter requests getting images.mp4	73.0 MB
115 Reusing code from the last section to save users.mp4	40.9 MB
116 Creating users in our app.mp4	34.3 MB
117 Retrieving users in our app.mp4	123.5 MB
118 Cleaning up the codeextremely important.mp4	82.6 MB
119 Introduction to Flask and Python Web Development.mp4	44.4 MB
120 Adding a Twitter login endpoint.mp4	33.1 MB
121 Adding Twitter authorization.mp4	83.3 MB
122 Creating the user profile.mp4	32.0 MB
123 The Flask before_request decorator.mp4	33.8 MB
124 Checking if a user is already logged in.mp4	11.6 MB
125 Searching tweets and displaying them.mp4	26.8 MB
126 Searching for different things.mp4	14.0 MB
127 What is Bootstrap.mp4	34.8 MB
128 Writing our own CSS.mp4	20.7 MB
129 Allowing users to perform custom searches.mp4	22.9 MB
130 Adding sentiment analysis with another API.mp4	50.6 MB
131 Section 10 Twitter Login code.html	0.7 KB
/.../131 Section 10 Twitter Login code/
section-10-twitter-login.zip	16.4 KB
/quizzes/
009 Section 10 Final Quiz.html	11.4 KB
/11 Introduction to Git and GitHub/
132 What is Git.mp4	16.9 MB
133 Installing Git on Mac and Windows.mp4	24.2 MB
134 Introduction to the UNIX terminal.mp4	15.6 MB
135 The VIM text editor a powerful terminal editor.mp4	11.4 MB
136 Dealing with files in the UNIX terminal.mp4	8.1 MB
137 What is a Git repository.mp4	14.2 MB
138 git init create a Git repository.mp4	8.3 MB
139 git add and git commit staging and committing.mp4	19.1 MB
140 git log viewing past commits.mp4	5.2 MB
141 Creating a repository on GitHub.mp4	8.1 MB
142 git remote managing remote repositories.mp4	7.4 MB
143 Adding your SSH key to GitHub.mp4	14.7 MB
144 What is a README file Introduction to Markdown.mp4	16.8 MB
145 git pull pulling others changes.mp4	6.6 MB
146 Keep thinking Section 11.html	0.5 KB
/.../146 Keep thinking Section 11/
keep-thinking-document.pdf	48.5 KB
/quizzes/
010 Section 11 Final Quiz.html	7.6 KB
/12 Advanced Python/
147 OOP Inheritance.mp4	38.6 MB
148 OOP Multiple Inheritance in Python.mp4	15.6 MB
149 OOP What is composition.mp4	12.7 MB
150 OOP What is encapsulation.mp4	52.5 MB
151 Introduction to Exceptions in Python.mp4	34.7 MB
152 Creating our own Exceptions.mp4	22.4 MB
153 Some of the available built-in Exceptions.mp4	20.3 MB
154 Python built-in methods.mp4	61.1 MB
155 Assertions in Python.mp4	19.8 MB
156 Lambda expressions in Python.mp4	21.2 MB
157 More uses of lambda expressions.mp4	26.7 MB
158 Lambda expressions in the wild.mp4	53.3 MB
159 Introduction to unit testing with unittest.mp4	65.3 MB
160 Section 12 Advanced Python code.html	0.9 KB
161 Keep thinking Section 12.html	0.5 KB
/.../161 Keep thinking Section 12/
keep-thinking-document.pdf	54.2 KB
/quizzes/
011 Section 12 Final Quiz.html	9.7 KB
/13 Data Structures and Algorithms/
162 What are data structures.mp4	14.4 MB
163 What is a Linked List.mp4	22.6 MB
164 Introduction to Linked List Assignment.mp4	31.9 MB
165 Assignment Linked List.html	2.8 KB
166 Programming our own Linked List in Python.mp4	26.5 MB
167 Creating a Queue.mp4	17.1 MB
168 Introduction to Queue Assignment.mp4	34.7 MB
169 Assignment Queue.html	3.5 KB
170 Programming our own Queue in Python.mp4	44.0 MB
171 Creating a Stack.mp4	10.1 MB
172 Introduction to Stack Assignment.mp4	18.9 MB
173 Assignment Stack.html	2.4 KB
174 Programming our own Stack in Python.mp4	23.6 MB
175 Creating a Binary Tree.mp4	20.3 MB
176 Introduction to Binary Tree Assignment.mp4	24.7 MB
177 Assignment Binary Tree.html	3.3 KB
178 Programming our own Binary Tree in Python.mp4	28.5 MB
/.../165 Assignment Linked List/
1-linked-list.zip	5.5 KB
/.../166 Programming our own Linked List in Python/
1-linked-list-solution.zip	6.9 KB
/.../169 Assignment Queue/
2-queue.zip	2.9 KB
/.../170 Programming our own Queue in Python/
2-queue-solution.zip	7.7 KB
/.../173 Assignment Stack/
3-stack.zip	2.7 KB
/.../174 Programming our own Stack in Python/
3-stack-solution.zip	7.4 KB
/.../177 Assignment Binary Tree/
4-binary-tree.zip	2.2 KB
/.../178 Programming our own Binary Tree in Python/
4-binary-tree-solution.zip	7.0 KB
/quizzes/
012 Section 13 Final Quiz.html	4.2 KB
/14 Conclusion/
179 Next steps.html	1.4 KB
180 Bonus lecture web development with Python.html	1.1 KB
Total files 212