-
Introduction To Databases 0/17
-
Why Do We Need A Database? 19 minLecture1.1
-
MySQL – Installed and Introduced (Mac OS X) 07 minLecture1.2
-
Setting up MySQL and the Workbench (Mac OS X) 17 minLecture1.3
-
MySQL Server and Workbench installed (Windows) 06 minLecture1.4
-
Entities And Attributes – Things And Stuff Which Describe Them 15 minLecture1.5
-
Identifying Entities Using Keys 13 minLecture1.6
-
The Entity Relationship (E-R) Model – Entities And Attributes 05 minLecture1.7
-
Relationships – What Connects Entities 05 minLecture1.8
-
Cardinality Of Relationships 09 minLecture1.9
-
The Entity Relationship (E-R) Model – Relationships 09 minLecture1.10
-
Mapping E-R Theory to the world of databases 09 minLecture1.11
-
Introducing The SELECT Statement Preview 13 minLecture1.12
-
Introducing The SELECT Statement 19 minLecture1.13
-
Quotes and NULLS – Avoid The Gotchas 11 minLecture1.14
-
Simple Examples 13 minLecture1.15
-
More Simple Examples 14 minLecture1.16
-
Using the Like Operator 13 minLecture1.17
-
Between, In and Not In 08 minLecture1.18
-
A Multi-Column Select 18 minLecture1.19
-
Working with Dates (MySQL As Example) 10 minLecture1.20
-
-
Creating Tables And Inserting Data Into Them 0/8
-
Creating Database, Use Database and Create Table 14 minLecture2.1
-
Column Subtleties: Null, Primary Key and Auto-Increment 14 minLecture2.2
-
An Example – Sales Data 12 minLecture2.3
-
Insert Table – Examples 19 minLecture2.4
-
More Insert Table Examples 09 minLecture2.5
-
Referential Integrity Introduced 19 minLecture2.6
-
Creating a Database and Using It 17 minLecture2.7
-
An Involved Bulk Loading Example 14 minLecture2.8
-
-
Back To Retrieving Data - More Advanced Queries Using Group By 0/7
-
Aggregation Operators Introduced 18 minLecture3.1
-
The Group By Clause 17 minLecture3.2
-
More Group By Examples 17 minLecture3.3
-
Order By 16 minLecture3.4
-
Having 16 minLecture3.5
-
Limit 07 minLecture3.6
-
Count and Count Distinct 08 minLecture3.7
-
-
Joins - Don't Let Them Intimidate You! They're All Fuzzy And Nice 0/5
-
Introduction To SQL Joins Preview 09 minLecture4.1
-
Cross Joins aka Cartesian Joins 17 minLecture4.2
-
Inner Joins 19 minLecture4.3
-
Left Outer Joins 15 minLecture4.4
-
Right, Full Outer Joins, Natural Joins, Self Joins 16 minLecture4.5
-
-
Subqueries: Layering The Cake 0/6
-
Subqueries Introduced 07 minLecture5.1
-
Union, Union All, Intersect and Except 19 minLecture5.2
-
Query-In-A-Query 13 minLecture5.3
-
Inserting Via Subqueries 09 minLecture5.4
-
Use A Subquery To Populate A Table 06 minLecture5.5
-
Outer Join And Inner Join: A Little Test 08 minLecture5.6
-
-
Constraints 0/5
-
Not NULL constraints 10 minLecture6.1
-
Primary Keys 09 minLecture6.2
-
Foreign Key Constraints 13 minLecture6.3
-
Deletes and Updates With Foreign Key Constraints 12 minLecture6.4
-
Check Constraints 01 minLecture6.5
-
-
Somewhat More Advanced Concepts 0/7
-
Indices 16 minLecture7.1
-
Stored Procedures 10 minLecture7.2
-
Triggers 11 minLecture7.3
-
Transactions 13 minLecture7.4
-
Handle with Care: Update and Delete 13 minLecture7.5
-
Handle with Care: Alter and Drop 12 minLecture7.6
-
Views, Temporary Tables, and User Priviliges 05 minLecture7.7
-
-
Table Design: Theory And Practice 0/3
-
Practical Tips for Table Designs that you won’t regret! 30 minLecture8.1
-
More Practical Design Tips 30 minLecture8.2
-
Normal Forms – Friends Once You Know Them 30 minLecture8.3
-
-
Putting It Together: Database Programming In Python 0/5
-
Interfacing with Databases from Python 06 minLecture9.1
-
SQLite works right out of the box 06 minLecture9.2
-
Build a database of Stock Movements – I 15 minLecture9.3
-
Build a database of Stock Movements – II 13 minLecture9.4
-
Build a database of Stock Movements – III 13 minLecture9.5
-
-
Appendix 0/1
-
[For Linux/Mac OS Shell Newbies] Path and other Environment Variables 08 minLecture10.1
-
This content is protected, please login and enroll course to view this content!
Prev
The Group By Clause
Next
Order By