Programming   

Learn advanced JavaScript concepts and their applications, key skills for any web developers.

This course will teach you the foundations of JavaScript framework like React, Vue.js, jQuery, or Angular, all of which use some advanced JavaScript techniques. Key topics include block-scoped variables, constants and arrow functions.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 11.0 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn advanced JavaScript concepts and their applications, key skills for any web developers.

1. Node.js
2. Scope, var, let, and const
3. Arrow Functions
4. Rest Parameters
5. Spread Operator
6. Array Destructuring
7. Template Literals
8. Objects
9. The Object
10. Array map() Method
11. Array filter() Method
12. Array find() Method
13. JavaScript Modules
14. npm

What you will learn

• Rest parameters
• The spread operator and array destructuring
• Objects, Context, and the object
• The map(), find(), and filter() methods of arrays

How you will benefit

• Prepare to learn JavaScript framework.

In the C++ Programming course you'll learn fundamental programming concepts, including decision making, looping, and classes, with the support of practical, step-by-step examples.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment. The following textbooks will be shipped to you approximately 7-10 business days after enrollment:

• C++ Programming: From Problem Analysis to Program Design

Please note: You will receive a digital book if the physical book is on backorder.

Many of today's popular desktop, web, and mobile apps were developed with the C++ programming language. With software development roles expected to grow at 22 percent from 2012-2022, learning C++ is an important first step to a career in computer science.

This course is designed to introduce you to the concepts, terminology, application, and coding of the C++ programming language. This course consists of 18 lessons that use text, full programming scenarios, instructional videos, and hundreds of live coding labs that give you real-time feedback on your work. You will learn fundamental programming concepts, including decision making and looping, with the support of practical, step-by-step examples.

After working through these lessons, you will understand the basics of structured and object-oriented programming techniques. Most importantly, you will be able to build C++ programs to strengthen your developer portfolio.

1. Overview of Computers and Programming Languages
2. Basic Elements of C++
3. Input / Output
4. Control Structures I (Selection)
5. Control Structures II (Repetition)
6. User-Defined Functions
7. User-Defined Simple Data Types, Namespaces, and the string Type
8. Arrays and Strings
9. Records (structs)
10. Classes and Data Abstraction
11. Inheritance and Composition
12. Pointers, Classes, Virtual Functions, and Abstract Classes
13. Overloading and Templates
14. Exception Handling
15. Recursion
16. Searching, Sorting, and the vector Type
17. Linked Lists
18. Stacks and Queues

What you will learn

• How to write C++ programs utilizing proper coding techniques
• How to apply problem solving methods
• Important programming terminology

How you will benefit

• Have a solid understanding of C++ language can lead to more advanced programming languages
• Meet the standard job requirements for an entry-level software development career by understanding how to write C++ programs
• Know how to use your knowledge in C++ programming to solve industry-specific problems and advancing your career in this field

Jeffrey A. Kent

Jeffrey A. Kent is a Professor of Computer Science, teaching both traditional and online classes. He has taught a number of computer programming languages, including C, C++, Java, Visual Basic, and Assembly. He is the published author of several computer-programming books, including "Visual Basic 2005 Demystified" and "C++ Demystified." He is also an attorney and has combined both careers by writing applications for law firms.

This course is intended for IT professionals who would like to better understand AWS Cloud concepts, core AWS services, and those looking to gain more knowledge into AWS's developing capabilities.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Virtual Labs included with the course
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and available online.

• Study guide
• Virtual labs
• Practice exams

This comprehensive course is the first step in training for the industry-leading Amazon AWS product. It serves as a thorough introduction to the services and solutions possible with AWS. It is also the first certification in paths available for IT professionals looking to codify their knowledge and skills in AWS.

You will learn how to use the AWS SDK to develop secure and scalable cloud applications. You will also explore how to interact with AWS using code and discuss key concepts, best practices, and troubleshooting tips.

This course can be used to prepare for the AWS Certified Cloud Practitioner - Foundational and AWS Certified Developer – Associate exams. This course offers enrollment with vouchers. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Course Overview and AWS Introduction
   1. Introduction to AWS Certified Cloud Practitioner Course and Exam Objectives
   2. Introducing AWS and the Cloud
   3. AWS Well-Architected Framework
   4. The AWS Global Architecture (Regions, Availability Zones, and Edge Locations)
   5. AWS Pricing, Billing, Support Plans, and Dashboards
   6. Accessing AWS Resources
2. AWS Compute
   1. Amazon EC2
   2. EC2 Scaling and Load Balancing
   3. Amazon ECS, EKS, and Fargate
   4. AWS Lambda
   5. Elastic BeanStalk
3. AWS Databases
   1. Database Overview and RDS
   2. Amazon Elasticache
   3. DynamoDB
   4. DocumentDB
   5. Amazon Redshift
   6. Amazon Neptune
4. AWS Storage
   1. Instance and EBS Storage
   2. EFS, FSx for Windows and FSx for Lustre
   3. Simple Storage Service (S3)
   4. AWS Storage Gateway
5. AWS Networking
   1. VPC Overview and Subnets
   2. VPC Internet Connectivity, Routing, and NAT
   3. VPC Security Groups and ACLs
   4. VPNs and Direct Connect
   5. CloudFront, Global Accelerator and Route53
   6. API Gateway
6. AWS Messaging, Migration, and Translation
   1. SQS
   2. SNS and SES
   3. Snowcone, Snowball, Snowmobile
   4. AWS DataSync, AWS Transfer, AWS Database Migration Service
   5. AWS Translate and Transcribe
7. Security
   1. Security Overview, IAM Users and Groups
   2. Permissions and Policies
   3. IAM Roles, Identity Federation, and Cognito
   4. KMS, Secrets Manager, AWS Organizations and Compliance
   5. AWS WAF, Shield, Inspector, Macie, and GuardDuty
8. Monitoring and Maintenance
1. CloudWatch, CloudWatch Logs, and CloudWatch Events
2. CloudTrail and Trusted Advisor
9. Course Overview and the AWS Global Infrastructure
   1. Introduction to AWS Developer Associate Course and Exam Objectives
   2. Regions, Availability Zones, and Edge Locations
10. AWS Security
    1. IAM Users, Groups, Permissions
    2. Access Keys and IAM Roles
    3. Identity Federation and Cognito
    4. KMS, HSM, and Secrets Manager
11. Networking and Compute
    1. VPC Overview and VPC Subnets
    2. VPC Internet Connectivity, Routing, and NAT
    3. VPC Security Groups and ACLs
    4. CloudFront and Global Accelerator
    5. EC2 Overview and Launching a Server
    6. EC2 Storage
    7. EC2 Auto Scaling
    8. EC2 Elastic Loadbalancing
    9. Elastic Container Service Overview
12. Databases
    1. Database Overview and RDS
    2. RDS Multi-AZ and Read Replicas
    3. Amazon Aurora
    4. Elasticache
    5. DynamoDB Overview, Table Creation, Modes, and Encryption
    6. DynamoDB Access Controls, Scans, Queries, Indexes
    7. DynamoDB DAX, Global Tables, Streams, and Additional Considerations
    8. DocumentDB
13. Simple Storage Service (S3)
    1. S3 Overview, Bucket Creation, Object Upload, Storage Classes, and Lifecycle Policies
    2. S3 Object Paths, Data Consistency, and Limits
    3. S3 Encryption, Permissions, and Pre-signed URLs
    4. S3 Versioning, MFA Delete, and Object Lock
    5. S3 CORs, Server Access Logging, Event Notifications, Replication
    6. S3 Static Website Hosting
14. Lambda, API Gateway, Step Functions
    1. Lambda Overview and Examples
    2. Lambda Features, Limits, and Permissions
    3. Step Functions
    4. API Gateway
15. Messaging
    1. SQS
    2. SNS
    3. SES
16. Elastic Beanstalk and Kinesis
    1. Elastic Beanstalk Overview
    2. Elastic Beanstalk Versions and Deployment Options
    3. Kinesis
17. Developer Tools
    1. Continuous Integration and Continuous Deployment Overview
    2. Code Commit, Artifact, Build, Deploy, and Pipeline
    3. CloudFormation and Sam
    4. SDKs, CLIs, and Simple Workflow Service
18. Monitoring
    1. CloudWatch, CloudWatch Logs, and CloudWatch Events
    2. CloudTrail and X-Ray

What you will learn

• Define what the AWS Cloud is and the basic global infrastructure and basic AWS Cloud architectural principles
• Describe the AWS Cloud value proposition
• Describe key services on the AWS platform and their common use cases Describe basic security and compliance aspects of the AWS platform and the shared security model
• Define the billing, account management, and pricing models
• Identify sources of documentation or technical assistance (for example, whitepapers or support tickets)
• Describe basic/core characteristics of deploying and operating in the AWS Cloud
• Set up the AWS SDK and developer credentials for Java, C#/.NET, Python, and JavaScript
• Interact with AWS services and develop solutions by using the AWS SDK
• Use AWS Identity and Access Management (IAM) for service authentication
• Use Amazon Simple Storage Service (Amazon S3) and Amazon DynamoDB as datastores
• Integrate applications and data by using AWS Lambda, Amazon API Gateway, Amazon Simple Queue Service (Amazon SQS), Amazon Simple Notification Service (Amazon SNS), and AWS Step Functions
• Use Web Identity Framework and Amazon Cognito for user authentication
• Use Amazon ElastiCache to improve application scalability
• Use containers in the development process
• Leverage the CI/CD pipeline to deploy applications on AWS

