ISBN:
9781835466735
,
1835466737
Language:
English
Pages:
1 online resource (1 video file (7 hr., 11 min.))
,
sound, color.
Edition:
[First edition].
DDC:
005.75/85
Keywords:
SQL server
;
Client/server computing
;
Database management
;
Instructional films
;
Nonfiction films
;
Internet videos
Abstract:
T-SQL, which stands for Transact-SQL, is a powerful extension of the Structured Query Language (SQL). It is a specialized programming language for interacting with and managing Microsoft SQL Server databases. T-SQL is proprietary to Microsoft and is the standard language for querying, modifying, and managing data in an SQL Server. The course covers all aspects of Microsoft SQL Server and Transact-SQL (T-SQL), from the basics to advanced topics. We will start by understanding SQL fundamentals and then proceed to hands-on exercises for installing SQL Server and Azure Data Studio. We will learn to create, modify, and manage database objects, perform data querying, filtering, and sorting, and explore advanced topics such as JOIN operations, subqueries, and window functions. The course also delves into database administration, transactions, and advanced query concepts. Practical skills in T-SQL development, database management, and optimization will be imparted, making it suitable for beginners and those looking to advance their database expertise. Upon completing this course, we will master Microsoft SQL Server/T-SQL. We will gain the skills to design, manage, and optimize databases and write efficient queries. This expertise opens doors to a wide range of career opportunities in the data management and analysis fields. What You Will Learn Master data analysis and reporting using SQL Server Explore database security and configuration Understand how to create and manage views Learn the practical use of variables and functions Understand the use of stored procedures and triggers Audience This course caters to a diverse audience, including beginners looking to establish a solid foundation in SQL Server and T-SQL, database developers aiming to enhance their SQL skills in the SQL Server ecosystem, application developers seeking to expand their SQL knowledge, IT professionals in database administration tasks, data analysts working with SQL Server databases, and career changers considering roles in database development, analysis, or administration. A basic understanding of database concepts is recommended. Access to a Microsoft SQL Server environment for hands-on practice is desirable. About The Authors Trevoir Williams: Trevoir Williams is a software engineer, lecturer, and author. With a master's degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure cloud services, and server administration. He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students. Emar Morrison: Emar J. Morrison, a seasoned database administrator with nearly a decade of experience, excels in managing databases for organizations of all sizes and is proficient in cloud platforms like AWS and Azure. Emar is also a skilled content creator, crafting informative pieces on database administration, cloud computing, investments, and personal finance, all designed to empower and educate his audience for success.
Note:
"Updated October 2023.". - Online resource; title from title details screen (O'Reilly, viewed November 15, 2023)
