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. |
|
|