|  

PostgreSQL and MS SQL for Beginners
Size :3.9 GB
Peers : Seeders : 0      Leechers : 0
Added : 1 year ago » by tutsnode » in Other
Language : English
Last Updated :6 months ago
Info_Hash :80302B01126A5FB9F1F7E36D8F7D85E806DECC96

Torrent File Contents

PostgreSQL and MS SQL for Beginners
  [TutsNode.net] - 12 - Group By Commands/53 - GROUP BY in PostgreSQL.mp4
  -  104.66 MB

  TutsNode.net.txt
  -  63 Bytes

  [TutsNode.net] - 22 - Congratulations/110 - Bonus Lecture.html
  -  2.35 KB

  [TutsNode.net] - 2 - Course Resources/2 - Course resources.html
  -  416 Bytes

  [TutsNode.net] - 6 - Restore and Backup in PostgreSQL/32 - Debugging summary and Code for CSV files.html
  -  2.18 KB

  [TutsNode.net] - 3 - Setting up PostgreSQL and PGAdmin/5 - If pgAdmin is not opening.html
  -  1.55 KB

  [TGx]Downloaded from torrentgalaxy.buzz .txt
  -  585 Bytes

  .pad/0
  -  342.39 KB

  [TutsNode.net] - 17 - String Functions/91 - String Functions in MS SQL.mp4
  -  101.47 MB

  .pad/1
  -  546.23 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/28 - ALTER in MS SQL.mp4
  -  98.3 MB

  .pad/2
  -  716.26 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/27 - ALTER Part 2 in PostgreSQL.mp4
  -  92.05 MB

  .pad/3
  -  971.77 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/8 - CREATE in PostgreSQL.mp4
  -  91.13 MB

  .pad/4
  -  893.52 KB

  [TutsNode.net] - 19 - DateTime Functions/102 - DateTime Functions in MS SQL.mp4
  -  89.94 MB

  .pad/5
  -  65.68 KB

  [TutsNode.net] - 6 - Restore and Backup in PostgreSQL/29 - Restore and Backup.mp4
  -  81.45 MB

  .pad/6
  -  560.47 KB

  [TutsNode.net] - 21 - PATTERN STRING MATCHING/108 - Pattern matching in MS SQL.mp4
  -  74.42 MB

  .pad/7
  -  589.36 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/10 - INSERT in PostgreSQL.mp4
  -  73.07 MB

  .pad/8
  -  954.16 KB

  [TutsNode.net] - 9 - Selection commands Ordering/42 - ORDER BY in PostgreSQL.mp4
  -  72.87 MB

  .pad/9
  -  130.57 KB

  [TutsNode.net] - 8 - Selection commands Filtering/39 - LIKE in PostgreSQL.mp4
  -  72.67 MB

  .pad/10
  -  341.33 KB

  [TutsNode.net] - 3 - Setting up PostgreSQL and PGAdmin/4 - Installing PostgreSQL and pgAdmin in your PC.mp4
  -  71.49 MB

  .pad/11
  -  521.25 KB

  [TutsNode.net] - 14 - JOINS/60 - Concepts of Joining and Combining Data.mp4
  -  64.98 MB

  .pad/12
  -  17.61 KB

  [TutsNode.net] - 18 - Mathematical Functions/97 - Mathematical Functions in MS SQL Part 1.mp4
  -  63.45 MB

  .pad/13
  -  559.23 KB

  [TutsNode.net] - 20 - Data Type conversion/103 - Data Type conversion to string in PostgreSQL.mp4
  -  61.58 MB

  .pad/14
  -  431.52 KB

  [TutsNode.net] - 15 - Subqueries/79 - Subqueries in MS SQL.mp4
  -  56.31 MB

  .pad/15
  -  702.53 KB

  [TutsNode.net] - 6 - Restore and Backup in PostgreSQL/30 - Debugging restoration issues.mp4
  -  53.6 MB

  .pad/16
  -  406.87 KB

  [TutsNode.net] - 8 - Selection commands Filtering/40 - LIKE in MS SQL.mp4
  -  53.58 MB

  .pad/17
  -  432.59 KB

  [TutsNode.net] - 8 - Selection commands Filtering/37 - BETWEEN in PostgreSQL.mp4
  -  52.26 MB

  .pad/18
  -  754.13 KB

  [TutsNode.net] - 19 - DateTime Functions/101 - EXTRACT in PostgreSQL.mp4
  -  51.98 MB

  .pad/19
  -  22.55 KB

  [TutsNode.net] - 14 - JOINS/62 - Inner Join in PostgreSQL.mp4
  -  51.12 MB

  .pad/20
  -  903.35 KB

  [TutsNode.net] - 21 - PATTERN STRING MATCHING/106 - Advanced pattern matching Part 1 REGULAR EXPRESSIONS.mp4
  -  50.74 MB

  .pad/21
  -  268.05 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/20 - Logical Operators in PostgreSQL.mp4
  -  50.46 MB

  .pad/22
  -  557.14 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/26 - ALTER Part 1 in PostgreSQL.mp4
  -  47.18 MB

  .pad/23
  -  844.67 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/16 - SELECT DISTINCT in PostgreSQL.mp4
  -  46.2 MB

  .pad/24
  -  817.86 KB

  [TutsNode.net] - 4 - Installing MS SQL/7 - Debugging the installation process.mp4
  -  45.97 MB

  .pad/25
  -  27.77 KB

  [TutsNode.net] - 17 - String Functions/87 - TRIM LTRIM RTRIM in PostgreSQL.mp4
  -  45.62 MB

  .pad/26
  -  390.03 KB

  [TutsNode.net] - 7 - Restore and Backup in MS SQL/34 - Restore and Backup in MS SQL.mp4
  -  45.36 MB

  .pad/27
  -  657.86 KB

  [TutsNode.net] - 11 - Aggregate Commands/52 - Aggregate Functions in MS SQL.mp4
  -  44.71 MB

  .pad/28
  -  300.04 KB

  [TutsNode.net] - 11 - Aggregate Commands/48 - COUNT in PostgreSQL.mp4
  -  43.89 MB

  .pad/29
  -  111.66 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/12 - Import data from File in PostgreSQL.mp4
  -  42.03 MB

  .pad/30
  -  994.21 KB

  [TutsNode.net] - 12 - Group By Commands/54 - GROUP BY in MS SQL.mp4
  -  41.62 MB

  .pad/31
  -  387.55 KB

  [TutsNode.net] - 14 - JOINS/63 - Inner Join in MS SQL.mp4
  -  41.57 MB

  .pad/32
  -  436.11 KB

  [TutsNode.net] - 14 - JOINS/64 - Left Join in PostgreSQL.mp4
  -  40 MB

  .pad/33
  -  1023.56 KB

  [TutsNode.net] - 17 - String Functions/89 - SUBSTRING in PostgreSQL.mp4
  -  39.68 MB

  .pad/34
  -  328.69 KB

  [TutsNode.net] - 14 - JOINS/66 - Right Join in PostgreSQL.mp4
  -  38.95 MB

  .pad/35
  -  46.35 KB

  [TutsNode.net] - 12 - Group By Commands/55 - HAVING in PostgreSQL.mp4
  -  38.76 MB

  .pad/36
  -  245.6 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/21 - Logical Operators in MS SQL.mp4
  -  38.43 MB

  .pad/37
  -  580 KB

  [TutsNode.net] - 6 - Restore and Backup in PostgreSQL/31 - Creating DB using CSV files.mp4
  -  38.39 MB

  .pad/38
  -  624.87 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/22 - UPDATE in PostgreSQL.mp4
  -  38.23 MB

  .pad/39
  -  792.06 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/11 - INSERT in MS SQL.mp4
  -  38.13 MB

  .pad/40
  -  886.41 KB

  [TutsNode.net] - 16 - Views and Indexes/80 - VIEWS in PostgreSQL.mp4
  -  37.03 MB

  .pad/41
  -  989.21 KB

  [TutsNode.net] - 16 - Views and Indexes/82 - INDEX in PostgreSQL.mp4
  -  36.77 MB

  .pad/42
  -  232.22 KB

  [TutsNode.net] - 21 - PATTERN STRING MATCHING/105 - PATTERN MATCHING BASICS.mp4
  -  36.76 MB

  .pad/43
  -  244.31 KB

  [TutsNode.net] - 18 - Mathematical Functions/98 - Mathematical Functions in MS SQL Part 2.mp4
  -  35.46 MB

  .pad/44
  -  555.52 KB

  [TutsNode.net] - 15 - Subqueries/77 - Subqueries Subquery in FROM clause in PostgreSQL.mp4
  -  35.26 MB

  .pad/45
  -  759.36 KB

  [TutsNode.net] - 13 - Conditional Statement/57 - CASE WHEN in PostgreSQL.mp4
  -  35.06 MB

  .pad/46
  -  966.21 KB

  [TutsNode.net] - 4 - Installing MS SQL/6 - Installing and Setting up MS SQL.mp4
  -  34.73 MB

  .pad/47
  -  280.53 KB

  [TutsNode.net] - 8 - Selection commands Filtering/38 - BETWEEN in MS SQL.mp4
  -  34.61 MB

  .pad/48
  -  397.37 KB

  [TutsNode.net] - 14 - JOINS/68 - Full Outer Join in PostgreSQL.mp4
  -  34.26 MB

  .pad/49
  -  760.6 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/18 - WHERE in PostgreSQL.mp4
  -  32.55 MB

  .pad/50
  -  462.65 KB

  [TutsNode.net] - 11 - Aggregate Commands/51 - MIN & MAX in PostgreSQL.mp4
  -  32.25 MB

  .pad/51
  -  771.6 KB

  [TutsNode.net] - 21 - PATTERN STRING MATCHING/107 - Advanced pattern matching Part 2 REGULAR EXPRESSIONS.mp4
  -  32.21 MB

  .pad/52
  -  810.12 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/14 - SELECT statement in PostgreSQL.mp4
  -  31.85 MB

  .pad/53
  -  155.54 KB

  [TutsNode.net] - 17 - String Functions/90 - LIST AGGREGATION in PostgreSQL.mp4
  -  30.77 MB

  .pad/54
  -  231.04 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/24 - DELETE in PostgreSQL.mp4
  -  30 MB

  .pad/55
  -  1.37 KB

  [TutsNode.net] - 14 - JOINS/75 - Intersect Except & Union in MS SQL.mp4
  -  29.87 MB

  .pad/56
  -  135.06 KB

  [TutsNode.net] - 16 - Views and Indexes/83 - INDEX in MS SQL.mp4
  -  29.66 MB

  .pad/57
  -  345.39 KB

  [TutsNode.net] - 8 - Selection commands Filtering/35 - IN in PostgreSQL.mp4
  -  29.65 MB

  .pad/58
  -  363.41 KB

  [TutsNode.net] - 16 - Views and Indexes/81 - VIEWS in MS SQL.mp4
  -  29.55 MB

  .pad/59
  -  457.19 KB

  [TutsNode.net] - 15 - Subqueries/78 - Subqueries Subquery in SELECT in PostgreSQL.mp4
  -  29.42 MB

  .pad/60
  -  591.42 KB

  [TutsNode.net] - 9 - Selection commands Ordering/44 - LIMIT in PostgreSQL.mp4
  -  29.3 MB

  .pad/61
  -  712.45 KB

  [TutsNode.net] - 20 - Data Type conversion/104 - Data Type conversion to Number and Date in PostgreSQL.mp4
  -  28.88 MB

  .pad/62
  -  125.24 KB

  [TutsNode.net] - 19 - DateTime Functions/99 - CURRENT DATE & TIME in PostgreSQL.mp4
  -  28.55 MB

  .pad/63
  -  465.6 KB

  [TutsNode.net] - 14 - JOINS/69 - Full Outer Join in MS SQL.mp4
  -  28.17 MB

  .pad/64
  -  851.72 KB

  [TutsNode.net] - 10 - Aliases/46 - AS in PostgreSQL.mp4
  -  27.35 MB

  .pad/65
  -  667.88 KB

  [TutsNode.net] - 14 - JOINS/72 - Intersect and Intersect ALL in PostgreSQL.mp4
  -  26.52 MB

  .pad/66
  -  495.01 KB

  [TutsNode.net] - 15 - Subqueries/76 - Subqueries Subquery in WHERE clause in PostgreSQL.mp4
  -  26.09 MB

  .pad/67
  -  931.43 KB

  [TutsNode.net] - 11 - Aggregate Commands/49 - SUM in PostgreSQL.mp4
  -  26.08 MB

  .pad/68
  -  938.92 KB

  [TutsNode.net] - 9 - Selection commands Ordering/43 - ORDER BY in MS SQL.mp4
  -  24.97 MB

  .pad/69
  -  28.69 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/25 - DELETE in MS SQL.mp4
  -  24.38 MB

  .pad/70
  -  633.78 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/23 - UPDATE in MS SQL.mp4
  -  24.28 MB

  .pad/71
  -  737.75 KB

  [TutsNode.net] - 18 - Mathematical Functions/93 - RANDOM in PostgreSQL.mp4
  -  24.28 MB

  .pad/72
  -  741.29 KB

  [TutsNode.net] - 17 - String Functions/86 - REPLACE in PostgreSQL.mp4
  -  24.2 MB

  .pad/73
  -  821.92 KB

  [TutsNode.net] - 19 - DateTime Functions/100 - AGE in PostgreSQL.mp4
  -  23.78 MB

  .pad/74
  -  227.89 KB

  [TutsNode.net] - 1 - Introduction/1 - Introduction.mp4
  -  23.38 MB

  .pad/75
  -  631.69 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/13 - Import data from File in MS SQL.mp4
  -  23.38 MB

  .pad/76
  -  636.66 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/9 - CREATE in MS SQL.mp4
  -  22.3 MB

  .pad/77
  -  712.27 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/19 - WHERE in MS SQL.mp4
  -  22.09 MB

  .pad/78
  -  928.65 KB

  [TutsNode.net] - 2 - Course Resources/3 - This is a milestone.mp4
  -  21.88 MB

  .pad/79
  -  126.26 KB

  [TutsNode.net] - 11 - Aggregate Commands/50 - AVERAGE in PostgreSQL.mp4
  -  21.14 MB

  .pad/80
  -  884.82 KB

  [TutsNode.net] - 14 - JOINS/71 - Cross Join in MS SQL.mp4
  -  20.5 MB

  .pad/81
  -  516.27 KB

  [TutsNode.net] - 14 - JOINS/70 - Cross Join in PostgreSQL.mp4
  -  20.21 MB

  .pad/82
  -  812.63 KB

  [TutsNode.net] - 8 - Selection commands Filtering/36 - IN in MS SQL.mp4
  -  20.2 MB

  .pad/83
  -  823.23 KB

  [TutsNode.net] - 9 - Selection commands Ordering/45 - LIMIT in MS SQL.mp4
  -  19.43 MB

  .pad/84
  -  587.79 KB

  [TutsNode.net] - 18 - Mathematical Functions/94 - SETSEED in PostgreSQL.mp4
  -  18.22 MB

  .pad/85
  -  795.1 KB

  [TutsNode.net] - 14 - JOINS/65 - Left Join in MS SQL.mp4
  -  16.8 MB

  .pad/86
  -  209.2 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/15 - SELECT statement in MS SQL.mp4
  -  16.74 MB

  .pad/87
  -  262.6 KB

  [TutsNode.net] - 7 - Restore and Backup in MS SQL/33 - Restoring and Backup in MySQL.mp4
  -  16.59 MB

  .pad/88
  -  421.87 KB

  [TutsNode.net] - 14 - JOINS/67 - Right Join in MS SQL.mp4
  -  16.55 MB

  .pad/89
  -  459.86 KB

  [TutsNode.net] - 18 - Mathematical Functions/92 - CEIL & FLOOR in PostgreSQL.mp4
  -  16.52 MB

  .pad/90
  -  487.17 KB

  [TutsNode.net] - 14 - JOINS/74 - Union in PostgreSQL.mp4
  -  16.5 MB

  .pad/91
  -  512.45 KB

  [TutsNode.net] - 10 - Aliases/47 - AS in MS SQL.mp4
  -  16.49 MB

  .pad/92
  -  519.77 KB

  [TutsNode.net] - 17 - String Functions/84 - LENGTH in PostgreSQL.mp4
  -  16.41 MB

  .pad/93
  -  608.1 KB

  [TutsNode.net] - 17 - String Functions/88 - CONCATENATION in PostgreSQL.mp4
  -  16.06 MB

  .pad/94
  -  963.43 KB

  [TutsNode.net] - 14 - JOINS/61 - Preparing the data.mp4
  -  15.69 MB

  .pad/95
  -  314.53 KB

  [TutsNode.net] - 5 - Fundamental SQL statements/17 - SELECT DISTINCT in MS SQL.mp4
  -  15.09 MB

  .pad/96
  -  934.6 KB

  [TutsNode.net] - 14 - JOINS/73 - Except in PostgreSQL.mp4
  -  13.94 MB

  .pad/97
  -  56.56 KB

  [TutsNode.net] - 18 - Mathematical Functions/95 - ROUND in PostgreSQL.mp4
  -  13.71 MB

  .pad/98
  -  297.43 KB

  [TutsNode.net] - 9 - Selection commands Ordering/41 - Side Lecture Commenting in SQL.mp4
  -  13.12 MB

  .pad/99
  -  896.83 KB

  [TutsNode.net] - 13 - Conditional Statement/58 - CASE WHEN in MS SQL.mp4
  -  13.05 MB

  .pad/100
  -  971.16 KB

  [TutsNode.net] - 22 - Congratulations/109 - The final milestone.mp4
  -  12.73 MB

  .pad/101
  -  275.14 KB

  [TutsNode.net] - 18 - Mathematical Functions/96 - POWER in PostgreSQL.mp4
  -  10.76 MB

  .pad/102
  -  241.14 KB

  [TutsNode.net] - 12 - Group By Commands/56 - HAVING in MS SQL.mp4
  -  10.66 MB

  .pad/103
  -  352.35 KB

  [TutsNode.net] - 17 - String Functions/85 - UPPER LOWER in PostgreSQL.mp4
  -  9.96 MB

  .pad/104
  -  37.61 KB

  [TutsNode.net] - 14 - JOINS/59 - Introduction to Joins.mp4
  -  8.57 MB



