Coding Academy Courses from SpringBoard Incubators Inc. & Urban League of Long Island
Urban League of Long Island and SpringBoard Incubators have launched a Pathway to Success Training Program to provide coding education in the tech industry. This initiative is designed for individuals interested in gaining essential programming and data analysis skills to prepare for careers in technology. The program offers comprehensive training in Python programming, Data Science/Data Analytics, and SQL Database Development, equipping participants with the necessary skills to enter the workforce with confidence.
Python Programming & Computer Science Fundamentals
Overview This course is designed for anyone at the beginner level of coding or is interested in learning the fundamentals of coding applications. Participants will learn to code applications in Python. No experience needed, easy pace, with a hands-on approach to coding Participants will also learn how to create interactive programs and leverage RESTful APIs from the Internet.
Learning Objectives: Application Development in Python, Understanding the Web & API(s) and JSON, coding Data-Driven Applications using real-world datasets.
Certification Exam (Recommended) from the Python Institute
PCEP™ – Certified Entry-Level Python Programmer
(Exam PCEP-30-0x)
PCEP™ – Certified Entry-Level Python Programmer certification shows that the individual is familiar with universal computer programming concepts like data types, containers, functions, conditions, loops, as well as Python programming language syntax, semantics, and the runtime environment.
Data Science / Data Analyst
Build a Data Analytics Dashboard using Python / Flask
Overview: This course is designed for anyone interested in learning about data, data science, data visualization, and coding. Take this course and learn all that is needed to lay a solid foundation and prepare you in becoming a data analyst.
Learning Objective: In this course you will learn various data and statistical analysis concepts, such as: population, sample, data sets, variables, types of data, i.e. numerical, categorical. Collect (extract) data from multiple sources, and ready for submission to workflow. Utilize data manipulation tools & techniques to create data insights. Participants will gain an understanding and expand on the use of Excel, Tableau, Seaborn, Pandas, Sci-kit Learn, and NumPy for statics and preprocessing. Coding environment & tools: VS Code, Google Colab, and Tableau.
Myth busting: You don’t need to be a math genius to become an effective Data Scientist, you just need to learn the tools, when and how to use them.
Certification Exam (Recommended) from the Python Institute
PCED™ – Certified Entry-Level Data Analyst with Python
(Exam PCED-30-0x)
The PCED certification validates comprehensive knowledge and skills in foundational data analytics, specifically tailored around Python. This certification assures proficiency in the entire spectrum of data handling from acquisition, pre-processing, validation, and preparation, through to analysis, modeling, and visualization.
SQL – Database Design & Development
Overview: This course provides a comprehensive introduction to database design and management, with a focus on relational databases and their application in large-scale systems.
Learning Objectives: By the end of this course, students will gain knowledge in the following topics.
Foundations of Database Systems: Understand the core principles of database systems, including the relational model, high-level database models, and design theory for relational databases.
SQL Proficiency: Gain practical skills in SQL, including CRUD operations, algebraic and logical query languages, and using SQL Workbench to interact with databases effectively.
Advanced Database Management: Explore advanced SQL topics such as views, indexes, and working in a server environment. Learn how to create a database web application and manage it effectively.
Database Administration and Security: Develop expertise in database administration, including granting privileges, securing databases, and implementing data backup and recovery strategies.
NoSQL and Beyond: Explore the world of NoSQL databases, data warehousing, and scaling relational databases. Understand the relevance of big data technologies in modern database management.
Semi-structured Data Handling: Learn to work with semi-structured data models, including XML and JSON, as well as specialized databases like graph databases and time-series databases.
Project Development and Optimization: Apply the knowledge gained throughout the course to design, develop, and optimize a database-backed web application. Gain hands-on experience in resolving performance bottlenecks, query optimization, and fine-tuning database parameters for efficiency.
Certification Exam (Recommended) from Oracle
MySQL 8.0 Database Developer Oracle Certified Professional Certification Overview
An MySQL 8.0 Database Developer Oracle Certified Professional credential acknowledges that the candidate has the required knowledge and skills to use connectors and APIs and how to support data-driven applications using the MySQL database. This certification shows that the professional can design, develop, and maintain MySQL schema objects and control transactions in SQL and applications. It also demonstrates the mastery of the professional on how to optimize query performance, create and execute stored programs, and manage JSON and document store.