Home 
Database Development
Database Development
Intoduction to SQL
You Will Learn How To
- Write SQL code based on ANSI/ISO standards to build and maintain database structures
- Update database content with SQL and transaction handling
- Retrieve data from single or multiple tables
- Process data with row and aggregate functions
- Manipulate data with correlated and non-correlated subqueries
- Apply views to break down problems and enhance security
Course Benefits
SQL forms the cornerstone of all relational database operations. The ability to write the SQL language is essential for those who develop database applications. This course provides a solid foundation of the SQL programming language that enables you to build, query and manipulate databases. Working in Oracle 10g or SQL Server throughout this course, you compare the ANSI/ISO standard with the SQL implementations of these two common database products. Who Should Attend
This course is valuable for anyone who needs to learn SQL programming. An understanding of relational database and basic programming concepts is helpful. Hands-On Training
In this course, you gain hands-on experience programming with SQL in Oracle Database 10g and Microsoft SQL Server 2005 environments. Exercises include: - Creating and modifying tables, constraints and indexes
- Modifying table contents
- Retrieving data from tables
- Joining multiple tables
- Applying row and aggregate functions
- Embedding subqueries within statements