Key Information
SQL Bootcamp
Ruby on Rails Bootcamp
iOS App Development Bootcamp
$975 18 Hours
$2,495 60 Hours
$2,495 60 Hours
Overview
Learn to extract info from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You’ll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL
Ruby on Rails allows you to quickly build dynamic web applications. Mastering Ruby on Rails has two parts: the Ruby Programming language and the Rails framework. Learn both Ruby and Ruby on Rails and build full-functioning web applications from your first class.
Develop several apps, including two in the very first week, using Swift and Xcode. Learn programming basics, intermingled with real apps such as a Tip Calculator and a Weather App that integrates with an API, and create a final project for your portfolio.
Prerequisite
Open to Beginners
While experience with Ruby on Rails is not necessary for this course, it is recommended that you have at least some exposure to HTML, CSS, and JavaScript. Students unfamiliar with these programs should check out our selection of coding courses in NYC.  We can provide you with a computer during class, but it is preferred that you bring your own so that you can continue working at home.
Open to Beginners
Location
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
Schedule
Next start date: December 5–21, Mondays & Wednesdays, 6–9pm
Other scheduling options Weeknights or weekdays
View full schedule
Not currently scheduled
Not currently scheduled
Certification
Receive a Certificate of Completion
Receive a Certificate of Completion
Receive a Certificate of Completion
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Payment Plan See our payment plan FAQ for more details
This program is eligible for our “pay-as-you-go” payment plan.
This program is eligible for our “pay-as-you-go” payment plan.
Financing See our Leif FAQ for more details
Target Audience
  • 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
Anyone
Anyone
What You’ll Learn
  • Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver (a popular free database app)
  • Write SQL queries to retrieve data from tables in a database
  • Combine information from multiple tables with JOIN statements
  • Filter data, group it, and sort it to extract the specific info you need
  • Advanced techniques like Subqueries, String Functions, and IF‑Else logic with CASE
  • When to use Views and User-Defined Functions instead of directly querying tables
  • How to create an application that really works
  • How to set up and work with a database
  • How to store and retrieve information submitted by users
  • Use Model-View-Controller (MVC) architecture to keep code organized
  • Principles of Software Engineering such as Convention over Configuration (CoC) and Don't Repeat Yourself (DRY)
  • Make different screens based on a user's login status
  • Use programming languages to reduce the amount of code you have to write
  • Deploying an application live to the web
  • Learn to build and develop apps using Swift & Xcode
  • Create numerous real-world apps
  • Add interactive elements such as buttons, taps & swipe gestures
  • Connect the user interface to code that makes the app work
  • Learn programming concepts and logic to create efficient app
  • Add image assets for your apps, launch screen, & app store
  • Build adaptable layouts that work across all iPhones & iPads
  • Add embedded videos, map location, external web links
  • Learn to use data models, including external datasets
  • Preview your apps on your own device
  • Create your own app with guidance from the instructor