Databases Research & Exercises SQL Basic Concepts Filtering, Functions, Subqueries JOIN, Table Operations Introduction to Databases The WHERE Statement Joining Tables SQL Statements: SELECT Filtering with AND, OR Types of Join SQL Syntax Rules IN, NOT IN Statements UNION Selecting Multiple Columns Custom Columns The INSERT Statement DISTINCT and LIMIT Functions UPDATE and DELETE Statements Sorting Results Subqueries Creating a Table Module 1 Quiz LIKE and MIN NOT NULL and AUTO_INCREMENT Demo: Cakes Module 2 Quiz Alter, Drp, Rename a Table Demo: Apartments Views Module 3 Quiz Challenges Demo: Zoo Databases by Stanford University on edX Relational Databases and SQL OLAP and Recursion Semistructured Data Modeling and Theory Advanced Topics in SQL Introduction and Relational Databases On-Line Analytical Processing XML Data Introduction and Relational Databases Indexes and Transactions SQL Recursion JSON Data Relational Algebra Constraints and Triggers Querying XML with XPath and XQuery Relational Design Theory Views and Authorization Querying XML with XSLT Unified Modeling Language DataCamp Career Track: Data Analyst with SQL Server 01. Introduction to SQL Server 02. Introduction to Relational Databases in SQL* 03. Intermediate SQL Server 04. Time Series Analysis in SQL Server 05. Functions for Manipulating Data in SQL Server* 06. Database Design 07. Hierarchical and Recursive Queries in SQL Server 08. Transactions and Error Handling in SQL Server 09. Writing Functions and Stored Procedures in SQL Server 10. Building and Optimizing Triggers in SQL Server 11. Improving Query Performance in SQL Server Introduction to Using MongoDB for Data Science in Python 01. Flexibly Structured Data.py 02. Working with Distinct Values and Sets.py 03. Get Only What You Need, and Fast.py 04. Aggregation Pipelines: Let the Server Do It For You.py