Course Class: Government

Advanced SQL

This course provides an advanced understanding of SQL and its uses. There are several hands-on labs in this course that will provide the participant with the opportunity to practice and perfect the knowledge or Oracle.

Accessing a relational Database requires understanding of Structured Query Language (SQL).  This hands-on course picks up where most SQL users’ skills end.  The focus of the course is on understanding SQL syntax, being able to write an efficient complex query, and “Thinking in SQL”.  A core component of this class is understanding performance.  This course includes an in-depth look at the factors that affect performance and understanding the issues prior to asking a DBA for help.  This course explores the ANSI-95 SQL standard, along with Oracle SQL.

SQL Introduction (3-day)

This course is a user’s introduction to SQL and how to put it into practice for their organization.

Accessing a relational Database requires understanding of Structured Query Language (SQL). This course introduces the student to the Oracle SQL language. This course explores the fundamentals of SQL Developer and SQL language, syntax rules and best practices. This hands-on course provides a thorough grounding in using SQL in Oracle from a developer viewpoint.

SharePoint Site User: Site Basics

This course provides the basics of accessing, storing, sharing, and collaborating for new SharePoint site users.

In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft® SharePoint® is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents.

SharePoint Site Owner

This course teaches SharePoint site owners to configure, integrate data and apps with, and manage information within the site in order to best meet the needs of the organization and its users.

Microsoft SharePoint helps people collaborate and use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. SharePoint can also help organizations segment digital information, share information from external sources, archive records, and create rich websites quickly and easily. In this course, you will learn how to create, configure, and manage a SharePoint site so that your team or organization can collaborate effectively, manage the flow of digital information, meet governance and compliance needs, and create rich websites for your organization’s needs.

SharePoint features are robust and complex. Site owners can determine what features and options to make available in SharePoint, and how to configure those features to meet organizational and user needs. By properly implementing these features, users will be able to collaborate effectively, and organizations will save time and money through automation of business processes, fast and efficient retrieval of information, and effective records management.

Modeling Techniques for the Business Analyst

This course presents the basics of Business Analysis.

The course covers the creation of a current system implementation model and its transformation into a system essential model (requirements specification). Current system implementation models are used to take a system and break it down into its subsystems based on business or project need. Each subsystem can then be broken down into greater levels of detail to document business requirements.

Leading Virtual & Hybrid Teams

The workshop teaches strategies for organizations operating in a post-pandemic hybrid world how to support teams, foster collaboration, and engage employees.

In describing the post pandemic hybrid model of the future, more than 50% surveyed want to work from home at least 3 days a week. Two to three days a week seems to be the sweet spot for work-life balance. Nearly 33% say they would like to work remotely full time. About 73% of employees want flexible remote work options to stay and 67% of employees want more in-person work or collaboration post-pandemic.

This workshop will teach you practical strategies and tools for creating, leading, and supporting your own dynamic virtual teams and organizations using organizational knowledge sharing and collaboration tools. The workshop will help you bridge the communication gaps created by geographical separation and guide you in fostering collaboration and engaging employees throughout your agency.

    • Redefine Team Culture roles and positions.
    • Benefits of working remotely and in the office.
    • Develop strong communication systems.
      1. Keep everyone on the same page
      2. Avoid communication breakdowns
      3. Provide opportunities for feedback
    • Motivating Employees
      1. Building a Virtual or Hybrid Team
      2. Explain fully what is expected and not expected working remotely
      3. Encourage team cohesiveness
      4. Minimize tension when people are dispersed

Leadership for Today, Tomorrow, and the Future!

This course is designed to help leaders how engagement is affected due to different leadership styles.

Teamwork is a “we” but starts with “me!”

The leader of the team impacts engagement and results through their style, skills, coaching, and interaction. This engaging session includes lectures, discussion, exercises, and goal setting. As a result of this session, participants will have the necessary skills to engage their team today, tomorrow, and in the future.

Leadership for Non-Supervisors

This course is designed to acquaint nonsupervisory employees with the qualities of leadership.

In this course, students will learn to identify factors that affect team performance, to discuss leadership styles and how to influence and inspire others, and to develop and refine leadership behaviors. Employees and team members enhance their value to the team as whole by assuming the qualities of a leader: having the ability to adapt to change, taking charge when necessary, and accepting responsibility for one’s decisions and actions. Students will learn skills and techniques that can readily use to enhance their efficiency and performance.

Business Systems Testing Fundamentals

This course is designed for those in an organization responsible for the testing of Systems Development Life Cycle deliverables or participating in the design and maintenance of a QA process.

This course presents an architecture that defines a process to implement a structured testing environment for all phases of the Systems Development Life Cycle (SDLC). It conveys the four techniques of structured testing, and the application of those techniques during the phases of the SDLC. Using risk assessment as a guide for structured testing is emphasized, and a risk matrix is presented. The main focus is on the creation of functional and structural test plans, test scripts, and test cases, including the use of break-it testing, complexity testing, and basis path testing. The organization of a testing team and the testing environment is also discussed. Hands-on workshops in a JAD format are used to reinforce concepts.

Collaborative Teamwork for Success

This is a course designed to help leaders better understand how to facilitate collaboration between teammates.

In this highly interactive, hands-on workshop participants will explore what collaboration means to the culture, relationships, and communications, to create an effective team to improve morale and productivity.  Collaborative facilitation process to integrate two different groups into a dynamic team with shared goals and values.