Join the Central Virginia CSTA

Hi folks! Were trying to streamline the membership list for the Central Virginia CSTA Chapter. Our first goal building a teaching community to support computer science education in Virginia. That means getting as many people to the table as possible.

Please take a second to fill out the form to become an official member.

Click here to Join CSTA Central VA

• Who can join?
  YOU! Anyone passionate about computer science education in Virginia is welcome. Our members include K-12 teachers, parents, college faculty and folks from the business community that all believe in the power of computer science education.
• Why Join?
  Because there is power in numbers. There are a lot of issues facing computer science education, from training in curriculum and instruction to advocacy for equity and access. The CSTA is on the front line.
• I am already a member!
  Please fill out the form anyway - we are trying to centralize to one list.
• How can I help?
  There are a lot of ways to become involved. Local chapter meetings are the best place to start. By meeting other people working to improve computer science education you become a part of a great community working to improve the education of our kids.

And if you prefer a QR code:

Read More..

Difference between LEFT and RIGHT OUTER Joins in SQL MySQL Join example

There are two kinds of OUTER joins in SQL, LEFT OUTER join and RIGHT OUTER join. Main difference between RIGHT OUTER join and LEFT OUTER join, as there name suggest, is inclusion of non matched rows. Sine INNER join only include matching rows, where value of joining column is same, in final result set, but OUTER join extends that functionality and also include unmatched rows in final result. LEFT outer join includes unmatched rows from table written on left of join predicate. On the other hand RIGHT OUTER join, along with all matching rows, includes unmatched rows from right side of table. In short result of LEFT outer join is INNER JOIN + unmatched rows from LEFT table and RIGHT OUTER join is INNER JOIN + unmatched rows from right hand side table. Similar to difference between INNER join and OUTER join, difference between LEFT and RIGHT OUTER JOIN can be better understand by a simple example, which we will see in next section. By the way joins are very popular in SQL interviews, and along with classic questions like finding second highest salary of employee,Inner join vs outer join or left outer join vs right outer join is commonly asked.

Read more »

Read More..