How you will benefit

• You will be prepared to sit for the AWS Certified Cloud Practitioner exam
• You will be prepared to sit for the AWS Certified AWS Developer Associate: Associate Exam
• Gain valuable career skills that you can apply immediately
• Increase your earning potential
• Complete your program in 6 months or less
• Certificate of completion from the school or organization that you registered through (upon successfully passing the final exam)

Raymond Lacoste

Raymond Lacoste is a highly recognized instructor and IT professional who holds the Cisco Sirius Instructor Award. He has authored Cisco Press publications on the Cisco ENARSI and Cisco TSHOOT exams.

Raymond's areas of expertise include Cisco Enterprise networking, Cisco Routing, and Switching, Cisco Datacenter Networking, ITIL, and Amazon AWS. He also holds certifications in Cisco CCSI, Cisco CCNP Routing and Switching, Cisco CCNP Enterprise, ITIL Foundations, ITIL Practitioner, ITIL Intermediate, Amazon AWS System Operations, Amazon AWS Architect, Amazon AWS Developer, and CISSP.

In addition to his certifications and experience, Raymond's engaging instruction style makes even the most obscenely complicated or obtuse concepts relatable and understandable. Outside of class, he enjoys dominating both on the golf course and the basketball court.

The AWS Developer course is designed for intermediate-level software developers and those looking to learn more about AWS's developing capabilities.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Virtual Labs included with the course
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and available online.

• Study guide
• Virtual labs
• Practice exams

In this online training course, you will learn how to use the AWS SDK to develop secure and scalable cloud applications. You will also explore how to interact with AWS using code and discuss key concepts, best practices, and troubleshooting tips

This course can be used to prepare for the AWS Certified Developer – Associate exam. This course offers enrollment with a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Developing in Azure
   1. Getting Started with AWS
   2. Exploring IAM
2. EC2
   1. EC2 Basics
   2. EC2 Instance Storage Section
3. Load Balancing, Auto Scaling Groups, and EBSVolumes
   1. High Availability and Scalability
   2. Load Balancing
   3. Auto Scaling Groups
4. RDS, Aurora, and Elasticache
   1. Relational Database Service
   2. Aurora
   3. Elasticache
5. DNS and VPCs
   1. Route 53
   2. VPC primer
6. Tier 3 Architecture
   1. Tier 3 Architecture
7. Amazon Simple Storage Service
   1. Amazon S3
   2. Cross Origin Resource Sharing
8. AWS Development
   1. Developing on AWS
   2. Development with Simple Storage Service
9. CloudFront, Beanstalk, and Docker development
   1. CloudFront
   2. Elastic Beanstalk
   3. AWS ECS Essentials
10. AWS CICD
    1. Introduction to AWS CICD
    2. AWS CodeBuild
    3. AWS CodeDeploy
    4. Other AWS CICD Services
11. Managing Your Infrastructure as Code
    1. CloudFormation
    2. CloudFormation Functions
12. AWS Monitoring, Troubleshooting & Audit
    1. CloudWatch
    2. AWS X-ray
    3. AWS CloudTrail
13. AWS Integration and Messaging
    1. Amazon Simple Queue Service
    2. Amazon Simple Notification Service
    3. Kinesis
14. AWS Lambda and DynamoDB
    1. Introduction to AWS Lambda
    2. Even More Lambda
    3. DynamoDB Basics
    4. Working with DynamoDB
15. API Gateway
    1. API Gateway Basics
    2. API Tuning
16. Working with the Serverless Application Model (SAM)
    1. Serverless Application Model
    2. AWS Cloud Development Kit
    3. Amazon Cognito
    4. Other Serverless Features
17. Additional Security
    1. Advanced Identity Management
    2. AWS Security and Encryption
18. Additional AWS Services
    1. Other AWS Services

What you will learn

• Set up the AWS SDK and developer credentials for Java, C#/.NET, Python, and JavaScript
• Interact with AWS services and develop solutions by using the AWS SDK
• Use AWS Identity and Access Management (IAM) for service authentication
• Use Amazon Simple Storage Service (Amazon S3) and Amazon DynamoDB as datastores
• Integrate applications and data by using AWS Lambda, Amazon API Gateway, Amazon Simple Queue Service (Amazon SQS), Amazon Simple Notification Service (Amazon SNS), and AWS Step Functions
• Use Web Identity Framework and Amazon Cognito for user authentication
• Use Amazon ElastiCache to improve application scalability
• Use containers in the development process
• Leverage the CI/CD pipeline to deploy applications on AWS

How you will benefit

• You will be prepared to sit for the AWS Certified AWS Developer Associate: Associate Exam
• Gain valuable career skills that you can apply immediately
• Increase your earning potential
• Complete your program in 3 months or less
• Certificate of completion from the school or organization that you registered through (upon successfully passing the final exam)

Raymond Lacoste

Raymond Lacoste is a highly recognized instructor and IT professional who holds the Cisco Sirius Instructor Award. He has authored Cisco Press publications on the Cisco ENARSI and Cisco TSHOOT exams.

Raymond's areas of expertise include Cisco Enterprise networking, Cisco Routing, and Switching, Cisco Datacenter Networking, ITIL, and Amazon AWS. He also holds certifications in Cisco CCSI, Cisco CCNP Routing and Switching, Cisco CCNP Enterprise, ITIL Foundations, ITIL Practitioner, ITIL Intermediate, Amazon AWS System Operations, Amazon AWS Architect, Amazon AWS Developer, and CISSP.

In addition to his certifications and experience, Raymond's engaging instruction style makes even the most obscenely complicated or obtuse concepts relatable and understandable. Outside of class, he enjoys dominating both on the golf course and the basketball court.

