PostgreSQL Tutorials – The Fundamentals
EduCBA
Summary
- Certificate of completion - Free
Overview
Basic PostgreSQL Tutorials
- 4+ Hours OF HD VIDEOS
- Verifiable CERTIFICATION
- Practical SKILLS DEVELOPMENT
- Accelerate YOUR CAREER
- Lifetime Access 24*7 Unlimited Access
- Access through any device
- Technical support
- Mobile App Access
PostgreSQL is a powerful, open source object-relational database system. This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language. It has been prepared for the beginners to help them understand the concepts related to PostgreSQL Database.
Description
Basic PostgreSQL Tutorials
PostgreSQL is a powerful, open source object-relational database system. This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language. It has been prepared for the beginners to help them understand the concepts related to PostgreSQL Database.
The training will include the following;
- Overview
- Environment Setup
- Syntax
- Data Types
- Create Database
- Select Database
- Drop Database
- Create Table
- Drop Table
- Schema
- Insert Query
- Select Query
- Operators
- Expressions
- Where Clause
- AND & OR Clauses
- Update Query
- Delete Query
- Like Clause
- Limit Clause
- Order By Clause
- Group By
- With Clause
- Having Clause
- Distinct Keyword
Please find the below curriculum of the courses:
Section: Introduction
- Video Name: Introduction to PostgreSQL
Section: Benefits of Database
- Video Name: Benefits of PostgreSQL
- Video Name: Aspect of Database
- Video Name: Types of Data
- Video Name: Issuing Database Commands
Section: Table Structure
- Video Name: Table Structure
- Video Name: Inserting Data in Table
- Video Name: Retreiving the Data
- Video Name: Sorting of Data
- Video Name: Analyzing of Various Queries
- Video Name: Destroying a Table
- Video Name: Customization of Queries
- Video Name: Understanding Null Values
- Video Name: Performing Complex Clause
- Video Name: Uses of Distinct Keyword
- Video Name: Set Show and Reset
- Video Name: SQL Aggregates
- Video Name: Group By and Having Clause
- Video Name: Concept of Joining Tables
Section: Joining Tables
- Video Name: Requirement for Joining Tables
- Video Name: Creating Join Tables
- Video Name: Inserting Customer Value
- Video Name: Three or Four Table Joins
- Video Name: Additional Join
- Video Name: One to Many Joins
- Video Name: Concept of Self Joins
- Video Name: Concept of Referential Integrity
- Video Name: Numbering Rows
- Video Name: Creating Functions for Sequences
- Video Name: Combining Selects
- Video Name: Understanding Subqueries
- Video Name: Executing Subqueries
- Video Name: Update with FROM Clause
- Video Name: Creating Tables using Select
- Video Name: Concept of Performance
- Video Name: Understanding PostgreSQL
Who is this course for?
- Professionals
- Students
Requirements
- Some basic knowledge on DBMS and SQL language.
- No particular programming experience is required.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.