Location:Main Road, Bangalore

courses@bangalore.com

Postgresql Database Administration Dba For Beginners

Course

POSTGRESQL DATABASE ADMINISTRATION DBA FOR BEGINNERS

Category

SQL Training Insitute

Eligibility

Freshers and Career Changers

Mode

Online and Classroom Sessions

Batches

Week Days and Week Ends

Duration :

60 Days

SQL Objectives

•Learn to build apps with SQL.
•Learn how to use advanced SQL functions.
•How to write clean production-ready code using SQL.
•Eliminate duplicate code and consolidate script files using SQL.
•Learn SQL programming best pracitices, SOLID, Design and more!
•Learn SQL) quickly, easily and effectively by using this course
•You’ll learn how to solve well known standard functions in SQL.
•Create Apps using SQL From Scratch and scale it up to any level
•Learn the essential skills to level-up from beginner to advanced SQL developer in 2021!

postgresql database administration dba for beginners Course Features

•24 × 7 = 365 days supportive faculty
•Basic Training starting with fundamentals
•Real time live project training and Guidance
•Trainer support after completion of the course
•Assignments and test to ensure concept absorption.
•Repeating of lectures allowed (based on seat availability)
•Our trainers have experience in training End Users & Students & Corporate employees.
•We help the students in building the resume boost their knowledge by providing useful Interview tips

Who are eligible for SQL

•Asp.net Mvc Developer, Asp.net Mvc Lead, Java Developer(spring), Ui Developer, Ui Lead, Data Architect
•Java Developer, java j2ee jsp servlets ejb, plsql, Unix Scripting, c, c++, dotnet
•Java Developer, Salesforce Developer, Solution Consulting, Qa Testing, Finance Executive, Full Stack Developer, Email Campaign, React.js, Ui Development
•scala, React.js, Backend Developers, Frontend Developers, Fullstack Developers, Ui/ux Designers, Test Engineering, Site Reliability Engineer, Machine Learning
•Software Developer, IBM MDM, QA, Business Anlaysit, Business Analyst, Software Engineer, Java, Informatica, DataStage, Project Mangement

POSTGRESQL DATABASE ADMINISTRATION DBA FOR BEGINNERS Topics

•Installing PostgreSQL Server
•What is PostgreSQL
•Who is using PostgreSQL
•Minimum Installation Requirements
•Installation versions Please Read
•Installing PostgreSQL Server version
•Connecting to a PostgreSQL Database
•Download and load Sample PostgreSQL Database
•Download PostgreSQL version
•Install PostgreSQL on windows
•Verify PostgreSQL installation
•Installing PostgreSQL on Mac OS X
•Connecting to PostgreSQL database
•Load sample database on PostgreSQL
•Exploring PostgreSQL Database Objects
•Server Service
•Database
•Table
•Schema
•Tablespace
•Views
•Functions
•Cast and Operators
•Sequences
•Extensions
•PostgreSQL Fundamentals
•Database Concepts
•PostgreSQL Data Types
•PostgreSQL Unique Constraint
•Filtering Data using WHERE clause
•Getting all data from a table
•Getting data from a specific column
•Removing duplicate records
•Sorting data
•Grouping data with GROUP BY clause
•Using HAVING clause
•Truncating a table
•Stored Procedures
•Performing CRUD operations
•Create Database with pgadmin tool
•Create Table with pgadmin tool
•Create Table Statement
•Using SELECT statement
•Using a subquery
•Using UPDATE Statement
•Using DELETE statement
•Using INSERT statement
•PostgreSQL Operators
•Comparison Operators
•BETWEEN Operators
•NOT BETWEEN Operators
•LIKE operators
•NOT operator
•OR Operator
•AND Operator
•Combining AND OR operators
•LIMIT Operators
•IN operator
•UNION Operator
•UNION ALL Operator
•INTERSECT Operator
•EXCEPT Operator
•PostgreSQL Table Joins
•Introduction to Joins
•INNER Join
•LEFT Join
•FULL OUTER Join
•CROSS Join
•NATURAL Join
•PostgreSQL Aggregate Functions
•Introduction to Aggregate Functions
•AVG Aggregate Functions
•COUNT Aggregate Functions
•MAX Aggregate Functions
•MIN Aggregate Functions
•SUM Aggregate Functions
•PostgreSQL Analytic Functions
•Introduction to Analytic Functions
•Creating Sample Tables
•Using AVG as window function
•ROW Number functions
•RANK Functions
•DENSE RANK Functions
•First Value Function
•LAST Function
•LAG Function
•LEAD Function
•PostgreSQL Views
•Introduction to views
•Benefits of using views
•Creating a view
•Modifying and removing views
•Updatable View
•Creating Updatable Views
•Materialized Views
•Creating a materialized view
•PostgreSQL Triggers
•Introduction to triggers
•Creating your first trigger part
•Managing triggers
•PostgreSQL Role Management
•Database Role
•Role Attributes
•Role membership
•Group and user role inheritance
•Removing Roles
•Default Roles
•Defining a role
•PostgreSQL Database Backup and Restore
•Backing up a single database using pgdump
•Backing up a single database using pgadmin
•Restoring a PostgreSQL Database
•Restoring a database using pgrestore
•Restoring a database using pgadmin
•Tablespace Management
•Creating a tablespace
•Changing a tablespace
•Deleting Tablespace
•Installation versions (Please Read)
•Installing PostgreSQL Server version10
•Download PostgreSQL version 9.6
•Install PostgreSQL 9.6 on windows
•Verify PostgreSQL 9.6 installation
•Installing PostgreSQL 9.6 on Mac OS X
•Connecting to PostgreSQL 9.6 database
•Load sample database on PostgreSQL 9.6
•Combining AND & OR operators
•Creating your first trigger
•Backing up a single database using pg_dump