Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Queries 101: A Beginner's Guide to Data Retrieval
Rating: 5.0 out of 5(3 ratings)
106 students

SQL Queries 101: A Beginner's Guide to Data Retrieval

Building a Strong Foundation in SQL Query Writing
Created bySunil Nair (MCT)
Last updated 10/2023
English

What you'll learn

  • Use of Scalar functions to manipulate or compute values for individual rows of a result set
  • Use of Aggregation Functions allowing you to summarize and compute statistics on data, providing valuable insights into trends and patterns.
  • Joins to combine data from multiple tables, enabling to perform more complex queries and gain insights from related datasets.
  • Subqueries as a means of filtering data based on the results of another query or performing calculations

Course content

16 sections • 54 lectures • 2h 27m total length

  • Getting Ready0:37
  • Install SQL Server1:59
  • Install SQL Server Management Studio1:21
  • Load Sample Database3:14
  • Load Flat Files7:20

Requirements

  • A basic understanding of mathematical concepts like arithmetic, comparisons, and logical operations can be beneficial when constructing SQL queries involving calculations or conditional statements.

Description

If you are a student or working professional, join me in this engaging beginner course on SQL Queries. This course will teach you how to write SQL Queries for effortless data retrieval with a minimal learning curve.

As of October 2023, I have provided in-person training to over 3,000 professionals, covering skills such as office productivity, programming, databases, analytics, and cloud computing, which enables rapid integration of newfound skill sets.


Course Curriculum

  • Basic SELECT Statement

  • Scalar Functions

  • Aggregates

  • GROUP BY and HAVING Clause

  • Comparison and Logical Operators

  • Table Relationships with JOINS

  • Sub Queries

  • Case Switch

  • SQL Views

  • CREATE Table

  • INSERT, UPDATE and DELETE Rows


What this course contains

  • 11 Sections with Easy-to-follow instructional videos

  • 2 Quizzes

Software and Credentials Required

  • You can install SQL Server Basic along with SQL Server Management Studio.

  • Alternatively, if you cannot install SQL Server, you may utilize the website SQLiteonline to execute the SQL queries relevant to this course.

Intended Course Outcome

  • Data Retrieval: Mastering SQL SELECT queries allows learners to efficiently access specific data from one or multiple database tables, ensuring quick and accurate information retrieval.

  • Data Filtering: Users can employ filtering conditions in SQL SELECT queries using the WHERE clause, enabling data extraction that meets particular criteria, such as date ranges, categories, or values.

  • Data Sorting: Utilizing SQL SELECT queries, retrieved data can be sorted in ascending or descending order based on one or more columns, simplifying analysis and presentation.

  • Data Aggregation: Proficiency in SQL SELECT queries empowers users to perform calculations and use aggregate functions (e.g., SUM, AVG, COUNT) on selected data, offering valuable insights and information summaries.

  • Data Joining: By mastering SQL JOIN clauses, learners can merge data from multiple related tables, promoting extensive data analysis and reporting.

Who this course is for:

  • Data and Business Analysts
  • Software Developers
  • Data Scientists
  • Quality Assurance/Testers
  • IT Professionals
  • Entrepreneurs and Small Business Owners
  • Students and Aspiring Data Professionals
  • Anyone interested in Data

Report abuse