SQL for Database Administrators

This track uses the SQL programming language to create, manage, and optimize your PostgreSQL database.

This track is perfect for aspiring or aspiring SQL Database Administrators, as well as for those who need to become proficient in PostgreSQL database management. It is also great for those who want to learn how to optimize their databases for scalability.

This track will equip you with the necessary skills to confidently run and manage a PostgreSQL Database. It covers all the basics from writing and running code to using T-SQL syntax and working with triggers and query optimization. It is designed to provide the necessary graphics to help you create and maintain a highly efficient and scalable database.

This Track typically takes 16 hours to complete as it consists of several courses.

A skills track will focus on teaching specific skills, usually within a certain field of technology, while a career track takes a more all-encompassing approach providing a variety of skills and knowledge needed to enter and succeed in a certain career.

The courses in this track cover a range of topics including Introduction to Relational Databases in SQL, Improving Query Performance in PostgreSQL, Creating PostgreSQL Databases and Database Design.

The language used for this track is SQL, and the exercises will require you to write code and run it in your browser.