PostgreSQL and MS SQL for Beginners

PostgreSQL and MS SQL for Beginners

Learn most popular SQL dialects, PostgreSQL & MSSQL. Learn SQL concepts, practice & compare syntax of PostgreSQL & MSSQL



Sub Category

  • Database Design & Development

{inAds}

Objectives

  • 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 combining 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


Pre Requisites

  1. Just a PC with any web browser


FAQ

  • Q. How long do I have access to the course materials?
    • A. You can view and review the lecture materials indefinitely, like an on-demand channel.
  • Q. Can I take my courses with me wherever I go?
    • A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!



{inAds}

Coupon Code(s)

Previous Post Next Post