FreeEnglish
CS50's Introduction to Databases with SQL
Harvard · CS50 · SQL & databasesFrom Harvard: table design, queries and indexes, with lectures and hands-on problem sets. Entirely free.
← All careers
SA
All courses
Junior Systems Analyst
Systems analysis & design path · Business & AnalysisCloser to the technology than a BA. Designs how a system works inside: data, screens and integration with other systems.
Open to new graduatesمحلل نظم مبتدئ
What the job involves
- Analyses existing systems and finds weak spots
- Draws DFD, UML and ERD diagrams
- Writes functional and technical specifications
- Coordinates developers and the database team
- Plans system integration and data migration
Your path from this job
- Junior Systems AnalystYou start as · 0–2 years
Documents current systems, draws diagrams and writes parts of specifications.
- Systems Analyst2–5 years
Designs a full system solution, including integration and data flows.
- Solution Architect5–10 years
Chooses technologies and designs solutions across connected systems.
- Enterprise Architect10+ years
Shapes the whole organisation's systems landscape in line with its strategy.
Years are approximate and vary by employer. What matters is that each stage builds on the last.
Where you'd work
IT departments in large organisations, software houses and solution providers.
Skills you need
SDLCUML & DFDDatabase designUnderstanding APIsTechnical writing
Tools of the trade
Lucidchart / draw.ioEnterprise ArchitectJiraSQL clientPostman
Certification ladder
Tap any certification for details. You don't need them all: pick one per level based on where you work.
EntryStart here
IntermediateAfter about 2 years
AdvancedFor seniors
Get ready for this role
Suggested courses for this role
YouTubeEnglish
SQL Tutorial: Full Database Course for Beginners
freeCodeCamp · SQL & databasesOne of YouTube's best-known SQL videos: from database design to joins.
Free to auditEnglish
SQL for Data Science
Coursera · UC Davis · SQL & databasesFrom UC Davis, focused on using SQL for analysis.
PaidEnglish
Business Analysis Fundamentals
Udemy · Jeremy Aschenbrenner · Business & systems analysisOne of the most popular beginner BA courses: the analyst's role, eliciting and documenting requirements.