This is an in depth course about using and programming with SQL Server. It assumes that the student has at least a rudimentary understanding of database concepts and architecture and gets right into the meat of the subject.
This course will get you up to speed on executing queries. The final part of the course briefly touches on stored procedures and user defined functions.
Here's a deal for you
UDEAFNULP2024
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 *
Read more
Syllabus
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.
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.
GROUP BY - HAVING CLAUSE - Part 2
xxx
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.
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.
Good to know
Save this course
Save
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
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
Career center
Database Programmer
Database Administrator
Data Warehouse Architect
Business Intelligence Developer
Data Analyst
Machine Learning Engineer
ETL Developer
Data Scientist
Business Intelligence Analyst
Software Engineer
Web Developer
Information Security Analyst
IT Auditor
Data Entry Clerk
Reading list
Save
Save
Share
Similar courses
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
