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.

For more information please click on the link.

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

For more information click on the link.

This course explores the developmental process and how to be successful in effectuating change. Since most business organizations are social systems, this course dives into organizational culture and how it influences the health of a business and its people long-term.

For more information please click on the link.

Persuasive communication is essential not only for selling the products or services of the business but for obtaining financing and running daily operations. This course will provide you with the opportunity to gain confidence and improve their communication skills. Even the most skilled communicator can always learn additional techniques for success.

For more information click on the link.

Are you a prospective teacher who needs to pass the Praxis Core Exam? Have you already attempted the Praxis Core and not been successful? If you answered yes to either of these questions, then this course is for you.

You will get familiar with the different types of questions that appear on the reading and writing tests. You will master the many areas of math that you will be tested on: number operations, negative numbers, exponents, square roots, order of operations, decimals, fractions, percentages, algebra, geometry, systems of measurement, and probability and statistics. To prepare for the two essays, you will learn what constitutes high scoring essays and go through the process of writing each essay in the amount of time allotted.

You will also learn useful test-taking strategies and have the opportunity to take a full-length practice test in each subject area. Using clear explanations, numerous examples, graphics, animation, and videos, this course will not only prepare you for the Praxis Core, but do so in a fun and interesting way. After completing this course, you will be ready to pass the Praxis Core Exam.

This class is Instructor-Led or Self-paced.  Instructor-Led classes start April 12, May 17, Jun 14 and July 12.

For more information or to register please click the link.

This course will help you navigate the laws of probate processes and estate planning. You'll learn how various types of ownership affect the passage of property at owner death, with or without a will. You will also learn about the administration and taxation of estates as well as basic requirements for trusts, wills and guardianships.

Introduction to Estate Planning

Components of a Will

Execution of a Will

Trusts in Estate Planning

For more info click on the link.

Improving organizational performance is a critical skill set for any leader. In this course, you will learn how to develop benchmarks, monitor performance and apply benchmark results to improve organizational efficiency and productivity.

Attention all writers! Learn how to efficiently and effectively conduct research for any writing project: fiction, nonfiction, business . . . even term papers and dissertations. Research has progressed far beyond a visit to the library. Today, myriad sources provide almost anything a writer might need to know on any subject. Learn how to identify and access every information source imaginable.

Research: The Foundation of Writing

In this introductory lesson, you'll learn why good research skills are necessary for effective writing. You'll unleash your creativity with the exciting "Mind Mapping" tool to identify your subject—in both a general and specific way—to help refine your research before you even begin. You'll also learn the importance of understanding jargon and technical terms specific to your subject, which will leave you much better prepared to begin your project.

Making a Plan

You probably already know that much time can be wasted if research is conducted in a disorganized manner. In this lesson, you'll learn how to organize a plan for your research and how to keep organized once your research is underway. You'll identify the first steps of research, including choosing between academic and anecdotal research, primary and secondary sources, and which resources will be the most productive for you in the early stages of research.

The Library: A Virtual Field Trip

The library is still the most all-inclusive resource for research, but many people aren't aware of the treasure trove of information residing within its walls. This lesson will take you on a virtual field trip through the many library sections and departments, introducing and reviewing the materials available, including periodicals, microfilm records, Lexis-Nexis, rare books, reverse directories, government reports, maps, old telephone books, and many others. You'll discover resources that you never knew existed.

The Personal Interview

One of the most productive resources for researches is the personal interview, but it can be intimidating. In this lesson, you'll learn how to find experts and how to prepare for an interview. You'll learn the keys to formulating questions designed to get the very best from your subject. By the time you finish this lesson, you'll feel confident and competent to approach your interview subjects with ease.

Getting the Most out of Reports and Studies

Perusing reports can seem about as much fun as a root canal, but it's worth it when you find nuggets of information essential to your research. This lesson will introduce you to numerous valuable reports, including census reports, public company reports and a multitude of government reports. You'll learn how to separate the wheat from the chaff, winnowing out the pertinent information, and how to assess a report not only for its content but also for the reliability of its source. As a bonus, you'll be given some guidelines for turning statistics into prose.

History: Fact or Fiction?

In this lesson, you'll learn how to incorporate history into your writing, whether it's fiction or nonfiction. You'll discover what you've probably suspected all along: the truth of history is often shaped by the perspective of the historian. This lesson will teach you how to evaluate different perspectives, how to spot "rewritten history," and how to zero in on fact versus mythology.

Public Records: A Treasure Trove of Information

This lesson will introduce you to the numerous public records that are waiting to reveal information about persons, places, and things. Real estate records, birth, marriage and death records, civil and criminal trial records, bankruptcy filings, construction records, and political campaign information are but a few of the many records available to the public. By the end of the lesson, you'll know what's out there and how to get to it.

The Internet: A Researcher's Best Friend

Conducting research on the Internet can be a valuable time-saver. It can also allow researchers to fall into the trap of believing everything they read. This lesson will discuss Internet reliability: what you can trust and what you should distrust. You'll also learn skills for effectively using search engines for your research, for both general and specific topics. You'll find many useful research links and learn about issues such as when you should and should not pay for your information. The Internet has as many pitfalls as benefits, and this lesson will show you how to avoid the pitfalls.

Creating Your Own Information

Some researchers can't resist the lure of using information that has never before existed. This lesson discusses the value of collecting your own data by way of surveys, studies, interviews, polls, and questionnaires. You'll learn how to effectively create these instruments of data-gathering, and you'll learn the difference between valid statistical sampling versus informal, nonscientific results, and when the use of each is appropriate.

Guerrilla Research

Have you ever had difficulty finding cooperative sources of information? This lesson will reveal the secrets of Guerilla Research; i.e., how to get answers when the questions are being evaded. You'll learn techniques for gaining the confidence of reluctant interview subjects, as well as methods for digging and snooping. In other words, you'll learn how to get what you want when the direct approach isn't working.

Attribution: Giving Credit When Credit Is Due

Once your research has been compiled, much of it will be quoted or paraphrased within your manuscript. This lesson will discuss the importance of proper attribution as well as the technical methods for crediting your sources. You'll learn how to painlessly create a bibliography, and you will also learn how to decide between citations, footnotes, and endnotes for your work. You can easily avoid copyright violations by gaining a basic understanding of copyright law, along with the fundamentals of fair use and permissions. Writers know how important it is to protect themselves, and in this lesson you'll learn how.

Pulling It All Together

Your research is complete, your facts are gathered; now what? In this final lesson, you'll learn what to do with all the research materials you have accumulated. You'll learn how to identify what is valuable and what should be discarded. You'll gain insight on both the writing and the editing process, and as a bonus, you'll learn how to avoid some of the most common word-usage mistakes. This lesson will give you the final skills you need to produce a well-researched, polished manuscript.

This is a self-paced class.  For more information or to register please click the link.