IT Certifications
Ready to take your information technology skills to the next level? Wake Tech's IT Power Packs are bundled, low-cost training programs designed to help you earn industry-recognized credentials. Each Power Pack can be completed in about four to six months.
Power Packs aim to prepare you for the next step in your career, whether you are new to the IT field or a mid-career professional looking to level up. And, if you want to take your knowledge even further, the credentials you earn in a Power Pack can count for college credit in a degree program at Wake Tech.
Financial assistance available
Don't have enough money to pay for a course? See if you qualify for funding through Wake Tech's Propel program.
Course descriptions and registration information
Course
Software Developer Using Python
Name
CSC-3110EH2
Overall Quality of This Course
★★★★★
Based on 17 student surveys.
Available Classes
Intended Audience
Individuals who want to expand their knowledge and skills for employment-readiness or those who want to successfully prepare for the relevant industry certification exam(s).
Description
This program bundles a series of three courses, including SQL databases, Introduction to Python, and Software Development Using Python. Course instruction will include both technical and employability skills training to prepare participants for workforce readiness or industry certification to meet the very high demand for these types of occupations in the local labor market. Participants will explore career options, use employability skills, which will include knowing how to provide good customer service to meet employer needs, identifying effective communication strategies, and using collaborative teamwork. In the SQL Database course, students will write database applications, perform administrative tasks, and generate reports. Introduction to Python, Unit 1 through Unit 3 are designed for students with no programming skills. Learners will practice coding in an online environment and develop their knowledge and skills using data structures such as strings, lists, and range sequences, as well as methods for working with these structures. In Unit 3, course participants will build on prior skills by developing sustainable code. Software Development Using Python allows students to build upon prior skills to help automate tasks by creating games and desktop applications. Students should also be prepared to take and pass the relevant certification exams.
Course Objectives
- SQL Databases:
• Use SQL data statements to generate, manipulate, and retrieve data
• Create database objects, such as tables, indexes, and constraints with SQL schema statements
• Use datasets to run queries for specific outputs
• Explain the importance of subqueries
• Convert and manipulate data with SQL’s built-in functions and use conditional logic in data statements - Introduction to Python - Unit 1:
• Learn basic programming concepts
• Perform online exercises in the Jupyter Notebook development environment
• Develop and run programs in Jupyter Notebooks
• Utilize concepts such as data types, variables, and user input
• Build functions, use operators, use conditional statements
• Build while loops, increment variables
• Troubleshoot errors
• Complete coding assignments related to the content of each module - Introduction to Python - Unit 2:
• Access string and substring content
• Iterate through strings
• Create, access, modify, and delete lists and list items
• Create numeric iteration
• Extend, sort, and reverse lists
• Convert between strings and lists
• Split and join lists
• Import, open, and navigate through files
• Read and write to files
• Complete coding assignments related to the content of each module - Introduction to Python - Unit 3:
• Implement Python modules for system navigation, math, and date-time calculations
• Apply more-powerful statements using compound conditionals (and/or), identity (is), and negation
• Apply complex operator precedence
• Precisely format print output
• Manage errors as a natural part of running code
• Solve problems requiring data collection and recall by using Tuples & dictionary data structures
• Build maintainable and distributable functions and files
• Use standard documentation practices
• Complete coding assignments related to the content of each module - Software Development Using Python:
• Know how to use classes and object-oriented programming
• Write clean and concise code with Python 3
• Create engaging visualizations
• Use Python to create responsive, modern web applications
• Demonstrate basic ability to automate essential day-to-day tasks with Python scripts
Outline of Instruction
- SQL Databases:
1. Getting Started
2. A Little Background
3. Creating and Populating a Database
4. Query Primer
5. Filtering
6. Querying Multiple Tables
7. Working with Sets
8. Data Generation, Manipulation, and Conversion
9. Grouping and Aggregates
10. Subqueries
11. Joins Revisited
12. Conditional Logic
13. Transactions
14. Indexes and Constraints
15. Views
16. Metadata
17. Analytic Functions
18. Working with Large Databases
19. SQL and Big Data
20. Certification Exam Preparation - Introduction to Python - Unit 1:
1. Python and Jupyter Basics
2. Functions
3. Conditionals
4. Nesting and Loops
5. Final Evaluation - Introduction to Python - Unit 2:
1. Sequence Indexes
2. Sequence Manipulation
3. Sequence Iteration
4. Working with Files
5. Final Evaluation - Introduction to Python - Unit 3:
1. Python Modules
2. More-Powerful Statements
3. Methods and Structures for Robust Code
4. Proper Functions
5. Final Evaluation - Software Development Using Python Workshops:
1. Vital Python – Math, Strings, Conditionals, and Loops
2. Python Structures
3. Executing Python – Programs, Algorithms, and Functions
4. Extending Python, Files, Errors, and Graphs
5. Constructing Python – Classes and Methods
6. The Standard Library
7. Becoming Pythonic
8. Software Development
9. Certification Exam Preparation
Contact Hours
115
CEU's
11.5
Industry Standard, State, or National Certification
Yes
Certification
Certiport
Website URL
• IT Specialist Python - https://certiport.pearsonvue.com/fc/ITS/python
• IT Specialist Databases - https://certiport.pearsonvue.com/fc/ITS/database
Certification Learning Outcomes/Requirements
- IT Specialist Python:
• Operations using Data Types and Operators
• Flow Control with Decisions and Loops
• Input and Output Operations
• Code Documentation and Structure
• Troubleshooting and Error Handling
• Operations Using Modules and Tools - IT Specialist Databases:
• Database Design
• Database Object Management using DDL
• Data Retrieval
• Data Manipulation using DML
• Troubleshooting
CE to CU Articulation
No
Prerequisites
Prior to course enrollment, students should have demonstrated knowledge and skills in alignment with the Technology Basics for Digital Literacy course.
Text and Supplies Needed
The course registration includes all textbooks and labs.
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
- Attendance 90% or above
- Participation
- Demonstrate an understanding of at least 80% of course material taught.
Accreditation/Special Approval Requirements
Intended Audience
Individuals who want to expand their knowledge and skills for employment-readiness or those who want to successfully prepare for the relevant industry certification exam(s).
Specific Industry or Business Support Needs
Software Developer, Computer Programmer, Information Technology Analyst (IT Analyst)
Wake County Need for Industry Positions
According to Burning Glass Technologies, Wake County has a very high demand for these job titles.
Industry or Job Titles Related to training Outcomes for Employment
- Software Engineer
- Software Developer
- Computer Programmer
- Information Technology Analyst (IT Analyst)
Related Courses
- Computer Technology Basics for Digital Literacy - CIS-3100L2
- Web Programmer Using HTML5, CSS, and JavaScript - CSC-3110EI2
- Web Programmer Using Python and Django - CSC-3110EJ2
- IT Support Technician - CTS-3255A2
- Network Technician - NET-3100O2
- Microsoft Windows 10 - CSP-4000DU2
Course Contact Information
Connect
Wake Tech eNewsWake Tech Podcast
Wake Tech Mobile App