For Knowledge For Experts For Teams Blog
Sign Up
menu
Database Fundamentals - Predefined Functions (Postgresql)
course-icon
clocklogo
Duration
2 hours session
Course outline
Design
Database - Predefined Functions :-
- SQL Functions in Postgres
- String Manipulation Functions in SQL using Postgres
- Case Conversion and Length using Functions
- Extracting Data
- Handling NULL Values
- Using CASE and WHEN
- Position Functions
- Trimming and Padding Function
- Date Manipulation
- Numeric Functions using SQL in Postgres
- Data Type Conversion using Functions
Prerequisite knowledge
Database Operations -Postgresql
Database Fundamentals - SQL Queries, Tables & Indexes
Learning outcomes
This micro-session allows the learners to take a deeper dive into a pertinent concept when it comes to databases, that is, application of predefined functions using SQL - this includes smaller sub-topics such as, string manipulation, date manipulation, and other functions.
Software / Hardware requirements
Postgresql Database
course-icon
Database Fundamentals - Tables & Indexes (Postgresql)
1.5 hours session
course-icon
Database Fundamentals - Postgresql Database & SQL Queries
1.5 hours session
course-icon
Database Operations -Getting Started with Postgres Database
1.5 hours session
Want to upskill or acquire a new skill?
Start Learning!