#Databases

Book - Intermediate

Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) amazon.co.uk

The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database...

Book - Beginner

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) amazon.co.uk

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that...

Tutorial - Beginner

SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ... use-the-index-luke.com

Tutorial - Beginner

Programming Foundations: Databases linkedin.com

Relational databases

Keys and unique values

Planning a database

Creating tables

Defining relationships

Normalization and denormalization

Writing queries

Sorting results

Joining tables

Modifying data

Tutorial - Beginner

Become a Data Analyst Learning Path | LinkedIn Learning, formerly Lynda.com linkedin.com

Data analysts examine information using data analysis tools and help their teams develop insights and business strategies. You’ll need skills in math, statistics, communications, and working with tools designed to do data analytics and data visualization. Explore this high-demand career.

Video Tutorial - Beginner

Intro to Database Systems (Fall 2019) youtube.com

This course is on the design and implementation of database management systems. Topics include data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexing (order preserving...

Video Tutorial - Advanced

Advanced Database Systems (Spring 2020) youtube.com

This course is a comprehensive study of the internals of modern database management systems. It will cover the core concepts and fundamentals of the components that are used in both high-performance transaction processing systems (OLTP) and large-scale analytical systems (OLAP). The class will...

Video Tutorial - Beginner

SQL Tutorial - Full Database Course for Beginners youtube.com

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Throughout the course we'll be looking at various...