SQL Fundamentals

CED Solutions - Los Angeles
Irvine, California, 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
...''

Phone:(800) 611-1840

School Address:

CED Solutions
c/o Irvine Marriot
18000 Von Karman Ave
Irvine, CA 92612
949-553-0100

Jobs & Resumes: Irvine
Houses & Roommates: Irvine

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.