+ Reply to Thread
Page 2 of 2 First 12
Results 26 to 37 of 37
  1. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    330

    Certifications
    OCA MySQL, ITIL-F (2012),MCITP: SQL 2008 DB Dev.
    #26
    All the best. Am following your journey as my team and I work with SQL and this is a track my team could benefit from.
    Reply With Quote Quote  

  2. SS
  3. Member
    Join Date
    Jul 2016
    Location
    PL
    Posts
    50

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462, 70-461
    #27
    Something from today: foreign key must be created on a column which refers to a column that is the primary key in another table.

    9 days until the my 70-461 exam.

    @Zorodzai: thank you for response. I'm very pleased, but it seems to me that what I am writing about is basics of T-SQL - I have to learn a lot myself. Greetings to You and Your Team from Poland.
    Reply With Quote Quote  

  4. Member
    Join Date
    Jul 2016
    Location
    PL
    Posts
    50

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462, 70-461
    #28
    I found a video about XML in SQL Server:

    https://www.youtube.com/watch?v=WIg64plWH80

    My 70-461 exam will be day after tomorrow.
    Reply With Quote Quote  

  5. Member
    Join Date
    Jul 2016
    Location
    PL
    Posts
    50

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462, 70-461
    #29
    I passed 70-461 with 757/1000.
    The exam was demanding. I'm confused.
    There were many tasks which consisted in the fact that you had to write the code. It's good to remember the syntax of the different commands. In normal life, fortunately, there is Microsoft Docs.
    Someone can recommend books to preparation for 70-463 for a beginner in the data warehousing topic?
    Reply With Quote Quote  

  6. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    330

    Certifications
    OCA MySQL, ITIL-F (2012),MCITP: SQL 2008 DB Dev.
    #30
    Congrats, well done on the pass
    Reply With Quote Quote  

  7. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    189

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #31
    Congrats on the pass!
    Reply With Quote Quote  

  8. Member
    Join Date
    Jul 2016
    Location
    PL
    Posts
    50

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462, 70-461
    #32
    @Zorodzai
    @nachodba
    Thank you.
    I'm studying for the 70-463 exam from several weeks.
    I starting read the official training kit, but the non-working examples discouraged me.
    During the reading of training kit, I spent a lot of time on dealing with additional topics such as partitioning of tables.
    Sometimes I learn in the morning (4-5 a.m), sometimes in the evenings.
    Now I reading "SQL Server 2017 Integration Services Cookbook" and I'm just completing the test environment.
    In the meantime, I'm blogging every monday.
    Except that, in May, I plan to go to training from a data warehouse during the SQLDay conference in Poland.
    I will probably want to get MCSA and MCSE by passing the following exams\
    70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
    70-767 Implementing a Data Warehouse using SQL
    Last edited by adam9870; 02-18-2018 at 08:09 PM.
    Reply With Quote Quote  

  9. Member
    Join Date
    Jul 2016
    Location
    PL
    Posts
    50

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462, 70-461
    #33
    It was difficult for me to find the right book. In the end, I found book named "Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer". I'm going slowly with her. I have read 24 chapters. Each chapter includes several pages of theory and a practical task. Practical tasks are also shown in the video materials at Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer - Wrox
    Reply With Quote Quote  

  10. Member
    Join Date
    Jul 2016
    Location
    PL
    Posts
    50

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462, 70-461
    #34
    I still reading Knight's MS SQL Server 2012 Integration Services 24-Hour Trainer. Some topics are incomprehensible for me, so I am looking for other sources on the internet. I found two good article about Lookup transformation in SSIS.


    https://www.red-gate.com/simple-talk...tion-services/


    SSIS Lookup Transformation with example step by step : Learn MSBI Tutorials
    Reply With Quote Quote  

  11. Member
    Join Date
    Jul 2016
    Location
    PL
    Posts
    50

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462, 70-461
    #35
    Recently I was a bit busy with business matters, especially the GDPR. I devoted a good two months to it. It's time to get back to the exam preparation.


    My current plan is that I want to read until the 15 September tutorials from this page https://www.tutorialgateway.org/how-...is-in-28-days/ and book: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling 3rd Edition (https://www.amazon.com/Data-Warehous.../dp/1118530802). Next, in October, at the latest in November I want to pass 70-463. I plan to spend full time on weekends and in the evenings or in the morning (before work, when the mind is fresh) for preparing for 70-463 exam.


    In May, in the form of notes, I recorded a few films about SSIS and published them on my blog.
    Reply With Quote Quote  

  12. Junior Member
    Join Date
    Jul 2018
    Posts
    5
    #36
    I would suggest you to go through CBT Nuggets. You can buy their videos on eBay for like $10.
    Reply With Quote Quote  

  13. Member
    Join Date
    Jul 2016
    Location
    PL
    Posts
    50

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462, 70-461
    #37
    I am happy to write that every day I learn SSIS from month. I've already processed almost all of the Data Flow Tasks. I make video notes and gradually (once a week) publish on my blog. Some topics looks hard but really not hard (for example lookup transform). On 21-23 November I join to the conference about SQL Server. I think that I will pass 70-463 this year and maybe by the way 70-767. If I would pass 70-768 later then I would have 2 x MCSA and 1 x MCSE.
    Reply With Quote Quote  

+ Reply to Thread
Page 2 of 2 First 12

Social Networking & Bookmarks