UD441 | 892D8830CEA5FE0CC46AAF6E9453B46C32F98711

UD441

Name	UD441	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	2.4 GB
Total Files	104
Hash	892D8830CEA5FE0CC46AAF6E9453B46C32F98711

/01 Introduction/
001 Intro Video.mp4	89.6 MB
002 Some Additional Resources.html	1.2 KB
003 BONUS Learning Paths.html	2.7 KB
004 Get the materials.html	1.2 KB
005 Your Shortcut To Becoming A Better Data Scientist.html	4.9 KB
/02 Installation/
006 Welcome to this section This is what you wil learn.mp4	12.5 MB
007 Updates on Udemy Reviews.mp4	21.4 MB
008 Installation PostgreSQL PgAdmin 4 for Windows.mp4	27.6 MB
009 Installation PostgreSQL PgAdmin 4 for MAC OS.mp4	9.0 MB
010 Installation MS SQL Server MS SQL Server Management Studio (SSMS) for Windows.mp4	23.4 MB
/03 Preparation/
011 Welcome to this section This is what you will learn.mp4	13.8 MB
012 The challenge Investigating Consumer Complaints.mp4	10.7 MB
013 Upload Consumer Complaints.mp4	20.4 MB
014 Getting To Know The PGADMIN.mp4	19.6 MB
015 Upload COnsumer COmplaints MS SQL.mp4	27.8 MB
016 Getting to know MS SQL SERVER.mp4	10.4 MB
/04 Basics of SQL/
017 Welcome to this section This is what you will learn.mp4	18.6 MB
018 Theory Select Query.mp4	8.0 MB
019 Time to write your first query in PostgreSQL.mp4	28.2 MB
020 Adding a filter using WHERE in PostgreSQL.mp4	17.1 MB
021 Logical conditions AND OR in PostgreSQL.mp4	22.1 MB
022 Using wildcards and _ (advanced tutorial).mp4	26.3 MB
023 Comments in SQL.mp4	11.6 MB
024 Getting to write your first query MS SQL.mp4	33.7 MB
025 Where MS SQL.mp4	28.1 MB
026 Logical conditions AND OR MS SQL.mp4	33.6 MB
027 Using wildcards MS SQL.mp4	29.5 MB
028 Comments in SQL MS SQL.mp4	13.2 MB
/05 Working With Data/
029 Welcome to this section This is what you will learn.mp4	25.1 MB
030 The challenge Analyzing Console Games Sales.mp4	12.2 MB
031 Uploading Console Games Dataset.mp4	12.5 MB
032 Working with arithmetic data types.mp4	31.6 MB
033 ORDER BY.mp4	23.6 MB
034 WORKING WITH VARCHARS.mp4	11.8 MB
035 WORKING WITH DATES.mp4	49.9 MB
036 Implicit Data Conversion in SQL.mp4	16.9 MB
037 WORKING WITH NULL.mp4	27.3 MB
038 Uploading Console Games DATASET MS SQL.mp4	17.0 MB
039 Working with arithmetic data types MS SQL.mp4	37.6 MB
040 ORDER BY MS SQL.mp4	29.5 MB
041 Working with VARCHAR MS SQL.mp4	13.2 MB
042 Working with Dates MS SQL.mp4	24.1 MB
043 Implicit DATA conversion MS SQL.mp4	8.8 MB
/06 Fundamentals of Database Theory/
044 Welcome to this section This is what you will learn.mp4	13.6 MB
045 Structured vs Unstructured Data.mp4	14.0 MB
046 Elements Of a Database.mp4	7.5 MB
047 Relational Keys.mp4	11.4 MB
048 Relational Database.mp4	6.4 MB
049 Functional Dependency.mp4	11.1 MB
/07 Joining tables in SQL/
050 Welcome to this section This is what you wil learn.mp4	24.3 MB
051 Types of Joins.mp4	12.6 MB
052 Duplicates in Joins.mp4	5.2 MB
053 Joining on multiple fields.mp4	11.1 MB
054 The challenge The Vets Clinic.mp4	8.7 MB
055 Upload the data.mp4	22.6 MB
056 Your First Left Outer Join.mp4	30.2 MB
057 Joins Tips Tricks.mp4	26.9 MB
058 Inner Join.mp4	35.9 MB
059 Full Outer join.mp4	19.0 MB
060 Joining on Multiple Fields (Practice).mp4	33.9 MB
061 Complex Joins.mp4	32.8 MB
062 Cleaning up your Join.mp4	25.3 MB
063 Cross Join (advanced tutorial).mp4	33.6 MB
064 Upload The Data - MS SQL.mp4	24.3 MB
065 Your First Left Outer Join - MS SQL.mp4	28.1 MB
066 Joins Tips Tricks - MS SQL.mp4	25.2 MB
067 Inner Join - MS SQL.mp4	36.0 MB
068 Full Outer Join - MS SQL.mp4	12.8 MB
069 Joining on Multiple Fields (Practice) - MS SQL.mp4	32.4 MB
070 Complex Joins - MS SQL.mp4	21.9 MB
071 Cleaning Up Your Join - MS SQL.mp4	20.3 MB
072 Cross Join (advanced tutorial) - MS SQL.mp4	27.5 MB
/08 Creating Tables in SQL/
073 Welcome to this section This is what you will learn.mp4	14.3 MB
074 Create Database.mp4	9.3 MB
075 Create Table.mp4	30.4 MB
076 Insert Data.mp4	30.2 MB
077 Alter Table.mp4	21.5 MB
078 Drop Table.mp4	16.8 MB
079 Create Database MS SQL.mp4	8.8 MB
080 Create Table MS SQL.mp4	13.3 MB
081 Insert Data MS SQL.mp4	18.5 MB
082 ALTER TABLE MS SQL.mp4	15.3 MB
083 DROP TABLE MS SQL.mp4	4.9 MB
/09 Database Design/
084 Welcome to this section This is what you wil learn.mp4	34.1 MB
085 MS SQL Server What is Database Normalization.mp4	14.5 MB
086 Prime and non-prime attributes.mp4	23.5 MB
087 First Normal Form (1NF).mp4	17.1 MB
088 Second Normal Form (2NF).mp4	39.0 MB
089 Third Normal Form (3NF).mp4	44.8 MB
090 The challenge Online Clothing Store (OLTP Database).mp4	24.3 MB
091 Upload the data.mp4	13.0 MB
092 Normalization 1NF Investigation.mp4	34.6 MB
093 Normalization 2NF Investigation.mp4	75.4 MB
094 Normalization 2NF Modification.mp4	43.7 MB
095 Normalization 3NF Investigation.mp4	52.3 MB
096 Normalization 3NF Modification.mp4	57.8 MB
097 Upload The Data - MS SQL.mp4	12.9 MB
098 Normalization 1NF Investigation - MS SQL.mp4	24.7 MB
099 Normalization 2NF Investigation - MS SQL.mp4	46.9 MB
100 Normalization 2NF Modification - MS SQL.mp4	47.6 MB
101 Normalization 3NF Investigation - MS SQL.mp4	43.6 MB
102 Normalization 3NF Modification - MS SQL.mp4	49.6 MB
103 THANK YOU bonus video.mp4	54.8 MB
/10 Bonus Lectures/
104 YOUR SPECIAL BONUS.html	4.2 KB
Total files 104