In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…
What is SQL? What is the difference between SQL the language and SQL the server?
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.
Restricting data by using Table Constraints in SQL Server. What are the different table constraints in SQL Server?
Learn about Transaction and Errors in SQL Server. Understand Auto-Commit vs Explicit Transactions for better error handling.
John Deardurff passed 70-765 Provisioning SQL Databases 2016 Stretch Database MCSA, MCSE Exam Microsoft Certifications
Unlock faster performance with In-Memory OLTP by downloading the free SQL Server Internals eBook today.
Discover the features of SQL Server 2017 released, empowering organizations with AI for better data management and innovation.