Mastering SQL using Postgresql

Partner: Udemy
Affiliate Name:
Area:
Description: About PostgresqlPostgresql is one of the leading datatabase. It is an open source database and used for different types of applications.Web ApplicationsMobile ApplicationsData Logging ApplicationsEven though it is relational database and best suited for transactional systems (OLTP), it’s flavors such as Redshift are extensively used for Analytical or Decision Support Systems.Course DetailsThis course is primarily designed to go through basic and advanced SQL using Postgres Database. You will be learning following aspects of SQL as well as Postgres Database.Setup Postgres Database using DockerConnect to Postgres using different interfaces such as psql, SQL Workbench, Jupyter with SQL magic etc.Understand utilities to load the dataPerforming CRUD or DML OperationsWriting basic SQL Queries such as filtering, joins, aggregations, sorting etcCreating tables, constraints and indexesDifferent partitioning strategies while creating tablesUsing pre-defined functions provided by PostgresqlWriting advanced SQL queries using analytic functionsDesired AudienceHere are the desired audience for this course.College students and entry level professionals to get hands on expertise with respect to SQL to be prepared for the interviews.Experienced application developers to understand key aspects of Databases to improve their productivity.Data Engineers and Data Warehouse Developers to understand the relevance of SQL and other key concepts.Testers to improve their query writing abilities to validate data in the tables as part of running their test cases.Business Analysts to write ad-hoc queries to understand data better or troubleshoot data quality issues.
Category: IT & Software > Other IT & Software > SQL
Partner ID:
Price: 19.99
Commission:
Source: Impact
Go to Course