We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence.

Transform your customer service into something extraordinary. As a result more repeat business will improve your bottom line.  Customer service separates you from your competition. Extraordinary customer service comes from focusing on the few essential elements that yield big results. Discover how easy it is to tweak your customer service from the ordinary to the extraordinary. You'll take away a customer service plan that will help you focus on the key elements that will get you started on your pathway to success.

Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level!
This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do.

If you have wanted to become a notary public, but have been worried about the exam, this class will help. Don't let the terminology scare you−you can become familiar with the terms and laws and learn the skills necessary to sit for the notary exam and earn the license to become a more valuable asset in your workplace.

This program is designed for beginning or advanced legal workers. To receive a certificate, you must pass numerous quizzes and successfully complete several writing assignments. To enroll, contact the Center for Legal Studies at 1-800-522-7737. Books and materials must be purchased separately. For more information, visit https://www.legalstudies.com/product/mohawk-valley-community-college-paralegal-certificate-course/

In today’s business environment, there is a need for good project management.  Project management provides visibility of project health to the business and the customer.  Through continuous monitoring, early detection of variations to plan, schedule, and budget can be communicated to stakeholders for quick resolution, including project cancelation.  The Project Management Professional community does this through the five (5) Project Management Processes supported by the ten (10) Project Management Knowledge Areas.  This course introduces the student to the ten (10) Project management Knowledge Areas and their support role and relationships to the five (5) Project Management Processes.

Acquire a well-rounded knowledge of the five Project Management Processes relating to the Project Management Body of Knowledge (PMBOK) Guide. This basic information will assist you in learning the beginnings of Project Management, whether you are interested in project management, in a project management field, or in any line of work.   Come away with a solid foundation of the five processes to learn and use when any type of project occurs in your employment arena.

The New York State Education Department requires healthcare, educational, and other licensed professionals to be trained to identify and report child abuse. Matriculated students at MVCC should consult with academic advisors before enrolling in this course.

This course will address the social patterns of harassment, bullying, and discrimination including, but not limited to, those acts based on a person's actual or perceived race, color, weight, national origin, ethnic group, religion, religious practice, disability, sexual orientation, gender, or sex. It will also cover the identification and mitigation of harassment, bullying, and discrimination and strategies for effectively addressing problems of exclusion and bias and aggression in educational settings. Successful completion of this course will meet the certificate requirements in 14(5) of Chapter 102 of the Laws of 2012.

This course will address the social patterns of harassment, bullying, and discrimination including, but not limited to, those acts based on a person's actual or perceived race, color, weight, national origin, ethnic group, religion, religious practice, disability, sexual orientation, gender, or sex. It will also cover the identification and mitigation of harassment, bullying, and discrimination and strategies for effectively addressing problems of exclusion and bias and aggression in educational settings. Successful completion of this course will meet the certificate requirements in 14(5) of Chapter 102 of the Laws of 2012.

This course will address the social patterns of harassment, bullying, and discrimination including, but not limited to, those acts based on a person's actual or perceived race, color, weight, national origin, ethnic group, religion, religious practice, disability, sexual orientation, gender, or sex. It will also cover the identification and mitigation of harassment, bullying, and discrimination and strategies for effectively addressing problems of exclusion and bias and aggression in educational settings. Successful completion of this course will meet the certificate requirements in 14(5) of Chapter 102 of the Laws of 2012.

This workshop satisfies the New York State Education Department's requirement for two-hour school violence prevention training (SAVE). The course focuses on issues relating to violence and safety for school-age children from both the identification and prevention perspectives. Topics include abuse and neglect, abduction, substance abuse, traffic and fire safety, and violence. Teachers' legal responsibilities, dangerous behavior identification, intervention techniques, effective classroom management, and promoting positive attitudes and behaviors will also be discussed.

Many of your business decisions involve comparing groups for differences. For example, would men and women prefer different product features? In addition, you may look at relationships between variables. Does product recognition relate to subsequent product purchase? This Intermediate Data Analysis course will introduce you to the statistics behind these group differences and relationships. In addition, you'll learn how to work with ratings, graphs and user-friendly reports of statistical results.

After taking this advanced course in Data Analysis, you will be able to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Take the guesswork out of important company decisions and make decisions based on statistically significant information. Whether your business is home based or a large company, this class will take you to the next level where important decision-making is concerned.

In this online certificate program, you'll get the most advanced information about the three most important and most prevalent characteristics you experience with your participants: generation, gender, and the autism spectrum. Your instructors are some of the foremost authorities in the world on these subjects. They write and speak around North America on learning styles.

