Exam Ref 70-761 Querying Data with Transact-SQL, Ben-Gan Itzik

Автор: Ben-Gan Itzik
Название: T-SQL Fundamentals
ISBN: 150930200X ISBN-13(EAN): 9781509302000
Издательство: Pearson Education
Рейтинг:
Цена: 35810 T
Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Gain a solid understanding of T-SQL and write better queries Master the fundamentals of Transact-SQL and develop your own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, you ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you ll quickly learn how to write effective code whether you re a programmer or database administrator. Discover how to:

• Work with programming practices unique to T-SQL
• Create database tables and define data integrity
• Query multiple tables using joins and subqueries
• Simplify code and improve maintainability with table expressions
• Implement insert, update, delete, and merge data modification strategies
• Tackle advanced techniques such as window functions, pivoting and grouping sets
• Control data consistency using isolation levels, and mitigate deadlocks and blocking
• Take T-SQL to the next level with programmable objects

Автор: Gand Gale
Название: Gale Gand`s Brunch!: 100 Fantastic Recipes for the Weekend`s Best Meal
ISBN: 0307406989 ISBN-13(EAN): 9780307406989
Издательство: Random House (USA)
Цена: 20910 T
Наличие на складе: Нет в наличии.
Описание: Every weekend is worth celebrating when you can relax over a good brunch. Food Network host, cookbook author, celebrated chef, and mother of three, Gale Gand has long made brunch a part of her life because it's the easiest way to gather around the table with family and friends. Now, in Gale Gand's Brunch she shares 100 recipes for scrumptious brunch fare, all destined to become household favorites.

Traditional breakfast treats become inspired dishes when Gale shares how to effortlessly enliven the basics, like Iced Coffee with Cinnamon-Coffee Ice Cubes, Baked Eggs in Ham Cups, and Almond Ciabatta French Toast. In five mini-classes, she teaches how to master easy but impressive classic egg dishes-omelets, quiches, strata, frittata, and crepes-with numerous variations on each. Finally, no cookbook by Gale would be complete without recipes for the wonderful baked goods she's famous for, such as Ginger Scones with Peaches and Cream, Moist Orange-Date Muffins, Glazed Crullers, and Quick Pear Streusel Coffee Cake.

Special occasion or not, brunch is a cinch with Gale's irresistible recipes. Start off the day with zesty Breakfast Burritos for the kids, or wow visiting in-laws with Poached Salmon with Cucumber Yogurt. Anyone will find Gale's salads, soups, and sides delicious and simple, and with 60 color photographs, you'll be enticed to try a new recipe every weekend. Wake up to a great weekend with Gale Gand's Brunch

Автор: Panfil Vanessa R.
Название: The Gang`s All Queer: The Lives of Gay Gang Members
ISBN: 1479870021 ISBN-13(EAN): 9781479870028
Издательство: Marston Book Services
Рейтинг:
Цена: 36590 T
Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:  Honorable Mention, 2018 Distinguished Book Award presented by the American Sociological Association’s Sociology of Sexualities Section The first inside look at gay gang members. Many people believe that gangs are made up of violent thugs who are in and out of jail, and who are hyper-masculine and heterosexual. In The Gang’s All Queer, Vanessa Panfil introduces us to a different world. Meet gay gang members – sometimes referred to in popular culture as “homo thugs” – whose gay identity complicates criminology’s portrayal and representation of gangs, gang members, and gang life.  In vivid detail, Panfil provides an in-depth understanding of how gay gang members construct and negotiate both masculine and gay identities through crime and gang membership.   The Gang’s All Queer draws from interviews with over 50 gay gang- and crime-involved young men in Columbus, Ohio, the majority of whom are men of color in their late teens and early twenties, as well as on-the-ground ethnographic fieldwork with men who are in gay, hybrid, and straight gangs. Panfil provides an eye-opening portrait of how even members of straight gangs are connected to a same-sex oriented underground world.   Most of these young men still present a traditionally masculine persona and voice deeply-held affection for their fellow gang members.  They also fight with their enemies, many of whom are in rival gay gangs. Most come from impoverished, ‘rough’ neighborhoods, and seek to defy negative stereotypes of gay and Black men as deadbeats, though sometimes through illegal activity. Some are still closeted to their fellow gang members and families, yet others fight to defend members of the gay community, even those who they deem to be “fags,” despite distaste for these flamboyant members of the community. And some perform in drag shows or sell sex to survive.   The Gang’s All Queer poignantly illustrates how these men both respond to and resist societal marginalization. Timely, powerful, and engaging, this book will challenge us to think differently about gangs, gay men, and urban life.

Автор: Ben-Gan Itzik, Machanic Adam, Sarka Dejan
Название: T-SQL Querying
ISBN: 0735685045 ISBN-13(EAN): 9780735685048
Издательство: Pearson Education
Рейтинг:
Цена: 47770 T
Наличие на складе: Поставка под заказ.
Описание: T-SQL insiders help you tackle your toughest queries and query-tuning problems
Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL's internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012.

Write faster, more efficient T-SQL code:

• Move from procedural programming to the language of sets and logic
• Master an efficient top-down tuning methodology
• Assess algorithmic complexity to predict performance
• Compare data aggregation techniques, including new grouping sets
• Efficiently perform data-analysis calculations
• Make the most of T-SQL's optimized bulk import tools
• Avoid date/time pitfalls that lead to buggy, poorly performing code
• Create optimized BI statistical queries without additional software
• Use programmable objects to accelerate queries
• Unlock major performance improvements with In-Memory OLTP
• Master useful and elegant approaches to manipulating graphs