Learning sql programming exercise files download torrent

Register for your free account! Forgot your password? Recent Entries. Best Entries. Best Blogs. Search Blogs. Page 1 of 2. Attached Files. Working with Temporal Data 7. Dealing with Time Zones 7. Temporal Data Generation 7. String representations of temporal data 7. String-to-date conversions 7. Functions for generating dates 7. Temporal Data Manipulation 7. Temporal functions that return dates 7. Temporal functions that return strings 7. Temporal functions that return numbers 7.

Conversion Functions 7. Exercises 7. Grouping and Aggregates 8. Grouping Concepts 8. Aggregate Functions 8. Implicit Versus Explicit Groups 8. Counting Distinct Values 8. Using Expressions 8. How Nulls Are Handled 8. Generating Groups 8. Single-Column Grouping 8. Multi-Column Grouping 8. Grouping via Expressions 8. Generating Rollups 8. Group Filter Conditions 8. Exercises 8. Subqueries 9. What Is a Subquery? Subquery Types 9. Noncorrelated Subqueries 9.

Multiple-Row, Single-Column Subqueries 9. The in operator 9. The all operator 9. The any operator 9. Multicolumn Subqueries 9. Correlated Subqueries 9. The Exists Operator 9. Data Manipulation Using Correlated Subqueries 9.

When to Use Subqueries 9. Subqueries as Data Sources 9. Table fabrication 9. Task-oriented subqueries 9. Subqueries in Filter Conditions 9. Subqueries as Expression Generators 9. Subquery Wrap-up 9. Exercises 9. Joins Revisited Outer Joins Left Versus Right Outer Joins Three-Way Outer Joins Self Outer Joins Cross Joins Natural Joins Exercises Conditional Logic What Is Conditional Logic? The Case Expression Searched Case Expressions Simple Case Expressions Challenge: Playlist maker Opens a modal.

Challenge: The wordiest author Opens a modal. Who issues SQL queries? Challenge: Gradebook Opens a modal. Project: Data dig Opens a modal. Relational queries in SQL. Learn how to store related data in multiple tables and use joins to bring them together inner joins, outer joins, and self joins. Splitting data into related tables Opens a modal. JOINing related tables Opens a modal. Challenge: Bobby's Hobbies Opens a modal. Joining related tables with left outer joins Opens a modal.

Go at your pace and don't be afraid to spend time experimenting with the exercises before continuing! If you happen to be familiar with SQL already, you can skip ahead using the links in the top-right, but we would recommend you work through the lessons anyways! By the end, we hope you will be able to have a strong foundation for using SQL in your own projects and beyond. Interactive Tutorial More Topics.

All Lessons.