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.
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.
Agenda
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
Speakers
Tom Fragale,
The PC Guy, Inc.- Computer professional with over 30 years of professional experience
- Microsoft® Certified Trainer, Microsoft® Certified Office Master, Microsoft® Certified Expert in Word® and Excel®, and a Microsoft® Certified Specialist in Access®, Outlook®, and PowerPoint®
- Trained over 30,000 business people in online webinars, public seminars, and onsite training
- Clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, and retail
- Topics of expertise include Access®, Excel®, Word®, PowerPoint®, Outlook®, Crystal Reports, SQL Server, Visio®, QuickBooks®, and SharePoint®, among others
- His passion is training people and helping people get the most out of their computers
- A published author, having written a book on Microsoft® Access®
- B.A. degree in computer science, LaSalle University
Who Should Attend
This live webinar is designed for business owners and managers, presidents, vice presidents, supervisors, associates, administrative professionals, sales and marketing professionals, accountants, and directors.