search
Follow Topic rss_feed

Installation of the PostgreSQL database is the first step to move one step ahead towards the open source world of the database. pgAdmin and PostgreSQL are both interconnected with each other by the core system of which is installed inside the machine.

Bharat Dwarkani shared on Mar 15, 2020
image
ubuntupit.com
bookmarks
share
favorite_border0 visibility3
favorite_border0 visibility3 share bookmarks

the loading time of a particular analytics report was ridiculously slow for a big Enterprise customer. Since I am part of the Data platform, a flag was immediately raised and I got involved in debugging the issue.

Bharat Dwarkani shared on Mar 11, 2020
image
medium.com
bookmarks
share
favorite_border0 visibility6
favorite_border0 visibility6 share bookmarks

There are a couple of different approaches with different benefits / drawbacks to choose from; let’s lay it out for the Internet Citizens! There’s a summary of pros and cons down below if you’re in a hurry.

Bharat Dwarkani shared on Feb 01, 2020
image
cybertec-postgresql.com
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share bookmarks

Learn how to perform basic operations (GET/PUT/DELETE/UPDATE) on items into DynamoDB using AWS-SDK, Serverless Framework and AWS Lambda.

Bharat Dwarkani shared on Dec 15, 2019
image
youtube.com
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share bookmarks

Learn how to use PostgreSQL in this full course. PostgreSQL is a general-purpose and object-relational database management system. It is the most advanced open-source database system widely used to build back-end systems.

Bharat Dwarkani shared on Dec 15, 2019
image
youtube.com
bookmarks
share
favorite_border0 visibility4
favorite_border0 visibility4 share bookmarks

MySQL Tutorial for beginners - Learn MySQL for web development

Bharat Dwarkani shared on Dec 15, 2019
image
youtube.com
bookmarks
share
favorite_border0 visibility0
favorite_border0 visibility0 share bookmarks

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Bharat Dwarkani shared on Dec 15, 2019
image
youtube.com
bookmarks
share
favorite_border0 visibility1
favorite_border0 visibility1 share bookmarks

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

Bharat Dwarkani shared on Nov 30, 2019
image
github.com
bookmarks
share
favorite_border0 visibility8
favorite_border0 visibility8 share bookmarks

Naming convention is a set of rules for choosing the character sequence to be used for identifiers which denote variables, types, functions, and other entities in source code and documentation.

Bharat Dwarkani shared on Nov 30, 2019
image
github.com
bookmarks
share
favorite_border0 visibility7
favorite_border0 visibility7 share bookmarks

In an effort to make my team write better SQL, written by non-developers and code reviews, and gathered common mistakes and missed optimization opportunities in SQL.

Bharat Dwarkani shared on Nov 23, 2019
image
hakibenita.com
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share bookmarks
add