BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Laurel Ridge Workforce Solutions - ECPv6.10.1.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260601
DTEND;VALUE=DATE:20260602
DTSTAMP:20260514T050706
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:20260514T050706
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:20260514T050706
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:20260706
DTEND;VALUE=DATE:20260707
DTSTAMP:20260514T050706
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:20260514T050706
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:20260706
DTEND;VALUE=DATE:20260707
DTSTAMP:20260514T050706
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:20260803
DTEND;VALUE=DATE:20260804
DTSTAMP:20260514T050706
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:20260514T050706
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:20260514T050706
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