Course Content

Course Content


Click New on the File tab, and select Blank Database. In the File Name box, type a file name. Click Browse for a location to put your database (next to the File Name box) to change the file's location from the default. Browse to the new location, then click OK. Select Create from the drop-down menu.

Connect to the instance of Database Engine that contains the database to be changed in SSMS's Object Explorer. Expand the Databases node in Object Explorer, then expand the database that will contain the new table. Right-click your database's Tables node in Object Explorer, then select New Table.

Select SQL Server Services in the left pane of SQL Server Configuration Manager. Right-click SQL Server (MSSQLServer) or a specified instance in the results pane and choose Start, Stop, Pause, Resume, or Restart.

  • Oracle SQL Developer is available for download and installation. See Connect SQL Developer for further information.
  • Oracle SQL Developer must be configured.
  • Use Oracle SQL Developer to connect.
  • Use the create user statement to create a new user.
  • Give the new schema user particular permissions.
  • Check that the schema was created correctly.

As an administrator, open the MySQL Workbench (Right-click, Run as Admin). To construct the database schema, go to File>Create Schema. Click Apply after giving the schema a name. To perform the SQL command that creates the schema, click Apply in the Apply SQL Script to Database window.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere