Information Technology

The Non-Credit Computer Education Department delivers basic and advanced technology training so you can learn a new skill or earn an industry-recognized credential to level up to your next job. 

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.

View IT Courses for Certification

Course Details & Registration Information for All IT Courses

Course
Software Developer Using Python
Name
CSC-3110EH2
Available Classes
    Section Location Begin Date End Date Instructor Price
250023 Face-to-Face Online Instruction 09/13/2021 01/26/2022 J. Whitmire $365.00
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