Udemy - SQL & Database Design A-Z™: Learn MS SQL Server + Postgre...

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 1.9 GB
  • Uploaded By CourseClub
  • Downloads 133
  • Last checked 1 hour ago
  • Date uploaded 21 hours ago
  • Seeders 25
  • Leechers 12

Infohash : D0506B46DC0D5432A306A4F941DA89D48E7ADB0B

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises

For More Courses Visit: https://desirecourse.net

Files:

[DesireCourse.Net] Udemy - SQL & Database Design A-Z™ Learn MS SQL Server + PostgreSQL 1. Introduction
  • 1. Intro Video.mp4 (25.2 MB)
  • 1. Intro Video.srt (3.1 KB)
  • 2. BONUS Learning Paths.html (2.4 KB)
  • 3. Some Additional Resources!!.html (0.3 KB)
10. Bonus Lectures
  • 1. YOUR SPECIAL BONUS.html (3.2 KB)
2. Installation
  • 1. Welcome to this section! This is what you wil learn.mp4 (3.3 MB)
  • 1. Welcome to this section! This is what you wil learn.srt (0.6 KB)
  • 2. Updates on Udemy Reviews.mp4 (52.4 MB)
  • 2. Updates on Udemy Reviews.srt (3.8 KB)
  • 3. BONUS Learning Paths.html (1.9 KB)
  • 4. Installation PostgreSQL & PgAdmin 4 for Windows.mp4 (21.9 MB)
  • 4. Installation PostgreSQL & PgAdmin 4 for Windows.srt (13.4 KB)
  • 5. Installation PostgreSQL & PgAdmin 4 for MAC OS.mp4 (6.8 MB)
  • 5. Installation PostgreSQL & PgAdmin 4 for MAC OS.srt (4.2 KB)
  • 6. Installation MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows.mp4 (22.3 MB)
  • 6. Installation MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows.srt (10.5 KB)
3. Preparation
  • 1. Welcome to this section! This is what you will learn.mp4 (4.0 MB)
  • 1. Welcome to this section! This is what you will learn.srt (0.5 KB)
  • 2. The challenge Investigating Consumer Complaints.mp4 (8.4 MB)
  • 2. The challenge Investigating Consumer Complaints.srt (4.0 KB)
  • 3. Upload Consumer Complaints.mp4 (0.2 KB)
  • 3. Upload Consumer Complaints.srt (8.6 KB)
  • 4. Getting To Know The PGADMIN.mp4 (15.4 MB)
  • 4. Getting To Know The PGADMIN.srt (10.7 KB)
  • 5. Upload COnsumer COmplaints MS SQL.mp4 (26.5 MB)
  • 5. Upload COnsumer COmplaints MS SQL.srt (14.6 KB)
  • 6. Getting to know MS SQL SERVER.mp4 (9.9 MB)
  • 6. Getting to know MS SQL SERVER.srt (6.5 KB)
4. Basics of SQL
  • 1. Welcome to this section! This is what you will learn.mp4 (4.8 MB)
  • 1. Welcome to this section! This is what you will learn.srt (0.6 KB)
  • 10. Logical conditions, AND OR MS SQL.mp4 (32.1 MB)
  • 10. Logical conditions, AND OR MS SQL.srt (13.9 KB)
  • 11. Using wildcards MS SQL.mp4 (28.1 MB)
  • 11. Using wildcards MS SQL.srt (12.5 KB)
  • 12. Comments in SQL MS SQL.mp4 (12.6 MB)
  • 12. Comments in SQL MS SQL.srt (6.4 KB)
  • 13. Basics of SQL quiz.html (0.1 KB)
  • 2. Theory Select Query.mp4 (6.7 MB)
  • 2. Theory Select Query.srt (5.0 KB)
  • 3. Time to write your first query in PostgreSQL.mp4 (20.5 MB)
  • 3. Time to write your first query in PostgreSQL.srt (9.8 KB)
  • 4. Adding a filter using WHERE in PostgreSQL.mp4 (13.3 MB)
  • 4. Adding a filter using WHERE in PostgreSQL.srt (8.0 KB)
  • 5. Logical conditions AND, OR in PostgreSQL.mp4 (17.1 MB)
  • 5. Logical conditions AND, OR in PostgreSQL.srt (10.0 KB)
  • 6. Using wildcards % and _ (advanced tutorial).mp4 (20.5 MB)
  • 6. Using wildcards % and _ (advanced tutorial).srt (12.6 KB)
  • 7. Comments in SQL.mp4 (9.0 MB)
  • 7. Comments in SQL.srt (6.2 KB)
  • 8. Getting to write your first query MS SQL.mp4 (32.1 MB)
  • 8. Getting to write your first query MS SQL.srt (16.0 KB)
  • 9. Where MS SQL.mp4 (26.8 MB)
  • 9. Where MS SQL.srt (12.8 KB)
