+ Reply to Thread
Page 1 of 2 1 2 Last
Results 1 to 25 of 28

Thread: SQL journey

  1. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #1

    Default SQL journey

    Hi guys,

    I don't mind admitting that I am an SQL noob, I've managed to get away with not using this for most of my career in server and network gigs. However, my new role has pushed a big project my way with the incentive of some MS SQL training at the end of next month but the project involves a lot of SQL work and a steep learning curve for me.

    I don't want to rock up knowing nothing SQL based and would like to learn this to add to my skills, where is best to start as there are millions of vids on youtube etc. I'm looking at codecademy and some free vids on Udemy but any other suggestions would be great.

    Thanks all.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    May 2006
    Posts
    1,947

    Certifications
    CISSP, CCSP, eJPT, ITIL,PA ACE,Qualys Certified Specialist, A+
    #2
    Microsoft Academy.
    Reply With Quote Quote  

  4. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #3
    Thanks for that, the virtual academy looks like there is plenty on there.
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #4
    Lynda.com, Pluralsight, Nuggets have some really good CBT's. I've watched them all, worth reviewing one or two. They follow the adventure works database.
    Reply With Quote Quote  

  6. Member
    Join Date
    May 2014
    Location
    UK
    Posts
    65

    Certifications
    CCNA R&S & Security, MCSA: Server 2012 & Office 365
    #5
    I've just got hold of the 70-462 materials to learn how to setup SQL servers and best practices. Looks good for sysadmin roles and not so much the programming side of things
    2017 Goals: 70-347[X], CCNA R&S [X], CCNA Security [X]
    2018 Goals: CCNP Route 300-101[], CCNP Switch 300-115[], CCNP T'Shoot 300-135[], VCP-DCV[]
    Reply With Quote Quote  

  7. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #6
    Thanks the help guys. 70-462 does sound more interesting that's for sure!
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #7
    Give 462 a go and see if anything comes out of it. At least you'll learn somethings....
    Reply With Quote Quote  

  9. Junior Member Registered Member
    Join Date
    Jan 2017
    Location
    We go where you go.
    Posts
    4
    #8
    We have a bunch of resources to help you get the hang of SQL. Our trainer Garth Schulte does some awesome work going through the ins and outs through our training. Our training isn’t necessarily free, but the first week of it is.
    We do have a few additional resources on our blog you can access right now to learn a bit more about SQL, too. Garth gets us ready for SQL Server 2016 in a webinar recording, we talk about 5 underused SQL functions and we tell you 5 great reasons to learn SQL.
    Hope this helps!
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Oct 2015
    Location
    UK
    Posts
    100

    Certifications
    MCSD (Web), MCSA (SQL Server 2012/14), AWS Architect (Assoc.)
    #9
    The Microsoft training book for exam 70-461 is pretty good as well. It focuses on SQL Server, but encourages the use of ANSI-standard SQL rather rather than vendor-specific syntax. SQL Server Express can be downloaded and installed for free, and contains a lot of the basic features that the full product does.

    If possible, try to find out what your role in the project will be, so you can prepare better. Will you be doing SQL development, DBA work, building SSIS packages, or perhaps a mixture of all of them?
    Reply With Quote Quote  

  11. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #10
    Thanks for the suggestions guys, will check them out!
    My role in the project is typical IT, do everything! Luckily won't be developing much it's more administration based SQL reporting and querying.
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #11
    Keep up the learning. You will be surprised on what you all of a sudden start to love. I wanted nothing to do with databases until my company deployed a solution that had a SQL Server 7 backend. I learned and got certified SQL 7.0 administrator and the rest is history. In my new job, I miss writing queries on a daily basis. Sounds like you have a nice plan. Learn as much as you can. You never know where this road in IT is going to lead you. Keep posting back!
    Reply With Quote Quote  

  13. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #12
    Thanks for that AvgITGeek - you are right, you never know quite where you will end up in IT. I am looking forward to learning some new things though whatever happens longer term!
    Reply With Quote Quote  

  14. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #13
    How's things going with your SQL Server adventure Chev?
    Reply With Quote Quote  

  15. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #14
    Finally hit year 5 developing SQL and I still have 50 miles to go on a 100 mile hike......
    Reply With Quote Quote  

  16. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #15
    That hike just keeps on going
    Reply With Quote Quote  

  17. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #16
    It's going well thanks mate but not had as much time to concentrate on SQL as I would've liked. Got a lot of cool but urgent stuff going on with VMware and cisco stuff at work so practical SQL side of things isn't quite where I wanted to be. Plodding along and learning though so all good
    Reply With Quote Quote  

  18. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #17
    Haha keep on going! I've got 99 miles left to go!
    Reply With Quote Quote  

  19. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #18
    Don't we all!

    I've had no time to study due to life and work (my senior engineer is on vacation so I'm trying to do what I can and figure out how to get the help that I need) I've been taking some notes on things to lab when I have time. I've still got to finish my taxes before I get sent to the big house for tax evasion lol!
    Reply With Quote Quote  

  20. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #19
    Land a Developer Role and you won't have that problem. As I look at my monitors and see 5 instances of SSMS up and 2 instances of SSAS..........

    Oh yeah can't forget Visual Studio.......

    Now I know why full stack devs end up as architects!
    Reply With Quote Quote  

  21. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #20
    No thanks on the developer role.... not my cup of tea.

    Yeah so much to do a work and home, trying to squeeze time in to study can be tough but trying where I can.
    Reply With Quote Quote  

  22. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #21
    I don't blame you.

    The funny thing is, from my perspective. You read all these books and train on these labs and the request in a real situation are sooooo much different than anything you learn about in the videos or books (generally speaking).

    I'm finding myself now creating large master views for a supply chain team right now. Building their catalogs and reporting data models (tables/views) that fuel their base reporting. It's fun but can be stressful as FK.
    Reply With Quote Quote  

  23. I drink and I know things Ertaz's Avatar
    Join Date
    Jan 2006
    Posts
    663

    Certifications
    CISSP, CASP, CSA+, GPEN, CCNA Cyber Ops, Security+, MCP
    #22
    Quote Originally Posted by DatabaseHead View Post
    I don't blame you.

    The funny thing is, from my perspective. You read all these books and train on these labs and the request in a real situation are sooooo much different than anything you learn about in the videos or books (generally speaking).

    I'm finding myself now creating large master views for a supply chain team right now. Building their catalogs and reporting data models (tables/views) that fuel their base reporting. It's fun but can be stressful as FK.
    Your report doesn't match when I pivot the data from 3 weeks ago in my trusty 32-bit version of Excel... Your system is crap.
    Reply With Quote Quote  

  24. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #23
    Quote Originally Posted by Ertaz View Post
    Your report doesn't match when I pivot the data from 3 weeks ago in my trusty 32-bit version of Excel... Your system is crap.
    Yeah the changing requirements are painful.

    I have a OLAP cube out there for them to use. Think Pivot table on steriods. They can aggregate millions of rows in seconds and barely anyone uses it. Strange........

    To your point that's SOP for me..... lol
    Reply With Quote Quote  

  25. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #24
    10:23 and counting on this query.........

    I could of moved my facts and aggregated my measures in less than 3 minutes.
    Reply With Quote Quote  

  26. Junior Member Registered Member
    Join Date
    Apr 2017
    Posts
    3
    #25
    I have passion working with data.With no hands on SQL experience and self study using materials online and those I could afford to buy,I recently passed MT-98-364(Database Fundamentals). I have tried to get a job but most companies are asking for 2-3 years working experiences. Now I am looking at MCSA 70-461. I need a honest advice career wise?
    Reply With Quote Quote  

+ Reply to Thread
Page 1 of 2 1 2 Last

Social Networking & Bookmarks