EE 9: Easing Database Maintenance with SQL Server Management Studio®
Program Level: Beginner
Whether you’re an Azure Cloud customer or on-prem web, understanding your Prophet 21 database is crucial to your success. In this course, we’ll start at the beginning. What is a database? Learn how to do a backup and restore of your Prophet 21 system. Practice some simple SELECT statements, and JOINs.
Cost: There is an additional $350 fee to attend this session.
Objectives:
♦ Register Servers
♦ Navigate through several sections of the Object Explorer
♦ Create, Backup, and Restore a database
♦ Write basic SELECT statements in a Query Window
♦ Create and Alter Views
♦ Understand JOINs and create SQL statements using INNER JOIN
Audience:
♦ System Administrators
♦ Database Administrators
Prerequisites:
♦ Basic understanding of SQL Server Management Studio®
♦ Knowledge of Prophet 21 application