5. Working With Data
  • 1. Welcome to this section! This is what you will learn.mp4 (6.6 MB)
  • 1. Welcome to this section! This is what you will learn.srt (1.0 KB)
  • 10. Uploading Console Games DATASET MS SQL.mp4 (16.2 MB)
  • 10. Uploading Console Games DATASET MS SQL.srt (7.6 KB)
  • 11. Working with arithmetic data types MS SQL.mp4 (35.8 MB)
  • 11. Working with arithmetic data types MS SQL.srt (14.1 KB)
  • 12. ORDER BY MS SQL.mp4 (28.1 MB)
  • 12. ORDER BY MS SQL.srt (9.6 KB)
  • 13. Working with VARCHAR MS SQL.mp4 (12.6 MB)
  • 13. Working with VARCHAR MS SQL.srt (6.1 KB)
  • 14. Working with Dates MS SQL.mp4 (23.0 MB)
  • 14. Working with Dates MS SQL.srt (13.6 KB)
  • 15. Implicit DATA conversion MS SQL.mp4 (8.4 MB)
  • 15. Implicit DATA conversion MS SQL.srt (4.8 KB)
  • 16. Working With Data quiz.html (0.1 KB)
  • 2. The challenge Analyzing Console Games Sales.mp4 (9.4 MB)
  • 2. The challenge Analyzing Console Games Sales.srt (4.8 KB)
  • 3. Uploading Console Games Dataset.mp4 (9.9 MB)
  • 3. Uploading Console Games Dataset.srt (5.5 KB)
  • 4. Working with arithmetic data types.mp4 (23.4 MB)
  • 4. Working with arithmetic data types.srt (13.3 KB)
  • 5. ORDER BY.mp4 (17.5 MB)
  • 5. ORDER BY.srt (8.0 KB)
  • 6. WORKING WITH VARCHARS.mp4 (9.1 MB)
  • 6. WORKING WITH VARCHARS.srt (5.1 KB)
  • 7. WORKING WITH DATES.mp4 (38.0 MB)
  • 7. WORKING WITH DATES.srt (20.8 KB)
  • 8. Implicit Data Conversion in SQL.mp4 (12.7 MB)
  • 8. Implicit Data Conversion in SQL.srt (7.4 KB)
  • 9. WORKING WITH NULL.mp4 (21.7 MB)
  • 9. WORKING WITH NULL.srt (13.3 KB)
6. Fundamentals of Database Theory
  • 1. Welcome to this section! This is what you will learn.mp4 (3.4 MB)
  • 1. Welcome to this section! This is what you will learn.srt (0.5 KB)
  • 2. Structured vs Unstructured Data.mp4 (10.6 MB)
  • 2. Structured vs Unstructured Data.srt (7.2 KB)
  • 3. Elements Of a Database.mp4 (5.8 MB)
  • 3. Elements Of a Database.srt (3.9 KB)
  • 4. Relational Keys.mp4 (9.4 MB)
  • 4. Relational Keys.srt (7.3 KB)
  • 5. Relational Database.mp4 (5.5 MB)
  • 5. Relational Database.srt (4.6 KB)
  • 6. Functional Dependency.mp4 (9.5 MB)
  • 6. Functional Dependency.srt (7.3 KB)
7. Joining tables in SQL
  • 1. Welcome to this section! This is what you wil learn.mp4 (7.2 MB)
  • 1. Welcome to this section! This is what you wil learn.srt (1.2 KB)
  • 10. Full Outer join.mp4 (15.2 MB)
  • 10. Full Outer join.srt (6.9 KB)
  • 11. Joining on Multiple Fields (Practice).mp4 (25.6 MB)
  • 11. Joining on Multiple Fields (Practice).srt (15.0 KB)
  • 12. Complex Joins.mp4 (24.2 MB)
  • 12. Complex Joins.srt (13.5 KB)
  • 13. Cleaning up your Join.mp4 (18.1 MB)
  • 13. Cleaning up your Join.srt (9.5 KB)
  • 14. Cross Join (advanced tutorial).mp4 (25.5 MB)
  • 14. Cross Join (advanced tutorial).srt (14.2 KB)
  • 15. Upload The Data - MS SQL.mp4 (23.2 MB)
  • 15. Upload The Data - MS SQL.srt (10.7 KB)
  • 16. Your First Left Outer Join - MS SQL.mp4 (26.8 MB)
  • 16. Your First Left Outer Join - MS SQL.srt (13.3 KB)
  • 17. Joins Tips & Tricks - MS SQL.mp4 (24.1 MB)
  • 17. Joins Tips & Tricks - MS SQL.srt (13.8 KB)
  • 18. Inner Join - MS SQL.mp4 (34.3 MB)
  • 18. Inner Join - MS SQL.srt (15.6 KB)
  • 19. Full Outer Join - MS SQL.mp4 (12.2 MB)
  • 19. Full Outer Join - MS SQL.srt (4.5 KB)
  • 2. Types of Joins.mp4 (11.0 MB)
  • 2. Types of Joins.srt (9.2 KB)
  • 20. Joining on Multiple Fields (Practice) - MS SQL.mp4 (30.9 MB)
  • 20. Joining on Multiple Fields (Practice) - MS SQL.srt (16.3 KB)
  • 21. Complex Joins - MS SQL.mp4 (20.9 MB)
  • 21. Complex Joins - MS SQL.srt (11.0 KB)
  • 22. Cleaning Up Your Join - MS SQL.mp4 (19.4 MB)
  • 22. Cleaning Up Your Join - MS SQL.srt (9.8 KB)
  • 23. Cross Join (advanced tutorial) - MS SQL.mp4 (26.3 MB)
  • 23. Cross Join (advanced tutorial) - MS SQL.srt (14.6 KB)
  • 3. Duplicates in Joins.mp4 (4.6 MB)
  • 3. Duplicates in Joins.srt (3.5 KB)
  • 4. Joining on multiple fields.mp4 (9.7 MB)
  • 4. Joining on multiple fields.srt (7.4 KB)
  • 5. The challenge The Vet's Clinic.mp4 (6.1 MB)
  • 5. The challenge The Vet's Clinic.srt (3.4 KB)
  • 6. Upload the data.mp4 (16.4 MB)
  • 6. Upload the data.srt (6.9 KB)
  • 7. Your First Left Outer Join.mp4 (23.1 MB)
  • 7. Your First Left Outer Join.srt (12.3 KB)
  • 8. Joins Tips & Tricks.mp4 (20.7 MB)
  • 8. Joins Tips & Tricks.srt (12.7 KB)
  • 9. Inner Join.mp4 (28.0 MB)
  • 9. Inner Join.srt (15.2 KB)
8. Creating Tables in SQL
  • 1. Welcome to this section! This is what you will learn.mp4 (3.9 MB)
  • 1. Welcome to this section! This is what you will learn.srt (0.5 KB)
  • 10. ALTER TABLE MS SQL.mp4 (14.6 MB)
  • 10. ALTER TABLE MS SQL.srt (8.3 KB)
  • 11. DROP TABLE MS SQL.mp4 (4.7 MB)
  • 11. DROP TABLE MS SQL.srt (3.3 KB)
  • 12. Creating Tables in SQL quiz.html (0.1 KB)
  • 2. Create Database.mp4 (7.5 MB)
  • 2. Create Database.srt (6.2 KB)
  • 3. Create Table.mp4 (24.7 MB)
  • 3. Create Table.srt (19.8 KB)
  • 4. Insert Data.mp4 (24.9 MB)
  • 4. Insert Data.srt (17.8 KB)
  • 5. Alter Table.mp4 (17.5 MB)
  • 5. Alter Table.srt (12.1 KB)
  • 6. Drop Table.mp4 (13.7 MB)
  • 6. Drop Table.srt (10.3 KB)
  • 7. Create Database MS SQL.mp4 (8.4 MB)
  • 7. Create Database MS SQL.srt (4.4 KB)
  • 8. Create Table MS SQL.mp4 (12.7 MB)
  • 8. Create Table MS SQL.srt (9.1 KB)
  • 9. Insert Data MS SQL.mp4 (17.7 MB)
  • 9. Insert Data MS SQL.srt (9.9 KB)
