{"presentation":{"slides":[{"elements":[{"x":8.714596949891067,"y":23.65591397849462,"width":67.53812636165577,"height":49.46236559139785,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Step by step SQL Server 2019 installation.<\/h2>\n\n
<\/p>\n"},"subContentId":"64488287-1628-408c-a787-eeb328597e74","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091507,"y":8.594989247311828,"width":92.5925925925926,"height":86.4516129032258,"action":{"library":"H5P.InteractiveVideo 1.27","params":{"interactiveVideo":{"video":{"startScreenOptions":{"title":"Interactive Video","hideStartTitle":false},"textTracks":{"videoTrack":[{"label":"Subtitles","kind":"subtitles","srcLang":"en"}]},"files":[{"path":"https:\/\/youtu.be\/hiXVaVRvlDA","mime":"video\/YouTube","copyright":{"license":"U"}}]},"assets":{"interactions":[{"x":7.641921397379913,"y":23.299366869086608,"width":22.270742358078603,"height":10.91703056768559,"duration":{"from":113.84899999999999,"to":113.84899999999999},"libraryTitle":"True\/False Question","action":{"library":"H5P.TrueFalse 1.8","params":{"media":{"disableImageZooming":false},"correct":"true","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false},"l10n":{"trueText":"True","falseText":"False","score":"You got @score of @total points","checkAnswer":"Check","submitAnswer":"Submit","showSolutionButton":"Show solution","tryAgain":"Retry","wrongAnswerMessage":"Wrong answer","correctAnswerMessage":"Correct answer","scoreBarLabel":"You got :num out of :total points","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"
Is SQL Server Developer Edition the same as Enterprise Edition in the background?<\/p>\n"},"subContentId":"9719ee65-d4e2-4254-ae46-4c24ba802ee6","metadata":{"contentType":"True\/False Question","license":"U","title":"SQL Server Developer Edition"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":"
SQL Server Version<\/p>\n"},{"x":3.2751091703056767,"y":13.592105811802524,"width":34.49781659388646,"height":15.283842794759826,"duration":{"from":284.316,"to":294.316},"libraryTitle":"Multiple Choice","action":{"library":"H5P.MultiChoice 1.16","params":{"media":{"disableImageZooming":false},"answers":[{"correct":true,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"
Windows Authentication only<\/div>\n"},{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"
SQL Authentication only<\/div>\n"},{"correct":true,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"
Mixed Windows authentication and SQL authentication<\/div>\n"},{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"
There is just one option<\/div>\n"}],"overallFeedback":[{"from":0,"to":100}],"behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"type":"auto","singlePoint":false,"randomAnswers":true,"showSolutionsRequiresInput":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"passPercentage":100,"showScorePoints":true},"UI":{"checkAnswerButton":"Check","submitAnswerButton":"Submit","showSolutionButton":"Show solution","tryAgainButton":"Retry","tipsLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","tipAvailable":"Tip available","feedbackAvailable":"Feedback available","readFeedback":"Read feedback","wrongAnswer":"Wrong answer","correctAnswer":"Correct answer","shouldCheck":"Should have been checked","shouldNotCheck":"Should not have been checked","noInput":"Please answer before viewing the solution","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"
What are possible User Access modes? (choose two)<\/p>\n"},"subContentId":"5cd960cf-2c3a-4fe3-8e88-dd693fc89a5b","metadata":{"contentType":"Multiple Choice","license":"U","title":"User Access Mode"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""}],"endscreens":[{"time":424,"label":"7:04 Submit Screen"}]},"summary":{"task":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"07c15180-3a26-4725-b75f-88026023526f","tip":""}],"overallFeedback":[{"from":0,"to":100}],"solvedLabel":"Progress:","scoreLabel":"Wrong answers:","resultLabel":"Your result","labelCorrect":"Correct.","labelIncorrect":"Incorrect! Please try again.","alternativeIncorrectLabel":"Incorrect","labelCorrectAnswers":"Correct answers.","tipButtonLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","progressText":"Progress :num of :total"},"subContentId":"8b580c47-e3c6-4222-a35d-7c206038de74","metadata":{"contentType":"Summary","license":"U","title":"Untitled Summary"}},"displayAt":3}},"override":{"autoplay":false,"loop":false,"showBookmarksmenuOnLoad":false,"showRewind10":false,"deactivateSound":false,"preventSkippingMode":"none"},"l10n":{"interaction":"Interaction","play":"Play","pause":"Pause","mute":"Mute, currently unmuted","unmute":"Unmute, currently muted","quality":"Video Quality","captions":"Captions","close":"Close","fullscreen":"Fullscreen","exitFullscreen":"Exit Fullscreen","summary":"Open summary dialog","bookmarks":"Bookmarks","endscreen":"Submit screen","defaultAdaptivitySeekLabel":"Continue","continueWithVideo":"Continue with video","playbackRate":"Playback Rate","rewind10":"Rewind 10 Seconds","navDisabled":"Navigation is disabled","sndDisabled":"Sound is disabled","requiresCompletionWarning":"You need to answer all the questions correctly before continuing.","back":"Back","hours":"Hours","minutes":"Minutes","seconds":"Seconds","currentTime":"Current time:","totalTime":"Total time:","singleInteractionAnnouncement":"Interaction appeared:","multipleInteractionsAnnouncement":"Multiple interactions appeared.","videoPausedAnnouncement":"Video is paused","content":"Content","answered":"@answered answered","endcardTitle":"@answered Question(s) answered","endcardInformation":"You have answered @answered questions, click below to submit your answers.","endcardInformationOnSubmitButtonDisabled":"You have answered @answered questions.","endcardInformationNoAnswers":"You have not answered any questions.","endcardInformationMustHaveAnswer":"You have to answer at least one question before you can submit your answers.","endcardSubmitButton":"Submit Answers","endcardSubmitMessage":"Your answers have been submitted!","endcardTableRowAnswered":"Answered questions","endcardTableRowScore":"Score","endcardAnsweredScore":"answered","endCardTableRowSummaryWithScore":"You got @score out of @total points for the @question that appeared after @minutes minutes and @seconds seconds.","endCardTableRowSummaryWithoutScore":"You have answered the @question that appeared after @minutes minutes and @seconds seconds."}},"subContentId":"f7b3aeff-f206-45db-a68f-efbd9b77b70a","metadata":{"contentType":"Interactive Video","license":"U","title":"Install SQL Server 2019"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":4.357298474945534,"y":8.602150537634408,"width":91.50326797385621,"height":30.10752688172043,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Next step is to download backup file from following link<\/span><\/span><\/span><\/span><\/span><\/p>\n\n
https:\/\/docs.microsoft.com\/en-us\/sql\/samples\/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms<\/a><\/span><\/span><\/span><\/p>\n\n
Download AdventureWorks2019.bak from OLTP<\/span><\/span><\/span><\/p>\n"},"subContentId":"4cd4f010-48e6-4e95-a139-e61fbb4b9118","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":4.357298474945534,"y":36.516129032258064,"width":67.53812636165577,"height":59.784946236559136,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","file":{"path":"images\/file-62ccb316260f1.png","mime":"image\/png","copyright":{"license":"U"},"width":1823,"height":818},"alt":"Backups"},"subContentId":"b57db4ec-5e83-4bab-9f93-97a44bb0967d","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":1.0893246187363834,"y":2.1433698924731184,"width":95.86056644880175,"height":23.65591397849462,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Restore to SQL Server<\/span><\/span><\/span><\/span><\/span><\/h2>\n\n
You can use the <\/span><\/span><\/span><\/span>`.bak<\/span><\/span><\/span><\/code> file to restore your sample database to your SQL Server instance. You can do so using the graphical interface (GUI) in <\/span><\/span><\/span><\/span>`SQL Server Management Studio<\/span><\/span><\/span><\/span><\/span><\/a> or <\/span><\/span><\/span><\/span>Azure Data Studio<\/span><\/span><\/span><\/span><\/span><\/a>.<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n"},"subContentId":"55aae281-8ee0-4961-83fa-35e79f4f0ee2","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":2.178649237472767,"y":27.9210752688172,"width":33.769063180827885,"height":68.17204301075269,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","file":{"path":"images\/file-62ccb3e929de5.png","mime":"image\/png","copyright":{"license":"U"},"width":420,"height":430},"alt":"Restore"},"subContentId":"ca1fac2b-6e0b-47d6-9b78-a59bc7ace34f","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":46.84095860566449,"y":27.956989247311824,"width":40.30501089324619,"height":69.24731182795698,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","file":{"path":"images\/file-62ccb4090219b.png","mime":"image\/png","copyright":{"license":"U"},"width":865,"height":750},"alt":"Restore"},"subContentId":"65442d39-80c6-4195-94e3-eb60f546dde8","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":39.21568627450981,"y":58.064516129032256,"width":5.446623093681917,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
---><\/span><\/strong><\/h2>\n"},"subContentId":"84c402ea-3de2-4e3a-96de-4a06990730ac","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}}],"keywordListEnabled":true,"globalBackgroundSelector":{},"keywordListAlwaysShow":false,"keywordListAutoHide":false,"keywordListOpacity":90},"override":{"activeSurface":false,"hideSummarySlide":false,"summarySlideSolutionButton":true,"summarySlideRetryButton":true,"enablePrintButton":false,"social":{"showFacebookShare":false,"facebookShare":{"url":"@currentpageurl","quote":"I scored @score out of @maxScore on a task at @currentpageurl."},"showTwitterShare":false,"twitterShare":{"statement":"I scored @score out of @maxScore on a task at @currentpageurl.","url":"@currentpageurl","hashtags":"h5p, course"},"showGoogleShare":false,"googleShareUrl":"@currentpageurl"}},"l10n":{"slide":"Slide","score":"Score","yourScore":"Your Score","maxScore":"Max Score","total":"Total","totalScore":"Total Score","showSolutions":"Show solutions","retry":"Retry","exportAnswers":"Export text","hideKeywords":"Hide sidebar navigation menu","showKeywords":"Show sidebar navigation menu","fullscreen":"Fullscreen","exitFullscreen":"Exit fullscreen","prevSlide":"Previous slide","nextSlide":"Next slide","currentSlide":"Current slide","lastSlide":"Last slide","solutionModeTitle":"Exit solution mode","solutionModeText":"Solution Mode","summaryMultipleTaskText":"Multiple tasks","scoreMessage":"You achieved:","shareFacebook":"Share on Facebook","shareTwitter":"Share on Twitter","shareGoogle":"Share on Google+","summary":"Summary","solutionsButtonTitle":"Show comments","printTitle":"Print","printIngress":"How would you like to print this presentation?","printAllSlides":"Print all slides","printCurrentSlide":"Print current slide","noTitle":"No title","accessibilitySlideNavigationExplanation":"Use left and right arrow to change slide in that direction whenever canvas is selected.","accessibilityCanvasLabel":"Presentation canvas. Use left and right arrow to move between slides.","containsNotCompleted":"@slideName contains not completed interaction","containsCompleted":"@slideName contains completed interaction","slideCount":"Slide @index of @total","containsOnlyCorrect":"@slideName only has correct answers","containsIncorrectAnswers":"@slideName has incorrect answers","shareResult":"Share Result","accessibilityTotalScore":"You got @score of @maxScore points in total","accessibilityEnteredFullscreen":"Entered fullscreen","accessibilityExitedFullscreen":"Exited fullscreen","confirmDialogHeader":"Submit your answers","confirmDialogText":"This will submit your results, do you want to continue?","confirmDialogConfirmText":"Submit and see results"}}

SQL Server Installation

Description

Morteza Safar-Ali