Database Engineerdba Postgresql Ibm Db2 Mariadbnosql

  1. Home
  2. Database-administration
  3. Database Engineerdba Postgresql Ibm Db2 Mariadbnosql

Tags: Database Administration

Practical Database Engineering | Administration

Last updated 2022-01-10 | 4.2

- Installing Database Servers
- Creating Databases
- Creating Tables

What you'll learn

Installing Database Servers
Creating Databases
Creating Tables
Extracting and joining data from multiple tables
Dropping and Truncating Tables
Performing CRUD Operations
Sorting and Filtering Data
Creating Stored Procedures
Querying database with various operators
Creating Triggers
Creating Views
Implementing Database Security
Backing up and restoring database
Aggregating data with Aggregate Functions
Analyzing data with Analytic Functions
Creating NoSQL Databases
Interacting with NoSQL Databases

* Requirements

* A Computer is required + Internet connection

Description

  • Installing Database Servers
  • Creating Databases
  • Creating Tables
  • Extracting and joining data from multiple tables
  • Dropping and Truncating Tables
  • Performing CRUD Operations
  • Sorting and Filtering Data
  • Creating Stored Procedures
  • Querying database with various operators
  • Creating Triggers
  • Creating Views
  • Implementing Database Security
  • Backing up and restoring database
  • Aggregating data with Aggregate Functions
  • Analyzing data with Analytic Functions
  • Creating NoSQL Databases
  • Interacting with NoSQL Databases

Course content

23 sections • 191 lectures

PostgreSQL Setup 13 lectures

Introduction Preview 01:08

What is PostgreSQL Preview 01:41

Minimum Installation Requirements Preview 03:29

Installing PostgreSQL on Windows Preview 09:53

Installing PostgreSQL on MacOS Preview 02:54

Installing PgAdmin Tool on MacOS Preview 05:23

Installing PostgreSQL on Linux Preview 07:17

Installing PgAdmin Tool on Linux Preview 05:58

Connecting to PostgreSQL Database Server Preview 09:35

Load Sample Database Preview 11:49

Loading Sample Database -Option 2 Preview Processing..

Database Concepts Preview 08:57

Data Types Preview 09:48

PostgreSQL Database Objects 10 lectures

Server Service Preview 05:00

Database Preview 03:45

Table Preview 03:54

Schema Preview 03:46

Tablespace Preview 03:30

Views Preview 04:18

Functions Preview 04:47

Cast and Operators Preview 02:48

Sequences Preview 06:44

Extensions Preview 04:42

PostgreSQL CRUD Operations 20 lectures

What is CRUD Preview 00:56

What is SQL Preview 03:38

Create Database using pgadmin Preview 05:40

Create Table using pgadmin Preview 07:48

Create Table using SQL Statement Preview 08:40

Retrieve data with SELECT statement Preview 05:10

Using Subqueries Preview 08:13

Modify data using UPDATE Statement Preview 07:48

Remove data using DELETE Statement Preview 05:26

Add data using INSERT INTO Statement Preview 09:36

PostgreSQL Unique Constraint Preview 06:09

Filtering data with WHERE clause Preview 06:58

Retrieve all data from a table Preview 06:33

Retrieve data from a specific column Preview 07:41

Remove duplicate records Preview 05:00

Sorting data Preview 08:16

Grouping Data using GROUP BY Clause Preview 11:15

Using HAVING Clause Preview 04:11

Truncating Tables Preview 03:52

Stored Procedures Preview 04:43

PostgreSQL Operators 14 lectures

Comparison Operators Preview 09:49

BETWEEN Operator Preview 09:06

NOT BETWEEN Operator Preview 05:33

LIKE OPERATOR Preview 11:37

NOT Operator Preview 05:49

OR Operator Preview 06:35

AND Operator Preview 07:07

Combining AND | OR Operator Preview 08:33

LIMIT Operator Preview 10:05

IN Operator Preview 10:57

UNION Operator Preview 04:42

UNION ALL Operator Preview 03:30

INTERSECT Operator Preview 06:20

EXCEPT Operator Preview 08:57

PostgreSQL Database Table Join 6 lectures

Introduction to Table Joins Preview 01:06

INNER JOIN Preview 10:35

LEFT Join Preview 11:17

FULL OUTER Join Preview 10:21

CROSS Join Preview 06:49

NATURAL Join Preview 10:27

PostgreSQL Aggregate Functions 5 lectures

Introduction to Aggregate Functions Preview 02:03

AVG Aggregate function Preview 11:56

COUNT Aggregate function Preview 11:09

MAX Aggregate function Preview 10:59

MIN Aggregate function Preview 08:58

PostgreSQL Analytic Functions 11 lectures

SUM Aggregate function Preview 06:48

Introduction to Analytic Functions Preview 05:39

Creating sample tables Preview 06:01

Using AVG as window function Preview 04:03

ROW Number Functions Preview 08:53

RANK Functions Preview 03:11

DENSE RANK Functions Preview 02:53

First Value Function Preview 02:26

LAST Function Preview 03:43

LAG Function Preview 02:59

LEAD Function Preview 03:19

PostgreSQL Views 8 lectures

Introduction to Views Preview 02:48

