Robert G Marquez
Robert G Marquez
  • 18
  • 334 375
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
=========================================================================
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
Robert Marquez Samples
Author Name Look ups are: Robert G Marquez, Robert G. Marquez, Robert Glenn Marquez, and Robert Marquez.
rgmtechvideos
zhlédnutí: 790

Video

Sample Motion Graphics - Affect Systems
zhlédnutí 253Před 4 lety
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
zhlédnutí 8KPřed 6 lety
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
zhlédnutí 8KPřed 6 lety
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
zhlédnutí 6KPřed 6 lety
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
zhlédnutí 4,1KPřed 6 lety
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
zhlédnutí 9KPřed 6 lety
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
zhlédnutí 9KPřed 6 lety
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
zhlédnutí 15KPřed 6 lety
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
zhlédnutí 13KPřed 6 lety
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
zhlédnutí 51KPřed 6 lety
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
zhlédnutí 11KPřed 6 lety
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
zhlédnutí 2,1KPřed 8 lety
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
zhlédnutí 2,8KPřed 8 lety
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
zhlédnutí 10KPřed 8 lety
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
zhlédnutí 77KPřed 8 lety
Sequence Diagram #1 Using Enterprise Architect 12 Tutorial
Activity Diagram Using Enterprise Architect 12 Tutorial
zhlédnutí 45KPřed 8 lety
Activity Diagram Using Enterprise Architect 12 Tutorial
Use Case Diagram Using Enterprise Architect 12 Tutorial
zhlédnutí 60KPřed 8 lety
Use Case Diagram Using Enterprise Architect 12 Tutorial

Komentáře

  • @hasanmougharbel8030
    @hasanmougharbel8030 Před 2 lety

    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 Před 4 lety

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

  • @G-User1
    @G-User1 Před 4 lety

    Very nice and concrete explanation of MVP

  • @zeroxity1260
    @zeroxity1260 Před 4 lety

    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 Před 4 lety

    Thank you! helpful for me

  • @anonymusxx1
    @anonymusxx1 Před 4 lety

    Thank You!

  • @WardahKafeel
    @WardahKafeel Před 4 lety

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

  • @albaterran
    @albaterran Před 4 lety

    Thank you! Very useful video!!!

  • @mwrdhz
    @mwrdhz Před 4 lety

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

  • @sphakhumalo3346
    @sphakhumalo3346 Před 5 lety

    thank u alot ver informative

  • @aboodlifetv778
    @aboodlifetv778 Před 5 lety

    best tutorial ever thanks man

  • @ernestarran7868
    @ernestarran7868 Před 5 lety

    thankyou for the tutorial

  • @NaaneVinu
    @NaaneVinu Před 5 lety

    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 Před 5 lety

    Well done! Thank you for the concise explanation.

  • @heldercosta921
    @heldercosta921 Před 5 lety

    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.

  • @tharindadivakara2881
    @tharindadivakara2881 Před 5 lety

    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 Před 6 lety

    Thanks sir

  • @theochry6984
    @theochry6984 Před 6 lety

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

  • @mohsinmemon3362
    @mohsinmemon3362 Před 6 lety

    can you please add sample code in details

    • @robertgmarquez3932
      @robertgmarquez3932 Před 6 lety

      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 Před 6 lety

    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

  • @Kalliskivi63
    @Kalliskivi63 Před 6 lety

    thx bro you really help my life

  • @pietersmith9745
    @pietersmith9745 Před 6 lety

    Very practical.

  • @pietersmith9745
    @pietersmith9745 Před 6 lety

    Well explained.

  • @hansmeier2272
    @hansmeier2272 Před 6 lety

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

    • @robertgmarquez3932
      @robertgmarquez3932 Před 5 lety

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

  • @vikramduhan8399
    @vikramduhan8399 Před 6 lety

    Waiting for next video... Thanks in advance.

  • @luiscrespo3083
    @luiscrespo3083 Před 6 lety

    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 Před 6 lety

      Hello Luis. The only videos I have using EA are already on CZcams. 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 CZcams 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 Před 6 lety

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

  • @vikramduhan8399
    @vikramduhan8399 Před 6 lety

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

    • @robertgmarquez3932
      @robertgmarquez3932 Před 6 lety

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

    • @robertgmarquez3932
      @robertgmarquez3932 Před 6 lety

      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 Před 6 lety

      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 Před 5 lety

      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.

  • @j00x877
    @j00x877 Před 6 lety

    Awesome Tutorial explained very well!

  • @jurajvt
    @jurajvt Před 6 lety

    Again - Thank you!

  • @vikramduhan8399
    @vikramduhan8399 Před 6 lety

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

  • @jurajvt
    @jurajvt Před 6 lety

    Thank you so much!

  • @gru74ik
    @gru74ik Před 6 lety

    Next video! Cool! Thanks a lot.

  • @nelobuensalida4105
    @nelobuensalida4105 Před 6 lety

    Thank you!

  • @calumh4103
    @calumh4103 Před 6 lety

    Really helpful, thank you!

  • @gru74ik
    @gru74ik Před 6 lety

    Thank you, Robert.

  • @gru74ik
    @gru74ik Před 6 lety

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

  • @nelobuensalida4105
    @nelobuensalida4105 Před 6 lety

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

  • @pawelsalford6373
    @pawelsalford6373 Před 6 lety

    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 Před 6 lety

      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.

  • @nelobuensalida4105
    @nelobuensalida4105 Před 6 lety

    Thank you

  • @nelobuensalida4105
    @nelobuensalida4105 Před 6 lety

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

  • @robertgmarquez3932
    @robertgmarquez3932 Před 6 lety

    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

    I want the next parts 😀 please

  • @nelobuensalida4105
    @nelobuensalida4105 Před 6 lety

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

  • @superpcstation
    @superpcstation Před 6 lety

    I was just googling this :D Thanks!

  • @seanmarsh2960
    @seanmarsh2960 Před 6 lety

    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

    Awesome Tutorial

  • @putchanarasimham3013
    @putchanarasimham3013 Před 6 lety

    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 Před 6 lety

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