SQL Statement Categories
There are four main categories of statements used when writing T-SQL. What are the differences between each of these categories?
SQL Server
Writing a SELECT statement
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
Filtering Records by Dates and Times
How to use the WHERE statement to filter records when the value is either a Date or a Time in a T-SQL statement.
Sort Records using ORDER BY
How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.
Table Constraints
Restricting data by using Table Constraints in SQL Server. What are the different table constraints in SQL Server?
Tables and Relationships
Understanding the difference between Parent Tables and Child Tables and the difference between Primary Keys vs Foreign Keys.
Integer Data Types
Explore the integer data type: learn how TINY, SMALL, REGULAR, and BIG INTEGER types can optimize data efficiency.
Writing a Stored Procedure
Learn the basics of writing a stored procedure and make your SQL Server code more efficient and reusable with parameters.
70-765 SQL Admin Exam
John Deardurff passed 70-765 Provisioning SQL Databases 2016 Stretch Database MCSA, MCSE Exam Microsoft Certifications
In-Memory OLTP
Unlock faster performance with In-Memory OLTP by downloading the free SQL Server Internals eBook today.