SQL Level I
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.
Took the SQL level 1 course with no prior knowledge. It was extremely helpful and it went a pace slow enough for me to understand, while being fast enough that I did not get bored.
SQL Level 1 is a great course to introduce you to writing SQL queries. Starting with the basics, by the end you will understand complex queries with inner or outer joins. Peter was our instructor and his customized course material is very well laid out with practical examples. You work on a local sample database, so you can type notes and test your queries to better understand the output you get. The facility is neat, the equipment is fairly new and ready to use, and beverages are provided.
This class was a great introduction. The instructor made the material relevant and fun. He did a great job reinforcing the basics and laying the groundwork to continue advancing with next course levels.
Very informative, great teacher, one good thing is you can retake once for no cost.
I took a SQL level 1 class on a Saturday and it was soo helpful. The instructor was humorous, extremely knowledgeable, and was an efficient communicator. He knew exactly how SQL was utilized in a real-world business aspect and was able to give examples of times you'd need to use certain queries and how they can be used most effectively.
I took SQL Levels 1, 2 and 3 with Peter. He is a great instructor who provides practical training you experience with databases. He was very clear with the explanations. Highly recommended!
The class was very informative, the instructor was very detailed & I highly recommend the course for all SQL beginners.
Great beginners class! The instructor was entertaining as she taught. Learned the fundamentals! I would definitely recommend this course.
I took the SQL Level 1 course and had a great experience. The course was very thoughtfully laid out, with easy to follow materials provided. The teacher was great and answered all questions well. Overall, I definitely recommend the course and will be taking more courses from NYIM in the future.
I felt that this class was a great introduction to SQL, coming from someone who had very little exposure to it before the class. They broke it down for us in a very comprehensible manner and provided examples along the way that we could practice. I look forward to taking Level 2!
The SQL I class was thorough, enjoyable, and made learning SQL easy! Will definitely continue the SQL courses and come back for Python. Great teachers and classrooms.
SQL level one is very comprehensive and covers a lot of ground.
Jeanette is a really wonderful teacher who is very helpful and explains SQL material very well.
I had self taught myself SQL while on the job a couple of years ago. I took this as a refresher since I haven't used SQL in a while and I left learning a lot more b/c I finally understood why everything worked a certain way.
My experience at Career Center was extremely valuable. In one day I was able to feel confident querying databases to get desired results and perform analysis. Real-world examples make the experience even more valuable.
I would definitely use the service again, considering current events, the team has been very helpful.
Jeannette took her time and used real world examples to highlight the usefulness of the material.
As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.
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.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
The class was very informative, the instructor was very detailed & I highly recommend the course for all SQL beginners.
— Kevin M.
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 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.
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 Level I with your selected courses.
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results so you can turn data into actionable insights.
Build on your knowledge of SQL fundamentals and enhance your skills to filter, group, and analyze data in this intermediate SQL course.
Take your SQL skills to the next level in this advanced course. You’ll learn about subqueries, views, variables, functions, stored procedures, and more.
If you want to master intermediate and advanced functions of Microsoft Access quickly, the bootcamp is the perfect place to start. In this two-day, 14-hour course, you’ll go from learning the Access interface to using advanced reporting techniques.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
SQL is the most commonly used coding language in databases around the world. SQL Level I covers the fundamentals of relational databases, Microsoft SQL Server, and the SQL database language. Learn how databases store data within tables and how to write queries to understand data.
Our experienced instructor will guide you through a variety of queries, including wildcard filters and multi-table queries with inner and outer joins. At the end of the class, apply the skills you’ve learned in a series of practice tasks. Our course workbook includes step-by-step instructions for each activity so you can brush up on the tasks at work or home.
At the end of this course, you’ll be able to do the following:
Is your ultimate goal to become a SQL pro? Go from Beginner to Expert in three days with our SQL bootcamp. You’ll start out with the same basic training in SQL fundamentals, and quickly move to advanced functions. Best of all, you’ll save 15%!
At NYIM, we provide everything you need for SQL Level 1. Exploring SQL and not sure if you’re ready to commit? This is the perfect course for you. We supply computers (PC), SQL software, and course workbooks for each student that enrolls in our classes.
Within one year of completing the class, you can retake the course again at no additional charge. SQL Level 1 is the perfect course for beginners or individuals that would like to know the basics of databases and queries.
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.
The first installment is due one week before the first class. Subsequent installments are spread out evenly across the duration of the course.
|10% non-refundable deposit|
|$350.00||Total You Pay|