Penn State Actuarial Science
  • Home
  • Students
    • New Students >
      • Boot Camp
      • What is an Actuary?
      • Career Paths
      • Actuarial Exams & VEEs
    • Career Fair
    • Information Sessions
    • Mentor Program >
      • Mentor
      • Mentee
    • Exams >
      • Exam Study Advice
      • Exam Dates
      • Exam Passers
    • Scheduling
    • Students with Jobs/Internships
    • Resume Dropbox
    • Event Attendance
    • International and Commonwealth Campus Students
    • Graduate School
  • Recruiters
    • Resume Book
    • Career Fair Registration
    • Career Fair Information
    • Information Sessions
    • Student Interviews
  • Resources
    • Databases and Lists
    • Career Tips
    • Excel/Coding >
      • Excel/VBA
      • Microsoft Access
      • SQL
      • R
      • SAS
      • Python
    • Bookings Page >
      • Bookings Mentors
    • Scholarships & Awards
    • Coaching Actuaries
  • About Us
    • Club Leadership
    • Executive Board Structure
  • Contact

SQL

What is SQL?

SQL (pronounced Sequel) is similar to Access in that it is used for database management, but SQL has a few key differences. SQL is a language that is designed for managing and summoning data from different databases based on a criteria you are looking for. Imagine you have a huge database of policies and you want to specify the specific types of information you want to find within it, SQL can help! SQL can be more powerful and versatile than Access, but to use its full functionality you will need to understand how coding words and what the syntax of SQL is.

How Can I Use SQL?

There are many different versions of SQL, but the Developer version, which is sufficient for learning it before applying it at a company, can be downloaded here. 

How Can I Learn SQL?

  • Initial Learning Strategy
  • Videos:
    • ​freeCodeCamp.org
    • Programming with Mosh​
  • W3 Schools
    • ​W3 has a really nice reading opportunity to learn SQL and perform exercises at the end of each section. Not many learning resources let you actually apply the learning, so this is a great resource!
  • SQL "Cheat Sheet"
    • ​Useful reference for syntax and frequently used commands.

Students
Career Fair
Information Sessions

Resume Dropbox
Scheduling
Event Attendance
Mentor Form 
Mentee Form
Students with Jobs/Internships
Exam Passers

Exam Dates
​International and Commonwealth
Graduate School



New Students
Boot Camp
Mentee Form
What Is An Actuary?
Actuarial Exams and VEEs
Recruiters
Resume Book
Career Fair Registration
​Information Sessions
​On-Campus Interviews
Resources
Databases and Lists
Career Tips
Excel/Coding
​
Bookings
Mentors List
Scholarships & Awards
Coaching Actuaries
About Us
Club Leadership
Executive Board Structure
Newsletters

Contact

The Pennsylvania State University | Penn State Actuarial Science Club
This website is brought to you by the Technology Team
  • Home
  • Students
    • New Students >
      • Boot Camp
      • What is an Actuary?
      • Career Paths
      • Actuarial Exams & VEEs
    • Career Fair
    • Information Sessions
    • Mentor Program >
      • Mentor
      • Mentee
    • Exams >
      • Exam Study Advice
      • Exam Dates
      • Exam Passers
    • Scheduling
    • Students with Jobs/Internships
    • Resume Dropbox
    • Event Attendance
    • International and Commonwealth Campus Students
    • Graduate School
  • Recruiters
    • Resume Book
    • Career Fair Registration
    • Career Fair Information
    • Information Sessions
    • Student Interviews
  • Resources
    • Databases and Lists
    • Career Tips
    • Excel/Coding >
      • Excel/VBA
      • Microsoft Access
      • SQL
      • R
      • SAS
      • Python
    • Bookings Page >
      • Bookings Mentors
    • Scholarships & Awards
    • Coaching Actuaries
  • About Us
    • Club Leadership
    • Executive Board Structure
  • Contact