| Sumario: | Overview Learn T-SQL from the world's #1 SQL Server developer and author, Alison Balter! Gain deep mastery in just six hours… just watch! Description In just six hours, you'll gain the in-depth practical understanding of T-SQL you need to create superior solutions with SQL Server. Your video instructor, Alison Balter, has spent nearly 25 years building Microsoft database solutions for top organizations… she's the world's #1 Microsoft database author. Now, Balter guides you step-by-step through every skill you'll need, from simple SELECT statements to powerful query and view techniques… flexible stored procedures, triggers, and UDFs… even query analysis and optimization. Whether you're a DBA, database or web developer, or power user, these LiveLessons deliver practical knowledge for writing high-quality T-SQL code—fast! About the Instructor Alison Balter has 24 years of real-life experience developing Access and SQL Server applications with T-SQL and related technologies. Her clients include USC, MIT, Southern California Edison, Cisco Systems, the Drug Enforcement Administration, and many other corporate and government entities. She has written 15 books and authored more than 300 computer training videos on Access and SQL Server development: work that has earned exceptionally high ratings at Amazon.com and elsewhere. Skill Level Intermediate Advanced What You Will Learn Database fundamentals every T-SQL developer needs to know How to make the most of common T-SQL statements, keywords, clauses, and functions How to write powerful queries using joins, subqueries, and other techniques How to take full advantage of Views to display, modify, index, and secure data How to design and improve SQL Server stored procedures How to create and work with triggers and User-Defined Functions (UDFs) How to analyze query performance Who Should Take This Course SQL Server database administrators (DBAs) who need to efficiently create tables, views, stored procedures, functions, and triggers Database developers who cannot rely on DBAs and must perform all T-SQL-related tasks on their own .NET, web, and client/server developers whose responsibilities include data/database access Microsoft Access power users seeking to deepen their skills in creating new solutions Microsoft Access developers moving to SQL Server Course Requirements Experience with either the SQL Server or Access databases as a DBA, developer, or intermediate-to-advanced user Table of Contents L...
|
|---|
