Learn to Code Special! | 30% off ALL ACCESS to One Month ๐ŸŽ‰๐ŸŽ‰๐ŸŽ‰

Hide

Welcome to Learn SQL at One Month!

Week 1: Learn SQL in One Month ยท Lesson 1 ยท


Hi ๐Ÿ‘‹! My name is Chris Castiglione, and I'm going to be your instructor for this One Month course! In addition to being a teacher at One Month, I'm an adjunct professor at Columbia Business School where I teach Digital Literacy. In this course, you are going to learn the fundamentals of SQL: how to create a SQL database from scratch, how to use SQL commands, how to fetch data from the database, write data to the database, edit data in the database as well as how to delete data from the database.

In One Month SQL we’ll cover everything you need to be proficient enough to comfortably use SQL in your applications or in performing data analysis. And the good news is, there are hardly any prerequisites to get started—you don’t have to have previous coding skills, you just need a computer and I’ll help you get your first database up and running.

In this course you'll learn

  1. How to setup a SQL Database
  2. Why and when it’s best to use SQL
  3. How to import and export large datasets
  4. Over 20 of the basic SQL Commands including SQL SELECT, WHERE, ORDER BY, JOIN and many more! 
  5. How to create a new database and tables from scratch