SQL for Non-Starters on postgresql

Structured Query Language SQL

What you'll learn:
Structured Query Language SQL

Requirements
Working knowledge of windows and some knowledge on data

Description
SQL structured query languge for Non-starters is about learning Structured Query Language step by step.

Business analysts, testers, developers anyone who would like to understand how to retrieve data from a database and analyze it will help. Each topic will explain the concept, run the statement and explain the results to make it easy to understand even for non starters. We have used northwind database to learn the relational database design concepts.

For students or just passed out of college, this course will provide a free tool to install and learn SQL structured query language statements and review the output for better understanding. After completing this course, one should be able to work on any database like Oracle, Sybase, SQL Server, Informix, DB2 to run SQL queries. These queries should able to work on any database which supports SQL structured query language.

1] How to install and verify postgresql database installation

2] What is a database and relational database concepts

3] How to retrieve and summarize data in SQL structured query language

4] How to use analytical functions to find top N rows

5] How to combine multiple tables

6] How to fetch data from multiple tables in a single query

This course should help anyone who would like to use SQL in their workplace or in their learning.

Who this course is for
Anyone who would like to learn structured query language SQL with examples