Programming with SQL
Course Code - MC-104 Duration - 3 Days
SQL is the industry standard language used to manipulate and retrieve data from relational databases. This course provides an overview of what a relational database is and describes the origins of SQL and the significant role it plays in the relational database arena. The course will teach delegates how to use SQL to create and maintain relational databases.
- Writing SQL queries
- Adding, removing and updating data in a relational database
- Performance implications when writing queries
- Writing efficient SQL scripts
Throughout this course, hands-on exercises will give delegates the opportunity to practice SQL. The exercises provided cover all components of the language providing experience in using joins, sub-queries and other complex queries to maximise system performance.
Two standards organisations;
- the American National Standards Institute (ANSI) and
- the International Standards Organisation (ISO), currently promote SQL standards to industry. The ANSI-92 SQL standard is used throughout this course although some common extensions to the standard are also discussed.
Who Should Attend
This course is valuable for developers, database analysts and designers who are or will be developing applications using SQL.
Attendance on the course 'Relational Database Design' ('MC-101') would be useful, though not essential. Prior knowledge of SQL is not required.
Introduction to Relational Databases
- What is a Database?
- What is a Database Management System?
- What is a Relational Database
- Management System?
- Relational Database Components
- Relations, Columns, Rows, Primary and Foreign Keys
- Organising data into Tables
Structured Query Language
- What is SQL?
- Main components of SQL
- The power of SQL
Data Manipulation Language
- SELECT Statement
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- WHERE Clause
- Expressions and Conditions
- ORDER BY Clause
- Aggregate, Character, Numeric, Date
- Inner, Outer, Self, Cartesian Product
- Simple and Correlated
- GROUP BY and HAVING Clauses Data Definition Language
- Creating and removing Tables
- Primary and Foreign Keys
- Referential Integrity
- Creating and removing Views
- Restricted Row View
- Restricted Column View
- Join View
- Creating and Removing Indexes
Data Control Language
- Granting and Revoking Privileges
- Manipulating Privileges via Roles
- Schemas and the Data Dictionary
- Designing Tables with performance in mind - Optimising SQL Queries
« Back to last page