Databases and Analytics
Business Intelligence with Tableau
Connect, shape and visualize data to build dashboards people actually use.
Databases and Analytics
SQL and Database Fundamentals
Relational design and the SQL needed to query, join and maintain business data.
Course overview
SQL remains the common language of business data. This program teaches relational concepts and practical SQL that applies across Oracle, MySQL, SQL Server and PostgreSQL, with attention to writing queries that are correct and efficient.
What participants will learn
- Model data using tables, keys and relationships
- Write queries with filtering, joins, grouping and subqueries
- Insert, update and delete data safely with transactions
- Use indexes and read query plans at a basic level
Indicative outline
The final syllabus is agreed with each organization and can be adjusted to your requirements.
- 01
Relational concepts
- Tables and keys
- Normalization
- Entity relationships
- 02
Querying
- SELECT and WHERE
- Joins
- Aggregation and GROUP BY
- Subqueries and CTEs
- 03
Changing data
- INSERT, UPDATE, DELETE
- Transactions
- Constraints
- 04
Performance basics
- Indexes
- Query plans
- Views
Who it's for
- Developers
- Analysts and reporting teams
- Support engineers who investigate data issues
Prerequisites
- None
Related courses
- Software Engineering
Java Programming
Core Java, object-oriented design and the standard library for building reliable applications.
- Software Engineering
Python Programming
Readable, practical Python for scripting, automation and application development.
Planning SQL and Database Fundamentals for your team?
Share your team's size, experience and goals. We'll discuss how to adapt this program to your requirements.