Learn the most popular SQL dialects, PostgreSQL & MSSQL. Learn SQL concepts, practice & compare the syntax of PostgreSQL & MSSQL
This course includes:
- 9 hours of on-demand video
- 4 articles
- Full lifetime access
- Access on mobile and TV
- Certificate of completion
Hot & new
4.6
(7 ratings)
4,098 students
Created by Start-Tech Trainings, Start-Tech Academy
What you’ll learn
- How to write SELECT queries to fetch relevant data in PostgreSQL and MS SQL
- How to filter and sort the data using WHEN, logical operators, and ORDER BY
- How to group and aggregate data in PostgreSQL and MS SQL
- How to apply joins and combine queries in PostgreSQL and MS SQL
- String, mathematical, date-time functions, and pattern matching in PostgreSQL and MS SQL
- Understanding of VIEWS and INDEXES in PostgreSQL and MS SQL
- How to write subqueries in PostgreSQL and MS SQL
Course content
22 sections • 110 lectures • 8h 51m total lengthCollapse all sections
Introduction1 lecture • 3min
- IntroductionPreview03:16
Course Resources2 lectures • 4min
- Course resources00:08
- This is a milestone!Preview03:31
Setting up PostgreSQL and PGAdmin2 lectures • 11min
- Installing PostgreSQL and pgAdmin in your PC10:44
- If pgAdmin is not opening…00:44
Installing MS SQL2 lectures • 8min
- Installing and Setting up MS SQL04:02
- Debugging the installation process04:07
Fundamental SQL statements21 lectures • 1hr 48min
- CREATE in PostgreSQLPreview11:40
- CREATE in MS SQLPreview03:11
- INSERT in PostgreSQL09:07
- INSERT in MS SQL04:35
- Import data from File in PostgreSQL04:59
- Import data from the File in MS SQL03:08
- SELECT statement in PostgreSQL03:40
- SELECT statement in MS SQL01:53
- SELECT DISTINCT in PostgreSQL06:05
- SELECT DISTINCT in MS SQL01:40
- WHERE in PostgreSQL04:02
- WHERE in MS SQL02:23
- Logical Operators in PostgreSQL06:03
- Logical Operators in MS SQL04:15
- UPDATE in PostgreSQL05:24
- UPDATE in MS SQL02:49
- DELETE in PostgreSQL04:11
- DELETE in MS SQL01:59
- ALTER Part 1 in PostgreSQL06:49
- ALTER Part 2 in PostgreSQL10:31
- ALTER in MS SQL09:53
Restore and Back-up in PostgreSQL4 lectures • 23min
- Restore and Back-up07:37
- Debugging restoration issues08:26
- Creating DB using CSV files05:40
- Debugging summary and Code for CSV files01:15
Restore and Back-up in MS SQL2 lectures • 6min
- Restoring and Back-up in MySQL01:39
- Restore and Back-up in MS SQL04:16
Selection commands: Filtering6 lectures • 29min
- IN in PostgreSQL04:18
- IN in MS SQL02:06
- BETWEEN in PostgreSQL05:40
- BETWEEN in MS SQL02:59
- LIKE in PostgreSQL08:52
- LIKE in MS SQL05:25
Selection commands: Ordering5 lectures • 17min
- Side Lecture: Commenting in SQL01:21
- ORDER BY in PostgreSQL07:42
- ORDER BY in MS SQL02:06
- LIMIT in PostgreSQL03:38
- LIMIT in MS SQL01:44
Aliases2 lectures • 5min
- AS in PostgreSQL03:33
- AS in MS SQL01:33
Aggregate Commands5 lectures • 21min
- COUNT in PostgreSQL05:07
- SUM in PostgreSQL03:24
- AVERAGE in PostgreSQL02:53
- MIN & MAX in PostgreSQL04:18
- Aggregate Functions in MS SQL05:37
Group By Commands4 lectures • 23min
- GROUP BY in PostgreSQL11:42
- GROUP BY in MS SQL04:40
- HAVING in PostgreSQL05:04
- HAVING in MS SQL01:28
Conditional Statement2 lectures • 7min
- CASE WHEN in PostgreSQL05:17
- CASE WHEN in MS SQL01:28
JOINS17 lectures • 1hr 17min
- Introduction to Joins02:54
- Concepts of Joining and Combining Data11:58
- Preparing the data02:00
- Inner Join in PostgreSQL08:04
- Inner Join in MS SQL03:58
- Left Join in PostgreSQL07:30
- Left Join in MS SQL01:29
- Right Join in PostgreSQL06:27
- Right Join in MS SQL01:29
- Full Outer Join in PostgreSQL04:59
- Full Outer Join in MS SQL02:26
- Cross Join in PostgreSQL04:21
- Cross Join in MS SQL02:08
- Intersect and Intersect ALL in PostgreSQL07:06
- Except in PostgreSQL02:53
- Union in PostgreSQL03:09
- Intersect, Except & Union in MS SQL03:45
Subqueries4 lectures • 20min
- Subqueries: Subquery in WHERE clause in PostgreSQL04:55
- Subqueries: Subquery in FROM clause in PostgreSQL05:23
- Subqueries: Subquery in SELECT in PostgreSQL04:02
- Subqueries in MS SQL05:29
Views and Indexes4 lectures • 20min
- VIEWS in PostgreSQL07:14
- VIEWS in MS SQL03:13
- INDEX in PostgreSQL06:25
- INDEX in MS SQL02:58
String Functions8 lectures • 43min
- LENGTH in PostgreSQL03:22
- UPPER LOWER in PostgreSQL02:10
- REPLACE in PostgreSQL04:13
- TRIM, LTRIM, RTRIM in PostgreSQL06:56
- CONCATENATION in PostgreSQL02:56
- SUBSTRING in PostgreSQL06:01
- LIST AGGREGATION in PostgreSQL04:54
- String Functions in MS SQL12:27
Mathematical Functions7 lectures • 29min
- CEIL & FLOOR in PostgreSQL03:20
- RANDOM in PostgreSQL05:04
- SETTLED in PostgreSQL04:11
- ROUND in PostgreSQL02:27
- POWER in PostgreSQL02:18
- Mathematical Functions in MS SQL- Part 108:08
- Mathematical Functions in MS SQL- Part 204:00
Date-Time Functions4 lectures • 28min
- CURRENT DATE & TIME in PostgreSQL04:25
- AGE in PostgreSQL03:50
- EXTRACT in PostgreSQL08:16
- Date-Time Functions in MS SQL11:03
Data Type conversion2 lectures • 17min
- Data Type conversion to string in PostgreSQL10:46
- Data Type conversion to Number and Date in PostgreSQL05:49
PATTERN (STRING) MATCHING4 lectures • 30min
- PATTERN MATCHING BASICS07:33
- Advanced pattern matching Part 1 (REGULAR EXPRESSIONS)08:29
- Advanced pattern matching Part 2 (REGULAR EXPRESSIONS)06:49
- Pattern matching in MS SQL07:29
Congratulations2 lectures • 3min
- The final milestone!01:33
- Bonus Lecture00:57
Requirements
- Just a PC with any web browser
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 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 your 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 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 an 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 RDMSs, 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, and Skype.
Companies that use MS SQL: Accenture, Cognizant, Dell, Microsoft, ViaVarejo, 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