PostgreSQL
Modern applications often rely on databases and, by extension, need software systems to manage those databases. One such system is PostgreSQL, which is notable for including many features that help facilitate application development and protect data. By the end of this course, you will be able to use PostgreSQL to manage databases and support application development and integration. This online class has optional live sessions.
Syllabus
Course Topics
Introduction
- What is SQL?
- What is a Relational Database?
- SQL Architecture
- Basic Database Operations Refresher
Single Table SQL
- Working with Tables and PostgreSQL
- Data Types
- Database Keys and Indices
Data Relationships
- Database Design
- Database Keys
- Database Normalizations
- Building Tables
- Inserting Data
- JOIN Operations
SQL Techniques
- Tools and Techniques
- Table Schema
- Dates
- Groupings
- Sub-queries
- Concurrency
- Stored Procedures
- Reading & Parsing Files
Text in PostgreSQL
- Text Functions
- Character Sets
- Hashes
- Index Choices and Techniques
- RegEx
Natural Language
Python & PostgreSQL
- Using Python with PostgreSQL
- Storage and Retrieval of API Data
- Pandas
JSON and PostgreSQL
- What is JSON?
- Using JSON with PostgreSQL
Database Architecture
- Scaling Databases
- Cloud Applications
- ACID and BASE Databases
Elastic Search
Course Level
200
Disclosure
This course is delivered online through an institution of the Lower Cost Models Consortium (LCMC) that is different than your degree-granting institution that awards the academic credit for the course.
