SQL Reporting by Example

Focused View

Ben Deitch

56:02

101 View

01. Orientation_ Selecting Data

01_01-Introduction.mp4

01:28

01_02-Learning the Database.mp4

02:03

01_03-Listing Subjects.mp4

00:49

01_04-Counting Students.mp4

01:01

01_05-Finding the ID.mp4

00:43

01_06-Listing Teachers.mp4

01:08

01_07-A Students.mp4

01:43

02. Day 1_ Joining Tables

02_01-Calculating School Capacity.mp4

00:57

02_02-The Biggest Room.mp4

01:22

02_03-Subjects in the Big Room.mp4

02:13

02_04-8th Grade Teachers.mp4

02:48

02_05-7th Grade Science.mp4

01:57

02_06-Elective Teachers.mp4

02:53

03. Day 2_ Advanced Selecting

03_01-Student Schedule.mp4

03:24

03_02-A Smelly Issue.mp4

03:04

03_03-Students A to M.mp4

02:00

03_04-Students by Grade.mp4

01:32

03_05-Predicting the Future.mp4

02:47

04. Day 3_ Getting Good at Grouping

04_01-Busiest Teachers.mp4

02:12

04_02-MultiSubject Teachers.mp4

01:57

04_03-Janis Schedule.mp4

04:17

04_04-Least Popular Subject.mp4

02:39

04_05-Finding the Troublemaker.mp4

04:20

04_06-Most Popular Teacher.mp4

04:28

04_07-Bus Troubles.mp4

02:17

Description

About this Course

In this course you'll get lots of practice writing SQL queries in a realistic environment!

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Ben Deitch

Instructor's Courses

Ben is an Android teacher at Treehouse with a long history of creating and tinkering with Android apps. He's an avid learner, loves playing sports, and is a fairly average chef.

Treehouse

View courses Treehouse

Treehouse or is an online technology school that offers beginner to advanced courses in web design, web development, mobile development and game development. Its courses are aimed at beginners looking to learn computer coding skills for a career in the tech industry.