9. Database Design
  • 1. Welcome to this section! This is what you wil learn.mp4 (10.0 MB)
  • 1. Welcome to this section! This is what you wil learn.srt (1.5 KB)
  • 10. Normalization 2NF Investigation.mp4 (55.2 MB)
  • 10. Normalization 2NF Investigation.srt (21.8 KB)
  • 11. Normalization 2NF Modification.mp4 (31.9 MB)
  • 11. Normalization 2NF Modification.srt (15.8 KB)
  • 12. Normalization 3NF Investigation.mp4 (39.2 MB)
  • 12. Normalization 3NF Investigation.srt (23.7 KB)
  • 13. Normalization 3NF Modification.mp4 (43.9 MB)
  • 13. Normalization 3NF Modification.srt (23.8 KB)
  • 14. Upload The Data - MS SQL.mp4 (12.3 MB)
  • 14. Upload The Data - MS SQL.srt (5.8 KB)
  • 15. Normalization 1NF Investigation - MS SQL.mp4 (23.5 MB)
  • 15. Normalization 1NF Investigation - MS SQL.srt (9.2 KB)
  • 16. Normalization 2NF Investigation - MS SQL.mp4 (44.7 MB)
  • 16. Normalization 2NF Investigation - MS SQL.srt (21.3 KB)
  • 17. Normalization 2NF Modification - MS SQL.mp4 (45.4 MB)
  • 17. Normalization 2NF Modification - MS SQL.srt (21.9 KB)
  • 18. Normalization 3NF Investigation - MS SQL.mp4 (41.5 MB)
  • 18. Normalization 3NF Investigation - MS SQL.srt (23.5 KB)
  • 19. Normalization 3NF Modification - MS SQL.mp4 (47.3 MB)
  • 19. Normalization 3NF Modification - MS SQL.srt (25.9 KB)
  • 2. MS SQL Server What is Database Normalization.mp4 (12.3 MB)
  • 2. MS SQL Server What is Database Normalization.srt (10.9 KB)
  • 20. THANK YOU bonus video.mp4 (52.2 MB)
  • 20. THANK YOU bonus video.srt (2.3 KB)
  • 3. Prime and non-prime attributes.mp4 (19.0 MB)
  • 3. Prime and non-prime attributes.srt (14.0 KB)
  • 4. First Normal Form (1NF).mp4 (14.3 MB)
  • 4. First Normal Form (1NF).srt (11.9 KB)
  • 5. Second Normal Form (2NF).mp4 (31.4 MB)
  • 5. Second Normal Form (2NF).srt (22.7 KB)
  • 6. Third Normal Form (3NF).mp4 (36.6 MB)
  • 6. Third Normal Form (3NF).srt (25.9 KB)
  • 7. The challenge Online Clothing Store (OLTP Database).mp4 (18.9 MB)
  • 7. The challenge Online Clothing Store (OLTP Database).srt (6.1 KB)
  • 8. Upload the data.mp4 (10.1 MB)
  • 8. Upload the data.srt (4.5 KB)
  • 9. Normalization 1NF Investigation.mp4 (26.2 MB)
  • 9. Normalization 1NF Investigation.srt (10.3 KB)
  • [CourseClub.Me].url (0.0 KB)
  • [DesireCourse.Net].url (0.0 KB)

There are currently no comments. Feel free to leave one :)

Code:

  • http://0d.kebhana.mx:443/announce
  • udp://tw.opentracker.ga:36920/announce
  • udp://temp1.opentracker.gq:6969/announce
  • udp://temp2.opentracker.gq:6969/announce
  • udp://tracker.torrent.eu.org:451/announce
  • http://torrent.nwps.ws:80/announce
  • udp://explodie.org:6969/announce
  • https://opentracker.xyz:443/announce
  • https://t.quic.ws:443/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://tracker.zer0day.to:1337/announce
  • udp://eddie4.nl:6969/announce
  • udp://open.demonii.si:1337/announce
/08/e7/ff/08e7ffd6a1ad8052c7c702273b643766.js'>