Mixing
How do I build a portfolio?
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;
up vote
1
down vote
favorite
After graduating, I started self-teaching myself SQL using Codecademy and books. I've listed this on my resume in a way that implies I'm not very experienced with the language but am familiar with it. I'd like a way to show employers my SQL skills more directly.
Standard advice to show employers your skills is to create projects or portfolios. Here's where my problem lies: I have no idea what the format is for these. Considering that I'm dealing SQL, I can't just build a website or app to show what I know. I'm assuming that projects in a portfolio involve more than just a document of plain code. Or is that all there is to it?
skills
asked Aug 31 '16 at 17:21
Student
409313
 |Â
show 7 more comments
up vote
1
down vote
favorite
After graduating, I started self-teaching myself SQL using Codecademy and books. I've listed this on my resume in a way that implies I'm not very experienced with the language but am familiar with it. I'd like a way to show employers my SQL skills more directly.
Standard advice to show employers your skills is to create projects or portfolios. Here's where my problem lies: I have no idea what the format is for these. Considering that I'm dealing SQL, I can't just build a website or app to show what I know. I'm assuming that projects in a portfolio involve more than just a document of plain code. Or is that all there is to it?
skills
asked Aug 31 '16 at 17:21
Student
409313
Given that SQL is more of a supporting back-end technology for broader applications, it's a bit difficult to show specific 'portfolio' type examples of SQL usage. You might then want to start looking more into overall structures and patterns of how database systems are setup, right from a small personal website to a large enterprise web-application. Understanding these design decisions and what makes sense in what context is more in-line with what you would want to show employers I think.
– pay
Aug 31 '16 at 17:30
1
Github is a excellent way to create a portfolio of your code. You can easily share it too and almost everyone knows what github is.
– Dan
Aug 31 '16 at 19:19
1
Can you explain why you want to build a portfolio? What is wrong with getting a job with your college education?
– nvoigt
Sep 1 '16 at 7:40
1
@nvoigt There's plenty of companies that are looking to hire the best. Even straight out of undergrad, they want to see actual projects. Maybe they don't have a tech background. OP doesn't need to explain why to you.
– Hobbes
Sep 1 '16 at 14:33
1
@Lilienthal OP doesn't have work experience, and as you said, in that circumstance a portfolio is helpful. You are also wrong about portfolios in IT. For example, anyone hiring a data scientist will want to see actual projects.
– Hobbes
Sep 1 '16 at 14:33
 |Â
show 7 more comments
up vote
1
down vote
favorite
up vote
1
down vote
favorite
After graduating, I started self-teaching myself SQL using Codecademy and books. I've listed this on my resume in a way that implies I'm not very experienced with the language but am familiar with it. I'd like a way to show employers my SQL skills more directly.
Standard advice to show employers your skills is to create projects or portfolios. Here's where my problem lies: I have no idea what the format is for these. Considering that I'm dealing SQL, I can't just build a website or app to show what I know. I'm assuming that projects in a portfolio involve more than just a document of plain code. Or is that all there is to it?
skills
asked Aug 31 '16 at 17:21
Student
409313
After graduating, I started self-teaching myself SQL using Codecademy and books. I've listed this on my resume in a way that implies I'm not very experienced with the language but am familiar with it. I'd like a way to show employers my SQL skills more directly.
Standard advice to show employers your skills is to create projects or portfolios. Here's where my problem lies: I have no idea what the format is for these. Considering that I'm dealing SQL, I can't just build a website or app to show what I know. I'm assuming that projects in a portfolio involve more than just a document of plain code. Or is that all there is to it?
skills
asked Aug 31 '16 at 17:21
Student
409313
asked Aug 31 '16 at 17:21
Student
409313
asked Aug 31 '16 at 17:21
Student
409313
asked Aug 31 '16 at 17:21
Student
409313
409313
Given that SQL is more of a supporting back-end technology for broader applications, it's a bit difficult to show specific 'portfolio' type examples of SQL usage. You might then want to start looking more into overall structures and patterns of how database systems are setup, right from a small personal website to a large enterprise web-application. Understanding these design decisions and what makes sense in what context is more in-line with what you would want to show employers I think.
– pay
Aug 31 '16 at 17:30
1
Github is a excellent way to create a portfolio of your code. You can easily share it too and almost everyone knows what github is.
– Dan
Aug 31 '16 at 19:19
1
Can you explain why you want to build a portfolio? What is wrong with getting a job with your college education?
– nvoigt
Sep 1 '16 at 7:40
1
@nvoigt There's plenty of companies that are looking to hire the best. Even straight out of undergrad, they want to see actual projects. Maybe they don't have a tech background. OP doesn't need to explain why to you.
– Hobbes
Sep 1 '16 at 14:33
1
@Lilienthal OP doesn't have work experience, and as you said, in that circumstance a portfolio is helpful. You are also wrong about portfolios in IT. For example, anyone hiring a data scientist will want to see actual projects.
– Hobbes
Sep 1 '16 at 14:33
 |Â
