Learn SQL and Databases from beginners to advanced level and grab this exclusive opportunity to understand how to deal with complicated data sets.
This course will teach you about how you can fit the data into an Excel spreadsheet as you not only use Excel as a basic tool of decision making and modeling. Data set is not too large or complicated you will easily learn about concepts which you have earlier found to be difficult to understand like
- Joins
- Aggregate Operators
- Interfacing with databases from programming
Layout of this course will be:
- Introduction To Databases
- Creating Tables And Inserting Data Into Them
- Back To Retrieving Data – More Advanced Queries Using Group By
- Joins – Don’t Let Them Intimidate You! They’re All Fuzzy And Nice
- Subqueries: Layering The Cake
- Constraints
- Somewhat More Advanced Concepts
- Table Design: Theory And Practice
- Putting It Together: Database Programming In Python
- Appendix
The following has been covered in this course in detail:
- SQL in Great Depth
- Database Fundamentals and Just Enough Theory
- Queries in MySQL and SQLite
- Code in Python
Any data analysts, businessmen, executives trying to make their data-driven decisions, willing to learn technical knowledge, Computer Science and Engineering students, Software Engineers and you would just need basic knowledge of Python if you want to read the source code.
Some exceptional benefits associated with this course enrollment are:
- Gaining knowledge from a group of the instructor having high-end experience in such topics
- Quality course material on SQL and Databases
- Lifetime access to the course
- Instant & free course updates
- Access to all Questions & Answers initiated by other students as well
- Personalized support from the instructor’s end on any issue related to the course
- Few free lectures for a quick overview
Don’t miss on this unique opportunity and enroll today itself!!
Curriculum
- 10 Sections
- 67 Lessons
- 52 Weeks
- Introduction To Databases20
- 2.1Why Do We Need A Database?19 Minutes
- 2.1Introducing The SELECT Statement Preview13 Minutes
- 2.1A Multi-Column Select18 Minutes
- 2.1Between, In and Not In8 Minutes
- 2.1Using the Like Operator13 Minutes
- 2.1More Simple Examples14 Minutes
- 2.1Simple Examples13 Minutes
- 2.1Quotes and NULLS – Avoid The Gotchas11 Minutes
- 2.1Introducing The SELECT Statement19 Minutes
- 2.1Mapping E-R Theory to the world of databases9 Minutes
- 2.1MySQL – Installed and Introduced (Mac OS X)7 Minutes
- 2.1The Entity Relationship (E-R) Model – Relationships9 Minutes
- 2.1Cardinality Of Relationships9 Minutes
- 2.1Relationships – What Connects Entities5 Minutes
- 2.1The Entity Relationship (E-R) Model – Entities And Attributes5 Minutes
- 2.1Identifying Entities Using Keys13 Minutes
- 2.1Entities And Attributes – Things And Stuff Which Describe Them15 Minutes
- 2.1MySQL Server and Workbench installed (Windows)6 Minutes
- 2.1Setting up MySQL and the Workbench (Mac OS X)17 Minutes
- 2.1Working with Dates (MySQL As Example)10 Minutes
- Creating Tables And Inserting Data Into Them8
- 3.1Creating Database, Use Database and Create Table14 Minutes
- 3.1Column Subtleties: Null, Primary Key and Auto-Increment14 Minutes
- 3.1An Example – Sales Data12 Minutes
- 3.1Insert Table – Examples19 Minutes
- 3.1More Insert Table Examples9 Minutes
- 3.1Referential Integrity Introduced19 Minutes
- 3.1Creating a Database and Using It17 Minutes
- 3.1An Involved Bulk Loading Example14 Minutes
- Back To Retrieving Data - More Advanced Queries Using Group By7
- Joins - Don't Let Them Intimidate You! They're All Fuzzy And Nice5
- Subqueries: Layering The Cake6
- Constraints5
- Somewhat More Advanced Concepts7
- Table Design: Theory And Practice3
- Putting It Together: Database Programming In Python5
- Appendix1
An ex-Google, Stanford and Flipkart team
Loonycorn is a team by Janani Ravi and Vitthal Srinivasan, product of Stanford University and IIM Ahmedabad.
We hold several years of working experience in the field of technology in Bay Area, New York, Singapore and Bangalore.
Janani Ravi: 7 Years of work experience (Google, Flipkart and Microsoft)
Vitthal Srinivasan: Worked at Google, Flipkart, Credit Suisse and INSEAD
We have come together to teach and educate on various technological courses in the most easiest and entertaining manner. Also, our courses will be based on practical elaborations & illustrations.
Courses you might be interested in
-
15 Lessons
-
10 Lessons
-
13 Lessons
-
39 Lessons