On the first day delegates will learn about the basic structure and history of relational databases. Delegates will then understand what SQL is and how it used with a relational database.
- Overview of Relational Database Concepts
- What is a relational database management system?
- Databases! Why do we need them?
- Relational Database Structures
- Brief overview of typical databases: Microsoft Access and SQL Server
- Introduction to SQL:
- Overview of SQL (Structured Query Language)
- Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
- Building a database
- Creating tables and columns
- Building tables with CREATE TABLE
- Altering tables with ALTER TABLE
- How to add columns to existing tables
- How to add a Primary Key
- How to add a Foreign Key
- Adding a Data Type to a Table
- How to improve performance with Indexes
- Selecting Data: The SELECT statement
- Setting Criteria using WHERE Clause
- Inserting into a Table: The INSERT Statement
- Updating a Table: The UPDATE Statement
- Modifying a Table structure with ALTER Statement
- Deleting from a Table: The DELETE Statement
- Removing a tables with DROP statement