Learn Microsoft SQL Server to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering the results. Extract actionable insights from data sets in this hands-on training.
Turn the information in databases into useful insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you’ll learn how to code queries to extract the specific information you want.
Learn how to filter the data, group it, and turn raw data into insights. Combine information from multiple tables using join statements. You’ll also learn more advanced techniques like aggregate functions and subqueries, as well as how to use functions with parameters and stored procedures.
In this hands-on course you’ll learn Microsoft SQL Server and the free SQL Server Management Studio app (SSMS) to explore the database and execute SQL queries you write. The concepts you’ll learn on SQL Server can be applied to other flavors of SQL (such as PostgreSQL, Microsoft Access, MySQL, etc.) with minor syntax differences.
This SQL Server Bootcamp is our SQL Level 1, 2, and 3 classes combined into a single comprehensive course.
With SQL you can answer questions from information stored in a database (the ultimate system of storing data for most companies). As nearly every industry is becoming more data-driven, having this skill will give you a larger role in decision-making wherever you work.
SQL is vital to anyone in business or any job that involves working with data: business analysts, data analysts, data scientists, web developers, business people, and many others.
As one of our smaller courses, tuition for this course is due in full before the start date.
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.
This program is a discounted package of classes that is 15–25% off the individual class prices, so additional discounts do not apply.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
We covered quite a bit of content and it really solidified my understanding of SQL.
— Peter S.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
Attend this course in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
Unlike other providers, these are not mass open-enrollment classes. At NYIM Training, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
We offer a single free retake of the any module or the whole program within a year.
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
Unit 1 6 Hours
Unit 2 6 Hours
Unit 3 6 Hours
In this hands-on course you’ll learn the ins and outs of SQL. You will learn to explore data using the graphical interface of SQL Server Management Studio, 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.
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).
You have some options:
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of SQL Bootcamp with your selected courses.
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
This course covers PostgreSQL, another popular relational database flavor, but the core concepts remain the same
In this bootcamp, you'll master the top data analytic tools: Excel, SQL, & Tableau. Organize, analyze, summarize, and visualize your data to present actionable insights.
Learn SQL along with Excel and Tableau to master the three main tools used by Data Analysts
Learn the skills you'll need to become a Data Analyst or Business Analyst, including data analysis, visualization, statistical analysis, and how to work with relational databases. Build a portfolio of projects and prepare for a career.
Prepare for a career as a Data Analyst. Learn data analytics concepts, as well as SQL, Excel, Tableau, and Python. You'll create your first portfolio project
Master the tools to become a data scientist: Python, SQL, automation, and machine learning. Learn Python programming fundamentals and analyze data with Pandas, NumPy, and Matplotlib, and query databases with SQL. Use machine learning to apply regressions and other statistical analysis to create predictive models.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
The SQL Bootcamp is for you if:
SQL Level 1 is perfect for beginners who are new to SQL and using databases. Begin with instruction in the fundamentals of relational databases. In this hands-on class, beginners will become familiar with basic SQL commands and the Microsoft SQL Server DBMS (Database Management System).
Students in SQL Level 2 will expand their knowledge of SQL and SQL Server with more advanced queries and SQL skills. In this course, students will learn how to group data with aggregate functions, filter groups with HAVING, work with dates/time, perform advanced JOINS such as Self Join and Union, and more.
In SQL Level 3, students will learn about subqueries, views, variables, functions, stored procedures, and other advanced skills that will build on their prior understanding of SQL.
Our SQL courses are offered each week at a variety of times to suit your schedule. Motivated learners can complete the entire bootcamp in one weekend. We also offer weekday and weeknight classes to accommodate any schedule. Purchase a package and choose the dates that are most convenient for you!
NYIM instructors are real-world professionals with practical experience using the programs they teach in the real world. Your SQL instructor will patiently guide you through database concepts, SQL Server, and using SQL commands. Throughout the course, your instructor is available to answer and clarify questions and can provide support as you work through practice tasks.
All of your class materials are included with your training fee! From our state-of-the-art computer lab with PCs to custom training materials, we’ve got everything you need! Our course manual is developed by our instructors and designed to guide you through each class exercise, step-by-step.
At NYIM, our classes are small, and you’ll have the opportunity to get your questions answered in class. Students will also have a chance to work on practice exercises to apply their SQL skills firsthand. Instructors are available throughout the lesson to provide additional clarification or help with practice exercises.
At NYIM, our SQL bootcamp includes everything you need from course materials to a computer and necessary software for one affordable fee. Over two decades, we’ve developed a proven instructional model that includes project-based tasks with real-world applications and customized training materials. Secure your spot in our SQL bootcamp in NYC today!
This policy was updated on August 14, 2018.
Your privacy is important to us. It is the policy of NYIM Training to respect your privacy regarding any information we may collect from you across our website, https://training-nyc.com, and other sites we own and operate.
We only ask for personal information when we truly need it to provide a service to you. We collect it by fair and lawful means, with your knowledge and consent. We also let you know why we’re collecting it and how it will be used.
We only retain collected information for as long as necessary to provide you with your requested service. What data we store, we’ll protect within commercially acceptable means to prevent loss and theft, as well as unauthorized access, disclosure, copying, use or modification.
We don’t share any personally identifying information publicly or with third-parties, except when required to by law.
Our website may link to external sites that are not operated by us. Please be aware that we have no control over the content and practices of these sites, and cannot accept responsibility or liability for their respective privacy policies.
You are free to refuse our request for your personal information, with the understanding that we may be unable to provide you with some of your desired services.
Your continued use of our website will be regarded as acceptance of our practices around privacy and personal information. If you have any questions about how we handle user data and personal information, feel free to contact us.
By accessing the website at https://training-nyc.com, you are agreeing to be bound by these terms of service, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws. If you do not agree with any of these terms, you are prohibited from using or accessing this site. The materials contained in this website are protected by applicable copyright and trademark law.
In no event shall NYIM Training or its suppliers be liable for any damages (including, without limitation, damages for loss of data or profit, or due to business interruption) arising out of the use or inability to use the materials on NYIM Training’s website, even if NYIM Training or a NYIM Training authorized representative has been notified orally or in writing of the possibility of such damage. Because some jurisdictions do not allow limitations on implied warranties, or limitations of liability for consequential or incidental damages, these limitations may not apply to you.
The materials appearing on NYIM Training’s website could include technical, typographical, or photographic errors. NYIM Training does not warrant that any of the materials on its website are accurate, complete or current. NYIM Training may make changes to the materials contained on its website at any time without notice. However, NYIM Training does not make any commitment to update the materials.
NYIM Training has not reviewed all of the sites linked to its website and is not responsible for the contents of any such linked site. The inclusion of any link does not imply endorsement by NYIM Training of the site. Use of any such linked website is at the user’s own risk.
NYIM Training may revise these terms of service for its website at any time without notice. By using this website you are agreeing to be bound by the then current version of these terms of service.
These terms and conditions are governed by and construed in accordance with the laws of New York and you irrevocably submit to the exclusive jurisdiction of the courts in that State or location.
Each installment is charged to your card on file one week before the start of the associated course. The payment schedule may vary if the courses are taken in a different order.
|10% non-refundable deposit
|SQL Server Level I
|SQL Server Level II
|SQL Server Level III
|▴ Your 10% deposit has been applied, as well as the certificate discount of $150
|Total You Pay