Skip to content Skip to main nav
  • Guests
  • Log in
  • Sign up
Career Center
Upcoming Events
Request Career Support
Recruit Our Students
Facebook Instagram LinkedIn X (formerly Twitter) YouTube
  • Explore Career Paths
    • Take a Career Assessment
    • Explore Careers & Industries
    • Labor Market Insights
    • Read Success Stories
  • Get Started with Career Resources
    • CareerOneStop
    • Resume Scanner
    • Search Jobs
    • Watch Recorded Workshops
  • People We Serve
    • Students
      • Mental Health Matters
      • The Power of Nurses: Celebrating National Nurses Week
    • Communities
      • VetConnect
    • Alumni
    • Employers
      • Virtual Healthcare Career Fair Preparation Guide
  • Share This: Share SQL Practice: Intermediate Queries on FacebookShare SQL Practice: Intermediate Queries on LinkedInShare SQL Practice: Intermediate Queries on X
SQL Practice: Intermediate Queries

View Resource

Related Resources

Online Tools

  • AI Cover Letter Generator For Healthcare Jobs from HEALTHeCAREERS
  • An Explosion of Valuable—and Free—Support
  • CareerOneStop’s Interest Assessment
  • The Student and New Graduate Guide To Job Search
    • Rock Your LinkedIn Profile
    • Resources For Students With Disabilities
    • Resume Makeover 
    • Resume Scanner
    • Essential Job Search Tips for Nurses

NACE Resources

  • NACE Career Readiness Competencies
  • An Explosion of Valuable—and Free—Support
  • The Student and New Graduate Guide To Job Search
  • Rock Your LinkedIn Profile

LinkedIn Learning

  • LinkedIn Learning Course: Common Interview Questions
  • Working with Computers and Devices

Interview Preparation

  • Interviewing & Job Search Strategies Webinar 10/2023
  • Best Questions to Ask at the end of an Interview
  • Weaknesses for Job Interviews: 10 Example Answers for 2023
  • Warning Signs to Watch Out for During the Interview Process
    • How to Deal with Interview Anxiety
    • An Explosion of Valuable—and Free—Support
    • Top 51 Nurse Practitioner Interview Questions (Plus Answers)
    • The Student and New Graduate Guide To Job Search
    • Rock Your LinkedIn Profile
    • LinkedIn Learning Course: Common Interview Questions
    • Invest in You: Personal and Professional Development Tips
    • Grow with Google’s Interview Warmup

How-tos & Support Guides

  • Public Health Core Competencies
  • An Explosion of Valuable—and Free—Support
  • Nursing Pocket Cards
  • Clinical Guideline Summaries
    • The Student and New Graduate Guide To Job Search
    • Search and Apply for jobs strategically
    • 11 Tips for an Effective Job Searching Process
    • Rock Your LinkedIn Profile
    • Resume Makeover 
    • LinkedIn Learning Course: Common Interview Questions
    • Invest in You: Personal and Professional Development Tips
    • Working with Computers and Devices
    • Information Technology Career Goals: Why They’re Important and Examples
    • The Go-To Job Boards For Tech And IT Job Seekers
    • How Technology Is Transforming The Future Of Healthcare
    • Essential Job Search Tips for Nurses

Featured Articles

  • WHAT IS CAREER READINESS?
  • Listing Professional Experience on Your Resume
  • Writing Your Best Possible Resume
  • How to Navigate Applicant Tracking Systems
    • ATS, Resumes, and Beating the Bots in 2023
    • Applicant Tracking Systems: What Every Job Seeker Needs to Know
    • 2023 Applicant Tracking System (ATS) Usage Report: Key Shifts and Strategies for Job Seekers
    • CV vs Resume: Differences Between the Two
    • 5 REASONS TO KEEP YOUR PROFESSIONAL BRAND FRESH (EVEN WHEN YOU AREN’T LOOKING FOR A NEW JOB)
    • How To Write a Great Resume With No Experience
    • A Complete Guide to Effective Written Communication
    • Workplace Communication – Everything You Need to Know
    • 7 Examples of Important Teamwork Skills
    • An Explosion of Valuable—and Free—Support
    • The Student and New Graduate Guide To Job Search
    • Rock Your LinkedIn Profile
    • Resume Makeover 
    • 21 Ways to Make Networking Less Scary and More Fun
    • Best Questions to Ask at the end of an Interview
    • Weaknesses for Job Interviews: 10 Example Answers for 2023
    • 12 Tough Interview Questions and Answers with Helpful Tips
    • Warning Signs to Watch Out for During the Interview Process
    • How to Deal with Interview Anxiety
    • How to Negotiate Your Salary Once You Get a Job Offer
    • 4 Salary Negotiation Tips
    • 18 Networking Tips You Need to Know in 2023
    • Questions never to ask your interviewer and what to ask instead
    • Sandy Jones-Kaminiski My 10 Favorite Quotes About Networking
    • How to Network as a Student and a Graduate
    • Career expert’s 4 best networking tips for new graduates: It’s ‘about quality, not quantity’
    • Why College Networking is Important
    • What’s an ATS-Friendly Resume? And How to Write One
    • The Easy How-To Guide to Formatting Resumes for Applicant Tracking Systems
    • Action Verbs to make your resume stand out

