IT Certifications

Many non-degree IT courses align with Wake Tech’s IT degree programs, which means you can take certain “non-degree” courses and still earn college credits for that course, if you enroll in a qualifying degree program.

Financial Assistance Available!

You may qualify for a scholarship through the WakeWorks Propel program!

Learn more and apply for a WakeWorks Propel Scholarship


 

IT Power Packs: Level Up Your Life!

Ready to take your IT 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 brand 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! 

Wake Tech's IT Power Packs are part of the WakeWorks Propel scholarship program, which means you may qualify to receive up to $750 to pay for course registration, books, certification fees, etc.

Learn more about WakeWorks Propel here

Let's get started! 

Select a Power Pack from the list below to register.

Course
Software Developer Using Python
Name
CSC-3110EH2
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
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 titled 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 MTA Database Fundamentals and Python certification exams.
Course Objectives
  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  1. 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
  2. Introduction to Python - Unit 1:
    1. Python and Jupyter Basics
    2. Functions
    3. Conditionals
    4. Nesting and Loops
    5. Final Evaluation
  3. Introduction to Python - Unit 2:
    1. Sequence Indexes
    2. Sequence Manipulation
    3. Sequence Iteration
    4. Working with Files
    5. Final Evaluation
  4. 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
  5. 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
Microsoft
Website URL
• Exam 98-381: Introduction to Programming Using Python - https://docs.microsoft.com/en-us/learn/certifications/exams/98-381 • Exam 98-364: Database Fundamentals - https://docs.microsoft.com/en-us/learn/certifications/exams/98-364
Certification Learning Outcomes/Requirements
  1. Exam 98-381: Introduction to Programming Using Python:
    • Perform Operations using Data Types and Operators
    • Control Flow with Decisions and Loops
    • Perform Input and Output Operations
    • Document and Structure Code
    • Perform Troubleshooting and Error Handling
    • Perform Operations Using Modules and Tools
  2. Exam 98-364: Database Fundamentals:
    • Understanding core database concepts
    • Create database objects
    • Manipulate data
    • Understand data storage
    • Administer a database
CE to CU Articulation
No
Prerequisites
Prior to course enrollment, students should have the ability to demonstrate technological literacy in alignment with the Technology Basics: IC3 Digital Literacy or have equivalent knowledge and skills.
Text and Supplies Needed
The course registration includes all textbooks and labs.
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 90% or above
  2. Participation
  3. 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
  • SQL: Structured Query Language Introduction - SEF-3001GH2
Course Contact Information
Jennifer Simmons-Bage
919-532-5915