Udemybeginneren

EssentialSQL: Get Started Learning SQL

Learn SQL! Master PostgreSQL, MySQL, SQL Server, Oracle & SQLite. Beginner-friendly crash course for interview prep. Write powerful database queries.

4.5(280)
8,322students
1h 15m
Kris Wenzel
Kris WenzelLet me teach you SQL using simple to understand English.

Course Content

EssentialSQL: Get Started Learning SQL is a beginner-level Udemy course taught by Kris Wenzel. It runs 1h 15m and is taught in English. Learners rate it 4.5 out of 5 from 280 reviews, with 8,322 students enrolled. It is free to enroll, last updated August 2023.

Get Started with SQL: A 7-Day Beginner's Course

Ready to learn SQL? This comprehensive 7-day course is designed to provide a solid foundation in SQL database fundamentals. We've structured it as a week-long learning experience, but feel free to progress at your own speed – it's designed for easy comprehension.

Here's a breakdown of what you'll master each day:

  • Day 1: SQL Basics & Queries

    • Introduction to SQL and relational databases.
    • Writing fundamental SQL queries using the SELECT statement.
    • Selecting specific columns and utilizing expressions within your queries.
    • Hands-on practice with guided SQL exercises.
  • Day 2: Data Filtering with WHERE Clause

    • Mastering data filtering using the WHERE clause.
    • Understanding comparison and logical operators in SQL.
    • Using the LIKE operator for pattern matching.
    • Reinforce your skills with practical SQL filtering exercises.
  • Day 3: Sorting Data with ORDER BY

    • Learn to sort data effectively using the ORDER BY clause.
    • Sorting data in ascending and descending order.
    • Sorting by multiple columns for advanced data organization.
    • Practice SQL sorting with targeted exercises.
  • Day 4: Data Manipulation (INSERT, UPDATE, DELETE)

    • Adding new data to tables with the INSERT statement.
    • Modifying existing data using the UPDATE statement.
    • Removing data with the DELETE statement.
    • Practical exercises to practice SQL data manipulation.
  • Day 5: Data Aggregation with GROUP BY

    • Aggregate data using the GROUP BY clause.
    • Utilizing aggregate functions: COUNT, SUM, AVG, MIN, and MAX.
    • Analyzing data trends and summaries with SQL aggregation.
    • Apply your knowledge with SQL aggregation exercises.
  • Day 6: Joining Tables in SQL

    • Understanding and implementing INNER JOIN operations.
    • Combining data from multiple tables using SQL joins.
    • Working with complex SQL join scenarios.
    • Practice SQL join techniques with hands-on exercises.
  • Day 7: Introduction to Subqueries

    • Understanding what subqueries are and how they function.
    • Using subqueries in SELECT statements and WHERE clauses.
    • Leveraging subqueries for more complex SQL queries.
    • Final practice exercises to solidify your understanding of subqueries.

By completing this course, you'll gain the essential SQL skills to write basic SQL queries, manipulate data effectively, and utilize powerful techniques like grouping and joining. Start your SQL learning journey today!

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0
1h 54m
intermediate
pluralsight
5.0
3h 5m
beginner
pluralsight
5.0(177)
50m
beginner
skillshare
5.0(228)
1h
all
skillshare
5.0(96)
2h 58m
beginner
skillshare