Advanced SQL For Developers

Applications for this class are closed.

Please visit our homepage for open professional development classes and subscribe to our email list for all the latest news and programs at NSS.

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

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

    Tuesdays and Thursdays 6PM - 9PM

  • Location

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

  • Dates

    March 7, 2023 - April 20, 2023

  • Tuition

    $1800

    NSS bootcamp alumni receive a 10% discount.
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

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.

Tuition

Standard tuition is $1800.

Deposit

A $1000 deposit is required to hold your seat. This is due when we send you acceptance to the class and you confirm you will attend. This deposit is refundable prior to the start of the second class session. The remaining $800 balance is due by the 7th class session.

Early Bird Discount

Save 10% with our early bird tuition! Pay in full by the first day of class and receive $180 off your tuition.

Alumni Discount

Alumni of our bootcamps are eligible for a 10% discount. Combine this with the Early Bird Discount and save $360 off your tuition.

Employer Paid

Is your employer paying for your education? We can invoice your company. (Eligible for Early Bird and Alumni Discounts.)

Have questions?
Email Us