Robert G Marquez
Robert G Marquez
  • Видео 18
  • Просмотров 338 139
Use Azure Data Studio to Load Wide World Importers Database File To SQL Server 2019
Import the free database Wide World Importers from a .bak file into SQL Server 2019. Azure Data Studio is the tool used in this video to load the database.
========================================================================
The free database is in a GitHub repository
Database Name: Wide World Importers
The URL is:
github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
========================================================================
File Name: WideWorldImporters-Full.bak
Additional information regarding the free databases for SQL Server
docs.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16
=============================================...
Просмотров: 850

Видео

Sample Motion Graphics - Affect Systems
Просмотров 2544 года назад
Sample motion graphics video I created with Cinema 4D and Sony Vegas of a fictional business named Affect Systems. Follow me on twitter to see what I'm working on and news on upcoming videos. My twitter page is at the below URL: RobertGMarquez1 My twitter account is @RobertGMarquez1 Personal website is at: www.robertmarquez.com Robert Glenn Marquez Samples Robert G Marquez Samples R...
Model View Presenter (MVP) Example - #10 Views and Presenters
Просмотров 9 тыс.6 лет назад
Video #10 Part 3 of Model View Presenter (MVP) covering Views and Presenters. Visual Studio 2017 development of the Views and Presenters using C# for a demo application. WinForms is being used for the graphical user interface. It will take several videos to cover this topic. Note that although WinForms is being used for the user interface, the other parts making up the engine such as service la...
Model View Presenter (MVP) Example - #9 Views and Presenters
Просмотров 9 тыс.6 лет назад
Video #9 Part 2 of Model View Presenter (MVP) covering Views and Presenters. Visual Studio 2017 development of the Views and Presenters using C# for a demo application begins with this video. WinForms is being used for the graphical user interface. It will take several videos to cover this topic. Note that although WinForms is being used for the user interface, the other parts making up the eng...
Model View Presenter (MVP) Example - #8 Views and Presenters
Просмотров 7 тыс.6 лет назад
Video #8 Part 1 of Model View Presenter (MVP) covering Views and Presenters. This video begins the discussion on the Views and Presenters part of MVP. Videos before this one covered areas of MVP prior to development of the user interface part. Note the overview video is in Video #1. Briefly discussed topics in this Video: - Demonstration of the Model View Presenter demo application - High level...
Model View Presenter (MVP) Example - #7 Repository Unit Testing With xUnit.NET
Просмотров 4,2 тыс.6 лет назад
Part 7 of MVP Using WinForms. This video shows how the repository is used by the services layer. This will be done by using the xUnit unit testing facilities to act as an interface to tell the service layer to perform repository actions. Note that video #8 is where coverage of the Presenters and Views begin if that is what you are looking for. The overview is in Video #1. Briefly discussed topi...
Model View Presenter (MVP) Example - #6 The Repository With ADO.NET
Просмотров 9 тыс.6 лет назад
Part 6 of MVP Using WinForms. This video covers creating a repository to be used in a demo application being built to demonstrate an example of Model View Presenter. Note that video #8 is where coverage of the Presenters and Views begin if that is what you are looking for. The overview is in Video #1. The repository in this video will use SQLite as the database engine. No Object Relational Mapp...
Model View Presenter (MVP) Example - #5 Unit Test Setup With xUnit.net
Просмотров 10 тыс.6 лет назад
Part 5 of MVP Using WinForms. This video covers setting up a Unit Test project using xUnit.Net in Visual Studio to test the Services Layer. Note that video #8 is where coverage of the Presenters and Views begin if that is what you are looking for. The overview is in Video #1. If you are not interested in unit testing an application then you should skip this video and move onto video #6. Video #...
Model View Presenter (MVP) Example - #4 Creating A Service Layer
Просмотров 15 тыс.6 лет назад
Part 4 of MVP Using WinForms. This video covers creating a services layer for use by the Presenter. The Presenter will use services in the Service Layer to carry out tasks such as send and receive model data from the repository. The Service Layer will also transform model data when needed for data being sent to the Presenter for use by the View. Note that video #8 is where coverage of the Prese...
Model View Presenter (MVP) Example - #3 Creating Models With Data Annotation Validations
Просмотров 13 тыс.6 лет назад
Part 3 of MVP Using WinForms. It covers model creation. Note that video #8 is where coverage of the Presenters and Views begin if that is what you are looking for. The overview is in Video #1. Briefly discussed topics in this Video: 1) Using Visual Studio 2017 to create a new solution 2) Create a Class Library project with .NET Framework support to be used as the Domain Layer 3) Creation of fol...
Model View Presenter (MVP) Example - #1 Overview
Просмотров 52 тыс.6 лет назад
This is part 1 of Model View Presenter (MVP) Using WinForms. The focus in this video is to provide an overview of how MVP was implemented in a WinForms application. Videos demonstrating how Visual Studio 2017 was used with C# and WinForms begin with video #3. Note that video #8 is where coverage of the Presenters and Views begin if that is what you are looking for. The coverage of Model View Pr...
Model View Presenter (MVP) Example - #2 SQLite Setup
Просмотров 12 тыс.6 лет назад
This is part 2 of MVP Using WinForms. It covers setting up SQLite for the Model View Presenter WinForms demo application. The use of Visual Studio 2017 will begin with video #3 which starts with model creation. Note that video #8 is where coverage of the Presenters and Views begin if that is what you are looking for. The overview is in Video #1. Briefly discussed topics in this Video: Using DB ...
Tutorial - Create A Matrix Report With SSRS and Visual Studio
Просмотров 2,1 тыс.8 лет назад
This tutorial demonstrates how to use the SSRS template for Visual Studio 2013 to create a matrix report. I created this video to demonstrate my knowledge of SSRS as well as my ability to use the following tools to create videos: - TechSmith Camtasia - Sony Vegas Studio 13 - Cinema 4D (Intro and ending) - Adobe Photoshop - Mixcraft Pro Studio 7 (music) Personal website is at: www.robertmarquez....
Tutorial - VMWare Workstation 8 Tips and Tricks
Просмотров 2,8 тыс.8 лет назад
Tutorial demonstrating several features of VMWare Workstation 8 such as the following: - Accessing files on your PC from a virtual desktop session - Suspending and restoring a session - Recording a virtual machine with the movie recorder - Access files outside of the virtual machine Personal website is at: www.robertmarquez.com Robert Glenn Marquez Samples Robert G Marquez Samples Robert Marque...
IIS 8.5 Tutorial #1 - Adding an additional website on Windows Server 2012 R2
Просмотров 10 тыс.8 лет назад
Tutorial showing how to add an additional web site on Windows Server 2012. Topic demonstrated are as follows: - How to create a virtual IP address for a web site on an intranet - IIS Manager 8.5 to create a site - DNS Manager to assign a friendly name to a site instead of an IP Address - Simple testing of a sample .NET WCF web service - Simple testing of a standard ASP.NET page - Simple testing...
Sequence Diagram #1 Using Enterprise Architect 12 Tutorial
Просмотров 78 тыс.8 лет назад
Sequence Diagram #1 Using Enterprise Architect 12 Tutorial
Activity Diagram Using Enterprise Architect 12 Tutorial
Просмотров 45 тыс.8 лет назад
Activity Diagram Using Enterprise Architect 12 Tutorial
Use Case Diagram Using Enterprise Architect 12 Tutorial
Просмотров 60 тыс.8 лет назад
Use Case Diagram Using Enterprise Architect 12 Tutorial

