4.2 Read 5 reviews
Overview
Context
Have you ever wanted to create and manage your own databases but thought such knowledge is reserved for database administrators? This Creating PostgreSQL Databases course offered by Data Camp teaches you the skills and knowledge necessary create your databases and effectively manage them yourself.
Discover the Structure of PostgreSQL Databases and Learn PostgreSQL Data Types
You’ll start this course by exploring the fundamentals of creating a Postgres database by covering databases, tables, and schemas, understanding how each fits into the PostgreSQL object hierarchy. Next, you’ll look at PostgreSQL data types, including text, numeric, temporal, and boolean data. You’ll also learn the appropriate times to use each data type. As you progress, you’ll learn about database normalization, understanding how it maintains the integrity of your data and reduces duplication. Finally, you’ll cover PostgreSQL access control and how you can protect your databases from unauthorized access.Create Your Own Database Using PSQL
As you master the skills to create a PostgreSQL database, you’ll work with real data from the U.S. Small Business Administration (SBA) to guide you through the lessons and provide context for the concepts covered in the course. By the time you've completed this PostgreSQL training, you’ll be able to confidently create your own databases using PostgreSQL. "Programme Structure
Chapters
Structure of PostgreSQL Databases
PostgreSQL Data Types
Database Normalization
Access Control in PostgreSQL
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
You can apply for and start this programme anytime.
Language
English
Delivered
Online
Campus Location
- New York City, United States
Disciplines
Data Science & Big Data View 467 other Short Courses in Data Science & Big Data in United StatesWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- PREREQUISITES: Introduction to SQL
- Intermediate knowledge of SQL is recommended before taking this course.
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions
Funding
Improve page content