SQL Fundamentals

CED Solutions
Marietta, Georgia, 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:(770) 937-0140

School Address:

CED Solutions
1640 Powers Ferry Road
Building 5, Suite 100
Marietta, GA 30067


Jobs & Resumes: Marietta
Houses & Roommates: Marietta

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: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.