Learn to extract information 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.
Learn to extract information 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.
Learn the essential skills needed to become a Data Analyst or Business Analyst, including data analysis, data visualization, and statistical analysis. Gain practical experience through real-world projects and prepare for a successful career in the field of data analytics.
Learn how to extract information from databases and turn it into actionable insights by writing SQL queries, filtering data, and joining tables. This comprehensive SQL Server Bootcamp will teach you the fundamentals of SQL and how to apply them to various database systems.
Learn Python, SQL, automation, and machine learning to become a Data Scientist. Gain Python programming, data analysis, SQL querying, and predictive modeling skills. Perfect for beginners, this program prepares you for entry-level data science and Python engineering roles. Unlock high-paying job opportunities in the field of data science.
Learn to extract information 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.
As technology advances at an exponential pace, so have the complexities of running a business. As routine decisions become more challenging, the need for more advanced data analysis and business intelligence capabilities grows. Structured Query Language (SQL) is a programming language that allows you to easily organize and navigate immense databases. While there are many varieties of SQL, they all seek to do the same task: query, collect, and group data.
Learning SQL can also be one of the easiest ways to enter the programming world, and serves as a perfect foundation for learning other languages such as Java or Ruby. SQL is one of the easiest programming languages to learn, and many people can master the fundamentals of SQL in a matter of days.
Chicago is home to many large technology and data companies that rely on SQL every day. Data consulting and analytics corporations like Avant, KAR Global, and Prime TSR, present attractive career opportunities to those with a strong knowledge of SQL, along with other critical data science skills, like Python and machine learning. However, your options for a SQL job are far more expansive than working for one of these institutions. As the third most popular programming language in the world, SQL is used by companies like Google, Wells Fargo, Uber, Netflix, and Apple. Because SQL is so widely used, knowing it will make you more marketable as a candidate for work almost anywhere. SQL is also used in the finance and insurance sector, with major institutions like JPMorgan Chase, Northern Trust, CME Group, and Morningstar relying heavily on SQL databases to manage vast amounts of financial data, optimize trading systems, and generate analytical insights. Beyond finance, healthcare companies in Chicago also depend on SQL for efficient data storage and analysis. Leading healthcare organizations such as Advocate Health Care, Northwestern Medicine, and Walgreens Boots Alliance use SQL to manage patient records, optimize resource allocation, and analyze health outcomes.
Learning SQL will prepare you for a highly paid career as a Data Scientist, Database Developer, Business Analyst, or Data Architect. A Chicago Data Scientist has an average yearly salary of $110, a Database Developer $97,000, and a Business Analyst $90,000. Oracle offers certifications that can set you apart in the field, including the Oracle Database SQL Certified Associate, Oracle Database PL/SQL Certified Associate, and Oracle Database PL/SQL Certified Professional certifications.
SQL Server Bootcamp
Noble Desktop’s SQL Server Bootcamp offers a robust curriculum intended to empower students with the skills needed for proficient data extraction and analysis across various database environments. The journey begins with an introduction to PostgreSQL, laying the groundwork for further learning in SQL Server, MySQL, and beyond.
Participants will start with essential database concepts and rapidly progress to crafting precise SQL queries. Instruction will cover how to seamlessly join data from disparate tables, apply filters to hone in on specific data subsets, and employ aggregation techniques to transform simple data into actionable intelligence.
As the course advances, students delve into more sophisticated topics such as constructing subqueries, manipulating strings with specialized functions, and controlling program flow using statements like IF-Else and CASE. The interactive learning experience is enhanced by using SQL Server Management Studio’s graphical interface, ensuring students gain hands-on experience with query execution and database management.
This in-depth bootcamp is specifically designed for individuals eager to leverage the capabilities of SQL in the realm of data analysis, providing a strong foundation for informed decision-making within any data-intensive field.
Data Analytics Technologies Bootcamp
The Data Analytics Technologies Bootcamp offered by Noble Desktop equips participants with a thorough understanding of the key tools and programming languages essential for a career in data analysis. Participants will delve into Excel, SQL, and Tableau, mastering techniques to collect, analyze, and interpret large datasets. The bootcamp’s practical approach includes real-world project work, which is instrumental in teaching students to organize and summarize data effectively, enhancing their ability to make data-driven decisions.
Learners will gain proficiency in Excel through advanced formulas and functions and PivotTables for data visualization. SQL training will cover sorting, filtering, and summarizing data, along with advanced queries and database procedures. Tableau sessions will focus on data manipulation and the development of visual dashboards. The program also includes training on SQL subqueries, using views, the CASE statement for conditional logic, and understanding functions and stored procedures, ensuring a comprehensive learning experience.
Chicago businesses that want to get formal SQL training for employees are in luck. Beyond the classes listed here, Noble Desktop offers customized solutions for corporate customers. If your business or organization needs specialized training in SQL delivered onsite or virtually, check out the class options available from Noble Desktop. These include three levels of SQL instruction, as well as a SQL Bootcamp that packages them all together.
Noble’s instructors will work with you to design a program that meets the needs of your organization. In addition, Noble Desktop offers group class vouchers to enable employers to send their employees to a scheduled group class session. For more information about Noble’s corporate SQL training, contact corporate@nobledesktop.com to speak with a consultant.
In the heart of the Midwest’s finance capital, there’s opportunity everywhere. From tech startups in Fulton Market to powerhouse Fortune 500 firms in the Loop, Chicago offers a virtually endless array of ways to level up your skills in tech, business, data, and design. The city thrives on bold ideas, making it the perfect place to grow a career that is not only lucrative but also makes a real impact. With expert instructors with decades of experience, you’ll learn more about the subjects you’re interested in, all while receiving hands-on training. These instructors live and breathe to explore and work within their field, meaning they don’t just teach; they mentor, guide, and connect you to the heart of Chicago’s many successful industries and direct you to the most meaningful path to help you achieve your goals.
Noble Desktop’s partner school, Practical Programming, has state-of-the-art facilities conveniently located in downtown Chicago’s iconic Hayworth Building at 29 E. Madison Street, Chicago, IL, 60602. It’s an easy-to-find location for students from across the city to attend. The campus is modern, equipped with the necessary tech and tools you may need, and provides resources like Wi-Fi, comfortable workstations, and expert instructors and staff ready to help you learn. Getting there is simple, whether you’re commuting from the Loop, River North, or surrounding areas. The school is easily accessible from the CTA trains and buses, with nearby stops for major lines like the Red, Blue, and Brown. If you’re driving, you can park nearby at various parking decks and metered spots within walking distance. The central location means you won’t have to stress about making it to class, and that your training sessions can fit into any schedule with ease.
SQL powers the databases behind many of Chicago’s corporate and civic systems, from analytics teams to finance departments. With this, the instructors at Noble Desktop work to help students understand how to write queries and manage data the way practitioners do in real jobs.
Henry Gonzalez is a certified Project Management Professional (PMP) with over 30 years of experience in the federal government, leading engineering, program management, and acquisition initiatives in naval warfare, air traffic management, and homeland security. A retired senior executive, Henry now serves as a part-time instructor in Chicago, where he teaches project and program management, leadership, and strategic planning to professionals of all kinds. He holds the highest level of federal certification one can hold for acquisition program management and systems engineering. In addition, Henry was part of the core team that updated the Project Management Institute’s Standard for Program Management. Henry is also a certified Balanced Scorecard Professional and holds a Bachelor of Science in Ocean Engineering from Florida Atlantic University, along with a dual Master of Science in Ocean Engineering and Ocean Systems Management from MIT.
Robert Simon is a highly accomplished financial management professional and educator with more than four decades of federal and private sector experience. As a Financial and Management Curricula Instructor at Graduate School USA since 2007, he teaches courses in financial management, federal travel regulations, and organizational leadership, both virtually and in person. Prior to his teaching career, he held senior roles at the General Services Administration, overseeing a six-state regional budget of approximately $100 million, and at the U.S. Treasury’s Financial Management Service, where he led national training initiatives on electronic banking. Robert’s background spans accounting, budgeting, and program analysis, holding certifications as a Certified Public Accountant and Certified Government Financial Manager.
Edward (Scott) Dillion is a seasoned financial expert with over three decades of experience in the Department of Defense, where he specialized in a range of financial management areas like budgeting and auditing, as well as performance-based management and cost analysis. He holds an MBA from Southern Illinois University and a B.A. in Business Administration from Grove City College. After retiring in 2014, Scott pivoted to a second career in education and consulting. He teaches project management and marketing at Graduate School USA and has also taught courses in federal budgeting. Additionally, Scott serves as a Subject Matter Expert (SME) for Management Concepts Inc., where he helps develop financial management course materials. He also has a lifetime membership with the American Society of Military Comptrollers, holds a Top Secret security clearance with the Department of Defense, and is a recognized Tier 2 instructor at Graduate School USA for his wealth of experience.