Комментарии

  • @hasanmougharbel8030
    @hasanmougharbel8030 2 года назад

    Hey there, God bless your efforts. I a a newbie sql learner with a simple enquiry. Where can i find a table with its properties that i have already created in sql managment studio? Thanks for taking care of this.

  • @dipakray9774
    @dipakray9774 4 года назад

    Nice and very useful explanation.Thanks ..!!!

  • @G-User1
    @G-User1 4 года назад

    Very nice and concrete explanation of MVP

  • @zeroxity1260
    @zeroxity1260 4 года назад

    Thank you for great videos Robert. I have been trying learn how to use the MVP pattern in my projects but haven't been able to find many articles on how everything interacts with each other specifically. From other guides on how the View and Presenter interact with each other I had always pictured it as something like view holding reference to Presenter and when user clicks button, button click event is raised in the view and calls method through the presenter reference. I never thought about the presenter subscribing to the event in the view so that the presenter can handle how it reacts to the event directly, instead of the view telling the presenter which methods to run when the event is raised.

  • @uiop1235
    @uiop1235 4 года назад

    Thank you! helpful for me

  • @anonymusxx1
    @anonymusxx1 4 года назад

    Thank You!

  • @WardahKafeel
    @WardahKafeel 4 года назад

    I have also found this tutorial on MVP: code.tutsplus.com/courses/windows-app-from-scratch

  • @albaterran
    @albaterran 4 года назад

    Thank you! Very useful video!!!

  • @mwrdhz
    @mwrdhz 5 лет назад

    Please make another enterprise tutorial. Ur vids really help me, thankyouu ❤❤❤

  • @sphakhumalo3346
    @sphakhumalo3346 5 лет назад

    thank u alot ver informative

  • @aboodlifetv778
    @aboodlifetv778 5 лет назад

    best tutorial ever thanks man

  • @ernestarran7868
    @ernestarran7868 5 лет назад

    thankyou for the tutorial

  • @NaaneVinu
    @NaaneVinu 5 лет назад

    Thank you Robert G Marquez. A lot of information here. i could able to learn not only EA Sequence diagram also some more UML elements and detailed Sequence diagram. Now I will apply these in my applications. Eagerly looking for some more videos regarding UML in your playlist.

  • @yukonzach
    @yukonzach 5 лет назад

    Well done! Thank you for the concise explanation.

  • @heldercosta921
    @heldercosta921 6 лет назад

    Thanks a lot. Great video series and very well explained. I'm trying download the source code to explore but the available link on www.robertmarquez.com/Videos/MVP is dead. Could you please restore the link? Again, thanks.

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Thanks for pointing out the broken link. I've fixed it now so please try it again.

  • @WisdomStacks
    @WisdomStacks 6 лет назад

    Thanks! Data annotation part [ 7:22] is really interesting. www.completecsharptutorial.com/asp-net-mvc5/data-annotation-validation-with-example-in-asp-net-mvc.php 👈 This is the link reference as a quick access.

  • @umayanrmr
    @umayanrmr 6 лет назад

    Thanks sir

  • @theochry6984
    @theochry6984 6 лет назад

    Thank you so much for your detailed explanation dear friend! It was a pleasure to watch your video

  • @mohsinmemon3362
    @mohsinmemon3362 6 лет назад

    can you please add sample code in details

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Hello Mohsin. View the details description for video #10. You will find the download link there which provides the project for this video series which includes sample code for this video, #3.

  • @robertgmarquez3932
    @robertgmarquez3932 6 лет назад

    The source code up to video number 10 is now available at the following location: www.robertmarquez.com/downloads/MVPDemo20180805(WithSqlLightDB).zip I won't have much time to work on this series for awhile

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      The first source code download I posted was missing the SQLight database. The below download link has it in the bin folder for debug: www.robertmarquez.com/downloads/MVPDemo20180805(WithSqlLightDB).zip

  • @Kalliskivi63
    @Kalliskivi63 6 лет назад

    thx bro you really help my life

  • @pietersmith9745
    @pietersmith9745 6 лет назад

    Very practical.

  • @pietersmith9745
    @pietersmith9745 6 лет назад

    Well explained.

  • @hansmeier2272
    @hansmeier2272 6 лет назад

    Thank you for this really helpful solution! Could you please give me a link where to download the demo's project code.

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      www.robertmarquez.com/downloads/MVPDemo20180805(WithSqlLightDB).zip

  • @vikramduhan8399
    @vikramduhan8399 6 лет назад

    Waiting for next video... Thanks in advance.

  • @luiscrespo3083
    @luiscrespo3083 6 лет назад

    The tutorial was fine, but where do I get another view or more examples of how to do this kind of diagrams, more examples with UML. Thanks a lot.

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Hello Luis. The only videos I have using EA are already on RUclips. I created those videos a few years ago to serve as a reference point for me to go back and re familiarize myself on how to use the tool later in the future. There are many videos like it on RUclips as well as several on the EA website. Just type the following search phrase on google: enterprise architect uml tutorial I probably would do more videos if I were to upgrade to version 14 but I am still using version 12 as it still meets all my current needs so I don't think I'll be purchasing an upgrade soon. If you send me a note identifying the kind of system you are trying to represent in a UML diagram I can give it consideration so if I do create another one it can hopefully come close to providing answers to the things you are looking for. For example, indicate if you are trying to create a sequence diagram for a web application processing a sales order or a desktop app performing typical client server CRUD operations etc. If you do this then it will give me an idea if I can create a video that is helpful but keep in mind there is no promise to create anything here.

  • @vikramduhan8399
    @vikramduhan8399 6 лет назад

    I am following you and working on a project, waiting for next video...

  • @vikramduhan8399
    @vikramduhan8399 6 лет назад

    Thanks much. Nicely explained. Could you please share this demo Project Code link!

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      I will try to make the Visual Studio project and code available this weekend.

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      The source code up to video number 10 is now available at the following location: www.robertmarquez.com/downloads/MVPDemo20180805(WithSqlLightDB).zip I won't have much time to work on this series for a while

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Yes, there will be a video number 11 for this series but due to other activities I am busy with I don't see it being released until probably September this year. I might release other videos this month on other topics I have a more immediate need for but it's too soon to know.

    • @heldercosta921
      @heldercosta921 6 лет назад

      Thanks a lot. Great video series and very well explained. I'm trying download the source code to explore but the available link is dead. Could you please restore the link? Again, thanks.

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Thanks for pointing out the broken link. It should work now using the below link: www.robertmarquez.com/downloads/MVPDemo20180805(WithSqlLightDB).zip

  • @j00x877
    @j00x877 6 лет назад

    Awesome Tutorial explained very well!

  • @jurajvt
    @jurajvt 6 лет назад

    Again - Thank you!

  • @vikramduhan8399
    @vikramduhan8399 6 лет назад

    Thanks a lot for these videos. Really helpful. Waiting for next videos... Awesome.....

  • @jurajvt
    @jurajvt 6 лет назад

    Thank you so much!

  • @gru74ik
    @gru74ik 6 лет назад

    Next video! Cool! Thanks a lot.

  • @nelobuensalida4105
    @nelobuensalida4105 6 лет назад

    Thank you!

  • @calumh4103
    @calumh4103 6 лет назад

    Really helpful, thank you!

  • @gru74ik
    @gru74ik 6 лет назад

    Thank you, Robert.

  • @gru74ik
    @gru74ik 6 лет назад

    Thank you for your videos Robert. They are very helpful.

  • @nelobuensalida4105
    @nelobuensalida4105 6 лет назад

    Hi Robert. Any update on the presenter and view? Thank you.

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Presenter an View are still being worked on. It is going to take more than one video to cover the two. Most likely at least one video covering the first part will be this weekend.

    • @nelobuensalida4105
      @nelobuensalida4105 6 лет назад

      Thanks!

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      I plan to upload the first part covering the Presenter and View by June 22. We are now coming to an end in this series of videos as the Presenter and View are the last remaining parts. Coverage will include integrating all that has been covered in the past videos with the graphical user interface (GUI). Basically the engine and car frame have been built so now we are just bolting the car body over it. Sounds like minimal work but there is actually a lot to do in getting the user interface operational with the underlying parts that have been built.The primary remaining work is in getting the GUI parts are set up.

    • @pawelsalford6373
      @pawelsalford6373 6 лет назад

      Hope to get more on interactions between View and PResenter - like Events, BusinessLogic validation on controls, DataBindings to textBoxes, Comboboxes, etc. And tests for it. Thanks

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Hello Pawel. The parts I will be covering are those that were implemented in the demo application. From the items you listed: events, controls, and databindings to textBoxes were implemented in the demo app so you will see that. Business Logic validation was covered in the Service video but I will also cover it again in the View/Presenter set so we can see how the view passes data to the presenter which is then validated by the service layer. I did not use a combo box in my implementation for data input. My example data input uses text boxes. A datagridview was used with binding data to list the departments. I don't know if I'll have time to add a combo box as I have spent far more time on the whole series than I thought I would. Please note that there will be more than one video covering presenter and view. The detail you asked about won't really be shown in Visual Studio probably no sooner than part two of the view/presenter parts.

  • @pawelsalford6373
    @pawelsalford6373 6 лет назад

    Great videos. Question: First time I see service class implementing IRepository. Can you point to an article about this design pattern? In most cases I use it under IService interface.

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Hello Pawel. While the service layer does have some method names that match those of the repository, it does not carry out the actual implementation. If you watch video #7, you will see how the Service Class is used to achieve data access operations by calling Repository methods and not by actually performing any database operations. . The actual implementation is in the Repository Class itself which you will see when you watch video #6. The reason this demo application service class is matching repository names only is so the Presenter part of the application goes through the Service class. I don't want the Presenter to communicate with the Repository. The Presenter will have to go through the Service class. This is a personal choice. Others may wish to talk to the Repository directly from the Presenter class. I went through the Service class to minimize code in the Presenter class. In some cases, a request for data from the Repository will require the return information to be transformed into something different like a DTO. I want all data transformations to take place in the Service Class as well rather than the Presenter. I want the Presenter to act as much as possible like a coordinator or foreman. I want the Presenter to focus on directing the work that needs to be done by other objects who have been identified as the labor workers of those tasks. Even so, the Presenter will still have a good amount of code in it to get things done. You can see an published example of a service class communicating with a repository in a book titled: Professional Enterprise .NET Chapter 3 look at the ReturnOrderService class. Keep in mind the video series I am putting together is using a small demonstration application. If it were a larger application requiring a wide variety to data access requests then the limited methods names I am using in the service layer (getall, getbyid, etc.) would not be enough. I would need to use other names in the service such as GetHighestRankDeptInNorthTerritory. So for now it looks like the Service Class is the Repository at a quick glance but it is not. The names it has for now are pass through names to the repository and will definitely not match as more customized data access needs arise.

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Hello Pawel. I took a second look at your comment and realize I did not answer the root of your question. You have a very good observation as there is an error in having the IDepartmentRepository (interface file) listed in the DepartmentServices class declaration. I added it there initially so Visual Studio would auto-generate the method stubs for me but I forgot to removed it. I have removed it now and everything still works fine. There have been a few code changes after some of the videos were released so there well be some out of sync code issues. However, I will be releasing the complete code set at the end of the series so no one will need worry about having code from an early video that was later updated. Thanks for pointing out the interface reference that does not need to be there.

  • @nelobuensalida4105
    @nelobuensalida4105 6 лет назад

    Thank you

  • @nelobuensalida4105
    @nelobuensalida4105 6 лет назад

    Thank you Robert. I hope part 6 will be uploaded soon.

  • @robertgmarquez3932
    @robertgmarquez3932 6 лет назад

    Video #5 should be ready by Friday, May 16 or sooner this week. It will cover the setup of a unit test project with a product called xUnit to test the service layer. A unit test setup will allow confirming various added C# modules actually work without having to build a GUI or console app to test invoke the modules. Coverage of the repository most likely will not be in Video #5 as I am trying to keep each video less than 15 or 20 minutes, it is too soon to know at this point. It may be possible Video #6 could also be released by this Friday as well. The repository will most likely be in Video #6.

  • @christianfuhrberg3842
    @christianfuhrberg3842 6 лет назад

    I want the next parts 😀 please

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Hello Christian. Thank you for watching. Please see the comment I have added which discusses the release of video #5 which I hope covers your comment.

  • @nelobuensalida4105
    @nelobuensalida4105 6 лет назад

    Thanks Robert. When will you upload the other parts (Repository, Presentation and View)?

    • @robertgmarquez3932
      @robertgmarquez3932 6 лет назад

      Hello Nelo. Thank you for watching. Please see the comment I have added which discusses the release of video #5 which I hope covers your comment.

    • @nelobuensalida4105
      @nelobuensalida4105 6 лет назад

      Thank you Robert. You explained it brief, well and easy to understand videos. Looking forward to it.

  • @superpcstation
    @superpcstation 6 лет назад

    I was just googling this :D Thanks!

  • @seanmarsh2960
    @seanmarsh2960 6 лет назад

    Thank you for this video. No one ever explains setting up the IP address and the forward looking zone. That key bit of information is what I needed to resolve the issue I was having. Thanks again

  • @milkiaswondimudemissie2026
    @milkiaswondimudemissie2026 7 лет назад

    Awesome Tutorial

  • @putchanarasimham3013
    @putchanarasimham3013 7 лет назад

    Robert Marquez: 1 Your's is one of the rare correctly developed UseCase Diagram. 2: You have rightly identified the software developer to be the user of UseCase Diagram and related documentation. 3: You associated only one Actor correctly with each UseCase, though other Actors have to act on the Actor has done. Many people wrongly associate other Actors with the same UseCase. 4: Your UseCase Names are expressive. Glad to find first error-free UseCase Diagram. I am surprised there are no comments so far. Other erroneous and misleading videos are highly appreciated by many learners. I hope more learners will watch and appreciate your video. I want to know, does the Enterprise Architect alert you if the user makes any mistakes?

  • @axelmouele5527
    @axelmouele5527 7 лет назад

    Thank you very much sir. You've really helped me understand it

  • @lucyrussell2342
    @lucyrussell2342 7 лет назад

    Very good and very clear !