This is a 1 day overview of the features that SQL Server and MySQL provides, and how to design, create, query and manipulate data as well as tools and some basic administration.

ON COMPLETION

  • Identify and know what tools to use with SQL Server and MySQL
  • Understand how to perform performance analysis
  • Create and simple and complex SQL statements with joins and aggregates
  • Understand what transactions are and how to use them
  • Understand what views, temporary tables and stored procedures are and where to use them
  • Work with database design commands to create databases, tables and indexes
  • Understand constraints and triggers
  • Understand how a database handles security
  • Be able to perform a back up and restore

WHO SHOULD ATTEND?

Anyone who wants a very quick introduction to SQL Server and/or MySQL

COURSE WORK

Since this is a 1 day course the main focus is to impart useful information with examples and demonstrations. There are some exercises included if time allows.

PRE-REQUISITS

None, although this is a fast pace course, so having used Access or another database will be of benefit

DURATION: 1 DAYS

PRICE: Call for latest

1st Day: Start 9:00am - Finish 5:00pm

COURSE CONTENT

Tools

Specific tools made by the manufacturers of SQL Server and MySQL and some generic tools

Introduction To SQL

The SELECT statement and querying tables, joining tables together to query data from a relationship, sub-queries and aggregate data

More SQL

What are views and where to use them, temporary tables the types and what they are used for, what are transactions and when to use them, programmatic SQL through stored procedures

Database Design

Create and manage tables, working with indexes and knowing when to apply them, adding constraints to prevent accidental data entry, and triggering events when a change occurs

Database Administration

Create and manage databases, manage security and roles for users, backing up and restoring database design and data