- [Instructor] Okay.…Let's run SQL Server Management Studio.…And we need to create a database.…So right click on Database, New Database,…and then name the database as AppDb,…and keep all the default settings as it is.…Click okay.…The database is now created.…Now I'll execute some script to create the tables…and the stored procedures.…The script is in the exercise folder.…
Zero three, zero three.…We have two scripts.…Let me bring both of them here…in the query window.…The first script, zero one dot create tables…and stored procedures, this would be done first.…And after that we would run the second one.…One thing to note that if you give the database…name something other than AppDB, then you will…have to change the USE statement on top of the script.…So you have to change AppDB to whatever name…you have given to your database.…
Let's now run this to create the tables.…All right, all the tables…and stored procedures are created.…Next we need some data.…I have created some fictitious data,…some customer data then some order data.…
AuthorKazi Nasrat Ali
- Setting up a dev environment
- Front-end frameworks
- Templates: React.js, Angular.js, Vue.js, Aurelia.js
- NodeServices and Node.js
- Single-page application services
- Using HMR (Hot Module Replacement)
- Performing server-side prerendering
- Using node-chartist
- Creating a database, tables, and stored procedures
- Creating data models, controllers, and actions
- Adding React components and subcomponents
- Testing and publishing an app
Skill Level Intermediate
1. Exploring ASP.NET Core SPA Project Templates
3. Creating a React and ASP.NET Core App
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.