Are you limited by the export functionality of DDE or export templates and looking for a more powerful way to do exports? Do you ever look at custom pages and wonder what the tlist_sql stuff is and how to modify it? This session will introduce you to SQL, also known as Structured Query Language. You'll learn how to use it with Oracle SQL Developer to get around the limits of PS exports, and get a basic understanding of how it works for use in custom pages and reporting engine reports.
 
We will cover SQL from bottom to top:
 
What is SQL?
ODBC
Oracle SQL Developer/Navicat
Data types
What tables are
The SELECT statement
WHERE clause
AND and OR
ORDER BY clause
DISTINCT
String functions (concat, substr, search)
IS [NOT] NULL operator
Math functions
Other functions (case, nvl, len)
LIKE operator
IN operator
Dates
INNER JOIN
OUTER JOIN
Subqueries
Aggregation (GROUP BY and sum, avg, max, min functions)
HAVING clause
LISTAGG

CLICK MEETING TITLE AND SCROLL DOWN TO VIEW MEETING DOCUMENTS.

 

Thursday, October 10, 2013
9:00 AM - 1:30 PM  **UPDATED**
Marquardt School District 15 - Glendale Heights, IL

Please plan to join us for a Fall PSUG-IL meeting!!  Find out the latest about Illinois State Reporting, see some cool customizations, get the latest on PowerSchool from Pearson reps, and network with other PowerSchools admins from throughout the State.

The meeting starts at 9:00 a.m., but plan to arrive early to sign-in, enjoy a light continental breakfast, and meet other PowerSchool users. 

**UPDATE**  Plan to stay for Pearson's "PowerSchool Lunch & Learn" session - a boxed sandwich lunch will be provided courtesy of Pearson School Systems.

There is no fee to attend this meeting.  Hope to see you there!!

 

**UPDATED AGENDA**:

 

8:30 - 9:00 AM:  Sign-in/Continental Breakfast/Networking
9:00 - 9:15 AM:  Welcome/Introductions
9:15 - 9:45 AM:  IL State Reporting Update (D. Gaertner)
9:45 - 10:15 AM:  Customizations Show & Tell
10:15 - 10:30 AM:  BREAK/Networking
10:30 - 11:00 AM:  Future Sessions Planning & Sign Up
11:00 - 12:00 AM:  Open Discussion & Ask the Experts
12:00 - 12:20 PM:  Break to Grab a Lunch (provided by Pearson School Systems)
12:20 - 1:30 PM:  PowerSchool Lunch & Learn - What's New & Upcoming?
                              (Brad Kerst - Pearson School Systems)

 

Please sign-up for this meeting below. 


Welcome to our meeting sponsor  - Level Data Inc!!!  Stop by the Level Data table and meet Carl Hoffman.

                                                Level Data Inc.

 

 

Wednesday, May 23, 2012
9:00 AM - 12:30 PM
Marquardt School District 15 - Glendale Heights, IL


Please plan to join us for our spring PSUG-IL meeting where you will learn more about Illinois State Reporting (including SCA/TCA) from Pearson's Diane Gaertner, see the "lazy-man" way to customize in PowerSchool, and meet with other PowerSchool administrators from throughout Illinois. Joshua Deegan and Eric Zorr from Pearson will give us an early peak of PowerSchool 7.2 and the Schoolnet for PowerSchool release.

Our meeting will start at 9:00 a.m., but plan to arrive early to sign-in and meet other PowerSchool users. There is no fee to attend this meeting. Hope to see you there!!

AGENDA:

8:30 - 9:00 AM - Sign-in/Continental Breakfast
9:00 - 9:05 AM - Welcome
9:05 - 10:00 AM - Illinois State Reporting (Diane Gaertner, Pearson)
10:00 - 10:15 AM - PowerSchool--Beyond State Reporting
10:15 - 10:30 AM - Break
10:30 - 11:30 AM - PowerSchool 7.2 and Schoolnet (Pearson)
11:30 AM - 12:15 PM - "Lazy-Man" Customizations
12:15-12:30 PM - Q&A

Pages

Subscribe to Front page feed