SQL Fundamentals

CED Solutions - Calgary
Calgary, Alberta, Canada

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:

Suite 107 Burns Building
237 - 8 Avenue SE
Calgary AB T2G 5C3
Canada

Jobs & Resumes: Calgary
Houses & Roommates: Calgary

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: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.