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, 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. 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.

Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required.

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

Live online attendance is available for selected upcoming dates. Check the schedule for each date's attendance format and time zone before enrolling.

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.
• 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.
• Contact us to confirm whether remote attendance is available for your session.
• You can use your free retake to make up any missed class time.

• A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement
• Expert instructors who are industry professionals and experienced educators that are driven to help you succeed
• Additional personalized 1-on-1 bonus training with an industry expert to reinforce concepts
• Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience
• A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice
• 30-day access to class recordings to review material at your own pace
• A certificate of completion to verify your accomplishment

There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.

However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.

Take this course as part of a certificate program and save:

• Data Science & AI Certificate
  Price: $3,995 | Hours: 114 Hours
• FinTech Bootcamp
  Price: $4,995 | Hours: 114 Hours
• Data Analytics Certificate
  Price: $4,995 | Hours: 156 Hours
• Data Analytics & AI Certificate
  Price: $6,995 | Hours: 210 Hours