Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC

Gentle Introduction to Non Programmers on SQL for Analytics. 1 day Bootcamp Course Begineers Hands-on. Project: New York
4.43 (1760 reviews)
Udemy
platform
English
language
Databases
category
instructor
Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC
39 551
students
1.5 hours
content
Feb 2019
last update
FREE
regular price

Why take this course?

🚀 Gentle Introduction to SQL for Analytics: A Bootcamp for Non Programmers 🌆

Welcome to the SQL 101 Bootcamp, tailored for beginners who aspire to master SQL for data analytics without prior programming experience. This one-day hands-on course, led by the experienced Shivgan Joshi, is designed to be a gentle yet comprehensive introduction to SQL, specifically optimized for those based in or interested in NYC's vibrant tech scene.

Why Take This Course? 🤔

  • Practical Skills for Real-World Applications: Learn to create a database design for your day-to-day work data that you currently manage in Excel.
  • Analytical Insights: Understand the capabilities and limitations of SQL for analytical tasks, making you more efficient in handling data.
  • Data Wrangling Mastery: Get hands-on experience with Group By, Joins, UNION, and other wrangling techniques to shape your data exactly as you need it.
  • Insights Across Data Types: Learn how new data types and tools can open up new insights in your analytics.
  • Excel Equivalents: Translate SQL commands into their Excel equivalents for a seamless transition between tools.
  • Common Data Wrangling Terminology: Gain understanding of common terms used across different programming languages, enhancing your data analytics communication skills.

Course Highlights:

  • 🗺️ Understanding SQL for Analytics: Discover why SQL is a must-have skill to overcome Excel's limitations.
  • 🛠️ SQL Server Database Interaction: Learn how to connect to and execute queries on a SQL Server database.
  • 🔍 Conditional Searching: Include search conditions in your queries to refine your data retrieval.
  • 📊 Data Calculations & Formatting: Utilize various functions for calculations and organize your results before display.
  • 🏙️ NYC Data Application: Apply your new skills using actual New York City datasets, providing real-world context and experience.

What You'll Learn:

  1. DB Design Basics: Create a database design tailored to your data needs.
  2. Analytical Capabilities: Understand the scope of what SQL can do for your analytical processes.
  3. Data Wrangling Techniques: Learn how to wrangle data using GROUP BY, JOINs, and UNION to get your data in the desired format.
  4. Insights from New Data: Discover how new data types can provide fresh insights.
  5. Excel & SQL Function Equivalents: Find out how SQL functions relate to Excel functions for seamless transitioning.
  6. Data Wrangling Terminology: Understand the common terms used in data analytics across various programming languages.
  7. Connecting to Databases: Learn how to connect to a SQL Server and execute a simple query.
  8. Query Conditions: Include search conditions in your queries to narrow down results.
  9. Calculations with SQL: Use SQL functions to perform calculations on your data.
  10. Data Organization: Organize the data obtained from a query for better visualization and analysis.
  11. Hands-On with NYC Data: Utilize New York City datasets in your hands-on learning experience.

Join Us for an Unforgettable Learning Experience! 📚 This Bootcamp is designed to be an immersive, one-day journey into the world of SQL. By the end of this course, you'll have a solid understanding of SQL and how it can be leveraged for data analytics, with a focus on practical application that will benefit your professional life immediately. Sign up today and transform the way you handle and analyze data! 🌟

Loading charts...

Related Topics

1913512
udemy ID
15/09/2018
course created date
16/05/2019
course indexed date
Bot
course submited by