BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Laurel Ridge Workforce Solutions - ECPv6.10.1.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Laurel Ridge Workforce Solutions
X-ORIGINAL-URL:https://laurelridgeworkforce.com
X-WR-CALDESC:Events for Laurel Ridge Workforce Solutions
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20280101
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102230Z
UID:10005572-1736812800-1830297599@laurelridgeworkforce.com
SUMMARY:Market Risk - Basic\, Intermediate\, Advanced
DESCRIPTION:Every professional involved in the Global Financial Services industry would benefit from this training!  This comprehensive course covers several important topics in the industry such as:  Statistical concepts\, Risk measurement\, Back Testing\, Stress Testing\, and Value of Risk methodologies\, used by leading financial institutions worldwide. Details
URL:https://laurelridgeworkforce.com/event/market-risk-basic-intermediate-advanced/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20280101
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102232Z
UID:10005574-1736812800-1830297599@laurelridgeworkforce.com
SUMMARY:Professional Tax Preparer Certification
DESCRIPTION:The Professional Tax Preparer Certification course teaches you how to become a tax preparation specialist equipped to prepare federal income tax filings for individuals and businesses. It also teaches you the current tax guidelines needed to prepare tax filings\, plus it provides an overview of the documents\, statements and other necessary filing materials. Details
URL:https://laurelridgeworkforce.com/event/professional-tax-preparer-certification/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20280101
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102315Z
UID:10005597-1736812800-1830297599@laurelridgeworkforce.com
SUMMARY:Comprehensive Tax Course with Business Guide
DESCRIPTION:Learn to prepare tax returns for most Form 1040 individual\, non-business taxpayers and small business taxpayers (self-employed/Schedule C). Learn how to research tax issues. Details
URL:https://laurelridgeworkforce.com/event/comprehensive-tax-course-with-business-guide/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20280101
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102316Z
UID:10005598-1736812800-1830297599@laurelridgeworkforce.com
SUMMARY:Comprehensive Tax Course
DESCRIPTION:Learn to prepare tax returns for most Form 1040 individual\, non-business taxpayers and small business taxpayers (self-employed/Schedule C). Learn how to research tax issues. Details
URL:https://laurelridgeworkforce.com/event/comprehensive-tax-course/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20280101
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102340Z
UID:10005609-1736812800-1830297599@laurelridgeworkforce.com
SUMMARY:Start Your Own Business in Bookkeeping Administration Professional
DESCRIPTION:The purpose of this course is to give the student tools\, information\, and strategies to equip them in a way that will give them the best chance of success when starting a business.  We will discuss topics such as risk\, economics\, the global market\, ethics\, legal considerations\, organization\, human resources\, and marketing. As a student reads\, completes practices and assignments\, discusses with others\, and takes assessments\, he or she will gain a practical understanding of the components of a small business and the steps that one takes to create and establish that business\, from the idea\, to the business plan\, to the strategies for helping that business to succeed and grow. Details
URL:https://laurelridgeworkforce.com/event/start-your-own-business-in-bookkeeping-administration-professional/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20280101
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102358Z
UID:10005617-1736812800-1830297599@laurelridgeworkforce.com
SUMMARY:Chartered Tax Professional Business Package
DESCRIPTION:A Chartered Tax Professional (CTP) is someone who has completed a series of 5 federal tax courses in individual and small business income tax preparation. This nationally recognized certificate program enables students to start working and earning money as a tax preparer while completing coursework toward the CTP credential! With the talk of more requirements for tax preparers\, many preparers have decided to work towards becoming an IRS Enrolled Agent (EA)\, the most distinguished credential in the tax industry. The CTP is the perfect career path for the EA! Details
URL:https://laurelridgeworkforce.com/event/chartered-tax-professional-business-package/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20280101
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102359Z
UID:10005618-1736812800-1830297599@laurelridgeworkforce.com
SUMMARY:Fundamentals of Accounting
DESCRIPTION:This course will  provide an introduction to the concepts and uses of accounting in a business environment. The primary areas of study in this course include analysis of business transactions\, recording procedures and the use of ledgers and journals\, accounting for sales and purchases\, managing cash\, payroll\, accruals and deferrals\, and preparation and analysis of basic financial statements. After completing this course\, students will have  solid understanding of business and financial accounting and its role in bookkeeping administration. Details
URL:https://laurelridgeworkforce.com/event/fundamentals-of-accounting/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250114
DTEND;VALUE=DATE:20280101
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102225Z
UID:10005569-1736812800-1830297599@laurelridgeworkforce.com
SUMMARY:Chartered Tax Professional Career Package
DESCRIPTION:The Chartered Tax Professional (CTP) designation is the undisputed professional credential for persons who typically advise clients on income tax situations.  After completing this comprehensive program\, candidates will be prepared to handle almost any individual and small business income tax situation encountered.  Candidates must successfully complete a series of five\, computer-administered courses in income tax preparation. All courses are offered via the Internet and can be completed anywhere\, anytime-24/7 – instructor support is included with each module.  Each module consists of ten 3-hour lessons and can be completed in 5-10 weeks (one or two lessons per week). Details
URL:https://laurelridgeworkforce.com/event/chartered-tax-professional-career-package/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260504
DTEND;VALUE=DATE:20260505
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102745Z
UID:10005729-1777852800-1777939199@laurelridgeworkforce.com
SUMMARY:Introduction to SQL
DESCRIPTION: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. \nAgenda \nUnit 1: The Relational Database and Structured Query Language\nThe relational database structure\nStructured Query Language\nTable creation and data insertion\nDefining datatypes and constraints\nCreating Indexes \nUnit 2: Table Management\nTable management\nAdding columns to a table\nDeleting columns from a table\nDeleting a table \nUnit 3: Selecting and Retrieving Data\nCreating a SELECT statement to retrieve data\nUsing DISTINCT to display unique values in a column\nUsing the AS keyword to create an alternate name for a column\nMerging columns \nUnit 4: Filtering Data\nCreating a WHERE clause\nUsing comparison\, character\, and logical operators to match conditions\nUsing the IN operator to match a condition\nUsing the BETWEEN operator to match a condition
URL:https://laurelridgeworkforce.com/event/introduction-to-sql/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260504
DTEND;VALUE=DATE:20260505
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102758Z
UID:10005736-1777852800-1777939199@laurelridgeworkforce.com
SUMMARY:Advanced SQL
DESCRIPTION: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.
URL:https://laurelridgeworkforce.com/event/advanced-sql/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260504
DTEND;VALUE=DATE:20260505
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102810Z
UID:10005742-1777852800-1777939199@laurelridgeworkforce.com
SUMMARY:Intermediate SQL
DESCRIPTION: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. \nAgenda \nUnit 1: The Relational Database and Structured Query Language\nThe relational database structure\nStructured Query Language\nTable creation and data insertion\nDefining datatypes and constraints\nCreating Indexes \nUnit 2: Table Management\nTable management\nAdding columns to a table\nDeleting columns from a table\nDeleting a table \nUnit 3: Selecting and Retrieving Data\nCreating a SELECT statement to retrieve data\nUsing DISTINCT to display unique values in a column\nUsing the AS keyword to create an alternate name for a column\nMerging columns \nUnit 4: Filtering Data\nCreating a WHERE clause\nUsing comparison\, character\, and logical operators to match conditions\nUsing the IN operator to match a condition\nUsing the BETWEEN operator to match a condition
URL:https://laurelridgeworkforce.com/event/intermediate-sql/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260601
DTEND;VALUE=DATE:20260602
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102755Z
UID:10005735-1780272000-1780358399@laurelridgeworkforce.com
SUMMARY:SQL Certificate
DESCRIPTION: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.\n   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.
URL:https://laurelridgeworkforce.com/event/sql-certificate/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260601
DTEND;VALUE=DATE:20260602
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102856Z
UID:10005767-1780272000-1780358399@laurelridgeworkforce.com
SUMMARY:Advanced Excel Functions
DESCRIPTION:Take your Excel skills to the next level.  Go beyond what others know\, equipping you with advanced functions to efficiently analyze and manipulate data. Explore the advantages of these functions in various contexts\, enhancing your productivity and data insights.
URL:https://laurelridgeworkforce.com/event/advanced-excel-functions/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260601
DTEND;VALUE=DATE:20260602
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102811Z
UID:10005743-1780272000-1780358399@laurelridgeworkforce.com
SUMMARY:Intermediate SQL
DESCRIPTION: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. \nAgenda \nUnit 1: The Relational Database and Structured Query Language\nThe relational database structure\nStructured Query Language\nTable creation and data insertion\nDefining datatypes and constraints\nCreating Indexes \nUnit 2: Table Management\nTable management\nAdding columns to a table\nDeleting columns from a table\nDeleting a table \nUnit 3: Selecting and Retrieving Data\nCreating a SELECT statement to retrieve data\nUsing DISTINCT to display unique values in a column\nUsing the AS keyword to create an alternate name for a column\nMerging columns \nUnit 4: Filtering Data\nCreating a WHERE clause\nUsing comparison\, character\, and logical operators to match conditions\nUsing the IN operator to match a condition\nUsing the BETWEEN operator to match a condition
URL:https://laurelridgeworkforce.com/event/intermediate-sql-2/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260601
DTEND;VALUE=DATE:20260602
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102759Z
UID:10005737-1780272000-1780358399@laurelridgeworkforce.com
SUMMARY:Advanced SQL
DESCRIPTION: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.
URL:https://laurelridgeworkforce.com/event/advanced-sql-2/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260601
DTEND;VALUE=DATE:20260602
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102749Z
UID:10005730-1780272000-1780358399@laurelridgeworkforce.com
SUMMARY:Introduction to SQL
DESCRIPTION: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. \nAgenda \nUnit 1: The Relational Database and Structured Query Language\nThe relational database structure\nStructured Query Language\nTable creation and data insertion\nDefining datatypes and constraints\nCreating Indexes \nUnit 2: Table Management\nTable management\nAdding columns to a table\nDeleting columns from a table\nDeleting a table \nUnit 3: Selecting and Retrieving Data\nCreating a SELECT statement to retrieve data\nUsing DISTINCT to display unique values in a column\nUsing the AS keyword to create an alternate name for a column\nMerging columns \nUnit 4: Filtering Data\nCreating a WHERE clause\nUsing comparison\, character\, and logical operators to match conditions\nUsing the IN operator to match a condition\nUsing the BETWEEN operator to match a condition
URL:https://laurelridgeworkforce.com/event/introduction-to-sql-2/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260706
DTEND;VALUE=DATE:20260707
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102801Z
UID:10005738-1783296000-1783382399@laurelridgeworkforce.com
SUMMARY:Advanced SQL
DESCRIPTION: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.
URL:https://laurelridgeworkforce.com/event/advanced-sql-3/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260706
DTEND;VALUE=DATE:20260707
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102749Z
UID:10005731-1783296000-1783382399@laurelridgeworkforce.com
SUMMARY:Introduction to SQL
DESCRIPTION: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. \nAgenda \nUnit 1: The Relational Database and Structured Query Language\nThe relational database structure\nStructured Query Language\nTable creation and data insertion\nDefining datatypes and constraints\nCreating Indexes \nUnit 2: Table Management\nTable management\nAdding columns to a table\nDeleting columns from a table\nDeleting a table \nUnit 3: Selecting and Retrieving Data\nCreating a SELECT statement to retrieve data\nUsing DISTINCT to display unique values in a column\nUsing the AS keyword to create an alternate name for a column\nMerging columns \nUnit 4: Filtering Data\nCreating a WHERE clause\nUsing comparison\, character\, and logical operators to match conditions\nUsing the IN operator to match a condition\nUsing the BETWEEN operator to match a condition
URL:https://laurelridgeworkforce.com/event/introduction-to-sql-3/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260706
DTEND;VALUE=DATE:20260707
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20260415T102812Z
UID:10005744-1783296000-1783382399@laurelridgeworkforce.com
SUMMARY:Intermediate SQL
DESCRIPTION: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. \nAgenda \nUnit 1: The Relational Database and Structured Query Language\nThe relational database structure\nStructured Query Language\nTable creation and data insertion\nDefining datatypes and constraints\nCreating Indexes \nUnit 2: Table Management\nTable management\nAdding columns to a table\nDeleting columns from a table\nDeleting a table \nUnit 3: Selecting and Retrieving Data\nCreating a SELECT statement to retrieve data\nUsing DISTINCT to display unique values in a column\nUsing the AS keyword to create an alternate name for a column\nMerging columns \nUnit 4: Filtering Data\nCreating a WHERE clause\nUsing comparison\, character\, and logical operators to match conditions\nUsing the IN operator to match a condition\nUsing the BETWEEN operator to match a condition
URL:https://laurelridgeworkforce.com/event/intermediate-sql-3/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260803
DTEND;VALUE=DATE:20260804
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20250114T070000Z
UID:10006022-1785715200-1785801599@laurelridgeworkforce.com
SUMMARY:Introduction to SQL
DESCRIPTION: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. \nAgenda \nUnit 1: The Relational Database and Structured Query Language\nThe relational database structure\nStructured Query Language\nTable creation and data insertion\nDefining datatypes and constraints\nCreating Indexes \nUnit 2: Table Management\nTable management\nAdding columns to a table\nDeleting columns from a table\nDeleting a table \nUnit 3: Selecting and Retrieving Data\nCreating a SELECT statement to retrieve data\nUsing DISTINCT to display unique values in a column\nUsing the AS keyword to create an alternate name for a column\nMerging columns \nUnit 4: Filtering Data\nCreating a WHERE clause\nUsing comparison\, character\, and logical operators to match conditions\nUsing the IN operator to match a condition\nUsing the BETWEEN operator to match a condition
URL:https://laurelridgeworkforce.com/event/introduction-to-sql-4/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260803
DTEND;VALUE=DATE:20260804
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20250114T070000Z
UID:10006023-1785715200-1785801599@laurelridgeworkforce.com
SUMMARY:Advanced SQL
DESCRIPTION: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.
URL:https://laurelridgeworkforce.com/event/advanced-sql-4/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260803
DTEND;VALUE=DATE:20260804
DTSTAMP:20260416T232022
CREATED:20250114T070000Z
LAST-MODIFIED:20250114T070000Z
UID:10006025-1785715200-1785801599@laurelridgeworkforce.com
SUMMARY:Intermediate SQL
DESCRIPTION: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. \nAgenda \nUnit 1: The Relational Database and Structured Query Language\nThe relational database structure\nStructured Query Language\nTable creation and data insertion\nDefining datatypes and constraints\nCreating Indexes \nUnit 2: Table Management\nTable management\nAdding columns to a table\nDeleting columns from a table\nDeleting a table \nUnit 3: Selecting and Retrieving Data\nCreating a SELECT statement to retrieve data\nUsing DISTINCT to display unique values in a column\nUsing the AS keyword to create an alternate name for a column\nMerging columns \nUnit 4: Filtering Data\nCreating a WHERE clause\nUsing comparison\, character\, and logical operators to match conditions\nUsing the IN operator to match a condition\nUsing the BETWEEN operator to match a condition
URL:https://laurelridgeworkforce.com/event/intermediate-sql-4/
LOCATION:Online 24/7
CATEGORIES:Accounting,Business and Professional Development
END:VEVENT
END:VCALENDAR