SQL and Relational Databases 101
|
Get started with SQL and relational databases. Learn the fundamentals of SQL queries, database design, and how to work with relational databases to store, retrieve, and manage data for a variety of applications.
At a Glance
Are you ready to dive into the world of SQL and relational databases? In just a few hours, you’ll be able to discuss SQL basics and explain various aspects of the relational database model. Try our hands-on exercises as we guide your first steps into SQL and relational databases.
About This Course
Course Syllabus
- Module 1 -SQL and Relational Databases 101
- Introduction to SQL and Relational Databases
- Information and Data Models
- Types of Relationships
- Mapping Entities to Tables
- Relational Model Concepts
- Module 2 – Relational Model Constraints and Data Objects
- Relational Model Constraints Introduction
- Relational Model Constraints Advanced
- Module 3 – Data Definition Language (DDL) and Data Manipulation Language (DML)
- CREATE TABLE statement
- INSERT statement
- SELECT statement
- UPDATE and DELETE statements
- Module 4 – Advanced SQL
- String Patterns, Ranges, and Sets
- Sorting Result Sets
- Grouping Result Sets
- Module 5 – Working with multiple tables
- Join Overview
- Inner Join
- Outer Join
Recommended skills prior to taking this course
- None
User Reviews
Be the first to review “SQL and Relational Databases 101”
Related Products
Microsoft Access Masterclass
This Free Online Course Includes: 5-6 Hours of Learning CPD Accreditation Final Assessment
SQL Server 2014: Tour and Installing
This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment
A Beginner’s Guide to MongoDB
This Free Online Course Includes: 3-4 Hours of Learning CPD Accreditation Final Assessment
Microsoft Access 2013 – Advanced Master Databases
This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment
Diploma in Microsoft Office Access 2013 Intermediate
This Free Online Course Includes: 10-15 Hours of Learning CPD Accreditation Final Assessment
Data Documentation and Record Keeping for Organisational Excellence
This Free Online Course Includes: 1.5-3 Hours of Learning CPD Accreditation Final Assessment
There are no reviews yet.