SQL

SQL stands for Structured Query Language. It is a language used to manage data in a relational database. It allows you to query, manipulate, and define the data in a relational database. It has become a standard language, which means that the language the database uses will be based on SQL despite which relational database you use. This makes it a very versatile language and an important skill to have if you work with databases or data.

• 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

Full Course Details