Employer Policies

  • An Explosion of Valuable—and Free—Support
  • The Student and New Graduate Guide To Job Search
  • Rock Your LinkedIn Profile

Cover Letter & Resume Templates

  • Nurse – Resume Objectives and Summaries
  • Federal Resume Sample
  • AI Cover Letter Generator For Healthcare Jobs from HEALTHeCAREERS
  • An Explosion of Valuable—and Free—Support
    • The Student and New Graduate Guide To Job Search
    • Free Cover Letter Templates
    • Rock Your LinkedIn Profile
    • Resume Makeover 
    • Psychology Resume Example and Template (Plus How To Write)

Labor Market InsightsIn partnership withLightcast logo

Explore occupations by career categories and pathways and use real time labor market data to power your decision making.

  • Find career data by selecting keywords Keyword Search
  • or, by filtering for industry and occupation Industry Search

First, choose an industry of interest, then filter for occupation. (If you'd like to see data for a specific location only, filter by state.)

Type in a keyword to select a relevant occupation. (If you'd like to see data for a specific location only, filter by state.)

  • 01 Occupation Description
  • 02 Employment Trends
  • 03 Top Employers
  • 04 Education Levels
  • 05 Annual Earnings
  • 06 Technical Skills
  • 07 Core Competencies
  • 08 Job Titles

Occupation Description

Employment Trends

The number of jobs in the career for the past two years, the current year, and projections for the next 10 years. Job counts include both employed and self-employed persons, and do not distinguish between full- and part-time jobs. Sources include Emsi industry data, staffing patterns, and OES data.

Top Employers

These companies are currently hiring for .

    Education Levels

    The educational attainment percentage breakdown for a career (e.g. the percentage of people in the career who hold Bachelor’s Degrees vs. Associate Degrees). Educational attainment levels are provided by O*NET.

    Annual Earnings

    Earnings figures are based on OES data from the BLS and include base rate, cost of living allowances, guaranteed pay, hazardous-duty pay, incentive pay (including commissions and bonuses), on-call pay, and tips.

    Technical Skills

    A list of hard skills associated with a given career ordered by the number of unique job postings which ask for those skills.

      Core Competencies

      The skills for the career. The "importance" is how relevant the ability is to the occupation: scale of 1-5. The "level" is the proficiency required by the occupation: scale of 0-100. Results are sorted by importance first, then level.

        Job Titles

        A list of job titles for all unique postings in a given career, sorted by frequency.

          News  |  Events  |  Jobs  |  Videos  |  Experiences  |  Contact Us

          Facebook Instagram LinkedIn X (formerly Twitter) YouTube
          THE UNIVERSITY
          • About SouthU
          • Alumni and Giving @ SouthU
          • Careers @ SouthU
          • Newsroom @ SouthU
          • Blog @ SouthU
          FOR STUDENTS
          • Academic Calendar
          • Academic Catalog
          • CARES Info
          • HEERF II
          Student Consumer Information  Do Not Call Policy  Privacy and Cookie Policy  Non-Discrimination Policy  Terms of Use  Program List CIP Code Report  South University Site Map
          Programs, credential levels, technology, and scheduling options vary by school and are subject to change. * Credentials and experience levels vary by faculty and instructors. Not all programs are available to residents of all U.S. states. Administrative office: South University, 709 Mall Boulevard, Savannah, GA 31406-4805 © 2023 South University. All rights reserved.

           

          South University is accredited by the Southern Association of Colleges and Schools Commission on Colleges (SACSCOC) to award associate, baccalaureate, masters, and doctorate degrees. South University also may offer credentials such as certificates and diplomas at approved degree levels. Questions about the accreditation of South University may be directed in writing to the Southern Association of Colleges and Schools Commission on Colleges at 1866 Southern Lane, Decatur, GA 30033-4097, by calling (404) 679-4500, or by using information available on SACSCOC’s website ( www.sacscoc.org).

          *South University does not promise or guarantee employment or salary amounts.

           

          Privacy Policy | Terms of Service
          Copyright © 2025 South University
          Powered by uConnect