T-SQL IN ONE HOUR A DAY

NOTE LIBRAIO

In just one hour a day, you’ll build all the skills you need to create effective database applications with T-SQL and SQL Server. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts:<br /><br />Learn the fundamentals of T-SQL from the ground up, one step at a time<br />Succeed with the newest versions of T-SQL, SQL Server, and SQL Server Management Studio<br />Use T-SQL effectively as both an application developer and DBA<br />Master powerful stored procedures, triggers, transactions, and user-defined functions (UDFs)<br />Systematically optimize and secure your SQL Server databases<br />Learn on your own time, at your own pace<br /><br />No previous T-SQL or database programming experience required<br />Learn how to design efficient, reliable SQL Server databases<br />Define efficient tables, table relationships, fields, and constraints<br />Make the most of T-SQL’s SELECT and UPDATE statements<br />Work effectively with simple and complex views and joins<br />Master stored procedure techniques every developer should know<br />Build and use powerful User-Defined Functions (UDFs)<br />Secure databases with authentication, roles, permissions, and principals<br />Configure, maintain, and tune SQL Server for maximum reliability, performance, and value<br />Back up, restore, and audit databases<br />Optimize databases with the SQL Server Profiler, System Monitor, and Index Tuning Wizard<br />Leverage valuable insight and time saving techniques from a world renowned database expert

ALTRE INFORMAZIONI

• Condizione: Nuovo
• ISBN: 9780672337437
• Collana: Sams Teach Yourself...
• Dimensioni: 8.25 x 5.25 x 1.00 inch.
• Formato: Paperback
• Pagine Arabe: 418