TOTAL DAYS: 1 | TOTAL HOURS: 8
In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. Now that you have a foundation in how to query databases, you will learn in this course how to identify and use advanced querying techniques. In addition, you might find that you need to perform tasks such as modifying the structure of a table; inserting, updating, or deleting data; and indexing tables to optimize query performance. In this course, you will learn how to complete these tasks and more.
In today’s competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization’s processes and give it a competitive edge. As the organization grows, you will need to handle large amounts of data. Under such circumstances, you might need to query multiple tables simultaneously and with increasing frequency. You must step up the speed of generating query output to cope with the increasing demands of data storage, management, and retrieval.
Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.
This training program is designed to help you acquaint others with stress management skills. In this course, participants will learn how to define stress and will learn to understand its effects on emotional health, examine strategies for coping with stress, employ mindfulness meditation techniques, learn how to make personal contacts positive and meaningful, and explore ways to attain and maintain emotional maturity.
Succession planning saves the cost and time of external personnel searches. It improves employee morale, lessens the effects of re-engineering and downsizing, but most important, it creates a diverse talent pool within your organization. This book was written to guide you through the evaluation process of succession planning. It describes the guidelines for setting up a program, along with bench-marking procedures for ensuring the ongoing success of your plan.
We all depend on phones every day, and we each have different phone communication styles. But few people realize how essential proper telephone techniques are to business. The fact is telephone skills are critical to quality customer service. Through this class, you will learn how to represent your company and satisfy the needs of customers through effective telephone usage.
This course teaches students the fundamentals of time management. Students will learn how to evaluate the use of time, correctly identify and control time wasters, identify goals and set priorities, implement time management techniques for travelers, and develop an overall time management plan.
Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 10 interface. This course will help you to define what a PC is and familiarize you with the Windows 10 user interface and its basic capabilities. In this course, you will explore Windows 10 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.