This program bundles a series of three courses, including SQL Databases, Introduction to Python and Software Development Using Python. Course instruction includes 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 explore career options and use employability skills, including 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 write database applications, perform administrative tasks and generate reports. Introduction to Python, Units 1-3 are designed for students with no programming skills. Learners 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 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; and 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; use concepts such as data types, variables and user input; build functions, use operators and use conditional statements; build while loops and increment variables; troubleshoot errors; and 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; and 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 and dictionary data structures; build maintainable and distributable functions and files; use standard documentation practices; and 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; and demonstrate basic ability to automate essential day-to-day tasks with Python scripts

Outline of Instruction

SQL Databases: Background; Creating and Populating a Database; Query Primer; Filtering; Querying Multiple Tables; Working with Sets; Data Generation, Manipulation and Conversion; Grouping and Aggregates; Subqueries; Joins Revisited; Conditional Logic; Transactions; Indexes and Constraints; Views; Metadata; Analytic Functions; Working with Large Databases; SQL and Big Data; and Certification Exam Preparation

Introduction to Python - Unit 1: Python and Jupyter Basics, Functions, Conditionals, Nesting and Loops, and Final Evaluation

Introduction to Python - Unit 2: Sequence Indexes, Sequence Manipulation, Sequence Iteration, Working with Files and Final Evaluation

Introduction to Python - Unit 3: Python Modules, More-Powerful Statements, Methods and Structures for Robust Code, Proper Functions and Final Evaluation

Software Development Using Python Workshops: Vital Python - Math, Strings, Conditionals and Loops; Python Structures; Executing Python - Programs, Algorithms and Functions; Extending Python - Files, Errors and Graphs; Constructing Python - Classes and Methods; The Standard Library; Becoming Pythonic; Software Development; and Certification Exam Preparation

Contact Hours

115

CEUs

Yes

Industry Standard, State or National Certification

Certification

Certiport

Website

• IT Specialist Python (https://certiport.filecamp.com/s/i/9Th6LzRzeAhrdCP7); IT Specialist Databases (https://certiport.filecamp.com/s/i/ITS_Databases)

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 and operations using modules and tools

IT Specialist Databases: Database design, database object management using DDL, data retrieval, data manipulation using DML and troubleshooting

CE or 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.

Learning Supplies Needed

The course registration includes all textbooks and labs.

Clinical Site/Special Facilities

N/A

Requirements for Successful Completion

90% attendance
Demonstrate an understanding of at least 80% of course material taught

Accreditation/Special Approval Requirements

N/A

Intended Audience

Individuals who want to expand their knowledge and skills for employment readiness or those who want to prepare for 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

CIS-3100L2

CSC-3110EI2

CSC-3110EJ2

CTS-3255A2

NET-3100O2

CSP-4000DU2

Course Contact Information

Alison Consol
919-866-5393
[email protected]