Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

SQL for Database Administrators

via DataCamp

Go to class Write review

Overview

Gain the foundational skills you need to be a confident, high-earning SQL database administrator. In this track, you’ll learn how to create, manage, and optimize your PostgreSQL database. Through real-world exercises you’ll write and run real-code in your browser as you learn how to use T-SQL syntax, DML triggers, and improve query performance, making sure that your database can scale as your business needs grow.

Syllabus

  • Introduction to Relational Databases in SQL
    • Learn how to create one of the most efficient ways of storing data - relational databases!
  • Database Design
    • Learn to design databases in SQL to process, store, and organize data in a more efficient way.
  • Creating PostgreSQL Databases
    • Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.
  • Improving Query Performance in PostgreSQL
    • Learn how to structure your PostgreSQL queries to run in a fraction of the time.

Taught by

Timo Grossenbacher, Amy McCarty, Darryl Reeves Ph.D, and Lis Sulmont

Reviews

Start your review of SQL for Database Administrators

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.