Learn Database Administration - PostgreSQL Database Administration (DBA) for Beginners

In this video, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more. The Complete SQL Bootcamp ☞ http://learnstartup.net/p/HJH7nHmre Restful API with NodeJS, Express, PostgreSQL, Sequelize, Travis, Mocha, Coveralls and Code Climate ☞ https://morioh.com/p/86d418cf65a6 Node.js - Express Persistent Session Store with PostgreSQL + Sequelize ☞ https://morioh.com/p/9317453ae3b6 Using PostgreSQL Database with Python ☞ https://morioh.com/p/eb2b68b712ee Why We Moved From NoSQL MongoDB to PostgreSQL? ☞ https://morioh.com/p/33b4d1157c70 The course also covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings. Topics also includes: Installing PostgreSQL Loading sample database Creating database and tables Performing CRUD operations Joining Tables Using aggregate and analytic functions Creating views and triggers What you’ll learn Install PostgreSQL Server Load sample database Create a database Create a table Insert data into tables Update existing records inside a table Delete Records in a table Remove duplicate records Query data from a table Create a subquery Get data from multiple tables Create and manage roles Create a view Create tablespace Backup and restore database Filter and sort data Use various operators Use aggregate and analytic functions Create triggers #PostgreSQL #Database #Administration Originally published by Gandhi Kumarasamy Sezhian at Udemy ---------------------------------------------------- Social Network for Developers: http://bit.ly/2TFv1y0 Learn Startup: http://bit.ly/2UDotMN Learn to code: http://bit.ly/2pN2aXx Fanpage: http://bit.ly/2O7RNIB Twitter: http://bit.ly/2GOyTlA Tumblr: http://bit.ly/2F30UX2