Torrent Description


Description

4 Reasons why you should choose this SQL course

Carefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businesses
Comprehensive – covers basic and advanced SQL statements in both, PostgreSQL and MS SQL
Downloadable resources covering essential topics on SQL
Your queries on SQL and anything covered in the Masterclass will be responded by the Instructor himself

A Verifiable Certificate of Completion is presented to all students who undertake this SQL course.

Why should you choose this course?

This is a complete tutorial on SQL which can be completed within a weekend. SQL is the most sought after skill for Data analysis roles in all the companies. PostgreSQL and MS SQL are highly desired skills for database management and data analysis roles. So whether you want to start a career as a data scientist or just grow you data analysis skills, this course will cover everything you need to know to do that.

What makes us qualified to teach you?

The course is taught by Abhishek, Pukhraj and Nadeem. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. They have an in-depth knowledge in advanced SQL, PostgreSQL, MS SQL, database management, and various data analysis tools available in the market.

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

By the end of this course, your confidence in using SQL will soar. You’ll have a thorough understanding of how to use SQL for Data analytics as a career opportunity.

Go ahead and click the enroll button, and I’ll see you in lesson 1!

Cheers

Start-Tech Academy

FAQ’s

Why learn SQL?

SQL is the most universal and commonly used database language. It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MS SQL. Simply put, If you want to access databases then yes, you need to know SQL.
It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people to get interesting data from the database. It is also an English-like language so anyone who can use English at a basic level can write SQL queries easily.
SQL is one of the most sought-after skills by hiring employers.
You can earn good money

How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.

What’s the difference between SQL and PostgreSQL?

SQL is a language. Specifically, the “Structured Query Language”

PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS’s, others of which are Oracle, Informix, MySQL, and MSQL.

All of these RDMSs use SQL as their language. Each of them has minor variations in the “dialect” of SQL that they use, but it’s all still SQL.

Which is better, PostgreSQL or MS SQL?

Both are excellent products with unique strengths, and the choice is often a matter of personal preference.

PostgreSQL offers overall features for traditional database applications, while MS SQL focuses on faster performance for Web-based applications.

Open-source development will bring more features to subsequent releases of both databases.

Who uses these databases?

Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.

Companies that use MS SQL: Uber, Airbnb, Netflix, Udemy, Pinterest etc.
Who this course is for:

Working Professionals beginning their Data journey
Anyone curious to learn and compare both PostgreSQL and MS SQL
Students about to join their first corporate job

Requirements

Just a PC with any web browser

Last Updated 11/2022