PostgreSQL Bootcamp

• Leaders interested in making better data-driven decisions and “knowing the numbers”
• Analysts looking to deepen their skillset beyond Excel and Tableau
• Developers who want to be more comfortable working with databases

In this hands-on course you’ll learn the ins and outs of PostgreSQL. You will learn to explore data using a graphical interface of DBeaver, write SQL queries, combine information from multiple tables, and much more. There will be a combination of lectures explaining the concepts, coding demonstrations showing you how to write SQL, and time for you to write SQL queries based on challenge questions we provide.

Data has become central to almost every job on the market and it is becoming an increasingly necessary skill to know how to handle and control data. As data is becoming larger, databases are now the only mode of storage that can handle the quantity. However, in order to work with a database, one must know SQL.

In this training you’ll learn Microsoft SQL Server, but the core concepts can be applied to other flavors of SQL (such as PostgreSQL, Microsoft Access, MySQL, etc.) with minor syntax differences.

Which version of SQL should you learn? You should learn the version of SQL used by the company you’ll be working with, but if you don’t know that here’s a guide to help:

• SQL Server only runs on Windows (it does not work on a Mac), and is widely used by businesses.
  
• PostgreSQL works on both Mac and Windows. It is widely used in data science, data analytics, and by companies like Apple, Instagram, Uber, Netflix, etc.

Whichever you end up learning, the concepts are transferrable to other SQL flavors with minor syntax differences. So if you’re not sure, choose the one based on whether you use Mac or Windows.

You are not required to complete any work outside of class.

You will learn how to explore and query data in a database, use join statements, filter data using various techniques such as subqueries, aggregate functions, and much more.

Students must be comfortable using a computer. No other prior knowledge is required.

This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.

You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).

How does attending “live online” work?

• Students can attend this training remotely through screen sharing software (we use Zoom).
• Participants can hear the instruction, ask questions, and even share their screen with the instructor.
• For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
• Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
• You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at nyc@careercenters.com

You have some options:

• You can watch a recording of the session. We will provide any course materials.
• If you can’t come into the classroom but can still attend remotely, we will provide you with the Zoom login information.
• You can use your free retake to make up any missed class time.