Sql Queries 101: A Beginner'S Guide To Data Retrieval
Date: 3 November 2023 | Posted by: oaxino
Sql Queries 101: A Beginner'S Guide To Data Retrieval
Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 930.40 MB | Duration: 2h 27m
Building a Strong Foundation in SQL Query Writing
Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 930.40 MB | Duration: 2h 27m
Building a Strong Foundation in SQL Query Writing
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
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 CurriculumBasic SELECT StatementScalar FunctionsAggregatesGROUP BY and HAVING ClauseComparison and Logical OperatorsTable Relationships with JOINSSub QueriesCase SwitchSQL ViewsCREATE TableINSERT, UPDATE and DELETE RowsWhat this course contains11 Sections with Easy-to-follow instructional videos2 QuizzesSoftware and Credentials RequiredYou 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 OutcomeData 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.
Overview
Section 1: Introduction
Lecture 1 Getting Ready
Lecture 2 Install SQL Server
Lecture 3 Install SQL Server Management Studio
Lecture 4 Load Sample Database
Lecture 5 Load Flat Files
Section 2: Setup without SQL Server
Lecture 6 SQLiteOnline
Section 3: The SELECT Statement
Lecture 7 SELECT All Columns
Lecture 8 SELECT Specific Columns
Lecture 9 SELECT Top and Bottom Rows
Lecture 10 SELECT Distinct Column Values
Lecture 11 ORDER BY Clause
Lecture 12 Query Summary
Section 4: Scalar Functions
Lecture 13 Concatenate
Lecture 14 RIGHT and LEFT
Lecture 15 LEN
Lecture 16 Format
Lecture 17 Query Summary
Section 5: Aggregate Functions and Grouping
Lecture 18 Aggregates
Lecture 19 Group By Clause
Lecture 20 Query Summary
Section 6: Date and Time Functions
Lecture 21 DATEDIFF
Lecture 22 Other Date Functions
Lecture 23 Query Summary
Section 7: Operators
Lecture 24 Comparison Operators
Lecture 25 AND or BETWEEN
Lecture 26 LIKE
Lecture 27 IN and OR
Lecture 28 Logical Operators - Wrap Up
Lecture 29 Query Summary
Section 8: GROUPING
Lecture 30 HAVING Clause
Lecture 31 Partition By
Lecture 32 Query Summary
Section 9: Table Relationships
Lecture 33 Inner Join - Video Chapter
Lecture 34 More with INNER JOINS
Lecture 35 LEFT and RIGHT JOIN
Lecture 36 JOIN Three Tables
Lecture 37 JOIN Four Tables
Lecture 38 FULL OUTER JOIN
Lecture 39 EXCEPT
Lecture 40 Query Summary
Section 10: SubQuery
Lecture 41 EXISTS
Lecture 42 ALL
Lecture 43 Query Summary
Section 11: CASE SWITCH
Lecture 44 CASE SWITCH
Lecture 45 Query Summary
Section 12: SQL View
Lecture 46 Create and Query a SQL View
Lecture 47 Query Summary
Section 13: Create and Drop Table
Lecture 48 Create and Drop Table
Lecture 49 Query Summary
Section 14: Insert and Delete Rows
Lecture 50 Insert and Delete Rows
Lecture 51 Query Summary
Section 15: Update Rows
Lecture 52 Update Statement
Lecture 53 Query Summary
Section 16: SQL Queries with Power BI
Lecture 54 SQL Queries and Power BI
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
Screenshots
Download link
rapidgator.net:
uploadgig.com:
nitroflare.com:
See full article