Introduction to SQL : SELECT, WHERE & More (Full Beginner Guide)

Learn the fundamentals of SQL in this beginner-friendly tutorial designed to help you start querying data with confidence. In this video, we break down essential SQL concepts including the SELECT statement, WHERE clause, and other core functions used in data analysis. You’ll learn how to retrieve specific columns, filter data using conditions, remove duplicates with DISTINCT, and perform basic calculations within your queries. We also cover powerful filtering techniques using operators like AND, OR, IN, NOT EQUAL, and pattern matching with the LIKE keyword. Whether you're starting a career in data analysis, business intelligence, or simply looking to build a strong foundation in SQL, this step-by-step guide will provide you with the practical skills you need. 00:00 Introduction to SELECT Statement 00:02 Selecting Specific Columns (Employee ID, First Name, Last Name) 00:45 Running Queries and Viewing Results 01:20 Using DISTINCT to Remove Duplicates 02:10 How DISTINCT Works in Data Cleaning 02:45 Performing Calculations in SELECT (Salary Example) 03:30 Creating Monthly Salary from Yearly Data 04:10 Renaming Columns with Aliases 04:40 Introduction to WHERE Clause (Filtering Data) 05:10 Filtering by Gender (Female Records) 05:50 Understanding WHERE Syntax 06:20 Filtering by Age (Greater Than Condition) 07:00 Using Comparison Operators (=) 07:30 Combining Conditions with AND 08:10 Using OR for Multiple Conditions 08:50 Practical Example: Age and Gender Filtering 09:20 Using NOT EQUAL (!=) for Opposite Results 09:50 Filtering with Exact Matches (Salary Example) 10:20 Using IN for Multiple Values 10:50 Text Matching with WHERE Clause 11:20 Introduction to LIKE Keyword 11:50 Pattern Matching (Starts With, Ends With) 12:30 Searching Anywhere Within Text (% wildcard) 13:00 Real Example: Finding Names Using LIKE