Banff Canada – look outs


This was the plan we made for our stay at Banff, Canada. We planned to stay in Canmore and then drive down each day to see these places. Unfortunately we had to cancel our trip as mum fell ill, but she’s doing perfectly fine now. You can add these stops to your maps for a smooth drive. Once the map is downloaded (automatically), you won’t even need data ūüėÄ

A – Minnewanka Lookout Banff

B – Sulphur mountain

C – Stoney Squaw mountain

D – Moraine Lake car parking

E – Mount Temple

F – Lake Louise

G – Lake Agnes

H – Bow Lake

I – Peyto Lake

Advertisements

A Scam that has gone too far?


Is this a Scam that has gone too far? Well, who are we talking about ?

They want control.

They influence people’s way of life, way of thinking, help them with decision making.

They claim to be all-knowing, have all the answers, and are more than happy to share with you, a free copy of what they call a blueprint to best way to live life.

They demand obedience, and shape your moral compass.

They own real estate, some own cities, schools, hospitals, old age homes, politicians, world influencial leaders and your mind.

And, yes they need money. Who are they?

What do they Provide?

Sense of Belonging

Stability

Familiarity

Comfort

State of Trance

What do they get?

Power

Money

Control

Why will this work?

Fear of Punishment

Forced down at a young age

Outcasted from Community/Society

Promise of Ultimate Reward

Manipulate the Poor by providing food, clothing, education in exchange of simply joining the club

What it has lead to?

Hierarchies

Uniforms

Rituals and Traditions

Division of people – Tribalism

So what’s wrong? Why is this so bad?

THE TRUTH DOESN’T NEED THOUSAND YEARS OF COVER-UPS, FIGHTS, DECEIPT, PUNISHMENT, REWARDS AND WARS TO PROVE THAT IT’S THE TRUTH.

WAKE UP. GET OUT OF YOUR COMFORT ZONE. SHAKE OFF THE STATE OF TRANCE, AND START THINKING FOR YOURSELF. 

STOP BEING THE CATTLE.
Image Source: Source
Write up Influenced by: DarkMatter2525

 

Teradata SQL Code – Generate Calendar with Holidays US and Canada


This piece of SQL code uses Teradata’s in-built System Calendar table to calculate the national holidays for US and Canada.


SELECT
Calendar_Date,
day_of_week,
day_of_week_name,
day_of_month,
day_of_year,
day_of_calendar,
weekday_of_month,
week_of_month,
week_of_year,
week_of_calendar,
month_of_quarter,
c.month_of_year,
month_of_calendar,
quarter_of_year,
quarter_of_calendar,
c.year_of_calendar,
case
when extract(month from Calendar_Date ) = 11 and TD_DAY_OF_WEEK(Calendar_Date) = 5 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 4 then 'Thanksgiving Day (USA)'
 
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 25 then 'Christmas Day' 
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 26 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Christmas Day (in Leiu)' /*26th December is a Monday then Holiday*/
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 27 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Christmas Day (in Leiu)' /*27th December is Monday then holiday*/
 
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 26 then 'Boxing Day'
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 28 and TD_DAY_OF_WEEK(Calendar_Date) = 3  then  'Boxing Day (in Leiu)' /*28th December is a Tuesday then Holiday*/
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 28 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Boxing Day (in Leiu)' /*28th December is Monday then holiday*/
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 27 and TD_DAY_OF_WEEK(Calendar_Date) = 3  then   'Boxing Day (in Leiu)'  /*27th December is Tuesday then holiday*/

when extract(month from Calendar_Date ) = 7 and extract(day from Calendar_Date ) = 4 then   'Independence Day'

when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 1 then   'New Years Day'
when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 2 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'New Years Day' /*1st Jan was Sunday*/
when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 3 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'New Years Day' /*1st Jan was Saturday*/

when extract(month from Calendar_Date ) = 5 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 1 then 'Memorial Day' /*Needs fix - Needs to be last Monday of May - Follow lines of Canada's Victoria Day shown in the left join below*/

when extract(month from Calendar_Date ) = 9 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 1 then 'Labour Day' /*First Monday of September*/

