Training Course:SQL FundamentalsSchool/Trainer:CED Solutions - Portland
Beaverton, Oregon, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Upon successful completion of this course, students will be able to:
Understand the concepts of databases and SQL.
Write SQL queries using the SELECT and FROM statements.
Calculate data using aggregate functions, column aliases, and mathematical operators.
Use the WHERE clause to select specific rows.
Use the LIKE keyword, wildcards, logical operators, and NULLs.
Use clauses that group data.
Create multi-table queries by joining tables.
Use other SQL front-end applications.
Course Outline
Lesson 1: Introduction to databases and SQL
Database concepts
Understanding SQL concepts
The SQL environment
Instructor demonstration
Lesson 2: Introduction to the SELECT statement
An overview of the SELECT statement
Using SELECT/FROM
Lesson 3: Calculating data
Aggregate functions
Column aliases
Performing calculations
Lesson 4: Selecting specific rows
The WHERE clause
Date functions
The ORDER BY clause
Lesson 5: Working with other operators
Condition operators
Logical operators
NULLs
Lesson 6: Grouping data
The GROUP BY clause
The HAVING clause
Comparing the WHERE and HAVING clauses
Lesson 7: Multi-table queries
Joins
Joining tables
Outer joins
Putting it all together
Lesson 8: Other SQL front-end applications
Q+E
Access 1.1
...''
Please go to the school's official website for training price and schedule:
http://www.cedsolutions.com
Phone:(800) 611-1840
School Address:
CED Solutions
c/o Courtyard Portland Beaverton Marriott 8500 S W Nimbus Drive
Beaverton, Oregon 97008
503-641-3200
Jobs & Resumes: Beaverton
Houses & Roommates: Beaverton
Other training courses offered by CED Solutions - Portland:
CompTIA Security+ Certification Boot Camp
Microsoft Project
CompTIA Project+
Access 2007
ACT! 2005
MCDBA Windows 2003 Certification Boot Camp
MCITP: Business Intelligence Developer Certification Boot Camp
MCITP: SQL 2005 Database Administrator Boot Camp
MCITP: SQL 2005 Database Developer Boot Camp
MCTS: SQL Server 2005 Boot Camp
Visual Basic 6.0
Adobe Acrobat 7.0
FrameMaker 7.0
Illustrator CS2
InDesign CS2
PageMaker 7.0
Photoshop CS2
Fireworks
Flash
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.
Tips:
Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results. |
|
| 