Discover how girls spend 30% of their study time, why boys get worse grades than girls, why boys do less homework than girls, and the 5 learning habits girls get in school that hurts them in the workplace. Your female students learn differently than your male students. Take away 10 top tips for helping students learn more, and the 5 tips to help students succeed more.

Today, every school in America has students who have been diagnosed with ASD (Autism Spectrum Disorder)−a neurological disorder on the autism spectrum. The effects of this disorder vary widely, but it is important for every teacher to understand how to recognize behaviors that may indicate ASD. In this course, take away strategies for working effectively with ASD students. You will find out how to work effectively with parents to create the most positive learning environments for children and teens with this disorder. The course is geared for K-12 teachers, but it is also relevant for counselors, faculty in higher education, parents and anyone else interested in understanding this important issue.

This course will focus on the influence of generational characteristics on learning styles. Your students learn differently than you do. Come find out how to help your students learn more and discover something new about yourself too! We will explore fascinating information on the brain and how each generation has responded to their unique "cohort experience." You will acquire the skills and information needed to facilitate Gen Y and the emerging generation of learners. Understand how your own generational characteristics impact your learning and your teaching. Come away with our top 20 generational techniques for helping your students learn more.

Develop a two-way communication and marketing strategy for your organization using social networks. Let your instructor guide you in exploring major social networks, including Twitter, LinkedIn, and blogging. Learn quick, easy ways to use Twitter, blogs and LinkedIn to engage your customers or clients and keep them interested in your organization or business. You'll find out the advantages and disadvantages of each, and learn what's right for your work and kind of organization.

Take away a practical strategy and techniques for implementing social networks for your organization or business. Learn how to create your own private social network using Ning, work socially using Google Docs and calendars, and move your web site to an interactive Web 2.0 site. Your instructor will help you choose which social network tools are right for your situation, and then integrate them into your web site to develop a social networking strategy for your organization. Find out what you can be doing, what you should be doing, and take back a plan to integrate social networks into your communication and marketing.

Learn about the online instructional environment, envisioning your online course, developing a web course, phases of design and development, design guidelines, and more. Discover the principles behind the adoption of technology innovation and the nature of the online learning environment. Then get tips for planning your online course, identifying resources and design guidelines. Discuss the phases of design and development and models, motivating student-student interaction, and managing interaction. Get the latest information on copyright issues, assessment and evaluation.

Being engaged with your online learners throughout the course is one of the three biggest weaknesses of online teachers. It is also one of the three biggest ways to take your online course to the next level, making it a superior learning experience for your learners. Come experience how to do it from the creator of the concept and practice of 'continual engagement' in teaching. Discover how to build student success through your interaction, how to give online learners feedback, communicating with them about everything from subject matter to delicate issues to grading. You will come away with advanced, practical, how-to tips from one of the foremost authorities on fostering online discussion. And you will see how your instructor models great interaction and engagement in the online environment.

This course covers all the basics of HTML coding language. You will learn building simple web pages by hand coding, using HTML tags to create paragraphs, headings, lists, links, insert images and tables and more. We also cover creating a simple multi-page website with images, text and a navigation bar.

In this introductory course, you will learn how to style web pages using Cascading Style Sheets (CSS) coding language. Topics include using inline, internal, and external CSS, web typography, formatting text, working with web colors, using Google fonts, working with id and class selectors, working with elements, creating page layouts using elements, and CSS box model.

Acquire the basic skills to boost your web site traffic, including how to analyze your visitor traffic, how to use search engine optimization to get greater visibility and exposure in Google searches, and how to redesign your web site copy to increase your visitors and results.

Get the keys to making online advertising work for you and your organization. See how pay-per-click advertising with Google AdWords works. Find out how to test low budget Adword campaigns. Learn how you can target local audiences. Then discover Facebook advertising and how you can determine the demographics and even numbers of people you want to reach.

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.

In this course, you will learn how to post journal entries to the correct general ledger accounts impacted by each transaction. This course will show you how to make sure your general ledger balances at the end of each month by preparing an unadjusted trial balance. You will learn how to look for errors when you don't balance, and how to determine to correct entries. After posting correcting entries and/or adjusting entries, you will verify debits and credits equal with an adjusted trial balance. This course also goes through the steps of performing monthly bank reconciliations.

This course shows you how to create a worksheet used to adjust the account balances and prepare the financial statements. Use your financial statements to measure performance, make improvements and set goals. The final step covered in this course is closing your books and preparing them for the next accounting period; this is done by journalizing and posting closing entries.

