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

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: 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
    48

    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
    48

    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
    48

    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
    328

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: 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
    48

    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
    48

    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
    48

    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  

+ Reply to Thread
Page 2 of 2 First 12

Social Networking & Bookmarks