agoldminer的博客

1. Selecting ColumnsWelcome to the course!Onboarding | TablesOnboarding | Query ResultOnboarding | ErrorsOnboarding | Bullet ExercisesBeginning your SQL JourneySELECTing Single ColumnsSELECTin...

Introduction to JoinsIntroduction to INNER JOINInner JoinInner Join (2)Inner Join (3)Inner Join (4)INNER JOIN via USINGReview Inner Join Using ONInner Join with UsingSelfish Joins, just in CA...

SQL-DataCamp-Intermediate SQL1. We’ll take the CASE1.1 We’l take the CASE1.2 Basic CASE statements1.3 CASE statements comparing column values1. 4 CASE statements comparing two column values part ...

1. What’s in the DatabaseWhat’s in the databaseExplore tables sizesCount missing valuesJoin tablesThe keys to the databaseForeign keysRead and entity relationship diagramCoalesceCoalesce with...

1. Revenue, Cost, and ProfitRevenueRevenue per customerRevenue per weekCost and Common Table Expressions (CTEs)Total costTop meals by costUsing CTEsProfitProfit per eateryProfit per month2....

1. Introduction to Business Intelligence for a Online Movie Rental DatabaseIntroduction to data driven decision makingExploring the databaseExploring the table rentingFiltering and orderingWorkin...

1. Use Real-World SQLEssential SQLReview the essentialsPractice the essentialsTransforming your resultsTransforming numeric & stringsExtract what you needWorking with aggregate functionsAg...