Course

PostgreSQL MSIB 7 2024

15 credits

Advanced

Enroll

Online

2350000 IDR.

Databases are the standard way of using dynamic information in modern technology, making them an indispensable part of almost every application. The intensive course on the basics of databases will introduce one of the most widely used database management systems (DBMS) used in the development of modern information systems - PostgreSQL. The course gives strong attention to the relational model, ER diagrams (tables and relational relationships) and working with the SQL language (data extraction, selection, projection, joins, aggregation, grouping, modification, deletion and insertion). Fundamental knowledge of working with functions, procedures, transactions and triggers is provided. This course lays the foundations of working with databases, making it easier to use them in real-world applications and to understand concepts such as converting a database into an object-oriented model (ORM).

Topics

Resources
Resources

No description yet

Resources

There are no resources for this lecture yet
Course Introduction
Course Introduction

No description yet

Resources

There are no resources for this lecture yet
PostgreSQL Introduction. Data Types. Working with Tables
PostgreSQL Introduction. Data Types. Working with Tables

No description yet

Resources

There are no resources for this lecture yet
Exercise: Data Types. Working with Tables
Exercise: Data Types. Working with Tables

No description yet

Resources

There are no resources for this lecture yet
Basic CRUD
Basic CRUD

• Lexical Structure in PostgreSQL;
• Retrieving Data;
• Data Manipulation;
• Views.

Resources

There are no resources for this lecture yet
Exercise: Basic CRUD
Exercise: Basic CRUD

No description yet

Resources

There are no resources for this lecture yet
Built-in Functions
Built-in Functions

• Functions in PostgreSQL;
• String Functions;
• Math Functions;
• Date/Time Functions;
• Wildcards.

Resources

There are no resources for this lecture yet
Exercise: Built-in Functions
Exercise: Built-in Functions

No description yet

Resources

There are no resources for this lecture yet
Data Aggregation
Data Aggregation

• Grouping;
• Aggregate Functions;
• Having;
• Conditional Statements.

Resources

There are no resources for this lecture yet
Exercise: Data Aggregation
Exercise: Data Aggregation

No description yet

Resources

There are no resources for this lecture yet
Table Relations
Table Relations

• Database Design;
• Table Relations;
• JOINs;
• Cascade Operations;
• E/R Diagrams.

Resources

There are no resources for this lecture yet
Exercise: Table Relations
Exercise: Table Relations

No description yet

Resources

There are no resources for this lecture yet
Subqueries and JOINs
Subqueries and JOINs

• Joins;
• Subqueries;
• Indices.

Resources

There are no resources for this lecture yet
Exercise: Subqueries and JOINs
Exercise: Subqueries and JOINs

No description yet

Resources

There are no resources for this lecture yet
Database Programmability and Transactions
Database Programmability and Transactions

• User-Defined Functions;
• Stored Procedures;
• Transactions;
• Triggers.

Resources

There are no resources for this lecture yet
Exercise: Database Programmability and Transactions
Exercise: Database Programmability and Transactions

No description yet

Resources

There are no resources for this lecture yet
Exam Preparation
Exam Preparation

No description yet

Resources

There are no resources for this lecture yet
Regular Exam
Regular Exam

No description yet

Resources

There are no resources for this lecture yet

See all topics

How can I enroll?

To register, click HERE or the " SIGN UP " button and follow the steps. After successful payment of the fee, you will be enrolled for the training.

How long can I enroll and when does the course start?

Enrollment in the course is open until January 5 . Training starts on January 7, 2025. You can find a detailed schedule of classes in the " Topics " section.

How and where will the classes be held?

You can learn online in real time. Immediately after each lesson, you also get access to the lesson recording and learning resources.

What is the exam and when will it be held?

The exam will be held online on February 8. It will include a practical part - in the form of project development and defense and a theoretical part - in the form of a test .

Will I get a certificate after the exam?

After passing the exam, you will acquire a certificate from SoftUni if you score above Mn. a good 5.00 from the practical part, and you will also have the opportunity to obtain a state-recognized " Professional Training Certificate " valid throughout the European Union. You can view the requirements for obtaining a certificate HERE .