Packt+ | Advance your knowledge in tech

0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

The Ultimate T-SQL And Microsoft SQL Server Bootcamp

You're reading from The Ultimate T-SQL And Microsoft SQL Server Bootcamp Mastering SQL Server and T-SQL: A Comprehensive Bootcamp for Database Management and Development

Product type Video

Published in Oct 2023

Last Updated in May 2025

Publisher Packt

ISBN-13 9781835466735

Length 7hrs 10mins

Edition 1st Edition

Languages

SQL

Tools

SQL Server

Concepts

Programming Language

Authors (2):

Trevoir Williams

Emar Morrison

View More author details

Table of Contents (14) Chapters

1. Introduction FREE CHAPTER

Introduction

2. Essential Questions

3. Environment Setup

4. Database Setup

5. Introduction to Data Definition Language

6. Reading Data

7. More Read Query Concepts

8. Inserting Data

9. Update and Delete Operations

10. Designing and Creating Views and Functions

11. Control-of-Flow Statements

12. Designing and Implementing T-SQL Routines

13. Managing Transactions and Concurrency

14. Conclusion

Conclusion

Content Locked

Visually different images

CONTINUE WATCHING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

The Ultimate T-SQL And Microsoft SQL Server Bootcamp

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (2)

Trevoir Williams

Trevoir Williams

Trevoir Williams, a passionate software and system engineer from Jamaica, shares his extensive knowledge with students worldwide. Holding a Master's degree in Computer Science with a focus on Software Development and multiple Microsoft Azure Certifications, his educational background is robust. His diverse experience includes software consulting, engineering, database development, cloud systems, server administration, and lecturing, reflecting his commitment to technological excellence and education. He is also a talented musician, showcasing his versatility. He has penned works like Microservices Design Patterns in .NET and Azure Integration Guide for Business. His practical approach to teaching helps students grasp both theory and real-world applications.

See other products by Trevoir Williams

Emar Morrison

Emar Morrison

Emar J. Morrison is an experienced database administrator with almost a decade of expertise in the field. He has worked with various organizations, both big and small, and has played an instrumental role in the successful implementation and maintenance of their databases. Emar is well-versed in various cloud platforms, including Amazon Web Services (AWS) and Microsoft Azure. Apart from his work in database administration, Emar is also an avid investor with a keen interest in the stock market. He believes in the importance of investing as a means of building wealth and achieving financial freedom. Emar has spent years studying the strategies of successful investors and has honed his skills in identifying promising investment opportunities. He has a passion for sharing his knowledge with others and is dedicated to helping people achieve their financial goals. In addition to his work as a database administrator and investor, Emar is also a content creator. He is passionate about writing and creating informative and engaging content about database administration, cloud platforms like AWS and Azure, investing, and personal finance. Emar's content is designed to educate and empower his audience, providing them with the tools and knowledge they need to succeed.

See other products by Emar Morrison

Personalised recommendations for you

Based on your interests and search pattern

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Mastering Python Design Patterns

Mastering Python Design Patterns

Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.

May 2024 9h 52m

System Programming Essentials with Go

System Programming Essentials with Go

From file operations to process management and network programming, this hands-on guide equips software engineers with the skills to build efficient, reliable applications and optimize their performance.

Jun 2024 13h 36m

Modern Python Cookbook

Modern Python Cookbook

The new edition of Modern Python Cookbook provides over 130 recipes for solving real-world problems with Python. Updated for Python 3.12 with new recipes and chapters. This practical guide will enhance your skills and teach you advanced techniques.

Jul 2024 27h 16m

The Ultimate Zoom Cookbook

The Ultimate Zoom Cookbook

This cookbook is an in-depth guide to using Zoom effectively. You'll be able to follow each recipe easily to harness the power of the communication and collaboration tools in Zoom.

May 2024 11h 20m

Enterprise Architecture with .NET

Enterprise Architecture with .NET

This book will help you create applications that integrate correctly into complex and ever-changing information systems. You'll execute this by using industry standards that reduce the app's technical debt and elevate software development practices.

May 2024 25h 44m

Salesforce B2C Solution Architect's Handbook

Salesforce B2C Solution Architect's Handbook

Discover how Salesforce Customer 360 unifies Marketing Cloud, B2C Commerce, Data Cloud, and Service Cloud into one solution, and learn the capabilities, integration options, limitations, and workflows to create value for your organization.

May 2024 15h 28m

Systems Programming with C# and .NET

Systems Programming with C# and .NET

Unlock the full potential of C# and .NET Core in systems programming to secure, deploy, and maintain robust applications. With this book, you'll focus on low-level APIs, memory management, and performance optimization.

Jul 2024 15h 48m

Technical Program Manager's Handbook

Technical Program Manager's Handbook

Unlock the full potential of your career as a TPM with this comprehensive guide, featuring new chapters on AI and more. Learn advanced techniques and gain insights from industry leaders. Elevate your skills and thrive in the Big Five tech companies.

Sep 2024 12h 16m

Microsoft Power Pages in Action

Microsoft Power Pages in Action

Packed with real-world examples, low-code coding techniques, and insights into crafting responsive pages, automating apps, and enhancing virtual agents, Microsoft Power Pages in Action is a valuable resource for building feature-rich web apps.

Jun 2024 11h 40m