Description
Learn how to manage large data using your SQL server.
In today’s world, we are all flooded with huge amounts of data. If you are part of the IT team, it may be your responsibility to manage your SQL server. There are many moving parts to setting up and managing the SQL server. This information will show you exactly how to manage some of the more important aspects of setting up and managing your SQL server to help you and others effectively manage that huge amount of data.
Date: 2020-03-06 Start Time: End Time:
Learning Objectives
Creating and Managing Databases
• Create a Database
• Changing the Properties for a Database
Creating and Managing Tables
• Creating a Table From Scratch
• Going Into Design View
• Making a Field a Primary Key
• Importing Data From Many Sources
Creating and Managing Queries
• Creating SQL Queries
• Running the Query
• Saving a Query
• Running a Saved Query
• Making a Query Into a More Permanent View
User Permissions
• Setting up Permissions for the Server
• Setting up Permissions for the Database
• Setting up Permissions for the Table
Tom Fragale-The PC Guy, Inc.
