Learn SQL Queries from Udemy

What's inside

Learning objectives

Learn how to insert, delete, update and query from tables
Learn about many of the useful built in t-sql functions (sum, cnt, avg...)

Learn about temp tables and table variables
Learn about the power of stored procedures

Learn how to insert, delete, update and query from tables
Learn about many of the useful built in t-sql functions (sum, cnt, avg...)
Learn about temp tables and table variables
Learn about the power of stored procedures

Syllabus

Queries - Part 1 - SELECT Records

Course Description

* * SECTION DESCRIPTION * *

SELECT *

SELECT COUNT(*)

SELECT DISTINCT

SELECT ISNULL()

SELECT SUM()

SELECT MAX()

SELECT MIN()

SELECT MAX() and MIN() Example

SELECT AVG()

SELECT MAX(), MIN() and AVG() Example

Concatenation Example

SELECT CASE Example

SELECT CASE and Concatenation Example

SECTION 1 - REVIEW QUIZ

Queries - Part 2 - FROM Clause

FROM - NO JOIN

FROM - INNER JOIN

FROM - LEFT JOIN

FROM - LEFT vs INNER

FROM - LEFT vs RIGHT

FROM - INNER JOIN with Temp Table

FROM - INNER JOIN with Table Variable

UNION QUERY - TSQL Command Line

SECTION 2 - REVIEW QUIZ

Queries - Part 3 - WHERE Clause

WHERE X = Y

WHERE X > Y

WHERE X IN (a,b,c,d)

WHERE X NOT IN (a,b,c,d)

WHERE X BETWEEN ...

WHERE X IN (SELECT ...)

WHERE X NOT IN (SELECT ...)

WHERE - IN Clause vs Sub Query

WHERE - AND Operator

WHERE - OR Operator

WHERE - AND Operator, OR Operator and Parentheses

SECTION 3 - REVIEW QUIZ

Queries - Part 4 - ORDER BY Clause

ORDER BY 1, 2

ORDER BY 1, 2 (Possible Issues)

ORDER BY ,

This video will discuss the importance of being familiar with ASCII values and how htis ties in with the ORDER BY Clause.

You really need to watch this video along with the next video, about COLATION to get the entire message.

This video will discuss the importance of being familiar with "COLATION" and how this ties in with the ORDER BY Clause.

You really need to watch this video along with the previous video, about ASCII values to get the entire message.

ORDER BY - ASC

ORDER BY - DESC

ORDER BY CASE - Part 1

In this video we continue on with a strange ordering request: "Put NY first, then all other states in order." This video shows a specific approach that works but is more complicated than what is necessary.

ORDER BY CASE - Part 3

ORDER BY (SELECT ...)

SECTION 4 - REVIEW QUIZ

Queries - Part 5- GROUP BY Clause

GROUP BY - MIN() & MAX() - Part 1

GROUP BY - MIN() & MAX() - Part 2

GROUP BY - MIN() & MAX() - Part 3

GROUP BY - COUNT(*)

GROUP BY - SUM()

GROUP BY - AVG()

GROUP BY - HAVING CLAUSE - Part 1

GROUP BY - HAVING CLAUSE - Part 2

GROUP BY - HAVING CLAUSE - Part 3

SECTION 5 - REVIEW QUIZ

A Quick Look at the value of STORED PROCEDURES

xxx

STORED PROCEDURES - EXAMPLE 1 - Part 2

STORED PROCEDURES - EXAMPLE 1 - Part 3

VIDEO - The video will show you how to write to a text file from SQL Server.

The following notes are references to the additional support files that are connected with this section. These files are downloadable so that you can copy and paste the code right into SSMS / T-SQL.

01 - CREATE PROCEDURE Write To File - This is the TSQL code to create your own [WriteToFile] STORED PROCEDURE.*

02 - Write To Text File - Command Line SQL - This is an example of how to EXECUTE the [WriteToFile] STORED PROCEDURE.*

03 - Write To Text File Command Line SQL - With Parameters - This is an example of how to EXECUTE the [WriteToFile] STORED PROCEDURE - with Parameters/Variables/Arguments.*

04 - Write To Text File Command Line SQL - With Parameters And Date In Filename - This is an example of how to execute the [WriteToFile] STORED PROCEDURE - with Parameters/Variables/Arguments and INSERTING a FORMATTED DATE-TIME STAMP into the file name.*

Ole Automation SQL - This is the code that you will need to run to initially turn on the OLE AUTOMATION Permissions in SQL SERVER.*

* This T-SQL code can be copied into the SSMS command line environment.

A Quick Look at the value of USER DEFINED FUNCTIONS

** SECTION DESCRIPTION **

USER DEFINED FUNCTIONS - EXAMPLE 1 - FormatCustName()

VIDEO- The video will show you how to make use of a User Defined Function. In this particular example the function will return a value that has been formatted with n instances of a specific text character.

The following notes are references to the additional support files that are connected with this section. These files are downloadable so that you can copy and paste the code right into SSMS / T-SQL.

01 - CREATE FUNCTION – dbo.PrePad() Example- This is the TSQL code to create your own dbo.[PrePad]USER DEFINED FUNCTION.*

02 – USER DEFINED FUNCTION – dbo.PrePad() Example- This is an example of how toCALL / USE the dbo.[PrePad]USER DEFINED FUNCTION.*

* This T-SQL code can be copied into the SSMS command line environment.

