Introduction to SQL (Beginner) (老虎机游戏) | 老虎机游戏
About this class
SQL is a powerful but simple programming language used to communicate with databases and a standard across most online applications. Knowing SQL allows you to gather, analyze and process data from any database you have access to.
This online class is meant for beginners. You’ll learn basic SQL queries needed to collect data from a database, even if it lives in different places and analyze the data to find the answers you’re looking for.
This class is for absolute beginners. If you already know some SQL, it may be too slow for you – check out our Intro to SQL (Intermediate) course.
Chart your own career path. Pick up where this workshop leaves off. Learn the fundamentals of data tools like Excel, SQL, and Tableau in 10 weeks in our part-time, on-campus Data Analytics course or online in our mentor-driven Data Analysis Circuit.
Takeaways
- Background on SQL
- Understanding data & Databases
- Basic SELECT-FROM-WHERE statements
- Math operations and constant expressions in SELECT statements
- Pattern matching in the WHERE clause
- Time permitting, additional basic functions and statements (SUM, AVG, LIMIT, COUNT, LIKE, DISTINCT, etc.)
Prereqs & Preparation
- This class is live and is taken completely online.
- We will provide login information and a link to the platform on the day of each session.
- Please download DB Browser for SQLite beforehand to follow along with the in-class examples and practice questions.
- You will need a computer, a strong internet connection, and an open mind to join.
- This class is taking place in Eastern Time.
