SQL 1-Day Fundamentals Workshop

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL fundamentals, you can slice and dice that data any way you want, providing critical insights that drive business strategy.

This 6-hourSQL 1-Day Workshop is the beginner level interactive way to get started on data analysis and handling. You will dive head first into SQL, skill up with exercises, and by the end of the day you'll write queries with confidence and distill insights from real-world data.

Takeaways

• Describe a relational database.
  
• Illustrate the structure of a database using an entity relationship diagram.
• Explore the anatomy of a SQL server.
• Write queries to retrieve data from a SQL database (e.g., Microsoft SQL Server, etc.).
• Sort and segment SQL query results to generate insights.
• Combine data from multiple tables in complex queries.

Preparation

A basic technical aptitude, orientation to computers, and curiosity to learn new tools will make you successful in this bootcamp. No prior knowledge of SQL is required.

Prior to class:

• Download the PG Admin and watch this Introduction to SQL video before your workshop starts.
• Download the DB Browser that is compatible with your operating system.

Regulatory Information:

General Assembly’s workshops are for recreational purposes and are not regulated by the Bureau of Proprietary School Supervision.