When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

SQL for Beginners - A Data Analyst Path

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
SQL for Beginners - A Data Analyst Path

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon1 hours 17 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About SQL for Beginners - A Data Analyst Path

Introduction

Class Project

Day 1 - What is SQL?

Day 2 - Install SQLite (Mac & Windows)

Day 2 - Create a Table

Day 3 - Managing Tables

Day 4 - Select, Order, and Filter

Day 5 - Wildcards and NULL Filter

Day 6 - Between, And, and Or

Day 7 - Limit and Case Statements

Day 8 - Aggregate Functions

Day 9 - Aggregate Functions With Grouping

Day 10 - Inner Join Tables

Day 11 - Left Join Tables

Day 12 - Cross Join Tables

Day 13 - Temporary Tables

Day 14 - Conclusion

What You Will Learn?

  • What is this class about?.
  • You're in the right place if you're looking to learn how to turn data into insightful real-world solutions. SQL is the most popular programming language used to manage and explore data stored in databases. It is a vital tool in any Data Analyst toolkit..
  • In this class, you'll learn how to use SQL from scratch. We'll download the tools we need to start off by creating our own database and filling it with data and then we'll explore it using SQL queries. This class is the perfect place for you if you're curious about data, how it's stored, and how to explore it..
  • What will I learn in this class?.
  • Throughout this class, you will learn how to use SQL to create and explore tables with data on your own local database. In this class we'll cover the following:.
  • Why should I take this class?.
  • Knowing how to work with data is one of the most valuable skills nowadays. That means that learning how to manage and explore data will give you an advantage in this data-filled world that we live in. This course will teach you the things you need to know to start using SQL to manage databases and explore them to get the data you want..
  • Who is this class for?.
  • This class is meant for absolute beginners; anyone who has no idea what SQL or a database is. It's the perfect place to start learning about data and getting your hands dirty with one of the most popular languages used to access and explore databases. This course is also meant for anyone who's already familiar with SQL but is looking for a structured refresher..
  • Supporting Material:.
  • * See the project section for supporting material..