Sql Server Part1 - Basics Of Sql
Published 5/2025
Created by ajay parmar
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner | Genre: eLearning | Language: English | Duration: 11 Lectures ( 3h 21m ) | Size: 1.8 GB
SQL Server Database - Part1 is for beginners
What you'll learn
Write SELECT Queries - Learn how to retrieve data from one or more tables using SELECT.
Filter Data Using WHERE Clause - Understand how to apply conditions with WHERE, IN, NOT IN, BETWEEN, and LIKE.
Use SQL Functions - Explore basic built-in functions like COUNT, SUM, AVG, MIN, and MAX.
Combine Conditions - Use AND, OR, and NOT operators to form complex filters.
Requirements
Basic Excel functions is fine to take up this course. No coding required.
Description
1. SQL Server InstallationSteps to install SQL Server
ownload and install SQL Server Developer Edition or Express Edition from Microsoft.Configure SQL Server setup (choose authentication mode).Install SQL Server Management Studio (SSMS) to interact with the database.Connect to the SQL Server instance using SSMS. SSMS Installation (SQL Server Management Studio)SSMS is used to manage SQL Server databases visually.Download from Microsoft's website and install it.Use it to create, modify, and execute SQL queries easily.2. SELECT QueryUsed to retrieve data from one or more tables.Syntax: SELECT column1, column2 FROM table_name;Can retrieve all columns using SELECT * FROM table_name;Can use aliases with AS for better readability: SELECT column1 AS NewName FROM table_name;3. ORDER BY ClauseUsed to sort query results in ascending (ASC, default) or descending (DESC) order.Example: SELECT * FROM Employees ORDER BY Salary DESC;Can sort by multiple columns: ORDER BY Department ASC, Salary DESC;NULL values usually appear first in ascending order, last in descending.4. WHERE ClauseFilters records based on conditions.Operators: =, !=, , =, BETWEEN, LIKE, IN, NOT INExample: SELECT * FROM Employees WHERE Salary > 50000;Used with AND, OR, and NOT for multiple conditions.5. HAVING ClauseUsed to filter aggregated results from GROUP BY.Difference from WHERE: WHERE filters individual rows, HAVING filters grouped results.6. GROUP BY ClauseGroups rows sharing the same values into summary rows.Must be used with aggregate functions like COUNT(), SUM(), AVG().Example: SELECT Department, AVG(Salary) FROM Employees GROUP BY Department;7. Aggregation CalculationsFunctions used to summarize data:SUM(), AVG(), COUNT(), MIN(), MAX()8. OVER Clause with PartitionUsed for window functions to calculate rankings, running totals, etc., without collapsing rows.Who this course is for
Data Analysts and those who work with medium or especially large datasets.
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
