FreeTutorials Us the complete sql bootcamp | 766473C23E0C3CFBD4E08C046FFEB71EC6407D0B

FreeTutorials Us the complete sql bootcamp

Name	[FreeTutorials.Us] the-complete-sql-bootcamp	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.7 GB
Total Files	108
Last Seen
Hash	766473C23E0C3CFBD4E08C046FFEB71EC6407D0B

/01 Course Introduction/
001 Introduction.mp4	11.5 MB
002 Course Curriculum Overview.mp4	16.9 MB
003 Overview of Databases.mp4	25.9 MB
004 Course FAQs.html	3.0 KB
005 Time to get your Computer Set-Up.html	5.7 KB
006 Setting Up with pgAdmin 4.mp4	45.0 MB
007 Installation Notes.html	1.2 KB
/.../004 Course FAQs/
PostgreSQL-Sample-Database.png	167.5 KB
SQLNotes.pdf	299.1 KB
/.../006 Setting Up with pgAdmin 4/
dvdrental.tar	659.8 KB
/02 PostGreSQL Installation Mac OS/
008 Mac OS X - Quick Note.html	1.0 KB
009 Mac OS Installation.mp4	18.7 MB
010 Mac Sample Database Download.html	2.1 KB
011 Mac Database Set-up.mp4	69.4 MB
012 Review of Set-up.html	1.5 KB
/.../009 Mac OS Installation/
dvdrental.zip	551.4 KB
/.../010 Mac Sample Database Download/
Database-Schema.png	195.4 KB
dvdrental.zip	551.4 KB
/03 PostGreSQL Installation Windows/
013 Windows - Quick Note.html	1.2 KB
014 Windows Installation.mp4	27.7 MB
015 Sample Database Download.html	1.2 KB
016 Windows Command Line Installation Lecture.mp4	98.6 MB
/.../014 Windows Installation/
Database-Schema.png	195.4 KB
dvdrental.zip	551.4 KB
/.../015 Sample Database Download/
Database-Schema.png	195.4 KB
dvdrental.zip	551.4 KB
/04 Databases and Tables/
017 Databases and Tables Overview.mp4	4.0 MB
018 Creating and Restoring a Database.mp4	29.2 MB
019 Overview of Challenges.mp4	6.3 MB
020 Challenge Restore a Database.mp4	1.6 MB
021 Restoring a Table Schema.mp4	32.4 MB
022 Challenge Restore a Table Schema.mp4	1.9 MB
023 Review of Section.html	1.0 KB
/05 SQL Statement Fundamentals/
024 SQL Cheat Sheet.html	0.7 KB
025 SQL Statement Fundamentals.mp4	2.3 MB
026 SELECT Statement.mp4	27.7 MB
027 Challenge SELECT task..mp4	5.1 MB
028 SELECT DISTINCT.mp4	24.7 MB
029 Challenge SELECT DISTINCT.mp4	4.2 MB
030 SELECT WHERE.mp4	45.5 MB
031 Challenge SELECT WHERE.mp4	10.5 MB
032 COUNT.mp4	17.1 MB
033 LIMIT.mp4	17.6 MB
034 ORDER BY.mp4	51.4 MB
035 Challenge ORDER BY.mp4	6.4 MB
036 BETWEEN.mp4	32.1 MB
037 IN.mp4	32.6 MB
038 LIKE.mp4	36.3 MB
039 General Challenge 1.mp4	18.0 MB
/.../024 SQL Cheat Sheet/
Screen-Shot-2016-04-17-at-12.22.49-PM.png	1.1 MB
/.../039 General Challenge 1/
general-challenge-1.pptx	54.4 KB
/06 GROUP BY Statements/
040 MIN MAX SUM and AVG.mp4	20.3 MB
041 GROUP BY.mp4	52.1 MB
042 ChallengeGROUP BY.mp4	29.0 MB
043 HAVING.mp4	35.2 MB
044 Quick Note.html	0.6 KB
045 ChallengeHAVING.mp4	7.7 MB
/07 Assessment Test 1/
046 Overview of Assessment Test 1.mp4	2.6 MB
047 Assessment Test 1.html	1.0 KB
048 Solutions to Assessment Test 1.html	1.0 KB
/08 JOINS/
049 Overview of JOINS.html	1.1 KB
050 AS Statement.mp4	14.8 MB
051 Overview of Inner Join.mp4	99.2 MB
052 Examples of Inner Joins.mp4	78.3 MB
053 Overview of Join types.mp4	29.0 MB
054 Example of Outer Joins.mp4	40.2 MB
055 Union.mp4	14.5 MB
056 Join Challenges.html	0.8 KB
/.../053 Overview of Join types/
JOINS-Overview-2.pptx	451.5 KB
/09 Advanced SQL Commands/
057 Overview of Advanced SQL Commands.html	1.3 KB
058 Timestamps and Extract.mp4	39.3 MB
059 Mathematical Functions.mp4	31.7 MB
060 String Function and Operators.mp4	55.1 MB
061 SubQuery.mp4	40.9 MB
062 Self-Join.mp4	39.5 MB
/10 Assessment Test 2/
063 Assessment Test 2 Overview.mp4	26.1 MB
064 Assessment Test 2.html	3.3 KB
065 Solutions to Assessment Test 2.html	2.0 KB
/.../063 Assessment Test 2 Overview/
exercises.tar	33.7 KB
exercises.zip	27.1 KB
/11 Creating Databases and Tables/
066 Overview of Section.mp4	7.5 MB
067 Data Types.mp4	17.7 MB
068 Primary Keys and Foreign Keys.mp4	21.7 MB
069 Resource for Create Table Code.html	1.8 KB
070 Note on Constraints.html	0.9 KB
071 Create Table.mp4	53.2 MB
072 Challenge Create Table.html	0.9 KB
073 Challenge Create Table - SOLUTION.mp4	13.6 MB
074 Insert.mp4	36.7 MB
075 Update.mp4	26.2 MB
076 Delete.mp4	11.4 MB
077 Alter Table.mp4	15.6 MB
078 Drop Table.mp4	12.3 MB
079 CHECK Constraint.mp4	23.7 MB
080 NOT NULL Constraint.mp4	14.1 MB
081 UNIQUE Constraint.mp4	11.9 MB
/12 Assessment Test 3/
082 Assessment Test 3.html	2.3 KB
083 Solutions to Assessment Test 3.html	1.6 KB
/13 Extra Views/
084 Views.mp4	27.3 MB
/14 Extra PostGreSQL with Python/
085 Overview of Python and PostgreSQL.html	1.3 KB
086 Psycopg2 Example Usage.mp4	29.4 MB
087 Psycopg2 Resources.html	0.7 KB
/.../085 Overview of Python and PostgreSQL/
Pgsql-with-Python.py	5.6 KB
/.../086 Psycopg2 Example Usage/
Pgsql-with-Python.py	5.6 KB
/.../087 Psycopg2 Resources/
Pgsql-with-Python.py	5.6 KB
/15 Bonus Offers/
088 Bonus Offers.html	1.6 KB
/
Freetutorials.us.url	0.1 KB
[FreeTutorials.us].txt	0.1 KB
Total files 108