This eight-hour initial certification course is required for any renovators without previous training to become a certified lead-safe contractor. Bring a pen, pencil, and paper; all other materials will be provided. The course concludes with a 25-question exam. Students should also bring lunch.

We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence.

The New York State Education Department requires this class for licensed professionals, including physicians, physicians' assistants, specialist assistants, dentists, dental hygienists, Registered Nurses, Licensed Practical Nurses, optometrists, and podiatrists. Certification is valid for four years. (0.3 CEUs)

The New York State Education Department requires this class for licensed professionals, including physicians, physicians' assistants, specialist assistants, dentists, dental hygienists, Registered Nurses, Licensed Practical Nurses, optometrists, and podiatrists. Certification is valid for four years. (0.3 CEUs)

Every successful person in the workplace utilizes financial information to aid effective decision making. The Certificate in Accounting and Finance for Non-Financial Managers explains the financial concepts and accounting processes used in most businesses and will provide practical techniques that will increase your effectiveness and career. 
   First, get a foundation to understand the seven steps in the accounting cycle and use financial information in decision making. Come away with the knowledge to analyze resource allocation and evaluate financial performance.
   Then find out what you need to know about cash.  Cash is the non-financial manager who really makes a difference in the day-to-day cash activities. Discover how to maximize cash flow, learn the importance of cash and find out your role in cash flow success.
   Finally, acquire advanced knowledge on the financial information that drives your organization. See how business reports are assessed and analyzed.  An understanding of this information will help you make smart decisions when it comes to budgeting, setting goals, and assessing performance within your own area of influence.

Whether it relates to retaining customers, serving your audience, or turning inquiries from potential customers into sales, good customer service is now one of the central factors in organizational success. Learn to improve your customer service skills to enhance your career skill set, improve productivity, and increase your organization’s success. You also will take away some extraordinary customer service techniques you won’t find anywhere else.

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world.

Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence.

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world.

Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence.

First, gain the skills, tools and templates to confidently develop and maintain a project. Then, acquire a well-rounded knowledge of the five Project Management Processes relating to the Project Management Body of Knowledge Guide. Finally, learn the 10 Project Management Knowledge Areas and their support role and relationships to the five Project Management Processes.

With the demands of daily operations, non-financial managers may put financial reports on the shelf. But take a look at some of the most admired companies like Apple, Google, and Berkshire Hathaway. Sure, they are evaluated by their products, innovation, and culture but they wouldn’t be in the limelight without profits. Money matters! This course will help you build on your understanding of financial concepts and help you establish your role in the financial success of your organization.  
    Designed for non-financial managers, business owners, entrepreneurs, and other decision-makers, this advanced course will take the mystery out of money matters. Throughout this course, financial information that drives your organization, as seen on the business’s reports, will be assessed and analyzed to understand it. An understanding of this information will help you make smart decisions when it comes to budgeting, setting goals, and assessing performance within your own area of influence. 

In today’s business environment, there is a need for good project management.  Project management provides visibility of project health to the business and the customer.  Through continuous monitoring, early detection of variations to plan, schedule, and budget can be communicated to stakeholder for quick resolution, including project cancelation. Project management is one of the fastest paths to promotion by increasing your network through greater exposure.  You will have the skills, tools and templates to confidently develop and maintain a project.  An overview of salaries, certification costs, education and experience requirements are provided.  We hope you will choose Project Management as a career.

Learning to build your customer service skills will have a powerful impact on your career success as well as success in other areas of your life.  Through this course you will discover the direct relationship between service skills and career achievement.  You will become skilled at being an exceptional service provider.  You can help your organization and your career by translating your good service intentions into a workable plan and gain knowledge of ways to consistently deliver great service.  The payoff is enormous.

Must-have skills to succeed in the workplace include the ability to create, edit and manage presentations in MS PowerPoint, documents in MS Word, email and calendars in MS Outlook, and spreadsheets in MS Excel. Microsoft Office Suite of applications is the most used software tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of MS Office change over time. Master the most common uses so that you can work faster and more efficiently and can take your computer skills from plain and drab to exciting and engaging. You will leave class with a set of skills that are a workplace requirement in today’s fast paced ever-changing environment and will enable your future career success.

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success.

