Download appDownload App

From 0 To 1 SQL And Databases Heavy Lifting

Data has become a crucial part of almost all business, regardless they belong to the computing world or not. Anyone who requires using excel to map or track their data, can definitely benefit from lea...

  • All levels
  • English

Course Description

Data has become a crucial part of almost all business, regardless they belong to the computing world or not. Anyone who requires using excel to map or track their data, can definitely benefit from learning about databases and SQL. Data is often found in large quantities, where it is difficult to manage, sort and analyze, and this is where databases come quite handy. When we hear databases, we o...

Data has become a crucial part of almost all business, regardless they belong to the computing world or not. Anyone who requires using excel to map or track their data, can definitely benefit from learning about databases and SQL. Data is often found in large quantities, where it is difficult to manage, sort and analyze, and this is where databases come quite handy. When we hear databases, we often think about systems that can store large amounts of data, but they can do so much more than that.

What you’ll learn
  • How to map the real world to a database.
  • Figure out the bridge between the real world entities and relational tables in a database using the entity relational model
  • How to query data to get the results
  • Learn SQL in detail, including basic concepts such as select from where, which allows you to retrieve data.
  • We will also cover more advanced concepts such as group-by, having, count, distinct alter table and drop, constraints, trigger, etc.
  • How to connect two tables and conduct queries using JOIN

Covering Topics

1
Section 1 : Introduction To Databases
2
Section 2 : Going From Relations To Database Tables
3
Section 3 : Creating Tables And Inserting Data Into Them
4
Section 4 : Back To Retrieving Data - More Advanced Queries Using Group By
5
Section 5 : Joins - Don't Let Them Intimidate You! Theyre All Fuzzy And Nice
6
Section 6 : Subqueries-Layering The Cake 6 Lectures
7
Section 7 : Constraints
8
Section 8 : Somewhat More Advanced Concepts
9
Section 9 : Table Design: Theory And Practice
10
Section 10 : Putting It Together: Database Programming In Python
11
Section 11 : Appendix

Curriculum

      Section 1 : Introduction To Databases
1
Data Is A Big Deal
2
Why Do We Need A Database? Preview
3
MySQL - Installed and Introduced (Mac OS X)
4
Setting up MySQL and the Workbench (Mac OS X)
5
MySQL Server and Workbench installed (Windows)
6
Entities And Attributes - Things And Stuff Which Describe Them
7
Identifying Entities Using Keys Preview
8
The Entity Relationship (E-R) Model - Entities And Attributes
9
Relationships - What Connects Entities
10
Cardinality Of Relationships Preview
11
The Entity Relationship (E-R) Model - Relationships
12
Mapping E-R Theory to the world of databases
      Section 2 : Going From Relations To Database Tables
13
Introducing The SELECT Statement
14
Columns Have Data Types
15
Quotes and NULLS - Avoid The Gotchas
16
Simple Examples Preview
17
More Simple Examples
18
Using the Like Operator
19
Between,In and Not In Preview
20
A Multi-Column Select
21
Working with Dates (MySQL As Example)
      Section 3 : Creating Tables And Inserting Data Into Them
22
Creating Database Use Database and Create Table
23
Column Subtleties: Null Primary Key and Auto-Increment
24
An Example - Sales Data Preview
25
Insert Table - Examples
26
More Insert Table Examples
27
Referential Integrity Introduced Preview
28
Creating a Database and Using It
29
An Involved Bulk Loading Example
      Section 4 : Back To Retrieving Data - More Advanced Queries Using Group By
30
Aggregation Operators Introduced
31
The Group By Clause
32
More Group By Examples Preview
33
Order By
34
Having
35
Limit
36
Count and Count Distinct
      Section 5 : Joins - Don't Let Them Intimidate You! Theyre All Fuzzy And Nice
37
Introduction To SQL Joins
38
Cross Joins aka Cartesian Joins
39
Inner Joins
40
Left Outer Joins
41
Right, Full Outer Joins, Natural Joins Self Joins
      Section 6 : Subqueries-Layering The Cake 6 Lectures
42
Subqueries Introduced
43
Union Union All Intersect and Except. Preview
44
Query-In-A-Query
45
Inserting Via Subqueries
46
Use A Subquery To Populate A Table
47
Outer Join And Inner Join: A Little Test
      Section 7 : Constraints
48
Not NULL constraints
49
Primary Keys
50
Foreign Key Constraints
51
Deletes and Updates With Foreign Key Constraints
52
Check Constraints
      Section 8 : Somewhat More Advanced Concepts
53
Indices
54
Stored Procedures
55
Triggers
56
Transactions
57
Handle with Care: Update and Delete
58
Handle with Care: Alter and Drop
59
Views ,Temporary Tables, and User Priviliges
      Section 9 : Table Design: Theory And Practice
60
Practical Tips for Table Designs that you won t regret!
61
More Practical Design Tips
62
Normal Forms - Friends Once You Know Them
      Section 10 : Putting It Together: Database Programming In Python
63
Interfacing with Databases from Python
64
SQLite works right out of the box
65
Build a database of Stock Movements - I
66
Build a database of Stock Movements - II
67
Build a database of Stock Movements - III
      Section 11 : Appendix
68
For Linux/Mac OS Shell Newbies Path and other Environment Variables

Frequently Asked Questions

It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.

A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.

A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.

We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.