show 7 more comments
Given that SQL is more of a supporting back-end technology for broader applications, it's a bit difficult to show specific 'portfolio' type examples of SQL usage. You might then want to start looking more into overall structures and patterns of how database systems are setup, right from a small personal website to a large enterprise web-application. Understanding these design decisions and what makes sense in what context is more in-line with what you would want to show employers I think.
– pay
Aug 31 '16 at 17:30
1
Github is a excellent way to create a portfolio of your code. You can easily share it too and almost everyone knows what github is.
– Dan
Aug 31 '16 at 19:19
1
Can you explain why you want to build a portfolio? What is wrong with getting a job with your college education?
– nvoigt
Sep 1 '16 at 7:40
1
@nvoigt There's plenty of companies that are looking to hire the best. Even straight out of undergrad, they want to see actual projects. Maybe they don't have a tech background. OP doesn't need to explain why to you.
– Hobbes
Sep 1 '16 at 14:33
1
@Lilienthal OP doesn't have work experience, and as you said, in that circumstance a portfolio is helpful. You are also wrong about portfolios in IT. For example, anyone hiring a data scientist will want to see actual projects.
– Hobbes
Sep 1 '16 at 14:33
Given that SQL is more of a supporting back-end technology for broader applications, it's a bit difficult to show specific 'portfolio' type examples of SQL usage. You might then want to start looking more into overall structures and patterns of how database systems are setup, right from a small personal website to a large enterprise web-application. Understanding these design decisions and what makes sense in what context is more in-line with what you would want to show employers I think.
– pay
Aug 31 '16 at 17:30
Given that SQL is more of a supporting back-end technology for broader applications, it's a bit difficult to show specific 'portfolio' type examples of SQL usage. You might then want to start looking more into overall structures and patterns of how database systems are setup, right from a small personal website to a large enterprise web-application. Understanding these design decisions and what makes sense in what context is more in-line with what you would want to show employers I think.
– pay
Aug 31 '16 at 17:30
1
1
Github is a excellent way to create a portfolio of your code. You can easily share it too and almost everyone knows what github is.
– Dan
Aug 31 '16 at 19:19
Github is a excellent way to create a portfolio of your code. You can easily share it too and almost everyone knows what github is.
– Dan
Aug 31 '16 at 19:19
1
1
Can you explain why you want to build a portfolio? What is wrong with getting a job with your college education?
– nvoigt
Sep 1 '16 at 7:40
Can you explain why you want to build a portfolio? What is wrong with getting a job with your college education?
– nvoigt
Sep 1 '16 at 7:40
1
1
@nvoigt There's plenty of companies that are looking to hire the best. Even straight out of undergrad, they want to see actual projects. Maybe they don't have a tech background. OP doesn't need to explain why to you.
– Hobbes
Sep 1 '16 at 14:33
@nvoigt There's plenty of companies that are looking to hire the best. Even straight out of undergrad, they want to see actual projects. Maybe they don't have a tech background. OP doesn't need to explain why to you.
– Hobbes
Sep 1 '16 at 14:33
1
1
@Lilienthal OP doesn't have work experience, and as you said, in that circumstance a portfolio is helpful. You are also wrong about portfolios in IT. For example, anyone hiring a data scientist will want to see actual projects.
– Hobbes
Sep 1 '16 at 14:33
@Lilienthal OP doesn't have work experience, and as you said, in that circumstance a portfolio is helpful. You are also wrong about portfolios in IT. For example, anyone hiring a data scientist will want to see actual projects.
– Hobbes
Sep 1 '16 at 14:33
 |Â