USER DEFINED FUNCTIONS - EXAMPLE 2 - Part 2 - PrePad() Function

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Suited for learners with some grounding in SQL principles and architecture

Provides a thorough understanding of querying, stored procedures, and user-defined functions in SQL Server

Useful for industry professionals seeking to enhance their SQL skills

Instructor Dave Merton possesses extensive experience in SQL Server

Course content aligns with industry standards and practices

In-depth exploration of SQL Server's functionality

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Learn SQL Queries with these activities:

Review SQL language fundamentals

Show steps

Refresh your understanding of the core concepts of SQL, ensuring a strong foundation for the course.

Browse courses on SQL

Show steps

Review the syntax and structure of SELECT statements
Practice writing queries to retrieve data from tables
Refresh your knowledge of data types and operators

Read 'SQL Queries for Mere Mortals'

Show steps

Gain insights into practical SQL querying techniques and best practices from an accessible and informative book.

View SQL Queries for Mere Mortals on Amazon

Show steps

Read through the chapters and work on the practice exercises
Refer back to the book as needed for clarification and reference
Apply the techniques learned to your own SQL projects

Show all two activities

Career center

Learners who complete Learn SQL Queries will develop knowledge and skills that may be useful to these careers:

Database Programmer

Database Programmers design, develop, and maintain database systems. This course provides a strong foundation in SQL Server programming, which is essential for database programmers to effectively design and implement database solutions. By understanding the concepts of data modeling, query optimization, and database administration, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for Database Programmer

Database Administrator

Database Administrators oversee the management and maintenance of database management systems, ensuring optimal database performance and security. This course provides a strong foundation in SQL Server programming, which is essential for database administrators to effectively manage and query databases. By understanding the concepts of data manipulation, retrieval, and management, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for Database Administrator

Data Warehouse Architect

Data Warehouse Architects design, develop, and maintain data warehouse systems. This course provides a strong foundation in SQL Server programming, which is essential for data warehouse architects to effectively design and implement data warehouse solutions. By understanding the concepts of data modeling, data integration, and data analysis, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for Data Warehouse Architect

Business Intelligence Developer

Business Intelligence Developers design, develop, and maintain business intelligence solutions. This course provides a strong foundation in SQL Server programming, which is essential for business intelligence developers to effectively develop and implement business intelligence solutions. By understanding the concepts of data analysis, data visualization, and data reporting, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for Business Intelligence Developer

Data Analyst

Data Analysts collect, analyze, and interpret data to provide insights and make informed decisions. This course helps build a foundation in SQL Server programming, which is essential for data analysts to effectively query and manipulate data. By learning about data retrieval, aggregation, and manipulation, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for Data Analyst

Machine Learning Engineer

Machine Learning Engineers design, develop, and maintain machine learning models. This course provides a strong foundation in SQL Server programming, which is essential for machine learning engineers to effectively query and manipulate data. By understanding the concepts of data analysis, data mining, and machine learning, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for Machine Learning Engineer

ETL Developer

ETL Developers design, develop, and maintain data integration processes. This course provides a strong foundation in SQL Server programming, which is essential for ETL developers to effectively extract, transform, and load data. By understanding the concepts of data integration, data transformation, and data quality, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for ETL Developer

Data Scientist

Data Scientists use scientific methods, processes, algorithms, and systems to extract knowledge and insights from data. This course provides a foundation in SQL Server programming, which is essential for data scientists to effectively query and manipulate data. By understanding the concepts of data retrieval, aggregation, manipulation, and analysis, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for Data Scientist

Business Intelligence Analyst

Business Intelligence Analysts use data analysis techniques to translate raw data into actionable insights for businesses. This course provides a foundation in SQL Server programming, which is essential for business intelligence analysts to effectively query and manipulate data. By learning about data retrieval, aggregation, manipulation, and analysis, learners can develop the skills necessary to succeed in this role.

See salaries and explore the career path for Business Intelligence Analyst

Software Engineer

Software Engineers design, develop, and maintain software systems. This course provides a foundation in SQL Server programming, which may be useful for software engineers who work with databases. By understanding the concepts of data retrieval, manipulation, and management, learners can develop the skills necessary to integrate databases into their software applications.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers design and develop websites and web applications. This course provides a foundation in SQL Server programming, which may be useful for web developers who work with databases. By understanding the concepts of data retrieval, manipulation, and management, learners can develop the skills necessary to integrate databases into their web applications.

See salaries and explore the career path for Web Developer

Information Security Analyst

Information Security Analysts plan and implement security measures to protect an organization's information systems. This course provides a foundation in SQL Server programming, which may be useful for information security analysts who work with databases. By understanding the concepts of data retrieval, manipulation, and management, learners can develop the skills necessary to secure databases from unauthorized access.

See salaries and explore the career path for Information Security Analyst

IT Auditor

IT Auditors assess and evaluate an organization's IT systems and practices to ensure compliance with regulations and standards. This course provides a foundation in SQL Server programming, which may be useful for IT auditors who work with databases. By understanding the concepts of data retrieval, manipulation, and management, learners can develop the skills necessary to audit databases for compliance.

See salaries and explore the career path for IT Auditor

Data Entry Clerk

Data Entry Clerks input and maintain data in computer systems. This course provides a foundation in SQL Server programming, which may be useful for data entry clerks who work with databases. By understanding the concepts of data manipulation and management, learners can develop the skills necessary to enter and maintain data accurately and efficiently.

See salaries and explore the career path for Data Entry Clerk

Learn SQL Queries

14 deals to help you save

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses