+ Reply to Thread
Page 3 of 9 First 123 4567 ... Last
Results 51 to 75 of 203
  1. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #51
    Honestly I am looking for something dumbed down where I can go to an employer and say yes I can write a join and I understand the difference of writing a query against a view and the table itself. I can write a subquery and know the difference between inner, outer, and cross joins.

    This beast goes well beyond that and then some. And to be honest I don't learn all that well if I am not applying the information.

    If you look at my certifications I was either doing a job related to that particular skill at that time or shortly before. Like Carl mentioned in an earlier post, he has worked with T-SQL for 3+ years. I have in spurts and at a very dumbed down level.
    Reply With Quote Quote  

  2. SS -->
  3. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,341

    Certifications
    CISSP
    #52
    Sorry you didn't get it! I can understand if you feel that the exam isn't matched for your skills. Are you having trouble learning the material, understanding the use scenarios or syntax or do you feel good about the material but the exam was just tough?
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #53
    Bottomline is I didn't put enough effort into studying. I'll have to think it over and see if I am going to sit it again. I am going to get the T-SQL book from ITZIK. That looks like something I could use a lot.

    I have 2 classes left to complete my MBA and I really need to channel my efforts on those right now. So after I complete these two I'll give it a hard thought.
    Reply With Quote Quote  

  5. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #54
    Let's put together some labs. Does anyone have some good example data sets other than Adventure Works etc that we could use? I'll start creating some SQLFiddles.
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #55
    We could come up with a fictious company and then ERD the business and convert to tables. Just a thought. Not only get the SQL DDL and DML, but also the modeling that goes along with a solid database. Work through the relationship etc. That way we can write the tables and then relationships etc in one swoop.

    Thoughts?
    Reply With Quote Quote  

  7. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,341

    Certifications
    CISSP
    #56
    The TSQL 2012 DB included with Iztik's book was quite good IMO.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #57
    Carl awesome call out. Thanks for the heads up. Just curious which book did you get of his/hers.
    Reply With Quote Quote  

  9. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,341

    Certifications
    CISSP
    #58
    I used this book Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012: Itzik Ben-Gan, Dejan Sarka, Ron Talmage: 9780735666054: Amazon.com: Books along with the TrainSignal videos. I liked the book but IMO it wouldn't be a good choice for beginners - rather, I would suggest his beginner's book then this book, then the exam.

    As I read through the book, I did each exercise as it was intended in the provided TSQL2012. Then, if I wasn't 100% on the technique, I went through on AdventureWorks and would try it there until I got it. The reason I used AdventureWorks instead of TSQL2012 is because I didn't want to fall into the trap of just repeating the exercise. I had to spend a lot of time on the advanced data aggregations and XML (a couple days each, which is a long time for me).
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #59
    Carl thanks for the heads up. I had SQL Express out last night and I was banging on some views and some joins. I plan on getting to the aggregates this weekend. I have out patient surgery tomorrow, but should be good to go on Saturday. I just really want to learn it first and then come back around with the certification piece.
    Reply With Quote Quote  

  11. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #60
    So how do we want to go about this?

    First let's all agree on the same data set. Adventure Works 2012 or another database? Whatever database we go with we need a roadmap to see all the relationships/schemas. I am assuming we are going to drop views on these tables as well so we will need a secondary roadmap for the views. Does anyone have this information in place? I would hate to reinvent the wheel if we can help it.

    I want to get the database in place first. I am not systems guy, but can someone spin up a VM to host a MDB file. Then we could all mount the database to our clients and start to bang out some queries.

    Thoughts? What would it take to make this happen? I just don't have enough knowledge with client server technology.
    Reply With Quote Quote  

  12. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #61
    Quote Originally Posted by CarlSaiyed View Post
    The TSQL 2012 DB included with Iztik's book was quite good IMO.
    I would have copyright concerns using that, though. Has he released it open source?
    Reply With Quote Quote  

  13. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #62
    Quote Originally Posted by N2IT View Post

    I want to get the database in place first. I am not systems guy, but can someone spin up a VM to host a MDB file. Then we could all mount the database to our clients and start to bang out some queries.

    Thoughts? What would it take to make this happen? I just don't have enough knowledge with client server technology.

    None of that is really needed if we use the SQL Fiddle site, though. We can version the labs and people can even fork them if they want to change something. This allows for collaborative work on the queries and the DDL.

    Using SQL Fiddle we can present a data set and schema and say, "Write a query that produces these results." We can then fork the Fiddle and write a potential answer. Users can then look at the answer and discuss them on the form.
    Reply With Quote Quote  

  14. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #63
    Here is an example: SQL Fiddle

    Your task is to write a query that displays only the information for the most recent Sales Order for each part number. This is simplified as the actual schema represents a JOIN on 3 tables in the original DB. The reason is to focus on how to perform the actual task and not be distracted by the JOINs

    Notice on the Fiddle site DDL should go on the left and DML (actual queries) on the right.
    Reply With Quote Quote  

  15. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #64
    What's up with the border at the top that cuts off the 1st 2 rows? I can't see the first of the DML.

    Nevermind you have to go full screen and then back to minimized.

    I'll mess around with this a little more.
    Reply With Quote Quote  

  16. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #65
    What does everybody else think? Does this concept have value?
    Reply With Quote Quote  

  17. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #66
    Anyone? Who's labbing this weekend?
    Reply With Quote Quote  

  18. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #67
    Have exams for my degree course fast approaching so haven't been able to spend as much time on SQL as I would have liked
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  19. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #68
    I understand that thing called life gets in the way

    I have been working on some Powershell recently for discovery so that's where a lot of my attention has been focused.
    Reply With Quote Quote  

  20. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #69
    Exams finally done with for this year, can now concentrate on SQL once again......
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  21. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #70
    How's it going? Z
    Reply With Quote Quote  

  22. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #71
    slooowww . I lost quite a bit of momentum from having to study for my uni exams. Slowly getting back into the 'technical' flow, had initially planned to attempt the exam this month but I think it makes better sense to go for it end of June. How's it going on your end ?
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  23. Senior Member knownhero's Avatar
    Join Date
    Jul 2008
    Location
    UK
    Posts
    434

    Certifications
    MCSE: SharePoint 2013, Productivity
    #72
    Quote Originally Posted by Zorodzai View Post
    slooowww . I lost quite a bit of momentum from having to study for my uni exams. Slowly getting back into the 'technical' flow, had initially planned to attempt the exam this month but I think it makes better sense to go for it end of June. How's it going on your end ?
    Same here on the momentum. Just started to pick it up again want to sit the exam end of August time.
    70-410 [x] 70-411 [x] 70-462[x] 70-331[x] 70-332[x]
    MCSE - SharePoint 2013

    Road map 2017: JavaScript and modern web development

    Reply With Quote Quote  

  24. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #73
    Anybody else interested in getting the MCSE Database? I know I am but I have a LONG way to go. Besides I am starting a new job that is primarily around Access and Excel. However it does use MS SQL so that hopefully gets the juices flowing. If I am not using the technology it's damn near impossible for me to get any kind of momentum going.
    Reply With Quote Quote  

  25. Senior Member knownhero's Avatar
    Join Date
    Jul 2008
    Location
    UK
    Posts
    434

    Certifications
    MCSE: SharePoint 2013, Productivity
    #74
    Quote Originally Posted by N2IT View Post
    Anybody else interested in getting the MCSE Database? I know I am but I have a LONG way to go. Besides I am starting a new job that is primarily around Access and Excel. However it does use MS SQL so that hopefully gets the juices flowing. If I am not using the technology it's damn near impossible for me to get any kind of momentum going.
    I'm thinking about going for that down the road, but for now its just focusing on the MCSA and getting a solid grasp on that.
    70-410 [x] 70-411 [x] 70-462[x] 70-331[x] 70-332[x]
    MCSE - SharePoint 2013

    Road map 2017: JavaScript and modern web development

    Reply With Quote Quote  

  26. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,341

    Certifications
    CISSP
    #75
    @N2IT I am very interested in the MCSE database
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

+ Reply to Thread
Page 3 of 9 First 123 4567 ... Last

Social Networking & Bookmarks