This program is designed for beginning or advanced legal workers. To receive a certificate, you must pass numerous quizzes and successfully complete several writing assignments. To enroll, contact the Center for Legal Studies at 1-800-522-7737. Books and materials must be purchased separately. For more information, visit https://www.legalstudies.com/product/mohawk-valley-community-college-paralegal-certificate-course/

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. Add a whole new skill set to your portfolio, and make a big difference in the success of your organization by acquiring data analysis skills. Begin with getting a basic understanding of how to analyze data in a business setting. Then learn how many of your business decisions involve comparing groups for differences. You will know the statistics behind these group differences and relationships. Finally you will find out how to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Whether your business is home based or a large company, this certificate will take you to the next level where important decision-making is concerned.

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. Add a whole new skill set to your portfolio, and make a big difference in the success of your organization by acquiring data analysis skills. Begin with getting a basic understanding of how to analyze data in a business setting. Then learn how many of your business decisions involve comparing groups for differences. You will know the statistics behind these group differences and relationships. Finally you will find out how to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Whether your business is home based or a large company, this certificate will take you to the next level where important decision-making is concerned.

This course will give you a basic understanding of how to analyze data in a business setting. Businesses look for candidates with an understanding of how to analyze the data they have been collecting; this course will help you start on that journey.

After taking this advanced course in Data Analysis, you will be able to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Take the guesswork out of important company decisions and make decisions based on statistically significant information. Whether your business is home based or a large company, this class will take you to the next level where important decision-making is concerned.

From Facebook to Twitter, blogging, YouTube, LinkedIn, and more, discover the new principles of communication that apply across all networks and how these specific social networks work and the possible uses for your organization. Whether you are new to social networks or already involved, you will come away with an understanding of social networks and practical, how-to techniques to integrate social networks into your organization or business.

From Facebook to Twitter, blogging, YouTube, LinkedIn, and more, discover the new principles of communication that apply across all networks and how these specific social networks work and the possible uses for your organization. Whether you are new to social networks or already involved, you will come away with an understanding of social networks and practical, how-to techniques to integrate social networks into your organization or business.

Get involved in the move from in-person to online communication. Learn what social networks are and their role in your business and personal life. Find out the top sites and how businesses are using the sites for communication, customer retention, branding, marketing, market research, needs assessment and serving customers and clients. Explore the options for your organization. Look at case studies of what other organizations are doing. Let your instructor guide your exploration of Facebook and YouTube. For anyone interested in social networks.

Take away a practical strategy and techniques for implementing social networks for your organization or business. Learn how to create your own private social network using Ning, work socially using Google Docs and calendars, and move your web site to an interactive Web 2.0 site. Your instructor will help you choose which social network tools are right for your situation, and then integrate them into your web site to develop a social networking strategy for your organization. Find out what you can be doing, what you should be doing, and take back a plan to integrate social networks into your communication and marketing.

From building to improving an online course, from fostering online discussion to encouraging student interaction, from traditional assessment to online tests, the program will give you the fundamentals of teaching online, as well as the most advanced tips and techniques in the business. Your instructors are authors, speakers, and consultants in online learning and teaching. This certificate includes Advanced Teaching Online, Designing Online Instruction, and Fostering Online Discussion.

From building to improving an online course, from fostering online discussion to encouraging student interaction, from traditional assessment to online tests, the program will give you the fundamentals of teaching online, as well as the most advanced tips and techniques in the business. Your instructors are authors, speakers, and consultants in online learning and teaching. This certificate includes Advanced Teaching Online, Designing Online Instruction, and Fostering Online Discussion.

In the 21st century, half of all learning will be online. The opportunities are tremendous for teaching online. Discover how to plan, develop and teach an online course. Take home a ten step model for developing your online course. Experience one of the most advanced online classrooms for teachers. Learn how to create online audio lectures with slide shows. Plus, find out how self quizzes enhance learning.

Being engaged with your online learners throughout the course is one of the three biggest weaknesses of online teachers. It is also one of the three biggest ways to take your online course to the next level, making it a superior learning experience for your learners. Come experience how to do it from the creator of the concept and practice of 'continual engagement' in teaching. Discover how to build student success through your interaction, how to give online learners feedback, communicating with them about everything from subject matter to delicate issues to grading. You will come away with advanced, practical, how-to tips from one of the foremost authorities on fostering online discussion. And you will see how your instructor models great interaction and engagement in the online environment.

Begin by getting introduced to the basics of computer programming and various programming languages, then go to the next level and acquire all the basics of HTML and CSS. You'll learn the relationship between these two industry-standard web page-coding languages and the step-by-step process of hand coding and building web pages. Finally, discover the advanced features of CSS and learn how to use this very powerful language.

Begin by getting introduced to the basics of computer programming and various programming languages, then go to the next level and acquire all the basics of HTML and CSS. You'll learn the relationship between these two industry-standard web page-coding languages and the step-by-step process of hand coding and building web pages. Finally, discover the advanced features of CSS and learn how to use this very powerful language.

