PostgreSQL and MS SQL for Beginners

seeders: 48
leechers: 32
updated:
Added by tutsnode in Other > Tutorials

Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 96
  • Language: English

Files

PostgreSQL and MS SQL for Beginners [TutsNode.net] - PostgreSQL and MS SQL for Beginners 12 - Group By Commands
  • 53 - GROUP BY in PostgreSQL.mp4 (104.7 MB)
  • 54 - GROUP BY in MS SQL.mp4 (41.6 MB)
  • 55 - HAVING in PostgreSQL.mp4 (38.8 MB)
  • 56 - HAVING in MS SQL.mp4 (10.7 MB)
22 - Congratulations
  • 110 - Bonus Lecture.html (2.3 KB)
  • 109 - The final milestone.mp4 (12.7 MB)
2 - Course Resources
  • 2 - Course resources.html (0.4 KB)
  • 3 - This is a milestone.mp4 (21.9 MB)
6 - Restore and Backup in PostgreSQL
  • 32 - Debugging summary and Code for CSV files.html (2.2 KB)
  • 29 - Restore and Backup.mp4 (81.5 MB)
  • 30 - Debugging restoration issues.mp4 (53.6 MB)
  • 31 - Creating DB using CSV files.mp4 (38.4 MB)
3 - Setting up PostgreSQL and PGAdmin
  • 5 - If pgAdmin is not opening.html (1.6 KB)
  • 4 - Installing PostgreSQL and pgAdmin in your PC.mp4 (71.5 MB)
17 - String Functions
  • 91 - String Functions in MS SQL.mp4 (101.5 MB)
  • 87 - TRIM LTRIM RTRIM in PostgreSQL.mp4 (45.6 MB)
  • 89 - SUBSTRING in PostgreSQL.mp4 (39.7 MB)
  • 90 - LIST AGGREGATION in PostgreSQL.mp4 (30.8 MB)
  • 86 - REPLACE in PostgreSQL.mp4 (24.2 MB)
  • 84 - LENGTH in PostgreSQL.mp4 (16.4 MB)
  • 88 - CONCATENATION in PostgreSQL.mp4 (16.1 MB)
  • 85 - UPPER LOWER in PostgreSQL.mp4 (10.0 MB)
5 - Fundamental SQL statements
  • 28 - ALTER in MS SQL.mp4 (98.3 MB)
  • 27 - ALTER Part 2 in PostgreSQL.mp4 (92.1 MB)
  • 8 - CREATE in PostgreSQL.mp4 (91.1 MB)
  • 10 - INSERT in PostgreSQL.mp4 (73.1 MB)
  • 20 - Logical Operators in PostgreSQL.mp4 (50.5 MB)
  • 26 - ALTER Part 1 in PostgreSQL.mp4 (47.2 MB)
  • 16 - SELECT DISTINCT in PostgreSQL.mp4 (46.2 MB)
  • 12 - Import data from File in PostgreSQL.mp4 (42.0 MB)
  • 21 - Logical Operators in MS SQL.mp4 (38.4 MB)
  • 22 - UPDATE in PostgreSQL.mp4 (38.2 MB)
  • 11 - INSERT in MS SQL.mp4 (38.1 MB)
  • 18 - WHERE in PostgreSQL.mp4 (32.5 MB)
  • 14 - SELECT statement in PostgreSQL.mp4 (31.8 MB)
  • 24 - DELETE in PostgreSQL.mp4 (30.0 MB)
  • 25 - DELETE in MS SQL.mp4 (24.4 MB)
  • 23 - UPDATE in MS SQL.mp4 (24.3 MB)
  • 13 - Import data from File in MS SQL.mp4 (23.4 MB)
  • 9 - CREATE in MS SQL.mp4 (22.3 MB)
  • 19 - WHERE in MS SQL.mp4 (22.1 MB)
  • 15 - SELECT statement in MS SQL.mp4 (16.7 MB)
  • 17 - SELECT DISTINCT in MS SQL.mp4 (15.1 MB)
19 - DateTime Functions
  • 102 - DateTime Functions in MS SQL.mp4 (89.9 MB)
  • 101 - EXTRACT in PostgreSQL.mp4 (52.0 MB)
  • 99 - CURRENT DATE & TIME in PostgreSQL.mp4 (28.5 MB)
  • 100 - AGE in PostgreSQL.mp4 (23.8 MB)
21 - PATTERN STRING MATCHING
  • 108 - Pattern matching in MS SQL.mp4 (74.4 MB)
  • 106 - Advanced pattern matching Part 1 REGULAR EXPRESSIONS.mp4 (50.7 MB)
  • 105 - PATTERN MATCHING BASICS.mp4 (36.8 MB)
  • 107 - Advanced pattern matching Part 2 REGULAR EXPRESSIONS.mp4 (32.2 MB)
