Udemy PostgreSQL: Advanced SQL Queries and Data Analysis Udemy
Price: AED 459

    Course details

    PostgreSQL is commonly known as Postgres and it is also  open source database. There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common relational database and data science tasks, including writing advanced queries,data analysis ,  finding, exploration, and extraction within relational databases. 

    What you will learn includes:
    Introduction PostgreSQL Triggers
    Creating Triggers
    Managing Triggers
    Introduction to Views
    How to create views
    Modifying and Removing Views
    Introduction to Updatable Views
    Creating Updatable Views
    Introduction to Materialized Views
    Creating Materialized Views
    Introduction to Stored Procedures
    Introduction to Aggregate Functions
    Illustrating various types of Aggregate functions
    Introduction to Analytic Functions
    Illustrating various Analytic functions
    Row Number Functions
    Using various types of Operators
    Introduction to Table Joins
    Using various types of joins
    Windowing functions for working with ordered data sets
    Installing PostgreSQL
    Verify postgresql installation
    Postgresql INNER JOIN
    Postgres LIKE Operator
    Postgresql OR Operator
    Server service
    Sequences
    Schema
    Retrieving all Data from Table
    Loading sample database
    Postgresql UNION Operator
    PostgreSQL UNION ALL Operator
    PostgreSQL FULL OUTER JOIN
    PostgreSQL CROSS JOIN
    PostgreSQL combining AND | OR  Operator
    PostgreSQL AND Operator
    PostgreSQL NATURAL JOIN Operator
    PostgreSQL EXCEPT Operator
    PostgreSQL INTERSECT Operator
    PostgreSQL Left Join
    PostgreSQL IN Operator
    Cast and Operators

    The course will teach you how to aggregate data,analyse data ,retrieve data from multiple tables using table joins and write more advanced queries.

    Updated on 14 February, 2018
    Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses