This course provides comprehensive training in SQL Server, with the aim of helping students achieve their certification in the language upon completing the course. This course covers basic, intermediate, and advanced SQL techniques, meaning students will start by learning core database concepts and the differences between major types of SQL (as well as their ideal use cases).
Intermediate and advanced training will cover advanced analysis techniques, including how to work with joins, data types, aggregate functions, and date/time operations to uncover deeper insights and organize complex datasets. Students will learn to write sophisticated queries and utilize techniques like subqueries, CASE expressions, views, functions, and stored procedures. Taken together, these are all key skills for roles in data analysis, data science, and database management.
This course aims to ensure that students, regardless of their skill level, are prepared to work with SQL Server in a professional capacity upon completing the course. Each student will receive a certificate of completion upon graduation, and they will be able to work alongside certified trainers and experts as part of the live course structure.
This is the recommended order, but some courses may be taken in a different order.
Unit 1 6 Hours
This beginner-level SQL course introduces the foundational concepts of structured query language and relational databases. Through hands-on exercises and the use of SQL Server Management Studio, you'll learn how to write, filter, and structure queries to extract meaningful insights from data.
Unit 2 6 Hours
This intermediate SQL course expands your ability to analyze and manipulate data through advanced querying techniques. Learn to work with joins, data types, aggregate functions, and date/time operations to uncover deeper insights and organize complex datasets.
Unit 3 6 Hours
This advanced SQL course is designed for professionals ready to deepen their expertise in data querying, logic, and database development. Learn to write sophisticated queries using subqueries, CASE statements, views, functions, and stored procedures, all key skills for roles in data analysis, data science, and database management.
OVER and PARTITION BY to apply aggregate logic across rows without groupingCASE and IIF statements to dynamically transform query resultsSUBSTRING, CHARINDEX, UPPER, and moreFrom our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Great PowerPoint slides and really good exercises. Excellent class overall!
Great instructor. Very knowledgeable, easy to follow instructions, interactive, knows when to pause, slow down, or speed up.
Dan was an excellent instructor—well-organized, patient, and thoughtful in his teaching approach. I especially appreciated how he broke down the reasoning behind SQL code in a way that was both clear and practical. Rather than simply having us memorize lines of code, he focused on helping us truly understand the concepts and develop a problem-solving mindset. His approach made the learning experience much more meaningful and effective.
Dan was a great teacher, and everything was explained in detail, which made it easy to understand.
Dan is easy to follow, kind, and easy to understand. I will definitely be back for SQL 2 and 3.
I really enjoyed the class and would recommend it to anyone looking to sharpen their SQL skills. Although it is a full-day class, I felt like enough breaks were given, and the content was not overwhelming. The instructor was also extremely helpful. He provided feedback to everyone who submitted answers in the chat.
The teacher is a very patient, kind, and knowledgeable person.
Mr. Garfield was easy to work with, understanding, and explained everything clearly for a thorough understanding. Thank you for the explanation and details of how everything comes together.
I have been studying SQL for several months, and keep getting stumped. I think this is a great class, and it helped me understand a little more clearly. I still have a long way to go, but this was great.
I use MSSQL for my job and this was a great refresher, not to mention a chance to learn some new tricks. The instructor was great and her patience was spot on for everyone, it seems!
Jeannette is on top of SQL. She is a very good instructor and knows what she is doing. Her approach to is easy to follow and understand.
Jeannette is an awesome instructor!
I love Jeannette. I can tell that she really knows the software programs well and knows that there is a variety of methods to get to the same result. That enables her to be very helpful to students who are exploring the software and are thinking of how to do things in the best way they can.
The class content is well designed and the examples for practice are great, really excellent so far. I am encouraged that by the time I complete this bootcamp, I will be on the super highway for Data Analysts.
I learned more than I expected and am impressed by the live online training course. Jeannette was extremely knowledgeable. She took time to explain everything while constantly encouraging us to ask questions. I really appreciate how she incorporated a few personal stories because it helped me understand how things work in the real world. I really enjoyed this first course because of her.
Instructors at Noble Desktop are devoted to their students!
Genghis was AMAZING. He was so clear in his explanations, and especially helpful if you had a specific question. I am in an online bootcamp now and his instruction was fantastic and helped me tremendously. Great format to offer practice SQL exercises, and then review with the instructor.
Showing 17 of 17 reviews
Learn the concepts and skills covered in this true or your tuition is on us. See details and terms & conditions.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
The teaching method at Noble Desktop is perfect and the classes provide you with infinite knowledge that makes you eager to take everything they offer. I love Noble!
—Ivonne Ackerman
Experienced educators who are driven to help you succeed
Refresh the materials for free within one year
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 Noble Desktop, 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 185 Madison Ave, 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!
Shareable on
We offer a single free retake of 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.
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 payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Sorry, but this training is not available online.
You have some options:
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
This program is a discounted package of classes that is 15–25% off the individual class prices, so additional discounts do not apply.