9 - Selection commands Ordering
  • 42 - ORDER BY in PostgreSQL.mp4 (72.9 MB)
  • 44 - LIMIT in PostgreSQL.mp4 (29.3 MB)
  • 43 - ORDER BY in MS SQL.mp4 (25.0 MB)
  • 45 - LIMIT in MS SQL.mp4 (19.4 MB)
  • 41 - Side Lecture Commenting in SQL.mp4 (13.1 MB)
8 - Selection commands Filtering
  • 39 - LIKE in PostgreSQL.mp4 (72.7 MB)
  • 40 - LIKE in MS SQL.mp4 (53.6 MB)
  • 37 - BETWEEN in PostgreSQL.mp4 (52.3 MB)
  • 38 - BETWEEN in MS SQL.mp4 (34.6 MB)
  • 35 - IN in PostgreSQL.mp4 (29.6 MB)
  • 36 - IN in MS SQL.mp4 (20.2 MB)
14 - JOINS
  • 60 - Concepts of Joining and Combining Data.mp4 (65.0 MB)
  • 62 - Inner Join in PostgreSQL.mp4 (51.1 MB)
  • 63 - Inner Join in MS SQL.mp4 (41.6 MB)
  • 64 - Left Join in PostgreSQL.mp4 (40.0 MB)
  • 66 - Right Join in PostgreSQL.mp4 (39.0 MB)
  • 68 - Full Outer Join in PostgreSQL.mp4 (34.3 MB)
  • 75 - Intersect Except & Union in MS SQL.mp4 (29.9 MB)
  • 69 - Full Outer Join in MS SQL.mp4 (28.2 MB)
  • 72 - Intersect and Intersect ALL in PostgreSQL.mp4 (26.5 MB)
  • 71 - Cross Join in MS SQL.mp4 (20.5 MB)
  • 70 - Cross Join in PostgreSQL.mp4 (20.2 MB)
  • 65 - Left Join in MS SQL.mp4 (16.8 MB)
  • 67 - Right Join in MS SQL.mp4 (16.6 MB)
  • 74 - Union in PostgreSQL.mp4 (16.5 MB)
  • 61 - Preparing the data.mp4 (15.7 MB)
  • 73 - Except in PostgreSQL.mp4 (13.9 MB)
  • 59 - Introduction to Joins.mp4 (8.6 MB)
18 - Mathematical Functions
  • 97 - Mathematical Functions in MS SQL Part 1.mp4 (63.5 MB)
  • 98 - Mathematical Functions in MS SQL Part 2.mp4 (35.5 MB)
  • 93 - RANDOM in PostgreSQL.mp4 (24.3 MB)
  • 94 - SETSEED in PostgreSQL.mp4 (18.2 MB)
  • 92 - CEIL & FLOOR in PostgreSQL.mp4 (16.5 MB)
  • 95 - ROUND in PostgreSQL.mp4 (13.7 MB)
  • 96 - POWER in PostgreSQL.mp4 (10.8 MB)
20 - Data Type conversion
  • 103 - Data Type conversion to string in PostgreSQL.mp4 (61.6 MB)
  • 104 - Data Type conversion to Number and Date in PostgreSQL.mp4 (28.9 MB)
15 - Subqueries
  • 79 - Subqueries in MS SQL.mp4 (56.3 MB)
  • 77 - Subqueries Subquery in FROM clause in PostgreSQL.mp4 (35.3 MB)
  • 78 - Subqueries Subquery in SELECT in PostgreSQL.mp4 (29.4 MB)
  • 76 - Subqueries Subquery in WHERE clause in PostgreSQL.mp4 (26.1 MB)
4 - Installing MS SQL
  • 7 - Debugging the installation process.mp4 (46.0 MB)
  • 6 - Installing and Setting up MS SQL.mp4 (34.7 MB)
7 - Restore and Backup in MS SQL
  • 34 - Restore and Backup in MS

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



Download torrent
3.9 GB
seeders:48
leechers:32
PostgreSQL and MS SQL for Beginners


Trackers

tracker name
udp://open.stealth.si:80/announce
udp://tracker.tiny-vps.com:6969/announce
udp://fasttracker.foreverpirates.co:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://explodie.org:6969/announce
udp://tracker.cyberia.is:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.uw0.xyz:6969/announce
udp://opentracker.i2p.rocks:6969/announce
udp://tracker.birkenwald.de:6969/announce
udp://tracker.torrent.eu.org:451/announce
udp://tracker.moeking.me:6969/announce
udp://tracker.dler.org:6969/announce
udp://9.rarbg.me:2970/announce
µTorrent compatible trackers list

Download torrent
3.9 GB
seeders:48
leechers:32
PostgreSQL and MS SQL for Beginners


Torrent hash: 80302B01126A5FB9F1F7E36D8F7D85E806DECC96