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.TECHNOLOGY REQUIREMENTS:- Windows 10 or later. Macs are not compatible.- Necessary rights (local administrative rights) to install programs on the computer.Prerequisite Requirement: Students should have taken Introduction to SQL & Intermediate SQL and have competency in the Introductory and Intermediate levels of SQL. IMPORTANT INFORMATION:*This class is included in the full certificate course, SQL Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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.TECHNOLOGY REQUIREMENT:-Microsoft Word-Microsoft Excel-Microsoft Powerpoint IMPORTANT INFORMATION:*This is registration for a full certificate course, which includes these classes: -Mastering Microsoft Excel (Sept.8-Oct. 2)-Intermediate Excel (Oct. 5-30)-Advanced Excel (Nov. 2-27)If you would like to register for only one of the classes, please search the name of the class here. Pre-requisite classes maybe required for certain classes. *A digital badge will be issued for each completed class, with a final badge awarded upon successful completion of the full course.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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.TECHNOLOGY NOTE: -Microsoft Excel is required.PREREQUISITE REQUIREMENT: -Students should have completed Mastering Microsoft Excel. IMPORTANT INFORMATION:*This class is included in the full certificate course, Certificate in Mastering Excel. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports. Prerequisite Recommendation: While not required, participants are encouraged to complete Introduction to Power BI before enrolling to maximize their success in this course. IMPORTANT INFORMATION:*This class is included in the full certificate course, Power BI Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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.TECHNOLOGY REQUIREMENTS:- Windows 10 or later. Macs are not compatible.- Necessary rights (local administrative rights) to install programs on the computer.Prerequisite Requirement: Students should have taken Introduction to SQL and have competency in the Introductory level of SQL. IMPORTANT INFORMATION:*This class is included in the full certificate course, SQL Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Gain insights into your data! Power BI (business intelligence) is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free. In this course, you will discover how to quickly extract, transform, and load data with just a few clicks. You will create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions. IMPORTANT INFORMATION:*This class is included in the full certificate course, Power BI Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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. TECHNOLOGY REQUIREMENT:- Windows 10 or later. Macs are not compatible.-Necessary rights (local administrative rights) to install programs on the computer. IMPORTANT INFORMATION: *This class is included in the full certificate course, SQL Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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.TECHNOLOGY REQUIREMENT:-Microsoft Excel is required. IMPORTANT INFORMATION:*This class is included in the full certificate course, Certificate in Mastering Excel & Certificate in Mastering Computer Skills for the Workplace. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Gain insights into your data using business intelligence software – Power Business Intelligence. Power BI is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free.Discover the process of creating interactive reports. Integrate financial, marketing, or any other source data in your accounting system, Excel, or on the Web. Streamline the data to what is needed using Power Query. Create charts, maps, and other visuals to see your data in real time.Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using relationships and DAX (Data Analysis Expressions). Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports and analyze your results.This certificate will enhance your skills in data analysis, giving you greater insight into your organization’s performance and allowing you to make more informed decisions. NOTE: This Certificate must be taken in the following order: Introduction- Intermediate- Advanced IMPORTANT INFORMATION:*This is registration for a full certificate course, which includes these classes: -Introduction to BI (Sept.8-Oct. 2)-Intermediate BI (Oct. 5-30)-Advanced BI (Nov. 2-27)If you would like to register for only one of the classes, please search the name of the class here. Pre-requisite classes maybe required for certain classes. *A digital badge will be issued for each completed class, with a final badge awarded upon successful completion of the full course.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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. Requirements:- Windows 10 or later. Macs are not compatible.- Necessary rights (local administrative rights) to install programs on the computer. This Certificate must be taken in the following order: Introduction - Intermediate - Advanced IMPORTANT INFORMATION:*This is registration for a full certificate course, which includes these classes: -Introduction to SQL (Sept.8-Oct. 2)-Intermediate SQL (Oct. 5-30)-Advanced SQL (Nov. 2-27)If you would like to register for only one of the classes, please search the name of the class here. Pre-requisite classes maybe required for certain classes. *A digital badge will be issued for each completed class, with a final badge awarded upon successful completion of the full course.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.