In this introductory course, you will learn how to style web pages using Cascading Style Sheets (CSS) coding language. Topics include using inline, internal, and external CSS, web typography, formatting text, working with web colors, using Google fonts, working with id and class selectors, working with elements, creating page layouts using elements, and CSS box model.

Come get a fundamental yet advanced introduction to eMarketing, including improving email promotions, analyzing your website traffic, doing search engine optimization, and how to successfully employ online advertising. Relevant for any type of organization, including businesses, companies, non-profits, and government agencies. No eMarketing experience or expertise is necessary. If you are already at an advanced level, your instructors are experts and can provide the latest most advanced information and answer your toughest questions.

Come get a fundamental yet advanced introduction to eMarketing, including improving email promotions, analyzing your website traffic, doing search engine optimization, and how to successfully employ online advertising. Relevant for any type of organization, including businesses, companies, non-profits, and government agencies. No eMarketing experience or expertise is necessary. If you are already at an advanced level, your instructors are experts and can provide the latest most advanced information and answer your toughest questions.

Discover new ways to improve your email promotions, including when to email, what to email, and testing email copy. Then find out how to analyze your email response rates, including getting the bench marks for open rates and click through rates. Learn how to improve your email promotion and responses with tracking and testing.

Get the keys to making online advertising work for you and your organization. See how pay-per-click advertising with Google AdWords works. Find out how to test low budget Adword campaigns. Learn how you can target local audiences. Then discover Facebook advertising and how you can determine the demographics and even numbers of people you want to reach.

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You'll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You'll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs.

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You'll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You'll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs.

Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database.

Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.

How do you manage the finances of a business? Whether you are an entrepreneur, running a family business, or just looking to advance your career and add to your skill set, this Bookkeeping Certificate will provide you with the knowledge needed to measure, and manage, the financial health of your business. This program focuses on cash basis accounting. No one will care more about the financial health of your business than you! It's imperative that you understand how the process works and are able to complete the accounting cycle accurately and in a timely fashion. Even if you plan to outsource your bookkeeping needs, you should still understand how the process works. No one should be clueless when it comes to the finances of their business.

How do you manage the finances of a business? Whether you are an entrepreneur, running a family business, or just looking to advance your career and add to your skill set, this Bookkeeping Certificate will provide you with the knowledge needed to measure, and manage, the financial health of your business. This program focuses on cash basis accounting. No one will care more about the financial health of your business than you! It's imperative that you understand how the process works and are able to complete the accounting cycle accurately and in a timely fashion. Even if you plan to outsource your bookkeeping needs, you should still understand how the process works. No one should be clueless when it comes to the finances of their business.

In this course, you will learn about the accounting equation and the five categories involved in every business (Assets, Liabilities, Owner's Equity, Revenue and Expenses). Every financial transaction falls into one or more of these categories. Learn how to create a chart of accounts that meet the needs of your business. You will learn how double entry bookkeeping works and the process of recording debits and credits. This course will show you how to identify, analyze and record transactions using journal entries under the cash basis accounting method.

This course shows you how to create a worksheet used to adjust the account balances and prepare the financial statements. Use your financial statements to measure performance, make improvements and set goals. The final step covered in this course is closing your books and preparing them for the next accounting period; this is done by journalizing and posting closing entries.

If you are not reviewing your website statistics, then you are missing several key opportunities to profit from your website traffic. This certificate, aimed at non-technical users, will take you through all the key techniques and how to use website analytics using the world-standard Google Analytics, a free online tool.

In this class, you'll understand your visitor traffic better, learn how to calculate return on investment (ROI) for your online advertising, and find out how to get more conversions and sales from your website visitors. A must for anyone serious about leveraging more success from their website.

Are you frustrated by the communication gap that can occur between you and your Spanish-speaking patients? If you answered yes, this Spanish class - designed specifically for healthcare professionals - will help you bridge that gap. You will practice the basic, practical language skills needed to effectively communicate with your Spanish-speaking patients and their families. You will learn the basics of the language, gain an understanding of the culture, and know how to ask the questions crucial to quality healthcare. 
   Whether you speak some Spanish and need a refresher, or speak no Spanish, you will complete the course with the skills you will need to effectively communicate with your Spanish-speaking patients. 

NOTE: Students will also need to order an eBook for under $15, or the paperback book version (please see book information below).

Students will purchase (on their own) McGraw-Hill Education Complete Medical Spanish, 3rd Edition: ISBN-13: 978-0071841887. The eBook version is available at Barnesandnoble.com. You can also purchase the paperback book version if you wish, available from numerous sources including Amazon.