I only know and work with T-SQL, is it possible to make a career with just SQL database knowledge? Or do I need to expand my skillset to survive as a dev?
I agree with Daniel.
SQL as the only skills, will limit the jobs you can get.
But if database is your thing and no other language is interesting, look into topics like database design, indexing, query optimization, performance. Be the best in that field and that will make a great career.
The world still runs on data and really good database people are rare.
You can move into Business Intelligence, Data Engineering, Data Analysis and Reporting, Data Warehousing and Architecture, Database Migration to the Cloud, and leading projects that build Data Models.
I'm not sure if you're referring to technical skills and knowledge, or soft skills so I'll cover both.
Every job requires soft skills, it's not enough to only crunch SQL code all day. For all the jobs I've listed you will need:
Time management and organisational skills
Excellent interpersonal and collaboration skills
Excellent verbal and written communication, including business process documentation and standards writing
Able to quickly comprehend, analyse, define and describe complex business requirements
As far as technical skills you may need to upskill in these areas:
Reporting tools for Analysts/BI:
SSRS or
PowerBI or
Tableau or
MicroStrategy or
Qlik Sense
Integration and ETL tools for Data Warehousing/Engineering:
SSIS or
DBT or
Airflow
Database modelling and design skills for Data Warehousing and Architecture
Performance monitoring and tuning for Database Administration
Knowledge of High Availability solutions, such as Mirroring, Replication, Clustering, & Always On (Availability Groups)
Understanding of database security users and roles
Basic performance monitoring and analysis of SQL queries
Patching and upgrades
Development knowledge of APIs, Python is becoming more desirable for more technical Data Engineering roles but isn't essential for every company.
I agree with Daniel.
SQL as the only skills, will limit the jobs you can get.
But if database is your thing and no other language is interesting, look into topics like database design, indexing, query optimization, performance. Be the best in that field and that will make a great career.
The world still runs on data and really good database people are rare.
Okay cool, thank you, what can database people do other than data science ?
Data Science isn't the only career option.
You can move into Business Intelligence, Data Engineering, Data Analysis and Reporting, Data Warehousing and Architecture, Database Migration to the Cloud, and leading projects that build Data Models.
Okay great, thank you very much that would all require more than SQL I imagine ?
I'm not sure if you're referring to technical skills and knowledge, or soft skills so I'll cover both.
Every job requires soft skills, it's not enough to only crunch SQL code all day. For all the jobs I've listed you will need:
As far as technical skills you may need to upskill in these areas:
Reporting tools for Analysts/BI:
Integration and ETL tools for Data Warehousing/Engineering:
Database modelling and design skills for Data Warehousing and Architecture
Performance monitoring and tuning for Database Administration
This is so great, thank you!
No, you defenitly need to expand your skillset
Thank you for your answer