This Java certification course prepares you for the Java SE 17 Developer (1Z0-829) and Java SE 21 Developer (1Z0-830) exam—the only exam needed to become an Oracle Certified Professional: Java SE 17 Developer or Java SE 21 Developer. Discover how convenient learning Java online can be!

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 10.8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Amazon Coretto 17 (Free. Instructions will be provided in the course)
• Free version of IntelliJ (available at https://www.jetbrains.com/idea/download)
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Enroll in our comprehensive Certified Java Developer training course to gain a deep understanding of Java fundamentals, key principles, and its application in real-world scenarios. This course is designed to equip you with the necessary knowledge and skills required to pass the Oracle Certified Professional: Java SE 17 Developer (1Z0-829) and Java SE 21 Developer (1Z0-830) exam.

Throughout this Java developer course, you will learn essential concepts such as "write once, run anywhere" and their significance in Java development. You will also master the creation of basic Java objects, implementation of flow-control concepts, effective organization of classes using Java's package concept, and manipulation of Java arrays.

You will gain proficiency in creating and utilizing classes using inheritance and interfaces, applying polymorphism in Java applications, and implementing effective exception-handling mechanisms. You will also explore advanced topics, including Concurrency, JDBC, Localization, Security, and Modules in Java development.

This Java developer training course includes hands-on exercises, practical examples, and real-world projects to enhance your learning experience. Obtain access to the Java Logging API to manage logs, track application activities, and explore the power of Generics and Lambda Expressions to enhance collections and process Java Streams efficiently. Additionally, you will delve into Java's IO and NIO Streams for file handling.

Completing this comprehensive Java developer certification training will prepare you to excel in the Java SE 17 Developer exam and Java SE 21 Developer exam, give you a competitive advantage in the job market, and help open up new career opportunities. Enroll now to kickstart your Certified Java Developer training and receive an exam voucher, providing you with prepaid access to sit for the certifying exam upon eligibility.

1. Java Developer
   1. Java Introduction
   2. Java Basics
   3. Java Objects
   4. Comparisons and Flow Control Structures
   5. Arrays
   6. Inheritance
   7. Interfaces
   8. Exceptions
   9. Collections
   10. Inner Classes
   11. Streams
   12. Advanced Topics

What you will learn

• Gain a comprehensive understanding of Java's fundamental principles and how it works
• Comprehend the concept of "write once, run anywhere" and its significance in Java development
• Create basic Java objects and implement flow-control concepts
• Grasp and utilize Java's package concept to organize classes effectively
• Master the usage of Java arrays and their manipulation
• Build proficiency in creating and utilizing classes using inheritance and interfaces
• Apply the concept of polymorphism in Java applications
• Understand and implement effective exception-handling mechanisms in Java
• Utilize the Java Logging API to manage logs and track application activities
• Harness the power of Generics to enhance collections in Java
• Use Lambda Expressions to process Java Streams efficiently
• Understand and utilize Java's IO and NIO Streams for file handling
• Dive into advanced topics such as Concurrency, JDBC, Localization, Security, and Modules in Java development

How you will benefit

• Develop in-demand skills in Java, one of the most widely used programming languages for application development
• Fully prepare to pass the Oracle Certified Professional: Java SE 17 Developer (1Z0-829) exam or Java SE 21 Developer (1Z0-830) exam
• Earn a leading Oracle certification to boost your resume
• Gain a competitive advantage in the job market to unlock new career prospects as a Java developer and increase your earning potential

Stephen Withrow

Stephen Withrow brings over four decades of experience in training, development, and consulting across a broad spectrum of technologies, including Python, Java, Web Development, Oracle, C, and C++. His extensive background includes the design and implementation of business-critical solutions on client/server, web, and enterprise platforms. He holds a degree in Computer Science and Physics from Florida State University.

Stephen has provided training for a wide array of organizations, including the Department of Defense, Home Depot, CVS, Bank of New York, Merrill Lynch, IBM, and UPS, delivering high-impact instruction to professionals at every level of technical proficiency.

As a trainer, Stephen is widely recognized for his deep subject matter expertise, engaging teaching style, and ability to translate complex technical topics into clear, practical instruction. Students consistently describe him as patient, approachable, and incredibly knowledgeable, often calling him the best technical instructor they've ever had. He is praised for his real-world examples, kindness, and attentiveness to students' needs.

Stephen creates a positive, encouraging learning environment where participation is welcomed and questions are thoroughly addressed. His ability to adapt to varying experience levels while maintaining a structured and effective course flow sets him apart. Whether teaching beginning HTML or advanced Oracle development, Stephen equips students with the skills, confidence, and insights to apply their knowledge immediately in the workplace.

Learn to use Django building an interactive website to enhance your developer skills.

In this Django Training for Python developers course, you will use what you know of Python and apply it to build interactive websites with Django. While this course assumes you have no prior knowledge of Django, you will need to have experience working with Python.

Through hands-on training, you'll discover how to work with the messages framework, allow users to upload files, make advanced queries, create view functions, work with Ajax, and implement pagination, ordering, and search. By the time you complete this course, you will fully understand how to customize Django admin and deploy a Django website into production. Learning Django will help you as a Python developer improve your skills and increase your career opportunities.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 11.0 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to use Django to create an interactive website. This course assumes you have no prior knowledge of Django, but you must have experience with Python. You will learn to work with the messages framework, discover how to allow users to upload files, and make advanced queries. By the end of the course, you will understand how to deploy a Django website to production and customize Django admin.

1. Setting Up Your Computer
2. Getting Started with Django
3. Git, GitHub, and an App with a Model
4. Template Filters and Tags
5. Static Files
6. Django Admin and the User Model
7. URLs and Slugs
8. Sending Email with Send Grid
9. Forms and Widgets
10. Model Forms
11. User Registration
12. Messages Framework
13. Media Files
14. Making Queries, Ajax, and View Functions
15. Pagination and Ordering
16. Advanced Querying and Search
17. Deploying your Website to Production
18. Customizing Django Admin
19. Additional Topics

What you will learn

• Understand how to set up a Django website
• Details of website account management
• How to work with media files and settings
• Knowledge of debugging and queries
• How to customize Django administration

How you will benefit

• Enhance your Python skills with Django training
• Learn a skill that will help you stand out as a web developer
• Gain the confidence to take on take on new responsibilities and start new career paths

Learn the core skills needed to build websites. In this online web development course, you will learn how to use HTML, CSS, and JavaScript.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 11.0 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Word (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online. Manuals are included as downloadable PDFs throughout the course.

A front-end developer builds everything a user sees and interacts with on a website. Considering how many websites exist and are being created, front-end web developers are in high demand. In fact, the U.S. Bureau of Labor Statistics reports that overall employment of web developers and digital designers is projected to grow 16% by 2032.

This web developer course will prepare you for an entry-level career in this high-demand job market. You will learn how to use HTML, CSS, and JavaScript to create functional, responsive web applications. In addition to learning these three languages, you will put theory into practice and apply your new knowledge to build the front end of a website.

One of the key advantages of this web developer training course is the portfolio you will develop. The portfolio you develop throughout this course will be vital when entering the web development field, as it showcases your skills and projects, giving potential employers a glimpse of your capabilities. By enrolling in this front-end developer course, you will be on your way to pursuing an entry-level career in this booming field.

1. Introduction to HTML
   1. A Quick Overview of Web Development
   2. Introduction to HTML
   3. Paragraphs, Headings, and Text
   4. HTML Links
   5. HTML Images
   6. HTML Lists
   7. HTML Tables
   8. Sectioning a Web Page
   9. Audio and Video
2. Introduction to CSS
   1. Crash Course in CSS
   2. CSS Fonts
   3. Color and Opacity
   4. CSS Text
   5. Borders, Margins, and Padding
   6. Backgrounds
   7. Display and Visibility
   8. Pseudo-classes and Pseudo-elements
   9. Styling Tables with CSS
   10. Positioning
   11. Transforms and Transitions
   12. Layouts
   13. CSS Lists as Hierarchical Navigation
   14. Media Queries
3. Introduction to JavaScript
   1. JavaScript Basics
   2. Variables, Arrays, and Operators
   3. JavaScript Functions
   4. Built-In JavaScript Objects
   5. Conditionals and Loops
   6. Event Handlers and Listeners
   7. The HTML Document Object Model
   8. CSS Object Model
   9. Errors and Exceptions
4. Introduction to Creating, Styling, and Validating Web Forms
   1. HTML Forms
   2. JavaScript Form Validation
   3. Styling Forms with CSS
5. Final Project

What you will learn

• Build websites with HTML
• Use CSS styling to change web pages
• JavaScript for web applications
• Creating, styling, and validating web forms

How you will benefit

• Gain foundational skills from expert-developed curriculum
• Create a website for your portfolio

Stephen Withrow

Stephen Withrow brings over four decades of experience in training, development, and consulting across a broad spectrum of technologies, including Python, Java, Web Development, Oracle, C, and C++. His extensive background includes the design and implementation of business-critical solutions on client/server, web, and enterprise platforms. He holds a degree in Computer Science and Physics from Florida State University.

Stephen has provided training for a wide array of organizations, including the Department of Defense, Home Depot, CVS, Bank of New York, Merrill Lynch, IBM, and UPS, delivering high-impact instruction to professionals at every level of technical proficiency.

As a trainer, Stephen is widely recognized for his deep subject matter expertise, engaging teaching style, and ability to translate complex technical topics into clear, practical instruction. Students consistently describe him as patient, approachable, and incredibly knowledgeable, often calling him the best technical instructor they've ever had. He is praised for his real-world examples, kindness, and attentiveness to students' needs.

Stephen creates a positive, encouraging learning environment where participation is welcomed and questions are thoroughly addressed. His ability to adapt to varying experience levels while maintaining a structured and effective course flow sets him apart. Whether teaching beginning HTML or advanced Oracle development, Stephen equips students with the skills, confidence, and insights to apply their knowledge immediately in the workplace.

Deepen your understanding of the Java programming language, and start writing programs that are more sophisticated and professional.

Deepen your understanding of the Java programming language, and start writing programs that are more sophisticated and professional. Learn how to save data permanently on a disk by writing it to a sequential data file. See how to read the file to get the data back and process it. Organize information using multiple classes in Java's class hierarchy and inheritance. Explore some of the hundreds of classes that are built into the Java language. Find out how to create GUI applications in Java using tools like windows, menus, buttons, text boxes, check boxes, scroll bars, and other GUI tools.

Over the duration of this course, you'll build several complete applications that combine these concepts. You'll also use the knowledge you gain to solve programming problems included with the lessons. These problems are designed to help you master all the principles you learn.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Linux can also be used.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Java SE (Standard Edition) Development Kit (JDK) Version 5 or later, from Sun Microsystems.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Deepen your understanding of the Java programming language, and start writing programs that are more sophisticated and professional.

1. Introduction and Java Review
2. Arrays, Loops, and Using Multiple Classes
3. File Input and Output
4. Inheritance and Class Hierarchies
5. Stand-Alone GUI Applications
6. Layouts and Multiple GUI Components
7. GUI Menus
8. A Working GUI Application: Part 1
9. A Working GUI Application: Part 2
10. Java Collections: Part 1
11. Java Collections: Part 2
12. Java Collections: Part 3

Advance your knowledge of SQL in this flexible self-paced online course. You will learn how to write, design, and test complex SQL queries.

When it comes to query language for relational database management systems, SQL is the industry benchmark. This flexible, self-paced course will help you advance your knowledge and keep pace with today's SQL standards. You will practice designing, writing, and testing complex SQL queries to execute on a practice database using SQL Server Express.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

• SQL Server Express
• SQL Server Management

Advance your knowledge of SQL in this flexible self-paced online course. You will learn how to write, design, and test complex SQL queries.

SQL Review

In this introductory lesson you will review SQL and database terms and concepts. You will also install SQL Server Express and SQL Server Management Studio (SSMS) to use throughout the course in your learn-by-doing practices. And, you will use SQL code scripts to create a practice database in SQL Server.

Joining Multiple Tables

In this lesson you will learn about join statements and how join queries make it possible to retrieve data from more than one table. You'll also practice how to write well-designed join queries that retrieve result-sets that meet your requirements.

Filtering Rows

Databases can contain massive amounts of data. Learning how to filter the rows that will limit the result-set is extremely important. In this lesson, you will explore various ways to write SQL queries that retrieve a filtered result-set that meets defined criteria.

Grouping and Summarizing Rows

Because of the size of databases, it is important to design SQL queries that retrieve results-sets with data that is organized. In this lesson, you will practice designing queries that group similar data and summarize result-sets. You will explore aggregate functions and how they can be used in producing result-sets that can be used for data analysis.

Subqueries

Subqueries are SQL queries that are written inside another SQL query. Subqueries are used to perform intricate requirements on complex data subsets to retrieve specific data from the database. You will practice writing various subqueries using the practice database.

Tables and Data Maintenance

This lesson is about maintaining the database and data. You will practice using SQL code to modify and add table structures and add new data records. You will also learn about writing SQL queries to modify and delete tables structures and data. Understanding how to write queries to modify, add, and delete is important in order to maintain a database and data that are accurate and up to date.

Unions and Other Joins

Unions are used to retrieve data from more than one table. Instead of returning columns from different tables, a union SQL query combines rows for columns that are the same datatype. In this lesson, you will practice writing SQL queries that retrieve data from multiple tables with specific requirements.

Using String and Date Functions

SQL built-in functions are useful when applied in the right situations. In this lesson, you will work with string and date functions and write SQL queries to retrieve result-sets that manipulate and display data that may be easier to read and understand.

Stored Procedures

User-defined functions are called stored procedures. A stored procedure is a query that is written, saved, and ready to be reused whenever needed. In this lesson, you will practice defining, writing, saving, and executing stored procedures.

Indexes and Views

Indexes are important to database performance. Views are used to simplify access and to secure accessibility to the data. In this lesson, these concepts will be explored and examined as you practice defining and creating SQL queries.

Triggers

A trigger is a user-defined stored procedure that is used for maintaining the database. Once a trigger has been defined and is implemented in the database, it is automatically executed when applicable. In this lesson, you will practice defining, writing, and saving triggers.

SQL Server Management Studio

Understanding the database and its parts is a necessary component of learning SQL. It is difficult to develop and write efficient and well-designed queries without knowing the database and table structures. This last lesson presents SQL queries that retrieve database information. You will also explore the SSMS to make use of its functions as you continue your SQL journey.

Learn the fundamentals of computer programming with the new C# programming language.

This course starts with programming fundamentals: input/output operations, decision making, and looping. Then, you will explore the many benefits of object-oriented programming, with plenty of vivid, real-life examples.

Then, you will gain hands-on experience with sequential data files, and you will be able to build a professional-looking and intuitive Graphical User Interface (GUI) application on your very own computer.

Because there is no better way to learn programming than hands-on practice, almost every lesson includes practical examples and assignments you can use to develop your knowledge of programming.

Learn to program the right way: by using a state-of-the-art language to build impressive applications on your schedule and on your very own computer.

Requirements:

Hardware Requirements:

• This course must be taken on a PC.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn the fundamentals of computer programming with the new C# programming language.

Computer Basics and the History of Programming

C# is a fantastic programming language that combines the best parts of C++, Java, and Visual Basic all into one language. This first lesson briefly explores the history of programming languages and then explore the .NET framework.

The C# Compiler and Your First C# Program

Armed with some background, you will now proceed to installing the C# compiler, and then you will write, compile, and run your first C# program. Although you will start with a small program, it will be clear even small C# programs can be a bit tricky. This lesson gives you a great opportunity to practice working with the compiler, something that you will be using for the remainder of the course.

Data Types and Mathematical Operators

Now that you're comfortable with compiling and running simple programs, you will shift to math. But you will be learning about the basic math operators that C# provides. And because you will need a place to save the results of your calculations, you will also learn about variables and their data types.

Value Returning Methods

This lesson is your first step into modular programming with methods. Methods are a helpful tool because they allow us to break up big programs into smaller, more manageable parts. First you will start learning a few built-in methods that are available. Then you will learn how to write your own methods and call them in your program. Hopefully you will agree that this way of programming makes it easier to tackle large problems.

Void Methods and Overloading

This lesson continues building on the concept of methods. You will learn about methods that don't return any value, which help make your program modular. This lesson also covers method overloading, which can help improve the readability of your programs by reusing method names within the same code file.

The if Selection Structure

By this point in the course, you will be comfortable doing the basics of C#: working with variables, math, and methods. In this lesson, you will learn about the if statement and how you can use it to let the computer choose which set of statements to execute based on some condition.

More About the Selection Structure

This lesson continues your investigation of the decision structure in today's lesson by taking a look at more complex if statements. You will also learn how to use the switch statement to make decisions in your programs as well. This ability to have multiple programming structures is sort of like having another tool in your tool belt. Sometimes a job is far easier to do if you just use the right tool. You may not always need to use every tool, but it's good to know what tools are there and how to use them. You will find the same is true in programming.

The Repetition Structure

Keeping with the theme of programming structures, you will now look at the repetition structure. Just as there were different ways to implement the decision structure, there are a couple of ways to work with loops. This lesson focuses on the while loop, the for loop, and the do loop. Each structure works the same in that they allow you to repeat statements, but each one is a little different. Here you will learn their differences and add to the tools in your tool belt.

Arrays

One of the most useful applications of loops is arrays, so it makes sense for you to build on your knowledge of loops and explore array variables in this lesson. You will learn how to create and access array variables.

Classes

Object-oriented programming is a big topic, and C# is an object-oriented language. You will write a class that will store the data necessary to keep track of the time. Since you're writing this class, you will have the ability to take this code and add it to any program that needs to store information about the time, such as appointment books and scheduling programs.

Exceptions and Files

Obviously, computer programs are big time savers and really help us to automate things. But in order for a program to be really useful, it needs to be able to save data for use later. In this lesson, you will learn how to read from and write to external data files, so you can store your user data forever.

Graphical User Interfaces

In your final lesson, you will learn programs with a Graphical User Interface (GUI). While C# has an Integrated Development Environment (IDE) that gives you the ability to easily create GUI applications, the code that's generated is buried deep in the file structure. You will also learn how to build your own GUI without an IDE. By doing this, you will be far better prepared for working with IDEs in the future because you will know exactly what's going on behind the scenes.

Learn to program in C++, even if you have no prior programming experience!

Here's your chance to learn how to program the easy way in C++. Introduction to C++ Programming is a project-oriented course taught by a master programming instructor and published author.

You'll get right to programming in this course—even if you have no prior programming experience! Before you know it, you'll be putting together programs, and you'll see how easy programming really is.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to program in C++, even if you have no prior programming experience!

1. Your First C++ Program
2. Understanding Your C++ Code and How to Fix Errors
3. Data Types and Computer Memory
4. Storing Data in Variables
5. Letting the Computer Do the Math
6. Letting the User Choose
7. Combining Choices
8. Repeating Code With Loops
9. Using Arrays
10. C Strings for Storing Text
11. Functions for Dividing and Organizing Code
12. Saving and Retrieving Data

Learn about Java topics with clear, step-by-step instructions developed by an experienced Java programmer.

Build your knowledge and confidence with easy-to-understand examples and plenty of skill-building exercises. So, whether you just want to try it out to see if you like it or plan on doing more with Java, this is a great place to start!

This course uses the latest release of Java, from Oracle, the company that maintains and supports the language. You will also learn how to use BlueJ, a graphical development environment designed especially for students. Both are free open-source products, and you will receive the proper instructions to download them. By the time you're done, you will be comfortable with Java programming and ready for more!

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Linux can also be used.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• The most recent versions of the Java Development Kit (JDK) and BlueJ. Download and installation instructions will be available in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Learn about Java topics with clear, step-by-step instructions developed by an experienced Java programmer.

Introducing Java

Java is one of the most widely used programming languages in the world, on machines from microprocessors in DVRs and microwaves to supercomputers. This lesson will introduce you to computer programming in general and to Java in particular. First, you will be set up with the downloads and installations you will need for the rest of the course. Then, you will explore the process of editing, compiling, and running computer programs written in Java.

Writing Your First Java Program

Now that you have the software downloaded and installed, you're ready to start programming! It's time to write your first Java program. Along the way, you will learn to create projects and classes in BlueJ. You will use the editor to enter your program, and you will find out more about how to compile it and run it.

Working With Java's Primitive Data Types

This lesson is about Java's primitive data types—the building blocks you need to use before you can build more complex types. First, you will learn how to use them in some simple programs and how they relate to each other. Beyond that, you will explore how to use these classes in the Java libraries.

Working With Objects

This lesson introduces classes and objects. You will revisit the HelloWorld application and rewrite it in Java's OOP (object-oriented programming) structure. While doing that, you will look at how to declare classes, objects, attributes, and methods to Java.

Creating a Program That Makes Calculations

This lesson covers how to declare data variables to Java and how to use variables in arithmetic expressions to calculate new results. You will learn about data input, which means getting information into programs from an outside source. Then you will write a program that incorporates all these features.

Computer Logic: Writing Programs That Make Decisions

Making decisions is one of the most important and powerful things a computer language can do. Without decision-making, computers would be big, bulky calculators. This lesson explores the decision-making process in detail and see how Java does it. When you're done with this lesson, you will know how to write Java programs that make decisions based on the principles of computer logic.

Writing Programs With Loops

In this lesson, you will learn to repeat actions using a control structure called a loop. Loops in Java involve decisions, just as branches do. But in a loop structure, if the condition is met, the branch is backward instead of forward.

Fixing Errors in Java

This lesson focuses on how Java generates exceptions and how to prevent them from crashing your programs. You will learn about class methods and how to call them without creating any objects. Last, you will find out about a debugger, which lets you look at what's going on inside the program as it runs.

Three Tools: Debugger, Enumeration, and Switch

This lesson is a grab bag of tools and topics. BlueJ's debugger lets you watch your program's internal actions as it runs. Enumeration lets you set up new data types with built-in limits on their values. Finally, Java's switch structure lets you replace a series of nested if statements with a single value-based structure. You will find all these items useful in future programming!

Formatting Output and the Java Application Program Interface

How can you make numbers and other output look the way you want them to in Java? This lesson looks at Java's application program interface (API). That's the documentation of all the classes that Java includes when you install the JDK, plus explanations of how to use them. The interface has several thousand classes, and it's important to know how to find things within it.

Creating Windows and Adding Graphics in Java

So far in this course, everything has been text-based. This lesson will introduce you to the world of Java windows, and you will look at GUI (graphical user interface) programming in Java. You will also learn about the basic components of a Java window and then add some simple graphics to it.

Java 2-D Animation

In your final lesson, you will continue exploring Java 2-D graphics with a look at some simple animation. You will use the same technique cartoonists have used for a hundred years now: redrawing an image in a slightly different location and repeating that process many times a second so the image appears to move. You will learn to create a self-contained object that "knows" its own size, color, shape, location, and how to draw itself into the window.

Build on your knowledge of HTML and CSS by learning to add interactivity to your web pages with JavaScript code and jQuery.

You may already know how to use HTML and CSS to create websites. If so, you're ready to add more power to your programming with JavaScript. This programming language lets you add interactivity to your pages by creating features such as buttons, picture carousels, and collapsible panels to your web pages.

The course begins with the basics of JavaScript code and then moves on to more advanced topics. Throughout the course, you'll get plenty of hands-on practice to give you the experience you need to really understand how JavaScript works. Of course, since no JavaScript course would be complete without a discussion of jQuery, you'll learn about it as well. By the end of the course, you'll understand how to use jQuery to catapult your basic JavaScript knowledge to incredible new heights.

This course assumes you already know HTML and CSS. JavaScript is always used with these two programming languages, not as an alternative to them.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• A text editor or authoring tools for writing HTML and CSS code.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Build on your knowledge of HTML and CSS by learning to add interactivity to your web pages with JavaScript code and jQuery.

1. What is JavaScript
2. Executing Scripts
3. The Document Object Model
4. Dates, Numbers, and Decision-Making
5. Search My Site Code
6. Fun With Music
7. Building a Picture Carousel
8. Fun With Arrays and Loops
9. Timers and Transition Effects
10. Introducing jQuery
11. Creating Collapsible Panels and Accordions
12. Using jQuery Plugins

This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL.

This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL. It does not cover PHP, but it prepares you for learning PHP to integrate with MySQL. Although most of the SQL learned in the course is applicable to all major databases, including SQL Server, Oracle, and PostgreSQL, it focuses on MySQL.

This course starts with the basics of relational databases. You will learn to use simple SELECT queries to pull data, and then move on to more advanced SELECTs and data manipulation. You will shape the results of your queries to create relevant reports. Once you have mastered the basics, you will get hands-on with complex data retrieval methods like subqueries, joins, outer joins, and unions. Finally, you will use INSERT, UPDATE, and DELETE while learning best practices for maintaining your records.

By the end of this MySQL for PHP course, you will know MySQL and SQL well enough to start using it with PHP (and elsewhere).

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. Chromebooks are not compatible.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins. Setup instructions can be found here.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

In this online course you will learn how to connect MySQL to PHP. You will also learn how to create a MySQL database This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL. This course does not cover PHP, but it prepares you for learning PHP to integrate with MySQL. Although most of the SQL learned in the course is applicable to all major databases, including SQL Server, Oracle, and PostgreSQL, it focuses on MySQL.

1. Relational Database Basics
   1. Brief History of SQL
   2. Relational Databases
   3. Tables
      1. Rows
      2. Columns
      3. Relationships
      4. Datatypes
      5. Primary Keys
      6. Foreign Keys
      7. Relational Database Management System
   4. Popular Databases
      1. Commercial Databases
      2. Popular Open Source Databases
   5. SQL Statements
      1. Database Manipulation Language (DML)
      2. Database Definition Language (DDL)
      3. Database Control Language (DCL)
2. Simple SELECTs
   1. Introduction to the Northwind Database
   2. Some Basics
      1. Comments
      2. Whitespace and Semi-colons
      3. Case Sensitivity
   3. SELECTing All Columns in All Rows
   4. Exercise: Exploring the Tables
   5. SELECTing Specific Columns
   6. Exercise: SELECTing Specific Columns
   7. Sorting Records
      1. Sorting by a Single Column
      2. Sorting By Multiple Columns
   8. Ascending and Descending Sorts
   9. Exercise: Sorting Results
   10. The WHERE Clause and Logical Operator Symbols
       1. Checking for Equality
       2. Checking for Inequality
   11. Exercise: Using the WHERE Clause to Check for Equality or Inequality
   12. Checking for Greater or Less Than
   13. Exercise: Using the WHERE Clause to Check for Greater or Less Than
   14. Checking for NULL
   15. Exercise: Checking for NULL
   16. WHERE and ORDER BY
   17. Exercise: Using WHERE and ORDER BY Together
   18. Checking Multiple Conditions with Boolean Operators
       1. AND
       2. OR
       3. Order of Evaluation
   19. Exercise: Writing SELECTs with Multiple Conditions
   20. The WHERE Clause and Logical Operator Keywords
       1. The BETWEEN Operator
       2. The IN Operator
       3. The LIKE Operator
       4. The NOT Operator
   21. Exercise: More SELECTs with WHERE
3. Advanced SELECTs
   1. Calculated Fields
      1. Concatenation
      2. Mathematical Calculations
      3. Aliases
   2. Exercise: Calculating Fields
   3. Aggregate Functions and Grouping
      1. Aggregate Functions
      2. Grouping Data
   4. Exercise: Working with Aggregate Functions
   5. Selecting Distinct Records
   6. Built-in Data Manipulation Functions
      1. Common Math Functions
      2. Common String Functions
      3. Common Date Functions
   7. Exercise: Data Manipulation Functions
4. Subqueries, Joins and Unions
   1. Subqueries
   2. Exercise: Subqueries
   3. Joins
      1. Table Aliases
      2. Multi-table Joins
   4. Exercise: Using Joins
   5. Outer Joins
   6. Unions
      1. UNION ALL
      2. UNION Rules
   7. Exercise: Working with Unions
5. Inserting, Updating and Deleting Records (if time allows)
1. Inserting Records
2. Updating and Deleting Records

What you will learn

• Understand how MySQL works
• Learn to use SQL to output reports with MySQL
• Learn to modify MySQL data with SQL

How you will benefit

• Organizations store data in databases, and MySQL is the most popular open source database. Knowing how to query those databases opens up opportunities for you to build reports for such organizations
• Database-driven websites require knowledge of SQL, and MySQL is one of the most popular databases used to build these websites, especially those built with PHP. This course gives you the prerequisite knowledge to start learning a server-side language such as PHP to use with MySQL

Take your first steps toward a career as a computer programmer as you master basic programming concepts and get hands-on practice in writing applications containing GUIs, sound, and graphics.

Take your first steps toward a career as a computer programmer! In this course, you'll learn to use Just BASIC, a free Windows programming language, to create stand-alone applications for professional or personal use.

Even if you've never programmed before, you'll find it easy to follow the step-by-step instructions in each lesson. By the end of the course, you'll have the skills and confidence you need to program in BASIC and design your own custom applications for home, school, or work.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Take your first steps toward a career as a computer programmer as you get hands-on practice writing applications containing GUIs, sound, and graphics. This course will provide the skills and confidence you need to program in BASIC and design your own custom applications for home, school, or work.

1. Getting Started With Just BASIC
2. Creating Programs With Just Basic
3. Creating Windows for Graphical User Interfaces
4. Adding Controls to Windows
5. Working With Controls and FreeForm-J
6. Working With Variables and Arrays
7. Making Decisions With Conditional Logic
8. Using Loops to Process Data
9. Functions and Subroutines
10. Working With Text Files
11. Working With Sound and Graphics
12. Debugging Your Applications

Enhance your professional profile by adding Python to your programming skills.

The Python programming language was developed to provide a way to develop code that's easy to create and understand. While Python contains the same basic structures as other languages, it also offers unique functionality that makes your life as a programmer easier.

This course will show you how to create basic programming structures including decisions and loops. Then you will move on to more advanced topics such as object-oriented programming with classes and exceptions. In addition, you will explore unique Python data structures such as tuples and dictionaries. You will even learn how to create Python programs with graphic elements that range from simple circles and squares to graphical user interface (GUI) objects like buttons and labels.

Whether you're interested in writing simple scripts, full programs, or graphical user interfaces, this course will give you the tools you need to use Python with skill and confidence.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• You will need Python 3.X (3.1, 3.2, or a later version), which you can download free of charge here.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Enhance your professional profile by adding Python to your programming skills.

Welcome to Python

Two things that make Python attractive are that it's a free download and that it comes with a free development environment, IDLE. This lesson starts off with a brief tour of both the language and the environment. You will see that with IDLE, you can either execute individual statements directly at the interpreter's prompt or save your commands in a program file to be run later.

Get Interactive With Variables and User Input

Programs aren't terribly useful unless you have some way to store values in memory. In this lesson, you will get up to speed with Python variables, and then you will learn how to use these variables to get input from the user. With this, you will be able to write Python code to make your programs interactive, making them more useful and a lot more interesting.

Decisions, Decisions

There are many times when you will want one set of statements run in one situation and another set run in a different situation. For that, you will need to use Python's if decision structure. In this lesson, you will practice with Python's if syntax and learn how to write both simple and complex conditions to select which statements should be run.

Looping (and Looping and Looping)

Keeping with the theme of programming structures, this lesson is all about the repetition structure. You will learn how to write both while and for loops in Python so that your statements can be repeated over and over until some condition is met. You will also learn some looping features that are unique to Python that help to make your programs more powerful.

Modular Programming With Functions

Modular programming gives you the ability to write code once, give it a name, and then call on it by name at a later time. In this lesson, you will learn how to write modular programs by creating functions. You will also learn how to pass data into the functions and then to return values back, building on this knowledge as you proceed through the course.

Introduction to Object-Oriented Programming

Building on the concept of modular programming, this lesson explores object-oriented programming. This is a popular technique and you will get an introduction to how it's done in Python. You will learn how to create a class definition and place variables and functions inside. Then later, you will use this class to create some objects and work with them to solve simple problems.

Creating Graphics With Tkinter

It's time to take some of the topics previously covered and apply them to something a little more creative. This lesson focuses on Python graphics. You will create simple shapes and practice writing programs that simulate animation. By the end of the lesson, you will be able to watch your shapes move across the screen.

Python Data Structures 1: Lists and Tuples

Now that you're comfortable with the decision and repetition structures, as well as ways to organize your code, it's now time to turn to ways of managing your data. This lesson looks at two of Python's basic data structures: lists and tuples. You will learn how to create these types of variables and use them to manage data for your programs.

Python Data Structures 2: Dictionaries

While lists and tuples are useful structures, they put the burden on you to keep track of your data's position within the structure. However, the dictionary structure gives you the ability to associate a word with each piece of data. In this lesson, you will learn how to use dictionaries to write useful programs in fewer lines of code that'll execute in a shorter amount of time.

Working With External Data Files

Programs that work with data in memory are great. However, it's also important to be able to save the data in a file for later use. In this lesson, you will learn how to read from and write to data files. You will also learn about Python's shelve feature, which is a database-like file that allows for quick and easy access to large amounts of data.

Handling Python Exceptions

Let's face it, programs sometimes encounter problems. In object-oriented terms, you would call this an exception. If the exception isn't handled, the program will crash. In this lesson, you will learn about Python's exceptions and learn how to handle them to keep the program up and running, even when something unexpected happens.

GUIs With Tkinter

You will finish the course by exercising the creative part of your brain again. This time, you will learn how to create a graphical user interface (GUI) in Python. Now you will be able to integrate all the conceptual material that you learned in the course with an attractive, easy to use interface to make for useful, interactive programs.

Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.

SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.
• Dual monitors are helpful but are not required.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.
• Necessary rights (local administrative rights) to install programs on the computer.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

• SQL Server Express
• SQL Server Management Studio

Gain a solid working knowledge of the most powerful and widely used database programming language. This course will provide you the skills to write SQL queries to create tables, retrieve data from single or multiple tables, manipulate data in a database, and gather statistics from data stored in a database.

Introduction to Database Design and SQL

In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database and collecting data is foundational to using SQL to write queries and retrieve data result-sets that are usable.

SQL Server

In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use a SQL code script to create one of the tables for the practice database in SQL Server.

Retrieving Data Result-Sets

SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meets a defined criteria.

Sorting Data

SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will explore and practice defining and writing queries to meet a defined criteria to retrieve the expected result-set.

Designing SQL Data Tables

This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in a RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.

Designing Data Rows

In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table, and you will also practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL code script to populate your tables with enough data rows to use in the learn-by-doing practices in this course.

Getting Data From Two Tables

SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN query statements that are defined to retrieve data result-sets from tables that have a relationship between their PKs and FKs.

Retrieving Data From Multiple Tables

In this lesson, you will continue writing JOIN statement that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.

Keeping the Database Up to Date

The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.

Aggregate Functions

In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.

SQL Views

SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.

Maximize Database Integrity and Performance

Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.

Master JavaScript, jQuery, and Vue.js and build out a responsive web application for your portfolio.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 11.0 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Java (download and installation instructions are provided in course)
• Visual Studio Code (download and installation instructions are provided in course)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Whether you're new to JavaScript development or want to enhance your developer skillset, this course will train you to use JavaScript, jQuery, and Vue.js. You will start the course by mastering JavaScript. You will then be introduced to React and learn the latest React techniques to build an application. Next, you will learn Vue.js, beginning with a simple "Hello, Vue!" app that takes you through the process of creating a small, but featureful math app. Finally, you will learn jQuery to maintain and modernize existing websites that use jQuery. When your coursework is complete, you will put your skills to use to build your own dynamic web application.

1. Introduction to JavaScript
   1. JavaScript Basics
   2. Variables, Arrays and Operators
   3. JavaScript Functions
   4. Built-In JavaScript Objects
   5. Conditionals and Loops
   6. Event Handlers and Listeners
   7. The HTML Document Object Model
   8. CSS Object Model
   9. Errors and Exceptions
2. Advanced JavaScript Concepts
   1. Node.js
   2. Scope, var, let, and const
   3. Arrow Functions
   4. Rest Parameters
   5. Spread Operator
   6. Array Destructuring
   7. Template Literals
   8. Objects
   9. The this Object
   10. Array map() Method
   11. Array filter() Method
   12. Array find() Method
   13. JavaScript Modules
   14. Npm
3. React
   1. Introduction to React
   2. JSX and React Elements
   3. React Components
   4. React State
   5. React Routing
   6. Styling React Apps
   7. Implementing Game Logic
   8. React Effects
4. Introduction to Vue.js 3
   1. Getting Started with Vue.js
   2. Basic Vue Features
   3. Directives
   4. Implementing Game Logic
   5. Transitions and Animations
   6. Vue Routing
5. Introduction to jQuery
   1. Getting Started with jQuery
   2. The jQuery Function and Selectors
   3. jQuery Manipulation
   4. jQuery Forms and Events
   5. jQuery Effects
   6. Ajax and jQuery
   7. Converting from jQuery to JavaScript
   8. Converting from JavaScript to jQuery

What you will learn

• The basic constructs of JavaScript, how to use JavaScript to access and change page elements and their properties, and how to test and debug JavaScript using Google Chrome
• Additional, advanced JavaScript techniques that prepare you for learning specific frameworks
• Vue and React frameworks for building applications
• Use jQuery to maintain and modernize existing websites

How you will benefit

• Gain intensive JavaScript skills to jump-start a career in a growing technical field
• Master Vue.js and React.js
• Be able to maintain legacy work with jQuery methods

Stephen Withrow

Stephen Withrow brings over four decades of experience in training, development, and consulting across a broad spectrum of technologies, including Python, Java, Web Development, Oracle, C, and C++. His extensive background includes the design and implementation of business-critical solutions on client/server, web, and enterprise platforms. He holds a degree in Computer Science and Physics from Florida State University.

Stephen has provided training for a wide array of organizations, including the Department of Defense, Home Depot, CVS, Bank of New York, Merrill Lynch, IBM, and UPS, delivering high-impact instruction to professionals at every level of technical proficiency.

As a trainer, Stephen is widely recognized for his deep subject matter expertise, engaging teaching style, and ability to translate complex technical topics into clear, practical instruction. Students consistently describe him as patient, approachable, and incredibly knowledgeable, often calling him the best technical instructor they've ever had. He is praised for his real-world examples, kindness, and attentiveness to students' needs.

Stephen creates a positive, encouraging learning environment where participation is welcomed and questions are thoroughly addressed. His ability to adapt to varying experience levels while maintaining a structured and effective course flow sets him apart. Whether teaching beginning HTML or advanced Oracle development, Stephen equips students with the skills, confidence, and insights to apply their knowledge immediately in the workplace.

Take your SQL skills to the next level and learn to write queries with PL/SQL in this online SQL training course.

This self-paced SQL training course is perfect for advancing your current SQL skills. While Oracle uses a standard SQL like other major databases, PL/SQL is specific to Oracle. PL/SQL is a procedural language with variables, conditions, loops, subprograms, stored procedures, and functions. By course completion, you will understand and know how to use PL/SQL's main features, including declaring, naming, and assigning variables.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
• Oracle SQL Developer - The client interface for connecting to Oracle (software not included).
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.

Other:

• Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to use PL/SQL to write sophisticated queries against an Oracle database.

1. PL/SQL Basics
1. What is PL/SQL?
2. Blocks
3. Outputting Information
4. Variables and Constants
5. Constants
6. Data Types
7. Naming Variables and Other Elements
8. Embedding SQL in PL/SQL
9. SELECT...INTO and RETURNING...INTO
10. PL/SQL Features
2. Subprograms
1. Introduction to Subprograms
2. Procedures
3. Variable Declarations
4. Dropping a Procedure
5. Parameters
6. Parameters with Default Values
7. Parameter Modes
8. IN Mode
9. OUT Mode
10. IN OUT Mode
11. Named Notation
12. Using SQL in a Subprogram
13. %TYPE
14. Functions
15. Using PL/SQL Functions in SQL Queries
3. Conditional Processing
1. Conditions and Booleans
2. IF-ELSIF-ELSE Conditions
3. ELSIF
4. BOOLEAN Values and Standard SQL
5. The CASE Statement
6. CASE Expressions
4. Exceptions
1. Introduction to Exceptions
2. Predefined Exceptions
3. The EXCEPTION Part of the Block
4. User-defined Exceptions
5. User-defined Exceptions in Subprograms
6. Re-raising Exceptions
7. Naming Unnamed Predefined Exceptions
8. WHILE Loops
9. When to Use Exceptions
5. Cursors
1. Implicit Cursors
2. Explicit Cursors
3. %ROWTYPE
4. Explicit Cursor Use Case
5. Cursor FOR LOOP
6. Cursor Parameters
6. Packages
1. Package Basics
2. The Package Specification
3. The Package Body
4. Building an Employee Package
5. Overloading Subprograms
6. Auditing
7. Validation Procedures
8. Package Cursors
9. Benefits of Packages
7. Triggers
1. What are triggers?
2. Trigger Parts
3. Validation Triggers
4. The WHEN Clause
5. Audit Triggers
6. Statement-level Triggers
7. Compound Triggers
8. Trigger Warning

What you will learn

• How to write a simple block of PL/SQL code and about subprograms in PL/SQL
• To create and call procedures and functions
• To write IF conditions, use the CASE statement, and handle exceptions in PL/SQL
• To use implicit and explicit cursors
• To use triggers for validating data and auditing changes to the database

How you will benefit

• Gain skills that every developer needs
• Bring your advanced SQL/PL skills to any web development job
• Advance your career as an Oracle developer

This online Oracle SQL and PL/SQL Developer course will teach you how to use SQL to build applications, generate business reports, master SQL in Oracle, and learn PL/SQL to work within an Oracle database.

Requirements:

Hardware Requirements:

• This course must be taken on a PC.
• Dual monitors are helpful but are not required.

Software Requirements:

• PC: Windows 10 or later (not the Home Edition).
• Browser: The latest version of Chrome (preferred), Microsoft Edge, or Firefox browsers.
• Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS (download and installation instructions are provided in course). Please view the required specs ahead of time to make sure that your system is compatible.
• Oracle SQL Developer - The client interface for connecting to Oracle (download and installation instructions are provided in course).
• Adobe Acrobat Reader.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This online course will teach you how to use SQL to build applications or generate business reports and will help you master SQL using an Oracle database. You will also learn how to use the PL/SQL extension language to write sophisticated queries against an Oracle database.

This course will prepare you to enter the job market as an entry-level Oracle SQL Developer or take on more responsibility within your current career. Designed for those new to writing SQL queries, this course is perfect for those who love to learn and like working with data.

1. Oracle SQL and PL/SQL Developer
   1. Oracle SQL
   2. Relational Database Basics
   3. Creating Tables
   4. Basic Selects
   5. Oracle SQL Functions
   6. Aggregate Functions
   7. Joins
   8. Subqueries
   9. Set Operators
   10. Conditional Processing with CASE
   11. Data Manipulation Language
   12. Creating Views
2. Oracle PL/SQL
   1. PL/SQL Basics
   2. Subprograms
   3. Conditional Processing
   4. Exceptions
   5. Cursors
   6. Packages
   7. Triggers
3. Oracle SQL Developer Final Project

What you will learn

• Build applications or generate business reports using Structured Query Language (SQL)
• Master SQL using an Oracle database
• Use PL/SQL extension language to write sophisticated queries against an Oracle database

How you will benefit

• Turn your passion for working with data into a profession by learning to write SQL queries
• Prepare to enter the job market as an entry-level Oracle SQL Developer or to take on more responsibility in your current role
• Set yourself apart from competitors by taking a challenging course in PL/SQL development

Stephen Withrow

Stephen Withrow brings over four decades of experience in training, development, and consulting across a broad spectrum of technologies, including Python, Java, Web Development, Oracle, C, and C++. His extensive background includes the design and implementation of business-critical solutions on client/server, web, and enterprise platforms. He holds a degree in Computer Science and Physics from Florida State University.

Stephen has provided training for a wide array of organizations, including the Department of Defense, Home Depot, CVS, Bank of New York, Merrill Lynch, IBM, and UPS, delivering high-impact instruction to professionals at every level of technical proficiency.

As a trainer, Stephen is widely recognized for his deep subject matter expertise, engaging teaching style, and ability to translate complex technical topics into clear, practical instruction. Students consistently describe him as patient, approachable, and incredibly knowledgeable, often calling him the best technical instructor they've ever had. He is praised for his real-world examples, kindness, and attentiveness to students' needs.

Stephen creates a positive, encouraging learning environment where participation is welcomed and questions are thoroughly addressed. His ability to adapt to varying experience levels while maintaining a structured and effective course flow sets him apart. Whether teaching beginning HTML or advanced Oracle development, Stephen equips students with the skills, confidence, and insights to apply their knowledge immediately in the workplace.

This course will teach you how to write SQL queries with Oracle.

Mastering Oracle SQL is one today's most marketable programming skills for end-to-end developers. This online, self-paced course covers the basics of Oracle SQL. You will learn the fundamentals, including queries, procedures, and functions through hands-on assignments. By course completion, your SQL skills will be on par with industry standards.

What you will learn

• How tables are structured and how data is stored
• To use Oracle to output reports and to use SQL functions
• To group data to get aggregate values
• To write joins and subqueries to get data from multiple tables and to write INSERT, UPDATE, and DELETE statements
• To use SET operators and to do conditional processing with CASE

How you will benefit

• Gain skills that every developers needs
• Bring your SQL skills to any web development job

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
• Oracle SQL Developer - The client interface for connecting to Oracle (software not included).
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.

Other:

• Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This self-paced training course will teach you the basics of writing SQL queries with Oracle.

1. Relational Database Basics
2. Creating Tables
3. Basic Selects
4. Oracle SQL Functions
5. Aggregate Functions
6. Subqueries
7. Set Operators
8. Conditional Processing with CASE
9. Data Manipulation Language
10. Creating Views

What you will learn

• How tables are structured and how data is stored
• To use Oracle to output reports and to use SQL functions
• To group data to get aggregate values
• To write joins and subqueries to get data from multiple tables and to write INSERT, UPDATE, and DELETE statements
• To use SET operators and to do conditional processing with CASE

How you will benefit

• Gain the SQL skills that every developer needs
• Bring your SQL knowledge to any web development job

Whether you're new to programming or just want to learn a new language, this in-depth course will teach you the ins and outs of Python programming.

Requirements:

Hardware Requirements:

• This course can be taken on a PC or a Mac.
• Dual monitors are helpful but not required.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 11.0 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Python (download and installation instructions are provided in course).
• Adobe Acrobat Reader.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Python's popularity has steadily increased over the years due to its simplicity, readability, and extensive libraries. According to the TIOBE Index, Python consistently ranks among the top programming languages, making it a valuable skill in today's job market.

Its clean syntax and intuitive nature make it an excellent choice for beginners, while its powerful features and vast ecosystem of libraries cater to the needs of experienced developers. Our Python course is perfect for both beginners and experienced programmers who are ready to start or advance their Python training.

In coding, Python is widely used for web development, data analysis, scientific computing, machine learning, and artificial intelligence. By enrolling in our Python coding course, you will gain a solid foundation in Python programming and become equipped with the skills and knowledge needed to build numerous applications, from simple scripts to complex web applications.

In this Python developer course, you will explore Python's applications, gain advanced sorting techniques for efficient data organization, and master mathematical operations and data manipulation. You will also understand how to perform complex numerical computations with NumPy and write modular, write reusable code with object-oriented programming in Python, and more.

1. Introduction to Python
   1. Python Basics
      1. Getting Familiar with the Terminal
      2. Running Python
      3. Running a Python File
      4. Exercise: Hello, world!
      5. Literals
      6. Exercise: Exploring Types
      7. Variables
      8. Exercise: A Simple Python Script
      9. Constants and Deleting Variables
      10. Writing a Python Module
      11. print() Function
      12. Collecting User Input
      13. Exercise: Hello, You!
      14. Reading from and Writing to Files
      15. Exercise: Working with Files
   2. Functions and Modules
      1. Defining Functions
      2. Variable Scope
      3. Global Variables
      4. Function Parameters
      5. Exercise: A Function with Parameters
      6. Returning Values
      7. Exercise: Parameters with Default Values
      8. Returning Values
      9. Importing Modules
      10. Methods vs. Functions
   3. Math
      1. Arithmetic Operators
      2. Exercise: Floor and Modulus
      3. Assignment Operators
      4. Precedence of Operations
      5. Built-in Math Functions
      6. The math Module
      7. The random Module
      8. Exercise: How Many Pizzas Do We Need?
      9. Exercise: Dice Rolling
   4. Python Strings
      1. Quotation Marks and Special Characters
      2. String Indexing
      3. Exercise: Indexing Strings
      4. Slicing Strings
      5. Exercise: Slicing Strings
      6. Concatenation and Repetition
      7. Exercise: Repetition
      8. Combining Concatenation and Repetition
      9. Python Strings are Immutable
      10. Common String Methods
      11. String Formatting
      12. Exercise: Playing with Formatting
      13. Formatted String Literals (f-strings) (introduced in Python 3.6)
      14. Built-in String Functions
      15. Exercise: Outputting Tab-delimited Text
   5. Iterables: Sequences, Dictionaries, and Sets
      1. Definitions
      2. Sequences
      3. Lists
      4. Sequences and Random
      5. Exercise: Remove and Return Random Element
      6. Tuples
      7. Ranges
      8. Converting Sequences to Lists
      9. Indexing
      10. Exercise: Simple Rock, Paper, Scissors Game
      11. Slicing
      12. Exercise: Slicing Sequences
      13. min(), max(), and sum()
      14. Converting between Sequences and Strings
      15. Unpacking Sequences
      16. Dictionaries
      17. The len() Function
      18. Exercise: Creating a Dictionary from User Input
      19. Sets
      20. *args and **kwargs
   6. Virtual Environments, Packages, and pip
      1. Exercise: Creating, Activiting, Deactivating, and Deleting a Virtual Environment
      2. Packages with pip
      3. Exercise: Working with a Virtual Environment
   7. Flow Control
      1. Conditional Statements
      2. Compound Conditions
      3. The is and is not Operators
      4. all() and any() and the Ternary Operator
      5. In Between
      6. Loops in Python
      7. Exercise: All True and Any True
      8. break and continue
      9. Looping through Lines in a File
      10. Exercise: Word Guessing Game
      11. The else Clause in Loops
      12. Exercise: for...else
      13. The enumerate() Function
      14. Generators
      15. List Comprehensions
   8. Exception Handling
      1. Exception Basics
      2. Generic Exceptions
      3. Exercise: Raising Exceptions
      4. The else and finally Clauses
      5. Using Exceptions for Flow Control
      6. Exercise: Running Sum
      7. Raising Your Own Exceptions
   9. Python Dates and Times
      1. Understanding Time
      2. The time Module
      3. Time Structures
      4. Times as Strings
      5. Time and Formatted Strings
      6. Pausing Execution with time.sleep()
      7. The datetime Module
      8. datetime.datetime Objects
      9. Exercise: What Color Pants Should I Wear?
      10. datetime.timedelta Objects
      11. Exercise: Report on Departure Times
   10. File Processing
       1. Opening Files
       2. Exercise: Finding Text in a File
       3. Writing to Files
       4. Exercise: Writing to Files
       5. Exercise: List Creator
       6. The os Module
       7. os.walk()
       8. The os.path Module
       9. A Better Way to Open Files
       10. Exercise: Comparing Lists
   11. PEP8 and Pylint
       1. PEP8
       2. Pylint
2. Advanced Python
   1. Advanced Python Concepts
      1. Lambda Functions
      2. Advanced List Comprehensions
      3. Exercise: Rolling Five Dice
      4. Collections Module
      5. Exercise: Creating a defaultdict
      6. Counters
      7. Exercise: Creating a Counter
      8. Mapping and Filtering
      9. Mutable and Immutable Built-in Objects
      10. Sorting
      11. Exercise: Converting list.sort() to sorted(iterable)
      12. Sorting Sequences of Sequences
      13. Creating a Dictionary from Two Sequences
      14. Unpacking Sequences in Function Calls
      15. Exercise: Converting a String to a datetime.date Object
      16. Modules and Packages
   2. Regular Expressions
      1. Regular Expression Tester
      2. Regular Expression Syntax
      3. Python's Handling of Regular Expressions
      4. Exercise: Green Glass Door
   3. Working with Data
      1. Virtual Environment
      2. Relational Databases
      3. Passing Parameters
      4. SQLite
      5. Exercise: Querying a SQLite Database
      6. SQLite Database in Memory
      7. Exercise: Inserting File Data into a Database
      8. Drivers for Other Databases
      9. CSV
      10. Exercise: Finding Data in a CSV File
      11. Creating a New CSV File
      12. Exercise: Creating a CSV with DictWriter
      13. Getting Data from the Web
      14. Exercise: HTML Scraping
      15. XML
      16. JSON
      17. Exercise: JSON Home Runs
   4. Testing and Debugging
      1. Testing for Performance
      2. Exercise: Comparing Times to Execute
      3. The unittest Module
      4. Exercise: Fixing Functions
      5. Special unittest.TestCase Methods
   5. Classes and Objects
      1. Attributes
      2. Behaviors
      3. Classes vs. Objects
      4. Attributes and Methods
      5. Exercise: Adding a roll() Method to Die
      6. Private Attributes
      7. Properties
      8. Exercise: Properties
      9. Objects that Track their Own History
      10. Documenting Classes
      11. Exercise: Documenting the Die Class
      12. Inheritance
      13. Exercise: Extending the Die Class
      14. Extending a Class Method
      15. Exercise: Extending the roll() Method
      16. Static Methods
      17. Class Attributes and Methods
      18. Abstract Classes and Methods
      19. Understanding Decorators
3. Python Data Analysis with JupyterLab
   1. JupyterLab
      1. Exercise: Creating a Virtual Environment
      2. Exercise: Getting Started with JupyterLab
      3. Jupyter Notebook Modes
      4. Exercise: More Experimenting with Jupyter Notebooks
      5. Markdown
      6. Exercise: Playing with Markdown
      7. Magic Commands
      8. Exercise: Playing with Magic Commands
      9. Getting Help
   2. NumPy
      1. Exercise: Demonstrating Efficiency of NumPy
      2. NumPy Arrays
      3. Exercise: Multiplying Array Elements
      4. Multi-dimensional Arrays
      5. Exercise: Retrieving Data from an Array
      6. More on Arrays
      7. Using Boolean Arrays to Get New Arrays
      8. Random Number Generation
      9. Exploring NumPy Further
   3. pandas
      1. Getting Started with pandas
      2. Introduction to Series
      3. np.nan
      4. Accessing Elements in a Series
      5. Exercise: Retrieving Data from a Series
      6. Series Alignment
      7. Exercise: Using Boolean Series to Get New Series
      8. Comparing One Series with Another
      9. Element-wise Operations and the apply() Method
      10. Series: A More Practical Example
      11. Introduction to DataFrames
      12. Creating a DataFrame using Existing Series as Rows
      13. Creating a DataFrame using Existing Series as Columns
      14. Creating a DataFrame from a CSV
      15. Exploring a DataFrame
      16. Exercise: Practice Exploring a DataFrame
      17. Changing Values
      18. Getting Rows
      19. Combining Row and Column Selection
      20. Boolean Selection
      21. Pivoting DataFrames
      22. Be careful using properties!
      23. Exercise: Series and DataFrames
      24. Plotting with matplotlib
      25. Exercise: Plotting a DataFrame
      26. Other Kinds of Plots

What you will learn

• Understand Python's significance and versatility among programming languages and its unique strengths.
• Learn advanced sorting techniques for efficient data organization
• Understand how to write modular and reusable code with object-oriented programming in Python
• Discover how to ensure the reliability of your Python code through testing and debugging
• Harness the power of regular expressions for advanced pattern matching
• Master mathematical operations and data manipulation using Python.
• Work seamlessly with databases, CSV files, JSON, and XML using Python.
• Perform complex numerical computations with NumPy in Python.
• Analyze and manipulate data effortlessly using the pandas library in Python

How you will benefit

• Prepare for an entry-level job as a Python programmer
• Elevate your programming abilities and expand your existing skill set by mastering new Python fundamentals
• Boost your confidence and resume with your new Python skills
• Stand out for a promotion or to future employers

Stephen Withrow

Stephen Withrow brings over four decades of experience in training, development, and consulting across a broad spectrum of technologies, including Python, Java, Web Development, Oracle, C, and C++. His extensive background includes the design and implementation of business-critical solutions on client/server, web, and enterprise platforms. He holds a degree in Computer Science and Physics from Florida State University.

Stephen has provided training for a wide array of organizations, including the Department of Defense, Home Depot, CVS, Bank of New York, Merrill Lynch, IBM, and UPS, delivering high-impact instruction to professionals at every level of technical proficiency.

As a trainer, Stephen is widely recognized for his deep subject matter expertise, engaging teaching style, and ability to translate complex technical topics into clear, practical instruction. Students consistently describe him as patient, approachable, and incredibly knowledgeable, often calling him the best technical instructor they've ever had. He is praised for his real-world examples, kindness, and attentiveness to students' needs.

Stephen creates a positive, encouraging learning environment where participation is welcomed and questions are thoroughly addressed. His ability to adapt to varying experience levels while maintaining a structured and effective course flow sets him apart. Whether teaching beginning HTML or advanced Oracle development, Stephen equips students with the skills, confidence, and insights to apply their knowledge immediately in the workplace.

Learn key skills that every developer needs to do their job more efficiently and effectively.

This course covers a variety of skills that every developer should know, like working with zipped folders and taking screenshots to working with Visual Studio Code and interacting with the developer community on Stack Overflow. These skills will help any developer be core prepared for additional learning and day-to-day work as a developer.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 11.0 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn key skills that every developer needs to do their job more efficiently and effectively.

1. Zip Files
2. Showing Extensions
3. Taking Screenshots
4. Using Command-Line Shell
5. Relative and Absolute Paths
6. Environment Variables
7. Browsers
8. Visual Studio Code
9. Stack Overflow

What you will learn

• How to create and extract zip files on a Windows computer or a Mac
• How to show extensions on a Windows computer or on a Mac
• How to take screenshots
• Basic commands in each shell
• Navigate the file system using relative paths and absolute paths

How you will benefit

• By learning these basic skills, developers will be more prepared to learn and develop additional skills.