May 11, 2016 at 9:59 am
hi all,
i posted in here a week ago and got loads of responses ( thank you again)
i was advised to download SQL Server 2014 developer edition instead of express which i was using.
i am only just getting started with writing statement eg select, alter, delete, drop, create, insert, truncate, joins, merge ect
can anyone help me with what i should start learning next as i know i'm only doing the querying side and i want to know what the next thing i should start looking at.
i'm sorry if this is just a silly question but some guide would really help.
thank you all for taking time to read this.
Scott
May 11, 2016 at 10:32 am
scott_carl_turner (5/11/2016)
can anyone help me with what i should start learning next as i know i'm only doing the querying side and i want to know what the next thing i should start looking at.
My opinion: it depends. Where do you want to go with this? Do you want to be a DBA, do you want to do development work, etc.?
If you're looking at becoming a full-blown DBA, you might want to start going in-depth into concepts, such as indexing, primary key/foreign key relationships, triggers, writing efficient code, etc. etc. etc. (that's off the top of my head). Lots of stuff to process, but SQL is a big animal. Nobody knows everything (if that was the case, we might not have these forums!), so take a look around and see what interests you.
I'm sure it's already been suggested, but if you haven't already done so, try setting up a sample database (NorthWind comes to mind) and just play. Hands-on, I think, is the best way to learn.
Also, see if there's a SQL Saturday near you coming up. That might be worth your time.
Hope this helps!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
May 11, 2016 at 10:38 am
Off the top of my head...
If you are interested in SQL Development then maybe consider learning about/creating stored procedures and functions.
If you are interested in the database administration side of things consider practicing backups, restores, attaching/detaching databases. Study up on the proper drive configuration.
Whatever you do, learn indexing. Play with clustered, non-clustered and filtered indexes. Play around with indexed views and learn how to run queries with "show actual execution plan turned on" to understand what's going on when you run a query.
That's a good start.
-- Itzik Ben-Gan 2001
May 11, 2016 at 1:48 pm
Thank you all for the advice
And this might sound like another stupid question but what's the diff between DBA and developer
Thanks again
May 11, 2016 at 1:54 pm
DBA : A database administrator or DBA plays a critical role in managing the databases of an organization. One of the major role of DBA is to keep data safe and secure and work on administration side of it like creating/removing logins, installation/setting up connection, managing backups,security etc
Developer:Developers’ job duties include developing SQL databases and writing applications to interface with SQL databases, as well as writing and testing code. Development often consists of designing tables, storing procedures, views and functions.SQL developers work with project managers, businesses owners, analyst teams and clients, building database prototypes to validate system requirements. They also document code, provide progress reports, and perform code review and peer feedback.
May 11, 2016 at 2:55 pm
Well if I'm being honest I am not quiet sure which I would prefer to do, which one would you start if you wanted to learn both and I don't wanna be nieve and think I could learn then in a week how long would it take to learn both these areas do you know
Sorry about all the questions
May 11, 2016 at 2:58 pm
If you want to learn both find a small company that needs you to do both 😀
Keep in mind at the entry level there's a lot of over lap in the skills required for the two roles. Basic development skills like creating tables/procedures and functions and queries more complex than SELECT * FROM will help you as a DBA. And inversely understanding at least the basics of performance tuning and indexing strategies, user management and SQL jobs will help you as a developer.
May 11, 2016 at 3:02 pm
This will help to start: https://sqlschool.modeanalytics.com/toc/
May 11, 2016 at 3:02 pm
1. There is absolutely no way you will learn these skills in a week (or even a month). These are skills that are built over time.
2. In terms of what direction you should go, you won't get an easy answer to that here (or anywhere else). The only person who can answer that is the one you see in the mirror. You can get information and advice everywhere, but ultimately, you need to figure it out.
I apologize if that sounds harsh (not my intent). It's possible to do both, but it probably depends on your situation.
Whatever you decide, good luck to you!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
May 12, 2016 at 6:21 am
scott,
believe me its not that complicated....start out learning basic ...join small firm with whatever position..developer or DBA....either position will make you more expose what both position do...and while experiencing...you will able to decide...which specific area..you want to focus....
keep in mind.....not all developers play DBA role...but most of the DBA do play developers role too in small fir...
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply