PowerSchool User Group - Midwest Conference (PSUG-MW)

March 25-27, 2014
Stardust Events Center @ Blue Chip Hotel
Michigan City, IN

This 3-day conference is put on by PowerSchool users for PowerSchool users and will feature some of the best known national PSUG presenters - many of which are featured each year at the PSUG National Conference in Las Vegas!  There will be State Reporting sessions from each state represented along with over 100 breakout sessions to choose from! While Pearson will be present at our event, this is NOT a Pearson event - this is a PowerSchool User event. 

PLUS, there will be dozens of vendors on hand that have products or services that work with PowerSchool.  Check out the Vendor Expo and see how school districts all over the country are using them to make their lives easier!

REGISTRATION WILL BE OPEN BY THE END OF NOVEMBER!

Click here for additional information!!.

READ MORE AND SIGNUP

Structured Query Langauge (SQL) with Adam Larsen
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

READ MORE AND SIGNUP

PSUG-IL FALL 2013 MEETING

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.

 

 

READ MORE AND SIGNUP

Pages

Subscribe to Front page feed