Home >
SQL Server >
SQL Server: SQL (DML) Fundamentals
SQL Server: SQL (DML) Fundamentals
| Course Code: |
SQSSQF |
| Duration: |
2 days |
| Audience: |
Developers: SQL and Transact-SQL. |
| Prerequisites: |
Windows operating system literacy. |
| Summary: |
This developer-oriented presentation uses mainly examples to
elaborate on the following SQL features:
- Data retrieval - SELECT statement
- Data aggregation (e.g., AVG, COUNT(*), MAX, MIN, SUM)
- Joins (INNER & OUTER)
- Data modification - INSERT, UPDATE, DELETE
|
| Objectives: |
Upon completion of this presentation, the participant should
have a working knowledge of the topics outlined under 'Core
Topics' in the detailed outline.
|
Detailed Outline |
|