CLICK HERE to access the registration site for the PSUG-MW Conference (March 25-27, 2014).  Hope to see you there!!

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!!.

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

Pages

Subscribe to Front page feed