17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
SQL Database Design A-Z Learn MS SQL Server PostgreSQL
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL Download
Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises
What you'll learn
Create basic SQL Queries Create advanced SQL Queries Create Left, Right, Inner and Full Outer joins Create new tables, alter existing tables in Databases Normalize Databases Understand database design Understand first, second and third normal form schemas
Requirements
A basic knowledge of computers
Description
Are you interested in a career in Data Science or Data Analytics?
In that case, inevitably you are going to encounter databases in your work.
But how do you interact with databases?
The answer is simple: SQL
SQL stands for Structured Query Language and this is one of the main tools used to organize databases, input data into them and extract it on request.
In this course you will learn how to create queries in a popular variation of SQL called PostgreSQL.
And even if at your workplace you are using a different variation (e.g. Oracle, SQL Server or MySQL), you will find that the skills you learn in this course are easily transferable.
But there are many SQL courses out there, so the question is:
What makes this course stand out?
The unique advantage of this course is that in addition to learning SQL you will also master the concepts of Database Design.
We will cover off topics such as:
- OLAP vs OLTP databases (Online Analytics Processing & Online Transaction Processing): you will understand exactly how and why the designs of these two types of Databases differ
- Normalization of Databases: we will show you the theory behind normalization AND together we will practice how to normalize a Database step-by-step
Why is that important?
Knowing how databases are designed is not a compulsory skill to have for a Data Scientist / Analyst. However, it's a HUGE added benefit.
These skills will allow you to better interact with databases and derive results and extract insights from your data faster.
This course is designed with the Data Scientists and Analysts in mind, so if you want to propel your Data Science career, then this course is for you!
We look forward to seeing you inside,
Kirill & Ilya
Who this course is for:
Anybody who wants to learn PostgreSQL Anybody who wants to better understand how databases work Anybody who wants to enhance their Data Science career
visit for more freetutorials
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/001 Intro Video.mp4
85.4 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/002 Welcome to this section This is what you wil learn.mp4
12 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/002 Working With Data quiz.html
5.4 KB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/003 Creating Tables in SQL quiz.html
5.7 KB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/003 Installation PostgreSQL PgAdmin 4 for Windows.mp4
26.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/004 Installation PostgreSQL PgAdmin 4 for MAC OS.mp4
8.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/005 Installation MS SQL Server MS SQL Server Management Studio SSMS for Windows.mp4
22.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/006 Welcome to this section This is what you will learn.mp4
13.2 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/007 The challenge Investigating Consumer Complaints.mp4
10.2 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/008 Upload Consumer Complaints.mp4
19.4 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/009 Getting To Know The PGADMIN.mp4
18.7 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/010 Upload COnsumer COmplaints MS SQL.mp4
26.5 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/011 Getting to know MS SQL SERVER.mp4
9.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/012 Welcome to this section This is what you wil learn.mp4
17.8 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/013 Theory Select Query.mp4
7.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/014 Time to write your first query in PostgreSQL.mp4
26.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/015 Adding a filter using WHERE in PostgreSQL.mp4
16.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/016 Logical conditions AND OR in PostgreSQL.mp4
21 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/017 Using wildcards and _ advanced tutorial.mp4
25.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/018 Comments in SQL.mp4
11.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/019 Getting to write your first query MS SQL.mp4
32.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/020 Where MS SQL.mp4
26.8 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/021 Logical conditions AND OR MS SQL.mp4
32.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/022 Using wildcards MS SQL.mp4
28.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/023 Comments in SQL MS SQL.mp4
12.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/024 Welcome to this section This is what you wil learn.mp4
23.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/025 The challenge Analyzing Console Games Sales.mp4
11.7 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/026 Uploading Console Games Dataset.mp4
11.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/027 Working with arithmetic data types.mp4
30.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/028 ORDER BY.mp4
22.5 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/029 WORKING WITH VARCHARS.mp4
11.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/030 WORKING WITH DATES.mp4
47.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/031 Implicit Data Conversion in SQL.mp4
16.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/032 WORKING WITH NULL.mp4
26.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/033 Uploading Console Games DATASET MS SQL.mp4
16.2 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/034 Working with arithmetic data types MS SQL.mp4
35.8 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/035 ORDER BY MS SQL.mp4
28.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/036 Working with VARCHAR MS SQL.mp4
12.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/037 Working with Dates MS SQL.mp4
23 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/038 Implicit DATA conversion MS SQL.mp4
8.4 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/039 Welcome to this section This is what you will learn.mp4
13 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/040 Structured vs Unstructured Data.mp4
13.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/041 Elements Of a Database.mp4
7.2 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/042 Relational Keys.mp4
10.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/043 Relational Database.mp4
6.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/044 Functional Dependency.mp4
10.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/045 Welcome to this section This is what you wil learn.mp4
23.2 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/046 Types of Joins.mp4
12.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/047 Duplicates in Joins.mp4
4.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/048 Joining on multiple fields.mp4
10.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/049 The challenge The Vets Clinic.mp4
8.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/050 Upload the data.mp4
21.5 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/051 Your First Left Outer Join.mp4
28.8 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/052 Joins Tips Tricks.mp4
25.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/053 Inner Join.mp4
34.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/054 Full Outer join.mp4
18.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/055 Joining on Multiple Fields Practice.mp4
32.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/056 Complex Joins.mp4
31.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/057 Cleaning up your Join.mp4
24.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/058 Cross Join advanced tutorial.mp4
32.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/059 Upload The Data - MS SQL.mp4
23.2 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/060 Your First Left Outer Join - MS SQL.mp4
26.8 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/061 Joins Tips Tricks - MS SQL.mp4
24.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/062 Inner Join - MS SQL.mp4
34.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/063 Full Outer Join - MS SQL.mp4
12.2 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/064 Joining on Multiple Fields Practice - MS SQL.mp4
30.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/065 Complex Joins - MS SQL.mp4
20.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/066 Cleaning Up Your Join - MS SQL.mp4
19.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/067 Cross Join advanced tutorial - MS SQL.mp4
26.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/068 Welcome to this section This is what you will learn.mp4
13.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/069 Create Database.mp4
8.8 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/070 Create Table.mp4
29 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/071 Insert Data.mp4
28.8 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/072 Alter Table.mp4
20.5 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/073 Drop Table.mp4
16 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/074 Create Database MS SQL.mp4
8.4 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/075 Create Table MS SQL.mp4
12.7 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/076 Insert Data MS SQL.mp4
17.7 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/077 ALTER TABLE MS SQL.mp4
14.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/078 DROP TABLE MS SQL.mp4
4.7 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/079 Welcome to this section This is what you wil learn.mp4
32.6 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/080 What is Database Normalization.mp4
13.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/081 Prime and non-prime attributes.mp4
22.4 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/082 First Normal Form 1NF.mp4
16.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/083 Second Normal Form 2NF.mp4
37.2 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/084 Third Normal Form 3NF.mp4
42.7 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/085 The challenge Online Clothing Store OLTP Database.mp4
23.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/086 Upload the data.mp4
12.4 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/087 Normalization 1NF Investigation.mp4
33 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/088 Normalization 2NF Investigation.mp4
71.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/089 Normalization 2NF Modification.mp4
41.7 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/090 Normalization 3NF Investigation.mp4
49.9 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/091 Normalization 3NF Modification.mp4
55.1 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/092 Upload The Data - MS SQL.mp4
12.3 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/093 Normalization 1NF Investigation - MS SQL.mp4
23.5 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/094 Normalization 2NF Investigation - MS SQL.mp4
44.7 MB
SQL_Database Design A-Z™ Learn MS SQL Server + PostgreSQL/095 Normalization 2NF Modification - MS SQL.mp4
