Advanced SQL For Developers

This class will be live online (i.e. synchronous).

This course is a part of ProTech. Please review eligibility requirements below before applying.
Students Learning

Are you interested in leveling up your SQL skills?

Have you been looking for the right opportunity to dig deeper into SQL? Are you just getting by with basic SQL skills? Advanced SQL for Developers starts with a basic SQL refresher and then launches into more advanced SQL functionality. You will learn the broad range of SQL skills necessary to be an intermediate to senior server-side developer. If you are looking for an instructor-guided, online introduction to SQL and need the flexibility of evening classes this course is designed for you.

Is this course for you?

  • Are you seeking to improve your working knowledge of SQL?
  • Are you preparing to increase back-end/database responsibilities at work?
  • Would you like to be able to use raw SQL without the help of an ORM?
  • Are you seeking to better understand, interpret, and analyze database design?
  • Are you seeking to analyze and interpret database performance, security, and integrity requirements?

If you answered 'yes' to any of these questions, the Advanced SQL for Developers course is designed for you.

Who is this course not designed for?
  • If you are not a developer and your only need is to formulate SQL queries to retrieve data.
  • If you need to administer a specific database management system (e.g. Oracle, SQL/Server, etc.).

What will the course cover?

  • Database Design
    Learn how to design and understand a 3NF normalized database using Entity-Relationship Diagrams (ERD) and planning with performance in mind.
  • Manipulation of Data
    Learn how to create, update, delete, and access data stored in a database.
  • Complex Queries
    Learn about accessing data with complex joins, subqueries, and aggregations.
  • Extensibility
    Learn about stored procedures and triggers to build out robust data management functionality.
  • Transactions
    Learn how to build SQL transactions to ensure data integrity.
  • Analysis & Performance
    Learn about the queries happening on your database and how to optimize their performance.

How will you learn the material?

Hands-on Learning
Students actively engage in hands-on exercises and projects as opposed to being passively lectured to. Students leave with a deeper understanding of the subject matter and are ready to apply their new skills on the job.
Flipped Classroom Style
Students are initially exposed to new material outside of class through readings and videos before it is discussed in class. This eliminates the need for lectures and allows class sessions to be used to apply knowledge through class discussions, instructor-led examples, and group/individual lab time.
Live Online Learning
Students have the opportunity to interact as a class, in smaller working groups and one-on-one with the instructor in a live virtual classroom.
Real-World Project
You will practice the skills you learn by exploring data to answer real-world questions.

  • Schedule

    Mondays and Wednesdays 6PM - 9PM CT

  • Location

    This class is live online (i.e. synchronous).

  • Dates

    August 11, 2025 - September 24, 2025 (Class will meet on Tues. Sept. 2nd instead of Mon. Sept. 1st)

  • Tuition

    FREE

    This course is a part of ProTech. Please review eligibility requirements below before applying.
What is required?
  • Personal Laptop
  • Must be 18+ years old
  • Must have knowledge of one or more server-side languages (e.g. C#, PHP, Java, Python)
  • Strongly prefer some familiarity with basic SQL
ProTech Eligibility
  • Must reside in Middle Tennessee
  • Graduate of NSS, another coding bootcamp, or college/university with tech-related degree AND searching for your first job in tech.
  • Tech professional who is unemployed after being laid off from a tech job

Attendance Information

Our policy regarding absences is based on making sure you get the most out of your professional development. Attendance is tracked for this course. Excused absences should be arranged with your instructor before they occur. Due to the short duration of this course we recommend that you not miss multiple days of this course. Absence due to emergencies are always excused as long as the instructor is notified as soon as possible.

Have questions?
Email Us
Ready to take the leap?
Apply