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.

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.