show 7 more comments
3 Answers
3
active
oldest
votes
up vote
2
down vote
You can create a project on github or bitbucket, and use SQL in that project. You can show a couple of demos, maybe a test suite for some back-end feature, or another project that makes use of SQL. This doesn't have to have a particular goal, but should have a "narrative" about what you're trying to do or show. Anyone can cut-and-paste code from elsewhere, so you need to show that you have a logical progression of ideas, and therefore couldn't have done that.
Both are free for this use case. It will only cost you time.
answered Aug 31 '16 at 18:56
jimm101
11.6k72753
suggest improvements |Â
up vote
2
down vote
In the past I have had job applications where they wanted to see SQL Code. What they want to see is how you can utilize the data in the database. The Microsoft sample databases are a great tool for this.
Start out and create a business question based on the sample database. "How many of X or Y were sold on such and such a date to which buyers." Follow that up with the SQL code for how you would determine the answer to the business question. Get creative, think of the most complex questions or caculations that could be made of the data in the sample database, and write SQL to answer it.
answered Aug 31 '16 at 19:02
JasonJ
6,47041334
suggest improvements |Â
up vote
1
down vote
I think in expounding on technical subjects where there's no front-end, you need to show:
- Problem domain
- Business rules
- Technical approach (EXACTLY how the implementation should work and why it's a good one. Enumerate some possible alternatives and explain why you didn't use them.)
- Solution
If you can cover the first three, the last is less relevant.
answered Aug 31 '16 at 17:25
Xavier J
26.3k104797
suggest improvements |Â
StackExchange.ready(function ()
$("#show-editor-button input, #show-editor-button button").click(function ()
var showEditor = function()
$("#show-editor-button").hide();
$("#post-form").removeClass("dno");
StackExchange.editor.finallyInit();
;
var useFancy = $(this).data('confirm-use-fancy');
if(useFancy == 'True')
var popupTitle = $(this).data('confirm-fancy-title');
var popupBody = $(this).data('confirm-fancy-body');
var popupAccept = $(this).data('confirm-fancy-accept-button');
$(this).loadPopup(
url: '/post/self-answer-popup',
loaded: function(popup)
var pTitle = $(popup).find('h2');
var pBody = $(popup).find('.popup-body');
var pSubmit = $(popup).find('.popup-submit');
pTitle.text(popupTitle);
pBody.html(popupBody);
pSubmit.val(popupAccept).click(showEditor);
)
else
var confirmText = $(this).data('confirm-text');
if (confirmText ? confirm(confirmText) : true)
showEditor();
);
);
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
You can create a project on github or bitbucket, and use SQL in that project. You can show a couple of demos, maybe a test suite for some back-end feature, or another project that makes use of SQL. This doesn't have to have a particular goal, but should have a "narrative" about what you're trying to do or show. Anyone can cut-and-paste code from elsewhere, so you need to show that you have a logical progression of ideas, and therefore couldn't have done that.
Both are free for this use case. It will only cost you time.
answered Aug 31 '16 at 18:56
jimm101
11.6k72753
suggest improvements |Â
up vote
2
down vote
You can create a project on github or bitbucket, and use SQL in that project. You can show a couple of demos, maybe a test suite for some back-end feature, or another project that makes use of SQL. This doesn't have to have a particular goal, but should have a "narrative" about what you're trying to do or show. Anyone can cut-and-paste code from elsewhere, so you need to show that you have a logical progression of ideas, and therefore couldn't have done that.
Both are free for this use case. It will only cost you time.
answered Aug 31 '16 at 18:56
jimm101
11.6k72753
suggest improvements |Â
up vote
2
down vote
up vote
2
down vote
You can create a project on github or bitbucket, and use SQL in that project. You can show a couple of demos, maybe a test suite for some back-end feature, or another project that makes use of SQL. This doesn't have to have a particular goal, but should have a "narrative" about what you're trying to do or show. Anyone can cut-and-paste code from elsewhere, so you need to show that you have a logical progression of ideas, and therefore couldn't have done that.
Both are free for this use case. It will only cost you time.
answered Aug 31 '16 at 18:56
jimm101
11.6k72753
You can create a project on github or bitbucket, and use SQL in that project. You can show a couple of demos, maybe a test suite for some back-end feature, or another project that makes use of SQL. This doesn't have to have a particular goal, but should have a "narrative" about what you're trying to do or show. Anyone can cut-and-paste code from elsewhere, so you need to show that you have a logical progression of ideas, and therefore couldn't have done that.
Both are free for this use case. It will only cost you time.
answered Aug 31 '16 at 18:56
jimm101
11.6k72753
answered Aug 31 '16 at 18:56
jimm101
11.6k72753
answered Aug 31 '16 at 18:56
jimm101
11.6k72753
answered Aug 31 '16 at 18:56
jimm101
11.6k72753
11.6k72753
suggest improvements |Â
suggest improvements |Â
up vote
2
down vote
In the past I have had job applications where they wanted to see SQL Code. What they want to see is how you can utilize the data in the database. The Microsoft sample databases are a great tool for this.
Start out and create a business question based on the sample database. "How many of X or Y were sold on such and such a date to which buyers." Follow that up with the SQL code for how you would determine the answer to the business question. Get creative, think of the most complex questions or caculations that could be made of the data in the sample database, and write SQL to answer it.
answered Aug 31 '16 at 19:02
JasonJ
6,47041334
suggest improvements |Â
up vote
2
down vote
In the past I have had job applications where they wanted to see SQL Code. What they want to see is how you can utilize the data in the database. The Microsoft sample databases are a great tool for this.
Start out and create a business question based on the sample database. "How many of X or Y were sold on such and such a date to which buyers." Follow that up with the SQL code for how you would determine the answer to the business question. Get creative, think of the most complex questions or caculations that could be made of the data in the sample database, and write SQL to answer it.
answered Aug 31 '16 at 19:02
JasonJ
6,47041334
suggest improvements |Â
up vote
2
down vote
up vote
2
down vote
In the past I have had job applications where they wanted to see SQL Code. What they want to see is how you can utilize the data in the database. The Microsoft sample databases are a great tool for this.
Start out and create a business question based on the sample database. "How many of X or Y were sold on such and such a date to which buyers." Follow that up with the SQL code for how you would determine the answer to the business question. Get creative, think of the most complex questions or caculations that could be made of the data in the sample database, and write SQL to answer it.
answered Aug 31 '16 at 19:02
JasonJ
6,47041334
In the past I have had job applications where they wanted to see SQL Code. What they want to see is how you can utilize the data in the database. The Microsoft sample databases are a great tool for this.
Start out and create a business question based on the sample database. "How many of X or Y were sold on such and such a date to which buyers." Follow that up with the SQL code for how you would determine the answer to the business question. Get creative, think of the most complex questions or caculations that could be made of the data in the sample database, and write SQL to answer it.
answered Aug 31 '16 at 19:02
JasonJ
6,47041334
answered Aug 31 '16 at 19:02
JasonJ
6,47041334
answered Aug 31 '16 at 19:02
JasonJ
6,47041334
answered Aug 31 '16 at 19:02
JasonJ
6,47041334
6,47041334
suggest improvements |Â
suggest improvements |Â
up vote
1
down vote
I think in expounding on technical subjects where there's no front-end, you need to show:
- Problem domain
- Business rules
- Technical approach (EXACTLY how the implementation should work and why it's a good one. Enumerate some possible alternatives and explain why you didn't use them.)
- Solution
If you can cover the first three, the last is less relevant.
answered Aug 31 '16 at 17:25
Xavier J
26.3k104797
suggest improvements |Â
up vote
1
down vote
I think in expounding on technical subjects where there's no front-end, you need to show:
- Problem domain
- Business rules
- Technical approach (EXACTLY how the implementation should work and why it's a good one. Enumerate some possible alternatives and explain why you didn't use them.)
- Solution
If you can cover the first three, the last is less relevant.
answered Aug 31 '16 at 17:25
Xavier J
26.3k104797
suggest improvements |Â
up vote
1
down vote
up vote
1
down vote
I think in expounding on technical subjects where there's no front-end, you need to show:
- Problem domain
- Business rules
- Technical approach (EXACTLY how the implementation should work and why it's a good one. Enumerate some possible alternatives and explain why you didn't use them.)
- Solution
If you can cover the first three, the last is less relevant.
answered Aug 31 '16 at 17:25
Xavier J
26.3k104797
I think in expounding on technical subjects where there's no front-end, you need to show:
- Problem domain
- Business rules
- Technical approach (EXACTLY how the implementation should work and why it's a good one. Enumerate some possible alternatives and explain why you didn't use them.)
- Solution
If you can cover the first three, the last is less relevant.
answered Aug 31 '16 at 17:25
Xavier J
26.3k104797
answered Aug 31 '16 at 17:25
Xavier J
26.3k104797
answered Aug 31 '16 at 17:25
Xavier J
26.3k104797
answered Aug 31 '16 at 17:25
Xavier J
26.3k104797
26.3k104797
suggest improvements |Â
suggest improvements |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fworkplace.stackexchange.com%2fquestions%2f75213%2fhow-do-i-build-a-portfolio%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Given that SQL is more of a supporting back-end technology for broader applications, it's a bit difficult to show specific 'portfolio' type examples of SQL usage. You might then want to start looking more into overall structures and patterns of how database systems are setup, right from a small personal website to a large enterprise web-application. Understanding these design decisions and what makes sense in what context is more in-line with what you would want to show employers I think.
– pay
Aug 31 '16 at 17:30
1
Github is a excellent way to create a portfolio of your code. You can easily share it too and almost everyone knows what github is.
– Dan
Aug 31 '16 at 19:19
1
Can you explain why you want to build a portfolio? What is wrong with getting a job with your college education?
– nvoigt
Sep 1 '16 at 7:40
1
@nvoigt There's plenty of companies that are looking to hire the best. Even straight out of undergrad, they want to see actual projects. Maybe they don't have a tech background. OP doesn't need to explain why to you.
– Hobbes
Sep 1 '16 at 14:33
1
@Lilienthal OP doesn't have work experience, and as you said, in that circumstance a portfolio is helpful. You are also wrong about portfolios in IT. For example, anyone hiring a data scientist will want to see actual projects.
– Hobbes
Sep 1 '16 at 14:33