PostgreSQL Fundamentals

Course Modality

Digital

Course Level

Foundational

Course Time

20 MINUTES

Course Language

English

Course Overview

This course offers a Foundational introduction to PostgreSQL, which is an open-source relational
database management system. You will learn about the history of PostgreSQL, get an introduction to
databases, and learn PostgreSQL fundamentals. You will also learn how to begin using PostgreSQL
databases.

Prerequisites

We recommend that attendees of this course have the following prerequisites:

  • Familiarity with relational databases
  • Familiarity with structured query language (SQL)

Intended Audience

  • Database administrators
  • Database developers
  • Database architects
  • Database engineers

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning approach that you can adapt to your learning style

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

  • PostgreSQL history
  • PostgreSQL lineage
  • Database 101
  • Database 101 – Transactions
  • Database 101 – Isolation
  • PostgreSQL 101
  • Features
  • Database limitations
  • PostgreSQL terminology

Get In Touch

Course Curriculum

Introduction and History of AWS

Foundational Services – Amazon EC2, Amazon VPC, Amazon S3, Amazon EBS

Lab 1: Build your VPC and launch a web server

Security, Identity, and Access Management – IAM

Databases – Amazon DynamoDB and Amazon RDS

Lab 2: Build your database server and interact with it

AWS Elasticity and Management Tools – Auto Scaling, Elastic Load Balancing, Amazon CloudWatch,
and AWS Trusted Advisor

Lab 3: Scale and load balance your application and monitor activity

Course Wrap-Up

Course Appendices

Recommended Exams

a

AWS Certified Database - Specialty

Validate your ability to recommend, design, and maintain the optimal AWS database solution to improve performance, reduce costs, and enable innovation

Recommended Exams

icon_cloud-practitioner.ba25289e242df8c105c6dfe057d079d77dc8904f

AWS Certified Cloud Practitioner

The AWS Certified Cloud Practitioner examination is intended for individuals who have the knowledge and skills necessary to effectively demonstrate an overall understanding of the AWS Cloud, independent of specific technical roles addressed by other AWS Certifications.

Reviews

Get in touch, enquire now!


By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.

© 2020 The Data Tech Labs Inc. All rights reserved.

TDTL-arrow
[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure