Learn the fundamentals of SQL (Structured Query Language) and relational databases, so you can start writing SQL queries to extract and understand the information stored in databases.
This SQL starter course will provide you with strong foundational skills to explore the tables, columns, and rows stored in a database and write/code SQL queries to extract and start analyzing that data. Using practical, hands-on exercises, our expert instructor will guide you through understanding the basics of database architecture and will develop your skills in writing real SQL code.
You’ll learn how to write SELECT statements to choose the specific columns you want from tables, start filtering the results using WHERE, AND/OR, IN, and NOT. You’ll learn how to use wildcard filters as well as mathematical comparisons like equals, greater than, less than, etc. to retrieve only the data you want. Finally, you’ll combine data from multiple tables with inner JOINs.
By the end of this introductory hands-on course, you’ll be able to write basic SQL queries for Microsoft SQL Server. You’ll learn how to use the free SQL Server Management Studio app to explore the database and execute your SQL queries. The concepts you’ll learn on SQL Server can be applied to other flavors of SQL (such as Microsoft Access, PostgreSQL, MySQL, etc.) with minor syntax differences.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
This is a good guide to getting started with SQL coding. With this foundation, detailed SQL coding will be much easier to absorb as needed.
Jeannette was an amazing instructor! Great explanations compared to other trainings I have participated in. Explained why we did things in SQL, not just how to do them.
I learned more than I expected and am impressed by this live online training course. Jeanette 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 helps me understand how things work in the real world.
Great instructor who was excited about the material and taught in a way that was engaging and interesting. I really enjoyed the examples provided to show how you can apply these SQL queries to workplace situations.
I've tried to learn SQL from courses, in books, and in asynchronous online courses. However, it was only after listening to this instructor that the material made sense. This has been helpful for me in my employment already.
NYC Career Centers's training environment at its Madison Ave location is very good. I took the SQL Server Bootcamp course that was presented by a very professional instructor (Dan) and the scope of each SQL lesson was well-planned.
Highly recommend introduction to SQL course. I thought it was well-paced, and Dan Rodney was well-spoken, easy to understand, and helpful!
Dan was a phenomenal instructor. He was patient, repetitive, and explained the logic behind the structure of the code instead of getting us to simply memorize it.
The instructor was attentive to both those online and in the classroom, and made an otherwise dry topic interesting and understandable. He is a very good instructor and it was obvious that he is knowledgeable.
The instructor was super patient and knowledgeable. She made sure to go step by step and made sure that no one in the class fell behind. Didn't make anyone feel bad for missing anything either. She's absolutely great!
Excellent instructor, very knowledgeable. Jeannette does a great job at explaining and checks that everyone is following along. The PowerPoint presentation she used was very helpful.
There was a LOT of content quickly, but that is good. We got our money's worth. Jeanette was easy to follow and pleasant to learn from. She was clear and concise which was great since we moved so fast. She checked on us often and paused for questions or to let us catch up.
Will definitely recommend NYC Career Centers to my Administrative Officers and encourage other staff to attend this course, which was well developed in scope, process, and procedures. NYC Careers Centers has put together an online platform that is VERY user-friendly, in order for students to participate in learning the content.
Great class! Thorough and took time to answer all my questions.
This class is a great introduction to the basics of SQL database querying.
This class was relevant to what I'm doing at work. It gave me more confidence in SQL and taught me things that I wouldn't have even known to Google.
Great class. The instructor constantly asked if anyone needed help - very attentive.
The class is very straight forward and easy to follow along. I learned new useful tricks I was not aware of before taking this class.
Jeanette was great. She was very thorough and enthusiastic!!
Overall, I would recommend this class. It's worth taking and definitely perfect for someone new to SQL.
Really helped me understand SQL better and improve my skill base.
Super helpful in giving me the foundations for SQL.
The class was uniquely helpful in pointing out applications of the material we covered in the real world. Clearly experienced instructor.
The course exceeded my expectations! A lot was placed into perspective for me as a moderate SQL user. The location and facility is very convenient. The class size is perfect.
I would recommend this class to anyone at any level
Showing 25 of 29 reviews
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
Learn with real-world projects
Step-by-step instruction to boost retention
The Career Centers instructors are highly skilled communicators who really know their craft. They are wonderful about explaining and re-explaining when necessary and I never felt rushed or foolish for asking a question.
—Diane Speros
Gain industry knowledge from professionals
Retake the course 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 NYC Career Centers, 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!
Shareable on
We offer a single free retake of the class 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.
Learn practical skills by working on real projects with instructor guidance and lectures to strengthen and improve your skill.
.png)
.png)
.png)
In this hands-on course you’ll learn to get started with 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 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.
In this training you’ll learn Microsoft SQL Server, but the core concepts can be applied to other flavors of SQL (such as PostgreSQL, MySQL, etc.) with minor syntax differences.
You are not required to complete any work outside of class.
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.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
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.
We don’t currently offer discounts as we do our best to affordably prices our courses.
We offer custom onsite training and discounted class vouchers.
corporate@nobledesktop.com
