LibCoder

T-SQL Fundamentals. 4Ed

1C Agda DataBase (SQL)
T-SQL Fundamentals. 4Ed
Автор: Ben-Gan Itzik
Дата выхода: 2023
Издательство: Pearson Education Limited
Количество страниц: 601
Размер файла: 5,3 МБ
Тип файла: PDF
Добавил: LibCoder
Оглавление
 CoverTable of ContentsChange HistoryBeta 9—June 9,....2021Beta 8—April 27,....2021Beta 7—March 11,....2021Beta 6—August 11,....2020Beta 5—June 5,....2020Beta 4—March 23,....2020Beta 3—February 9,....2020Beta 2—December 4,....2019Beta 1—October 30,....2019AcknowledgmentsSo You Want to Write Some Client-Side CodeBasic AssumptionsThe Tools We’ll UseHow This Book Is OrganizedLet’s Build an AppThe Sample CodePart I—Getting Started1. Getting Started with Client-Side RailsManaging State and Front-End DevelopmentConfiguring WebpackerUsing WebpackerWhat’s Next2. Hotwire and TurboThe Hotwire WayInstalling TurboWhat Is Turbo Drive?Adding Interactivity with Turbo FramesNavigating Outside a Turbo FrameExtending Our Page with Turbo StreamsTurbo Frames vs. Turbo StreamsLazy Loading a Turbo FrameWhat’s Next3. StimulusWhat Is Stimulus?Installing StimulusAdding Our First ControllerCreating an ActionAdding a TargetUsing ValuesAutomating Value ChangesStimulus Has ClassGoing GenericStimulus Quick ReferenceWhat’s Next4. ReactWhat Is React?Installing ReactAdding Our First ComponentComposing ComponentsConnecting to the PageInteractivity, State, and HooksSharing StateWhat’s Next5. Cascading Style SheetsBuilding CSS in webpackAdding CSS and Assets to webpackAnimating CSSAdding CSS TransitionsAnimating Turbo Streams with Animate.cssUsing CSS and React ComponentsWhat’s NextPart II—Going Deeper6. TypeScriptUsing TypeScriptUnderstanding Basic TypeScript TypesStatic vs. Dynamic TypingAdding Type Annotations to VariablesAdding Type Annotations to FunctionsAdding Type Annotations to ClassesDefining InterfacesType Checking Classes and InterfacesGetting Type Knowledge to TypeScriptWhat’s Next7. webpackUnderstanding Why webpack ExistsManaging Dependencies with YarnUnderstanding webpack ConfigurationWhat’s Next8. WebpackerWebpacker BasicsWriting Code Using WebpackerIntegrating Webpacker with FrameworksRunning webpackDeploying Webpacker in ProductionCustomizing WebpackerWhat’s NextPart III—Managing Servers and State9. Talking to the ServerUsing Stimulus to Manage FormsStimulus and AjaxUsing Data in StimulusAcquiring Data in React with useStateWhat’s Next10. Immediate Communication with ActionCableInstalling ActionCableTurbo Streams and ActionCableStimulus and ActionCableReact and ActionCableWhat’s Next11. Managing State in Stimulus CodeUsing Data Values for LogicObserving and Responding to DOM ChangesRendering CSS with Data AttributesWhat’s Next12. Managing State in ReactUsing ReducersUsing Context to Share StateAdding Asynchronous Events to ContextsWhat’s Next13. Using Redux to Manage StateInstalling and Using ReduxAdding Asynchronous Actions to ReduxWhat’s NextPart IV—Validating Your Code14. Validating Code with Advanced TypeScriptCreating Union TypesSpecifying Types with Literal TypesUsing Enums and Literal TypesBuilding Mapped Types and Utility TypesTypeScript Configuration OptionsDealing with StrictnessWhat’s Next15. Testing with CypressWhy Cypress?Installing CypressConfiguring Cypress and RailsWriting Our First TestUnderstanding How Cypress WorksWhat’s Next16. More Testing and TroubleshootingWriting More Cypress TestsTesting the Schedule FilterCypress and ReactCypress Utilities and APITroubleshootingWhat’s NextA1. Framework SwapThe All-Hotwire AppThe All-React AppComparisonIndex

Описание

В этом материале разберём тему: data.

Long-time Microsoft Data Platform MVP Itzik Ben-Gan explains key T-SQL concepts, helping you apply your knowledge with hands-on exercises. Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance. Ben-Gan first introduces T-SQL's theory and underlying logic, illuminating it as both a language and a way of thinking. Building on this foundation, you'll enhance your coding capabilities, from programmatic constructs to the powerful new SQL Graph. Next, he walks through core topics, including logical query processing, single table queries, joins, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, and transactions and concurrency. Throughout, Ben-Gan presents reusable T-SQL sample code that works in cloud, on-premises, and hybrid environments.

Microsoft Data Platform MVP Itzik Ben-Gan helps you:Understand why T-SQL works as it does, so you can write better codeReview relational theory elements and modern SQL Server architectureCreate tables and defi ne data integrityBuild single-table SELECT queries, multiple-table joins, and subqueriesUtilize derived tables, Common Table Expressions, views, inline table-valued functions, and APPLYMake the most of UNION, INTERSECT, and EXCEPT set operatorsPerform data analysis with window functions, pivoting, grouping sets, and time seriesInsert, update, delete, and merge dataGet started with system-versioned temporal tablesUnderstand and apply transactions and concurrency, including concurrent user connections, locks, blocking, isolation levels, and moreUse SQL Graph to model, create, modify, and query graph-based dataExplore SQL Server programmable objects and programming capabilitiesSet up your environment, install sample databases, and fi nd even more helpFor IT Professionals and ConsultantsFor T-SQL developers, DBAs, BI practitioners, data scientists, report writers, analysts, architects, and SQL Server power usersFor anyone else who needs to write queries or develop T-SQL code for SQL Server, Azure SQL Database, or Azure SQL Managed Instance

Файл доступен для загрузки ниже.

data table server azure write code microsoft including

Частые вопросы

Можно ли скачать «T-SQL Fundamentals. 4Ed» бесплатно?

Да, «T-SQL Fundamentals. 4Ed» доступна для бесплатного скачивания на нашем сайте в формате PDF. Ссылка на файл находится на этой странице.

В каком формате и какого размера файл?

Книга предоставляется в формате PDF, размер файла 5,3 МБ.

Кто автор и когда вышла книга?

автор — Ben-Gan Itzik, издательство Pearson Education Limited, год выпуска 2023, 601 страниц.

О чём книга «T-SQL Fundamentals. 4Ed»?

Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

Похожие материалы