SQL Server Fundamentals

$149.00

SKU: 411572

Description

Learn how to manage large data using your SQL server.
In todays 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: 2024-08-22 Start Time: 1:00 PM ET End Time: 2:05 PM ET

Learning Objectives

* You will be able to define tables in your SQL server.

* You will be able to describe how to navigate the database objects of your SQL server.

* You will be able to discuss how to set up and manage users in your SQL server.

* You will be able to explain how to create queries and views in your SQL server.

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

CPE ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Tom Fragale-The PC Guy, Inc.