Training Course:SQL FundamentalsSchool/Trainer:Computer Training Center - South Bend
South Bend, Indiana, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This course is designed for anyone needing to query a database to access business questions.
Overview: This course is designed to teach the students to concepts of databases and SQL, through hands-on practice creating queries of various types and methods.
Topics covered include:
Introduction to Databases and SQL
Database Concepts
Understanding SQL Concepts
The SQL Environment
Instructor Demonstration
Introduction to the Select Statement
Overview of the SELECT Statement
Using SELECT/FROM
Calculating Data
Aggregate Functions
Column Aliases
Performing Calculations
Selecting Specific Rows
The WHERE Clause
Date Functions
The ORDER BY Clause
Working with Other Operators
Condition Operators
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
Putting it All Together
Querying a Database Using Access 97
Connecting to a Database
Querying a Database
Generating a Report of the Data
Prerequisites: The student should be familiar with personal computers, and have knowledge of basic database structures and terminology.
...''
Please go to the school's official website for training price and schedule:
http://www.comtrain.com/
Phone:574.287.1053
School Address:
St. Joseph: 2364 S. Cleveland Ave | St Joseph, MI 49085 | 269.983.3903
South Bend: 2750 Foundation Drive| South Bend, IN 46628 | 574.287.1053
Jobs & Resumes: South Bend
Houses & Roommates: South Bend
Other training courses offered by Computer Training Center - South Bend:
InDesign CS - Level I
InDesign CS - Level II
PageMaker 7.0
Microsoft Publisher 2003
QuarkXPress 6
Lotus Approach ME 9.5
Lotus Notes 6.0 - Database Features
Access 2007
Oracle 10g - Introduction
Relational Database
Oracle 9i
Oracle 8i - SQL, PL/SQL, and SQL*Plus
Illustrator CS
PageMill 3.0
Photoshop CS
CorelDRAW
ColdFusion MX
HTML
Paint Shop Pro 7.0
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:
We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa. |
|
|
