SQL

ExecuTrain
Alpharetta, Georgia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this course you will be introduced to the SQL language and how it can be used to query a database in order to answer business questions. Upon successful completion of this course you will be able to write and execute SQL queries including those that perform analysis and use functions, aliases, and calculations. You will also be able to search the database with precise search conditions and use Access to create a query.

Objectives:
After completing this course you will be able to explain basic database and SQL concepts, apply syntax rules, use Aggregate and Date functions, use various clauses, search for text, perform joins, query databases, and generate reports of the data.
Hardware and Software Required:
Browser Netscape Communicator 4.0
Browser Other: AOL 4.0
Operating System MacOS 8.5
Browser Microsoft Internet Explorer 4.0
Operating System MS-Windows 95

Table of Contents:

Introduction to Databases and SQL

Database Concepts

Understanding SQL Concepts

Introduction to the SELECT Statement

An Overview of the SELECT Statement

Syntax Rules You’ll Want to Know

Calculating Data

Aggregate Functions

Column Aliases

Performing Calculations

Date Functions

Selecting Specific Rows

The WHERE Clause

The ORDER BY Clause

Working with Other Operators

Searching for Text

Logical Operators

NULLs

Grouping Data

The GROUP BY Clause

The HAVING Clause

Comparing the WHERE and HAVING Clauses

Multi-table Queries

Joins

Joining Tables

Outer Joins

Querying a Database Using Access 97

Creating a Blank Database

Querying a Database

Generating a Report of the Data


...''

Phone:1-800-908-7246

School Address:



Jobs & Resumes: Alpharetta
Houses & Roommates: Alpharetta

Upgrading Web Development Skills from ASP to Microsoft ASP.NET
ADO.NET
Creating ASP.NET Web Applications
Microsoft Windows Server 2003 Active Directory and Network Infrastructure
Microsoft Networking Essentials
Visual Studio .NET
Developing XML Web Services Using Microsoft ASP.NET
Microsoft Expressions 2007
Microsoft Office 2004 for Macintosh
CompTIA Server+
Windows SharePoint Services Administration
Windows SharePoint Services Installation
CompTIA A+ Certification 2006
Internet Security and Acceleration (ISA) Server 2000 System Administration
Managing a Microsoft Windows Server 2003 Environment
Network + Certification
Security + Certification
MCSE
MCSA

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!