|
|
|
Overview: This course is designed to provide students with the solid understanding of database concepts and the essentials of the SQL language. Through a series of hands-on activities you will learn data selection and manipulation using multi-vendor compliant SQL syntax.
|
You will learn:- Basic concepts related to database terminology and structure
- Basic query statement - Select
- Joining tables with SQL
- Formatting and organizing results
- Manipulating data with insert, update, and delete statements
- Table indexes use for faster query execution
- Nested query writing
- Principals of referential integrity
|
Pre-Requisites: Basic PC skills |
|