{"product_id":"t-sql-in-one-hour-a-day-sams-teach-yourself","title":"T-SQL in One Hour a Day, Sams Teach Yourself","description":"\u003cp\u003e\u003cb\u003eMaster T-SQL database design, development, and administration the easy way–hands-on!\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eIn 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:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \n Learn the fundamentals of T-SQL from the ground up, one step at a time  \u003c\/li\u003e\n \u003cli\u003e \n Succeed with the newest versions of T-SQL, SQL Server, and SQL Server Management Studio  \u003c\/li\u003e\n \u003cli\u003e \n Use T-SQL effectively as both an application developer and DBA  \u003c\/li\u003e\n \u003cli\u003e \n Master powerful stored procedures, triggers, transactions, and user-defined functions (UDFs)  \u003c\/li\u003e\n \u003cli\u003e \n Systematically optimize and secure your SQL Server databases \u003c\/li\u003e\n \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eLearn on your own time, at your own pace\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \n No previous T-SQL or database programming experience required  \u003c\/li\u003e\n \u003cli\u003e \n Learn how to design efficient, reliable SQL Server databases  \u003c\/li\u003e\n \u003cli\u003e \n Define efficient tables, table relationships, fields, and constraints  \u003c\/li\u003e\n \u003cli\u003e \n Make the most of T-SQL’s SELECT and UPDATE statements  \u003c\/li\u003e\n \u003cli\u003e \n Work effectively with simple and complex views and joins  \u003c\/li\u003e\n \u003cli\u003e \n Master stored procedure techniques every developer should know  \u003c\/li\u003e\n \u003cli\u003e \n Build and use powerful User-Defined Functions (UDFs)  \u003c\/li\u003e\n \u003cli\u003e \n Secure databases with authentication, roles, permissions, and principals  \u003c\/li\u003e\n \u003cli\u003e \n Configure, maintain, and tune SQL Server for maximum reliability, performance, and value  \u003c\/li\u003e\n \u003cli\u003e \n Back up, restore, and audit databases  \u003c\/li\u003e\n \u003cli\u003e \n Optimize databases with the SQL Server Profiler, System Monitor, and Index Tuning Wizard  \u003c\/li\u003e\n \u003cli\u003e \n Leverage valuable insight and time saving techniques from a world renowned database expert \u003c\/li\u003e\n \u003c\/ul\u003e \u003cp\u003eRegister your book at informit.com\/register for access to source code, example files, updates, and corrections as they become available.\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":46286716829934,"sku":"9780134176000","price":42.3,"currency_code":"AUD","in_stock":true}],"url":"https:\/\/bookland.com.au\/products\/t-sql-in-one-hour-a-day-sams-teach-yourself","provider":"Book Land AU","version":"1.0","type":"link"}