Penn State Actuarial Science
  • Home
  • Students
    • New Students >
      • Boot Camp
      • What is an Actuary?
      • Career Paths
      • Actuarial Exams & VEEs
    • Career Fair
    • Mentor Program >
      • Mentor
      • Mentee
    • Exams >
      • Exam Study Advice >
        • Exam P 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
    • Exam Preparations
    • Databases and Lists
    • Career Tips
    • Excel/Coding >
      • Excel/VBA
      • Microsoft Access
      • SQL
      • R
      • SAS
      • Python
    • Scholarships & Awards
  • 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
New Students
Career Fair
Information Sessions

Mentor Form 
Mentee Form
Exams

Scheduling
Students with Jobs/Internships
Resume Dropbox

Event Attendance
​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
Career Fair Information
​Information Sessions
​On-Campus Student Interviews
Resources
Exam Preparations
Databases and Lists
Career Tips
Excel/Coding
Scholarships & Awards

About Us
Club Leadership
Executive Board Structure

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
    • Mentor Program >
      • Mentor
      • Mentee
    • Exams >
      • Exam Study Advice >
        • Exam P 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
    • Exam Preparations
    • Databases and Lists
    • Career Tips
    • Excel/Coding >
      • Excel/VBA
      • Microsoft Access
      • SQL
      • R
      • SAS
      • Python
    • Scholarships & Awards
  • About Us
    • Club Leadership
    • Executive Board Structure
  • Contact