From 0 To 1:SQL And Databases – Heavy Lifting

Your bodyguard for when data gets too big​, this course is strong but friendly, funny yet deep, animated yet thoughtful.

Created by: Loony Corn
An ex-Google, Stanford and Flipkart team

What Will I Learn?

• Explore large datasets and uncover insights - going far beyond the Excel, deep into the data
• Model and create a database for day-to-day use
• Interface with databases from a programming language such as Python
• Have the comfort and confidence needed to load data and use both GUI and a command line interface for database operations
• Fully understand and leverage joins, subqueries, aggregates, indices, triggers, stored procedures and other major database concepts

Requirements

• This course will cover generic (non-system-specific) SQL, but will also conduct exercises using 2 different database technologies: MySQL and SQLite. Installation and use of both these will be explained in-depth

Target audience

• Yep! Data analysts who would like to really get down and dirty with the data
• Yep! Business folks and executives looking to make their decision making more data-driven, and seeking the technical knowledge to do so.
• Yep! Students of Computer Science and Computer Engineering looking to understand database concepts for the first time
• Yep! Software engineers who need to understand and interface with databases from programming languages in their work