Benefits of views Preview 01:56

Creating views Preview 09:07

Modifying and removing views Preview 06:32

Updatable Views Preview 04:38

Creating Updatable Views Preview 08:23

Materialized Views Preview 02:20

Creating Materialized Views Preview 09:46

PostgreSQL Triggers 5 lectures

Introduction to Triggers Preview 08:38

Creating your first trigger-part 1 Preview 11:06

Creating your first trigger-part 2 Preview 08:49

Creating your first trigger-part 3 Preview 13:48

Managing Triggers Preview 06:26

PostgreSQL Security | Roles 8 lectures

Introducton Preview 02:07

Database Role Preview 04:15

Role Attributes Preview 08:20

Role Membership Preview 01:58

Group and user role inheritance Preview 03:31

Removing Roles Preview 01:32

Default Roles Preview 04:05

Defining Roles Preview 04:32

Tablespace Management 4 lectures

Introduction Preview 03:05

Creating a tablespace Preview 06:59

Changing a tablespace Preview 02:54

Deleting Tablespace Preview 01:57

PostgreSQL Database Backup and Restore 6 lectures

Introduction Preview 02:20

Backing up a single database with pg_dump Preview 05:38

Backing up a single database using pgadmin Preview 04:25

Restoring a PostgreSQL Database Preview 01:58

Restoring a database using pgrestore Preview 07:52

Restoring a database using pgadmin Preview 04:13

IBM DB2 Setup 6 lectures

What is DB2 Preview 00:45

Installing DB2 Database Server Preview 08:15

Installing IBM Data Studio Client Preview 12:41

Schemas Preview 02:50

What is an ERD Preview 05:40

Multiple Table Relationships Preview 02:35

IBM DB2 Operations 16 lectures

Creating a new database and table Preview 09:08

Launching IBM Data Studio Client Preview 06:00

Creating multiple tables using SQL Scripts Preview 09:20

Manually Inserting Data into database Preview 08:50

Inserting Multiple records using SQL Scripts Preview 04:17

SELECT Statement Preview 02:24

Updating Records Preview 04:12

Deleting Records Preview 02:33

Excluding duplicate records Preview 02:33

Sorting data Preview 03:57

Filtering Records Preview 02:24

LIMIT Clause Preview 02:24

LIKE OPERATOR Preview 07:14

Aggregate Functions Preview 05:28

Truncating Tables Preview 05:01

Dropping Tables Preview 01:45

MariaDB Setup 7 lectures

What is MariaDB Preview 01:34

Who is using MariaDB Preview 02:15

Relationship between MySQL and MariaDB Preview 02:01

Download and install MariaDB Preview 03:17

Download and install MariaDB Management Tool Preview 08:02

Download Sample Database Preview 07:14

MariaDB Data Types Preview 09:06

MariaDB CRUD Operations 11 lectures

Introduction Preview 01:57

Creating Objects using CREATE Preview 11:06

Inserting Data Preview 08:22

Reading data from a database Preview 08:29

Updating data in a database Preview 06:32

Deleting data from a database Preview 03:46

Truncating Tables Preview 03:20

Dropping Tables Preview 02:55

Remove duplicate records Preview 04:36

Sorting data Preview 07:34

Using Aliases Preview 06:54

MariaDB Aggregate Functions 8 lectures

Introduction to Aggregate Functions Preview 03:01

AVG Aggregate function Preview 04:09

COUNT Aggregate function Preview 06:20

MAX Aggregate function Preview 03:04

MIN Aggregate function Preview 02:59

SUM Aggregate function Preview 03:09

Grouping Data using GROUP BY Clause Preview 05:44

Using HAVING Clause Preview 05:06

MariaDB Table Joins 6 lectures

Introduction Preview 04:12

Extracting data with INNER Join Preview 09:43

Extracting data with CROSS Join Preview 07:26

Extracting data with LEFT Join Preview 07:04

Extracting data with RIGHT Join Preview 09:16

NULL Values Preview 05:14

MariaDB Operators 5 lectures

UNION Operator Preview 07:27

EXCEPT Operator Preview 06:42

INTERSECT Operator Preview 03:43

Comparison Operator Preview 06:39

AND | OR Operators Preview 06:29

NoSQL Databases 4 lectures

What is NoSQL Preview 07:29

What NoSQL Databases can do Preview 03:49

Types of NoSQL Databases Preview 06:50

Download and Install CouchDB Preview 05:26

Examples of NoSQL Databases 5 lectures

MongoDB Preview 02:12

Cassandra Preview 02:12

Hbase Preview 01:55

Riak Preview 03:24

Redis Preview 02:32

NoSQL Database Data Retrieval 6 lectures

Creating a database Preview 08:38

Nesting data Preview 07:38

Retrieving data Preview 03:39

Querying data Preview 06:46

Defining Views Preview 05:05

Reducing data with Reduce function Preview 07:58

NoSQL Database Application Development 7 lectures

Creating Menu Items Preview 05:03

Attaching and retrieving images Preview 03:59

Querying attachments Preview 05:26

Using HTML to display database data Preview 09:05

Deploying Applications Preview 06:32

Applying Security to CouchDB Preview 04:32

Thank You Preview 00:09