when extract(month from Calendar_Date ) = 2 and extract(day from Calendar_Date ) = 14 then 'Valentines Day'

when extract(month from Calendar_Date ) = 3 and extract(day from Calendar_Date ) = 17 then 'Saint Patricks Day'

when extract(month from Calendar_Date ) = 1 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 3 and extract(year from Calendar_Date ) >= 1983 then 'Martin Luthor King Jr Day' /*Third Monday of January*/

when extract(month from Calendar_Date ) = 2 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 3 then 'Presidents Day' /*Third Monday of Feb*/

when extract(month from Calendar_Date ) = 5 and TD_DAY_OF_WEEK(Calendar_Date) = 1 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 2 then 'Mothers Day' /*Second Sunday of May*/

when extract(month from Calendar_Date ) = 6 and TD_DAY_OF_WEEK(Calendar_Date) = 1 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 3 then 'Fathers Day' /*Third Sunday of June*/

when extract(month from Calendar_Date ) = 10 and extract(day from Calendar_Date ) = 31 then 'Halloween'

when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 11 then 'Remembrance Day'
when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 12 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Remembrance Day (in Lieu)' /*11th Nov was Sunday*/
when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 13 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Remembrance Day (in Lieu)' /*11th Nov was Saturday*/

/*Easter and Good Friday*/
when Calendar_Date = cast((concat(trim(extract(year from Calendar_Date)), LPAD(TRIM(((3 + ( ((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))),2,'0'), LPAD(TRIM(((((24+ (19 * (extract(year from Calendar_Date) mod 19)))  mod 30)  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 28 - (31 * ((( 3 + (((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 +   ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))/4))),2,'0')) )  as dateformat 'yyyymmdd') then 'Easter Sunday'

when Calendar_Date = cast((concat(trim(extract(year from Calendar_Date)), LPAD(TRIM(((3 + ( ((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))),2,'0'), LPAD(TRIM(((((24+ (19 * (extract(year from Calendar_Date) mod 19)))  mod 30)  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 28 - (31 * ((( 3 + (((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 +   ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))/4))),2,'0')) )  as dateformat 'yyyymmdd') - 2  then 'Good Friday'

else '' end as Holiday_Name_US,

case

when extract(month from Calendar_Date ) = 11 and TD_DAY_OF_WEEK(Calendar_Date) = 5 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 4 then 'Thanksgiving Day (CANADA)'

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 25 then 'Christmas Day'
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 26 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Christmas Day (in Leiu)' /*26th December is a Monday then Holiday*/
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 27 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Christmas Day (in Leiu)' /*27th December is Monday then holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 26 then 'Boxing Day'
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 28 and TD_DAY_OF_WEEK(Calendar_Date) = 3  then  'Boxing Day (in Leiu)' /*28th December is a Tuesday then Holiday*/
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 28 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Boxing Day (in Leiu)' /*28th December is Monday then holiday*/
when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 27 and TD_DAY_OF_WEEK(Calendar_Date) = 3  then   'Boxing Day (in Leiu)'  /*27th December is Tuesday then holiday*/

when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 1 then   'New Years Day'
when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 2 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'New Years Day' /*1st Jan was Sunday*/
when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 3 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'New Years Day' /*1st Jan was Saturday*/

when extract(month from Calendar_Date ) = 9 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 1 then 'Labour Day' /*First Monday of September*/

when extract(month from Calendar_Date ) = 2 and extract(day from Calendar_Date ) = 14 then   'Valentines Day'

when extract(month from Calendar_Date ) = 3 and extract(day from Calendar_Date ) = 17 then 'Saint Patricks Day'

when extract(month from Calendar_Date ) = 5 and TD_DAY_OF_WEEK(Calendar_Date) = 1 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 2 then 'Mothers Day' /*Second Sunday of May*/

when extract(month from Calendar_Date ) = 6 and TD_DAY_OF_WEEK(Calendar_Date) = 1 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 3 then 'Fathers Day' /*Third Sunday of June*/

when extract(month from Calendar_Date ) = 10 and extract(day from Calendar_Date ) = 31 then 'Halloween'

when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 11 then 'Remembrance Day'
when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 12 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Remembrance Day (in Lieu)' /*11th Nov was Sunday*/
when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 13 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Remembrance Day (in Lieu)' /*11th Nov was Saturday*/

/*Second Last Monday in May - Victoria day*/
when extract(month from Calendar_Date ) = 5 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = (max_occurance_of_mon - 1) then 'Victoria Day' /*Second Last Monday in May*/

when extract(month from Calendar_Date ) = 7 and extract(day from Calendar_Date ) = 1 then 'Canada Day'
when extract(month from Calendar_Date ) = 7 and extract(day from Calendar_Date ) = 2 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Canada Day' /*Canada Day was Sunday*/
when extract(month from Calendar_Date ) = 7 and extract(day from Calendar_Date ) = 3 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  'Canada Day'/*Canada Day was Saturday*/

/*Easter and Good Friday*/

when Calendar_Date = cast((concat(trim(extract(year from Calendar_Date)), LPAD(TRIM(((3 + ( ((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))),2,'0'), LPAD(TRIM(((((24+ (19 * (extract(year from Calendar_Date) mod 19)))  mod 30)  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 28 - (31 * ((( 3 + (((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 +   ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))/4))),2,'0')) )  as dateformat 'yyyymmdd') then 'Easter Sunday'

when Calendar_Date = cast((concat(trim(extract(year from Calendar_Date)), LPAD(TRIM(((3 + ( ((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))),2,'0'), LPAD(TRIM(((((24+ (19 * (extract(year from Calendar_Date) mod 19)))  mod 30)  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 28 - (31 * ((( 3 + (((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 +   ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))/4))),2,'0')) )  as dateformat 'yyyymmdd') - 2  then 'Good Friday'

when extract(month from Calendar_Date ) = 8 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 1 then 'Civic Holiday' /*First Monday of August*/

else '' end as Holiday_Name_CAN,

case

when extract(month from Calendar_Date ) = 11 and TD_DAY_OF_WEEK(Calendar_Date) = 5 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 4 then 1

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 25 then 1

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 26 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  1/*26th December is a Monday then Holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 27 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1/*27th December is Monday then holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 26 then 1

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 28 and TD_DAY_OF_WEEK(Calendar_Date) = 3  then  1 /*28th December is a Tuesday then Holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 28 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*28th December is Monday then holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 27 and TD_DAY_OF_WEEK(Calendar_Date) = 3  then 1 /*27th December is Tuesday then holiday*/

when extract(month from Calendar_Date ) = 7 and extract(day from Calendar_Date ) = 4 then  1

when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 1 then  1

when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 2 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*1st Jan was Sunday*/

when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 3 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*1st Jan was Saturday*/

when extract(month from Calendar_Date ) = 5 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 1 then 1 /*Needs fix - Needs to be last Monday of May*/

when extract(month from Calendar_Date ) = 9 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 1 then 1 /*First Monday of September*/

when extract(month from Calendar_Date ) = 2 and extract(day from Calendar_Date ) = 14 then 1

when extract(month from Calendar_Date ) = 3 and extract(day from Calendar_Date ) = 17 then 1

when extract(month from Calendar_Date ) = 1 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 3 and extract(year from Calendar_Date ) >= 1983 then 1 /*Third Monday of January*/

when extract(month from Calendar_Date ) = 2 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 3 then 1 /*Third Monday of Feb*/

when extract(month from Calendar_Date ) = 5 and TD_DAY_OF_WEEK(Calendar_Date) = 1 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 2 then 1 /*Second Sunday of May*/

when extract(month from Calendar_Date ) = 6 and TD_DAY_OF_WEEK(Calendar_Date) = 1 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 3 then 1 /*Third Sunday of June*/

when extract(month from Calendar_Date ) = 10 and extract(day from Calendar_Date ) = 31 then 1

when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 11 then 1

when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 12 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*11th Nov was Sunday*/

when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 13 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*11th Nov was Saturday*/

/*Easter and Good Friday*/

when Calendar_Date = cast((concat(trim(extract(year from Calendar_Date)), LPAD(TRIM(((3 + ( ((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))),2,'0'), LPAD(TRIM(((((24+ (19 * (extract(year from Calendar_Date) mod 19)))  mod 30)  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 28 - (31 * ((( 3 + (((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 +   ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))/4))),2,'0')) )  as dateformat 'yyyymmdd') then 1

when Calendar_Date = cast((concat(trim(extract(year from Calendar_Date)), LPAD(TRIM(((3 + ( ((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))),2,'0'), LPAD(TRIM(((((24+ (19 * (extract(year from Calendar_Date) mod 19)))  mod 30)  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 28 - (31 * ((( 3 + (((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 +   ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))/4))),2,'0')) )  as dateformat 'yyyymmdd') - 2  then 1

else 0 end as Holiday_US_Flag,

case

when extract(month from Calendar_Date ) = 11 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 2 then 1

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 25 then 1

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 26 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*26th December is a MOnday then Holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 27 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*27th December is Monday then holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 26 then 1

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 28 and TD_DAY_OF_WEEK(Calendar_Date) = 3  then  1 /*28th December is a Tuesday then Holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 28 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*28th December is Monday then holiday*/

when extract(month from Calendar_Date ) = 12 and extract(day from Calendar_Date ) = 27 and TD_DAY_OF_WEEK(Calendar_Date) = 3  then 1 /*27th December is Tuesday then holiday*/
 
when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 1 then  1

when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 2 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*1st Jan was Sunday*/

when extract(month from Calendar_Date ) = 1 and extract(day from Calendar_Date ) = 3 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*1st Jan was Saturday*/

when extract(month from Calendar_Date ) = 9 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 1 then 1 /*First Monday of September*/

when extract(month from Calendar_Date ) = 2 and extract(day from Calendar_Date ) = 14 then 1

when extract(month from Calendar_Date ) = 3 and extract(day from Calendar_Date ) = 17 then 1

when extract(month from Calendar_Date ) = 5 and TD_DAY_OF_WEEK(Calendar_Date) = 1 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 2 then 1 /*Second Sunday of May*/

when extract(month from Calendar_Date ) = 6 and TD_DAY_OF_WEEK(Calendar_Date) = 1 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 3 then 1 /*Third Sunday of June*/

when extract(month from Calendar_Date ) = 10 and extract(day from Calendar_Date ) = 31 then 1

when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 11 then 1

when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 12 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*11th Nov was Sunday*/

when extract(month from Calendar_Date ) = 11 and extract(day from Calendar_Date ) = 13 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*11th Nov was Saturday*/

/*Second Last Monday in May - Victoria day*/

when extract(month from Calendar_Date ) = 5 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = (max_occurance_of_mon - 1 ) then 1 /*Second Last Monday in May*/

when extract(month from Calendar_Date ) = 7 and extract(day from Calendar_Date ) = 1 then 1

when extract(month from Calendar_Date ) = 7 and extract(day from Calendar_Date ) = 2 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then  1/*Canada Day was Sunday*/

when extract(month from Calendar_Date ) = 7 and extract(day from Calendar_Date ) = 3 and TD_DAY_OF_WEEK(Calendar_Date) = 2  then 1 /*Canada Day was Saturday*/

/*Easter and Good Friday*/

when Calendar_Date = cast((concat(trim(extract(year from Calendar_Date)), LPAD(TRIM(((3 + ( ((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))),2,'0'), LPAD(TRIM(((((24+ (19 * (extract(year from Calendar_Date) mod 19)))  mod 30)  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 28 - (31 * ((( 3 + (((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 +   ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))/4))),2,'0')) )  as dateformat 'yyyymmdd') then 1

when Calendar_Date = cast((concat(trim(extract(year from Calendar_Date)), LPAD(TRIM(((3 + ( ((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))),2,'0'), LPAD(TRIM(((((24+ (19 * (extract(year from Calendar_Date) mod 19)))  mod 30)  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 + ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 28 - (31 * ((( 3 + (((( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - ((extract(year from Calendar_Date) + extract(year from Calendar_Date) / 4 +   ( ( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 )  - (( (24 + (19 * (extract(year from Calendar_Date) mod 19) ) )  mod 30 ) / 28) ) - 13) mod 7)) + 40) / 44)))/4))),2,'0')) )  as dateformat 'yyyymmdd') - 2  then 1

when extract(month from Calendar_Date ) = 8 and TD_DAY_OF_WEEK(Calendar_Date) = 2 and TD_WEEKDAY_OF_MONTH(Calendar_Date) = 1 then 1 /*First Monday of August*/

else 0 end as Holiday_Canada_Flag

FROM    sys_calendar.calendar c

LEFT JOIN

(

/*How many Mondays are there in each month - Required for Victoria Day*/

SELECT Year_of_Calendar, month_of_year, max( TD_WEEKDAY_OF_MONTH(Calendar_Date)) as max_occurance_of_mon

FROM   sys_calendar.calendar

WHERE  TD_DAY_OF_WEEK(Calendar_Date) = 2

GROUP BY

Year_of_Calendar, month_of_year

) MONDAYS_IN_MONTH

ON MONDAYS_IN_MONTH.Year_of_Calendar = c.Year_of_Calendar

AND MONDAYS_IN_MONTH.month_of_year = c.month_of_year

Continue reading Teradata SQL Code – Generate Calendar with Holidays US and Canada

Woman’s Day


img_20170304_171013_778
She wondered what this day was.. Mankind had just made up
She who hath created ye need no day.
She believeth that every day is hers so she knows not what you mean by woman’s day
Ye thinkest this hath been evened.. Think again!!
The power to create has she, but she treat all even
She like to share and share alike
She like to be fair and so she asked, ¬†why aren’t all days “Mankind Day”

Oh January


Oh January the unknown hath cast a spell upon thee,

Masked thou art with sparkling stars tricking man’s senses

Cometh thou with freshness and  hope, and numbers that game new days

With merriment and laughter we step into this newness

But Alas! When with glee we smile, the spell works

Bringing this earth to a place that is no good

Where every breath is brewed with horror and fright

Oh darkness, all that is asked of me, to trust in January yet again

 

I wrote this octave ¬†on the eve of 2013. Here’s a little background. I lost my grandmother in 2011, then grandfather in 2012. I was beginning to believe we were cursed and was scared to welcome the new year 2013 and that’s when I wrote this. In 2013 I lost my other grandmother, 2014 lost my other grandfather and 2015 lost my favourite person who we call BRI. Finally 2016 went well and I am now posting this poem cause I believe the curse is broken ūüôā

Do a Phd in Canada and then get back to Corporate / Industry – Yay or Nay?


I’ve been debating this myself, since the time I learned that I have gained admission to a Phd program at the Institute for Big Data Analytics at Dalhousie University, NS, Canada.

It was exciting at first and wanted to quit my job and jump onboard no sooner I learned of it. But then the budding analyst in me kicked in, and I took a step back and realized that I am going to do my research, so why not do a little research (digging in) to see what people have to say about doing your Phd with plans of getting back into the corporate / industry workforce.

Career

After speaking to a lot of Phd holders, Professors, colleagues, friends, family and a lot googling, I found a few points that helped me make my decision. Read the information below (especially the little excerpts shown in qoutes) before you take this plunge.

HOW MANY PHD’S¬†DO YOU KNOW WHO WORK FOR CORPORATES?

When I spoke to my fellow post doctorate friends, this was the first thing I asked them, “How many Phd’s do you know who are currently working for a corporate?”.

And, for some reason they only responded in Binary digits (0 or 1)!!

Private sector in Canada hires only 4 per cent PhDs compared to the 42 per cent hired in the United States.” – The Huffington Post. Read full article.

Now this will vary from country to country, city to city and also based on your field of research.

For instance, if you have a Phd in Computer Science / Biology / Applied Mathematics or a combination of them you will get calls by big Healthcare / Analytical corporations.

“In Canada, PhDs unemployment rate is even worse: 50 per cent more than Masters (6 per cent as compared to 4 per cent).” – The¬†Huffington Post. Read full article.

If you are willing to go against those odds, is proof by itself that you are passionate about your research and must go for it without any second thoughts.

Many things¬†remain the same no matter which country you apply to, like this comment here –

Many HR departments will view the PHD and assume that you wouldn’t be satisfied with the pay levels that are set to attract people with Bachelors or were self-taught.¬†Even if you declare you’re fine with it, there’s the assumption that your job dissatisfaction will be very high after a few months and you will view the work as beneath you.”¬†–¬†by¬†dcousineau. Read¬†full discussion on reddit.

It is advisable to be straight forward and mention your salary expectations in your cover letter so that they know you are willing to work for a reasonable pay.

That being said, you must have a dream role / designation / job title in your mind before you commence your Phd. And work towards it; In that way, you will not be dissatisfied with your role or willl not be doing work that is ‘beneath’ you. This is exactly what is said below, in different words –

There’s still a lot of prejudice against post-grad degrees in the industry, and listing a PHD on your resume may actively harm your chances at landing a job. The one exception to this rule is if your PHD is extremely focused and you’re looking for a job that perfectly matches your focus.” – by¬†dcousineau. Read¬†full discussion on reddit.

There are also HR departments that view a Phd student as a person who worked for a university with minimum pay for the past 4 or 5 years and try to take advantage of that fact. Be confident, and be bold. You know how much you deserve.

MONEY IN YOUR POCKET

Willingness to accept a minimum pay (funding) for 4 or 5 years while doing your research, while your friends move up the corporate ladders and buy fancy cars, is something you will have to deal with for a very long time until you find your spot in the corporate jungle.

PhDs, even after five to six more years of schooling, earn only 8 per cent more than Masters. In U.S., they earn 43 per cent more.”¬†– The¬†Huffington Post. Read full article.

This may sound clich√©d, but if you are passionate enough, doesn’t matter in which field you’ve obtained your Phd, companies like Wallmart, Google Alphabets will have a spot for you!!; And they pay BIIIGGGGG!!

It is the market leaders that seem to respect, value and strive on Phd holders.

4-YEARS, ARE YOU SURE?

…looking at studies on PhD completion times at Canadian universities, it is clear that the vast majority of students do not finish in four years: the average post-master‚Äôs completion time is about five years, according to a 2003 report by Frank Elgar, Dalhousie University (PDF).” – University Affairs. Read full article.

ENVIRONMENT

Another important factor to consider when selecting your University is the city, campus, department, life style and weather. Otherwise, you will spend 5 long years walking in the corridors of the university shaking your head, trapped by the weather, or because there is nothing fun that the University campus can offer.

ALL HOPE IS NOT LOST

If you’ve come this far you may have realized that there is no universal answer to this as it varies from case to case

You can very well do a PhD and wind up with much more impressive experience than you would get at your average entry level position. For example, there are¬†students who work with governments and large corporations solving very real issues like traffic congestion and automated threat detection etc. All this depends on your research lab and how much you yourself put into it. If at the end of your PhD all you have is the word PhD on your resume along with some publications on theory, then that’s on you.” – by¬†pamme.¬†Read¬†full discussion on reddit.

But, what is common for all prospective Phd students is that you have to choose a field that you are willing to sleep, eat, dream and think about for the next 4 or 5 years.

Don’t quit your job; Instead create a new one : If you wish to get back into the industry immediately after your Phd, one way to do it is to narrow down and select a field that is relevant to your employer and the University. It must be a topic that will benefit / solve a real world problem for the company. In this way you can establish that bridge between your employer and the University, and do your Phd in a mutually beneficial topic,¬†while working at the company. It’s not only a win-win situation. It is a win(employer)-win(university)-win(you) situation.

What‚Äôs most important is for prospective PhDs is to have a clear understanding not only of the competitive conditions for academic jobs, but also the range of possibilities opened up by doctoral education, which are far more diverse than those generally presented in graduate programmes. Those possibilities must also be developed actively through collaboration between universities, governments, other non-academic organizations and students, so that the promise of advanced education isn‚Äôt lost due to lack of mentorship, guidance and opportunity.” – ¬†The Global and Mail.¬†Read full article.

To the future 2% of the world, good luck.. and to the 98%.. good luck as well. : )

Let me know your thoughts. How many Phd’s do you know that work in the private sector?


Choosing the Right Higher Education Program for You


The spring before high school graduation can be one of the most difficult semesters. Not only are you leaving the group of friends you have grown up with and are working to officially tie up loose ends necessary to graduate, but you are also preparing to enter the adult world. As a high school senior determining what you are going to do with your life after graduation, there are a lot of important decisions to take into consideration.

Possibly the most important of these questions is: are you going to pursue higher education? And if so, how do you determine which type of higher education institution is right for you? Identifying which type of higher education program is right for you can be difficult, especially if you have limited sources of advice from people who’ve been there. Below is a short list of options to consider outside of the traditional four year public school.

Liberal Art Colleges

Interested in a little bit of everything? A liberal arts college might be the type of higher education you are looking for. These schools tend to focus on students gaining a very broad amount of knowledge in a number of disparate fields, working closely with students from differing majors, and developing strong technical writing skills. Liberal arts colleges tend to have requirements for students to take classes outside of their major and typical graduates usually have a major and one or two minors in widely divergent fields.

Graduates

of liberal arts colleges are considered highly versatile and are typically able to succeed in any career path because of this exposure to many contrastable ideas throughout their education. In fact, over 55% of hiring managers say they prefer graduates with a broad education because they can work with people of various backgrounds well and they think outside of the box.

Technical/Vocational Schools

For some people the idea of learning about everything seems exceptionally undesirable. Students who would rather learn a skill that enables them to acquire a well-paying job and call it a day might find a good fit in a technical or vocational school. Technical schools were designed for this – they were developed to train people to complete specific jobs that companies are hiring for.

Often times, they focus on the practical, hands-on skills rather than the academic education. That being said, employment rates for students coming out of technical programs tend to be much higher than that of other higher education institutions. Technical/vocational degree programs can range from cosmetology, to IT, to mechanics. Really the certifications are limitless.

Online Education

When many people think of online education they tend to think of somewhat sketchy, unaccredited universities that are just devised to take people’s money and offer no real benefit. Although in the past that may have been the case, nowadays online education programs are on the rise and being offered by credible institutions. A number of them are even degrees most people would not typically associate with online classes such as political management and nursing.

The number of people getting online degrees is on the rise too. According to Ohio University, over 6.7 million students are enrolled in online education programs. They elect this type of higher education because it enables them to learn in a non-traditional setting i.e. when they want and where they want. Part of the reason online programs are gaining so much traction is because they enable people to have schedules outside of school such as full-time jobs or families.

Community College

Community colleges offer a lot of students that want to attend college on a campus some form of financial relief. Typically community colleges are a much cheaper form of education and a great way to complete an associates degree before either transferring to a larger school to complete a bachelor’s degree or entering the workforce. Furthermore, most moderate to large cities have a community college, meaning it is possible to live at home at attend college. Although for most young adults this isn’t the most ideal situation, the money saved can really add up.

Private College

Attending a private college may be a great option for students looking for a very personalized college experience. In these institutions the students – not the politics – are the priority, leading to a unique culture and typically rigorous educational standards. These schools tend to be more on the expensive side; however, a number of merit-based scholarships are usually offered that can really take the edge off.

Private colleges do offer many benefits to their students. Professors working for private colleges are usually there to teach rather than do research, meaning they are going to have high classroom expectations and small class sizes. At some smaller private colleges, even intro classes have less than 30 students. The small schools also typically lend themselves to very tight-knit communities. Most students want to be involved somehow, whether it is through a few different clubs, working for professors, or by participating in classroom discussions.

Graduate Programs with Low Undergrad GPA


There are many short-term and long term professional and personal perks that successful completion of both undergraduate and graduate education can bring to your life. That knowledge drives many individuals to seek higher education at times in their life when they are incapable, for various reasons, to spend enough time or effort to cultivate an amazing undergraduate grade point average (GPA) and transcript. Unfortunately that can have a major long term consequence: difficulty finding graduate programs that accepts individuals with low GPAs.

Not all is lost. While the majority of colleges expect all applicants to have managed at least a 3.0 GPA, some colleges and programs understand that a slightly lower undergraduate GPA is not a guarantee that the individual will not excel in a graduate program. A few college and programs requirements:

  • Do not set a minimum GPA.
  • Accept the GRE/GMAT to compensate for low GPA.
  • Require additional professional work samples to compensate.
  • Set a slightly lower minimum (2.5 to 2.7).

To set you on the path to locating a program that will work for you, here is a list of master programs for individuals with a low GPA.

No GPA Minimum Given                                                                                  

Business

Boston University – Master of Science in Management

Pepperdine University – MBA

 

Health

USC – Master of Public Health

 

Psychology
USC – Master of Science in Applied Psychology

 

GRE/GMAT to Compensate

Business

Norwich University – MBA

Norwich University – Master of Science in Leadership

Northeastern University – Master of Science in Taxation

Northeastern University – Master of Science in Finance

 

Public Service
University of Cincinnati – Master of Science in Criminal Justice

George Washington University – Master’s in Strategic Public Relations

George Washington University – Master’s in Political Management

Norwich University – Master of Public Administration

Rutgers –¬†Masters in Public Administration¬†

 

Miscellaneous

Norwich University – Master of Arts in Diplomacy

Norwich University – Master of Civil Engineering

Norwich University – Master of Science in Information Security & Assurance

 

Additional Professional Work Samples

Business

Northeastern University – Master of Science in Taxation

Northeastern University – Master of Science in Finance

 

Public Service

George Washington University – Master’s in Strategic Public Relations

George Washington University – Master’s in Political Management

 

Miscellaneous

Rutgers –¬†Master’s of Engineering¬†with a Pharmaceutical Engineering emphasis

 

Low Minimum

Business

CollegeAmerica – Business Administration with an Entrepreneurship emphasis

2.5 GPA

Stevens-Henager – MBA

2.5 GPA

 

Health

Stevens-Henager – Health Informatics Master of Science

2.5 GPA

Stevens-Henager – Nursing Administration Master of Science

2.5 GPA

CollegeAmerica – Healthcare Informatics Master of Science

2.5 GPA

CollegeAmerica – Healthcare Administration Master of Science

2.5 GPA

Stevens-Henager – Nurse Education Master of Science

2.5 GPA

 

Psychology

Wake Forest University – Master of Arts in Counseling
2.5 GPA

 

Miscellaneous

Ohio University – Master of Athletic Administration

2.7 GPA

Nova Southeastern University – MATL & MEAL (Teaching Education)
2.5 GPA

CollegeAmerica – Informatics Systems Master of Science

2.5 GPA

Now you know that you can still apply to a graduate program with a low GPA. Remember that the path from application to acceptance will be more difficult for lower undergrad GPA students. Why? Colleges and Universities can only accept a portion of all applicants each semester. And chances are due to your GPA, your request to be accepted into the program will be slightly weaker than the other individuals seeking entrance. This means you should do everything you can to strengthen the other aspects of your application.

You can strengthen your application by:

  • Gaining as much time and experience in your field as you can before applying.
  • Ensure all professional references can speak intelligently and avidly about your performance and knowledge of the field.
  • Craft a strong statement of purpose and resume.
  • If allowed, take the GRE or GMAT.
  • And if all else fails, retake a few of the core subjects in order to boost your GPA slightly.

 

Other Resources:

Choosing a Program

Why America Needs Tax Professionals

A Growing Demand ‚Äď A Look at MBAs

How to Choose Your MBA Concentration

How to Choose the Right School for Your Career Path

5 Tips to Help You Stand Out from Other MBA Graduates

From Healthcare to Hiring: Climbing the Rungs of the Nursing Administration Ladder

FinanceU Syllabus

 

Prepping To Apply

Delve Into the Nuances of the MBA Resume

How to Get a Business School Recommendation

Statement of Purpose for MBA

Statements of Purpose: Overview and Before You Draft

Preparing for the GMAT

%d bloggers like this: