Skuteczne zapytania i modyfikowanie danych przy użyciu Transact-SQL

Opanuj podstawy języka T-SQL i pisz niezawodny kod dla Microsoft SQL Server i Azure SQL Database. Itzik Ben-Gan wyjaśnia kluczowe koncepcje języka T-SQL i pomaga w wykorzystaniu tej wiedzy w praktycznych zastosowaniach. Książka przedstawia zasady działania T-SQL i logikę działającą w tle. Następnie prowadzi czytelnika poprzez kluczowe zagadnienia, takie jak zapytania jednotabelowe, złączenia, podzapytania, wyrażenia tablicowe i operatory zbiorów. Dalej książka przedstawia bardziej zaawansowane zagadnienia, takie jak funkcje okna, tworzenie tabel przestawnych i grupowanie zbiorów. Wyjaśnione zostaną również techniki modyfikowania danych, pracy z tabelami tymczasowymi i obsługa transakcji, a także przegląd obiektów programowalnych.

Itzik Ben-Gan, MVP w dziedzinie Microsoft Data Platform, przedstawia:

•\tPodstawowe koncepcje SQL i jego matematyczne korzenie

•\tTworzenie tabel i wymuszanie integralności danych

•\tWykonywanie efektywnych zapytań przy użyciu wyrażenia SELECT

•\tOdpytywanie wielu tabel przy użyciu złączeń, podzapytań, wyrażeń tablicowych i operatorów zbiorów

•\tStosowanie zaawansowanych technik, takich jak funkcje okna, tabele przestawne i grupowanie zbiorów

•\tWstawianie, aktualizowanie, usuwanie i scalanie danych

•\tKorzystanie z transakcji w wielodostępnym środowisku

•\tWprowadzenie do obiektów programowalnych – od zmiennych i plików wsadowych po funkcje definiowane przez użytkownika, procedury składowane, wyzwalacze i dynamiczny kod SQL

","html_annotation_litres":"","first_time_sale_at":"2019-07-25T22:57:05","is_azimyt_trial":false,"is_pdw_trial":false,"is_discount_forbidden":false,"is_preorder_show_fragment":false,"reviews_count":0,"livelib_rated_count":0,"livelib_rated_avg":0,"livelib_ratings":null,"parent_podcast_name":null,"parent_podcast_id":null,"parent_podcast_url":null,"podcast_episodes_count":null,"is_podcast_complete":false,"is_podcast_last_episode":false,"is_webtoon_complete":false,"genres":[{"id":185304,"uuid":"d919f320-b5b2-11e6-b088-0cc47a52085c","name":"IT-менеджмент","is_root":false,"url":"/genre/it_menedzhment-185304/"},{"id":6645,"uuid":"ed1b7358-f034-11e5-a511-0cc47a5454c6","name":"информатика и вычислительная техника","is_root":false,"url":"/genre/informatika_vychislit_tekhnika-6645/"}],"tags":[{"id":27275,"uuid":"611bed07-5b5b-11e4-96e2-0025905a06ea","name":"информационные системы","is_root":false,"url":"/tags/informacionnye-sistemy/"},{"id":92375,"uuid":"613eaa2c-5b5b-11e4-96e2-0025905a06ea","name":"информационные технологии (IT)","is_root":false,"url":"/tags/informacionnye-tehnologii-it/"}],"paper_book":null,"paper_books":[],"isbn":"978-83-7541-349-6","publication_date":"2019-07-25","quotes_count":0,"is_auto_speech":false,"youtube_videos":[],"contents_url":null,"is_prohibited_for_sale":false,"additional_info":{"registered_at":"2019-07-25T22:57:05","translated_at":null,"current_pages_or_seconds":502,"expected_pages_or_seconds":null},"publisher":{"id":18856278,"name":"Promise","url":"/author/promise/"},"copyrighter":{"id":null,"name":"OSDW Azymut","url":null},"rightholders":[{"id":null,"name":"OSDW Azymut","url":null}],"is_referrable":false,"referral":null,"alisa_url":null,"update_events":["none"],"prequels":[],"alternate_urls":[{"url":"https://litres.de/book/itzik-ben-gan/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azure-sql-43356262/","language":"de"},{"url":"https://litres.com/book/itzik-ben-gan/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azure-sql-43356262/","language":"en"},{"url":"https://litres.es/book/itzik-ben-gan/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azure-sql-43356262/","language":"es"},{"url":"https://www.litres.ru/book/itzik-ben-gan-210707/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azu-43356262/","language":"ru"},{"url":"https://litres.pl/book/itzik-ben-gan/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azure-sql-43356262/","language":"pl"},{"url":"https://litres.ee/book/itzik-ben-gan/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azure-sql-43356262/","language":"et"}],"is_art_online_readable":false,"webtoon_chapter_number":null,"webtoon_parent_id":null,"next_webtoon_chapter_id":null,"meta_title":null,"meta_tags":{"root":{"title":"«Podstawy języka T-SQL Microsoft SQL Server 2016 i Azure SQL Database», Itzik Ben-Gan – скачать pdf на Литрес","description":null,"rel_canonical_url":null,"seo_robots":null,"open_graph_title":"Podstawy języka T-SQL Microsoft SQL Server 2016 i Azure SQL Database — Itzik Ben-Gan | Литрес","open_graph_description":null,"text":null},"readonline":null,"reviews":{"title":"Отзывы о книге «Podstawy języka T-SQL Microsoft SQL Server 2016 i Azure SQL Database», Itzik Ben-Gan | Литрес","description":null,"rel_canonical_url":null,"seo_robots":null,"open_graph_title":null,"open_graph_description":null,"text":null},"quotes":null},"audio_drm3_key":null},"fulfilledTimeStamp":1749762612276},"getSimilarArtsForRecommendation({\"artIDorSlug\":\"book/itzik-ben-gan-210707/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azu-43356262\",\"limit\":24,\"offset\":\"936\"})":{"status":"fulfilled","endpointName":"getSimilarArtsForRecommendation","requestId":"to9kZWQBbufxYsMa9LR_y","originalArgs":{"artIDorSlug":"book/itzik-ben-gan-210707/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azu-43356262","offset":"936","limit":24},"startedTimeStamp":1749762611888,"data":{"pagination":{"next_page":null,"previous_page":"/api/arts/book/itzik-ben-gan-210707/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azu-43356262/similar?limit=24&offset=912"},"data":[],"recommendation_model_version":{"response_model_tag":"not_ranked_top","response_model_name":"not_ranked_top 2025-06-12_22-30-12"}},"fulfilledTimeStamp":1749762611953}},"mutations":{},"provided":{"ArtShortList":{"__internal_without_id":["getSimilarArtsForRecommendation({\"artIDorSlug\":\"book/itzik-ben-gan-210707/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azu-43356262\",\"limit\":24,\"offset\":\"936\"})"]},"Art":{"43356262":["getArtData({\"artIdOrSlug\":\"book/itzik-ben-gan-210707/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azu-43356262\"})"]}},"subscriptions":{"getBanners({\"place\":\"web-header-full-width\"})":{"UDUU9wpOF3ChsKhXHY1Ha":{}},"getArtData({\"artIdOrSlug\":\"book/itzik-ben-gan-210707/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azu-43356262\"})":{"NTCKRqNhvfiHd9TqU3FZR":{}},"getSimilarArtsForRecommendation({\"artIDorSlug\":\"book/itzik-ben-gan-210707/podstawy-jezyka-t-sql-microsoft-sql-server-2016-i-azu-43356262\",\"limit\":24,\"offset\":\"936\"})":{"to9kZWQBbufxYsMa9LR_y":{}}},"config":{"online":true,"focused":true,"middlewareRegistered":true,"refetchOnFocus":false,"refetchOnReconnect":false,"refetchOnMountOrArgChange":false,"keepUnusedDataFor":60,"reducerPath":"rtkqApi"}},"HeadHunterApi":{"queries":{},"mutations":{},"provided":{},"subscriptions":{},"config":{"online":true,"focused":true,"middlewareRegistered":true,"refetchOnFocus":false,"refetchOnReconnect":false,"refetchOnMountOrArgChange":false,"keepUnusedDataFor":60,"reducerPath":"HeadHunterApi"}},"user":{"accountSettings":{"actions":{"changePasswordCSRF":{},"changeProfilePrivacyCSRF":{},"setMarketingConsentCSRF":{}}},"credentials":{"isAnon":true,"userID":"0","userSID":"anonimous-empty-sid","name":"Anonymous","groups":[8,16],"lfrom":"","actions":{"changeCredentialsCSRF":{}}},"balance":{"account":0,"bonus":0,"accountFull":0},"basket":{"inBasket":0,"inDeferred":0,"purchased":0},"library":{},"boughtCollections":{"collections":[]},"notifications":{"isLoading":false,"unreadedCount":0,"allCount":0,"list":[]},"abonement":{"active":false,"price":"399"},"subscription":{"subscriptionClass":[{"id":1,"trial":true,"month":1,"price":"0","pricePerMonth":"0","basePrice":"399"},{"id":2,"trial":false,"month":1,"price":"399","pricePerMonth":"399","basePrice":"399"}],"active":false},"partnersSubscriptions":{"isAnyPartnerSubscriptionActive":false,"isMegafonSubscriptionActive":false,"isRostelecomSubscriptionActive":false,"isYotaSubscriptionActive":false,"isA1SubscriptionActive":false,"isKCellSubscriptionActive":false,"isInlabSubscriptionActive":false,"isTinkoffSubscriptionActive":false,"isLifebelSubscriptionActive":false},"socnet":{"attachedSocnets":[]},"avatar":{"availability":false,"avatarHash":"785","actions":{"uploadAvatarCSRF":{}}},"tests":{},"webpushes":{"status":false},"offers":{"offersList":[]},"actions":{"updateMyRegCSRF":{},"uniteUsersCSRF":{}},"authorization":{"actions":{"checkPassCorrectCSRF":{},"otpinLoginCSRF":{},"loginCSRF":{},"attachSocnetCSRF":{},"socnetCSRF":{},"checkSocnetCSRF":{}}},"registration":{"actions":{"checkEmailAvailabilityGUJ":{},"verifyPhoneCSRF":{},"recoverPasswordCSRF":{},"registrationCSRF":{}}},"rebills":{"list":{},"actions":{"deletePaymentCardCSRF":{},"getRebillsGUJ":{}}}},"foundationUser":{"id":0,"login":"","BSK":[],"LKS":[],"is_staff":false,"isOfficeUser":false,"profile":{"has_folder_arts":false},"account":{"display":0,"real":0,"full":0,"bonus":0},"settings":{"profile_privacy":"default","is_safemode_enabled":null},"socials":[],"library_info":{"title":null,"logo":{},"host":null,"is_school_user":false},"abonement":{"id":null,"is_active":false,"price":null,"rebill_id":null,"valid_till":null,"grace_period_start":null,"gift_arts_refresh_at":null,"payment_system_id":null,"purchase_origin":null},"subscription":{"id":null,"grace_period_start":null,"rebill_id":null,"payment_system_id":null,"purchase_origin":null},"partner_subscriptions":{"has_active":false,"subscriptions":[]},"phone":{},"ab_tests":[],"isLoading":false,"error":{},"isAsking":false,"actions":{"teleport_CSRF":{}},"varioqubTests":{"ymabParam":"","flags":{},"testIds":[],"initialized":false,"initializingError":false,"rawFlagResponse":[]},"loyalty":{"is_loyalty_user":false,"bonuses_info":null},"is_tester":false},"browser":{"screen":{"width":null,"height":null},"urlParams":{},"pda":false,"clientHost":"www.litres.ru","headers":{"client-host":"www.litres.ru","ui-currency":"RUB","Ui-Language-Code":"ru","x-request-id":"2b511733e92fcd75b0795604bc1925bd","Basket":"","Wishlist":""},"isRobot":true},"player":{"data":{"playerSettings":{"url":"","drm3key":"","isPlaying":false,"volume":0.5,"playbackRate":1,"muted":false,"isContentsOpen":false,"downloadForbidden":false,"readOnly":false,"isAnon":true,"isChapterLoading":false,"contentsData":[]},"currentTime":0,"playerData":{"error":null,"event":null,"isReady":false,"loadedTime":0,"duration":0,"totalDuration":0,"isHalf":false,"canBackward":false,"canForward":true,"stats":{"hits":0,"secondsListened":0}}},"notes":{"order":0}},"payment":null,"pages":{"personalCabinet":{"paymentsHistory":{"payments":{"paginator":{"page":0,"limit":0,"maxPageNumber":0,"items":0},"pages":[]},"actions":{"paymentsHistoryCSRF":{}}},"userLibraries":{"libraries":[],"actions":{"teleportCSRF":{},"unsubscribeCSRF":{},"uniteCSRF":{},"uniteCSRFV2":{},"getUserLibrariesCSRF":{}}},"loyaltyCards":{"list":[],"actions":{"changeLoyaltyCSRF":{},"getLoyaltyCardsCSRF":{}}},"spam":{"userChannels":[],"userLangs":[],"actions":{"updateChannelsCSRF":{},"getUserChannelsGUJ":{},"getUserLangsGUJ":{}}},"bonuses":{"bonusExpiration":[],"actions":{"getBonusExpirationGUJ":{}}}},"paymentReceipts":{"receipts":[],"actions":{"getPaymentReceipts":{}}}},"global":{"auth":{"activeStep":"authenticationByEmail","fallbackStep":"init","stepsHistory":[],"formData":{},"isRateLimitError":false},"header":{"auth":{"isAuthPopupVisible":false,"analyticsData":{}},"banners":{"subscr":{"isActive":false},"onlyLitres":{"isActive":false},"promotion":{"isActive":false},"audioSubscr":{"isActive":false},"tvCampaignBanner":{"isActive":false}}},"globalModals":{"visibilityState":"init"},"availableBonuses":{"list":{},"actions":{"getAvailableBonusesListGUJ":{}}},"login":{"authValues":{"code":"","email":"","pwd":"","phoneCode":{"id":"91","tel_codes":[{"tel_mask":"7 XXX XXX XX XX","tel_code":"7"}],"code":"RU","name":"Россия"},"phone":"","otpin":""},"activeStep":"welcome","strategy":"email","isBiblioLogin":false,"isOldUser":false,"isVerifyPhone":false,"isLoading":false,"loginFormat":"email","passRecovery":{"method":"email","isTimerActive":false},"prevSteps":["welcome"],"usersMerges":false,"isLoginReserved":false,"serverError":null},"search":{"query":"","searchResults":[],"history":[],"loading":false,"error":{},"isInitiated":false},"interface":{"loginPopupError":{"isOpen":false},"stickyPlayer":{"isOpen":false},"bookUpsalePopup":{"isOpen":false},"isPageWithPlayer":true,"checkoutBox":{"isOpen":false,"height":0},"helpdesk":{"isOpen":false},"spamTickets":{"isOpen":false,"isHtmlFetched":false},"paymentPopup":{"isOpen":false},"reviewComplainPopup":{"isOpen":false,"id":0},"forceScroll":{"scrollToReviewForm":false,"scrollToReviewId":0},"notRecommendArts":{"arts":[]},"sharingPopup":{"reviewId":0,"userName":"","userId":0,"rating":0,"comment":"","date":"","hasAvatar":false,"isOpen":false,"isReply":false},"headerHeight":0},"lastViewedBooksWidget":{"arts":[],"isLoading":false,"error":null},"phonecodes":{"countriez":"","actions":{"getPhonecodes":{"isLoading":false}}},"onboarding":{"isOpen":false},"genres":{"popup":{"history":[],"currentGenre":null,"isOpen":false}},"arts":{"details":{"xmlProps":null},"reviews":{"list":[],"idMap":{},"sortType":"popular","pagination":{"next":null,"previous":null},"userReview":null,"lastGetRequestDate":"Thu Jun 12 2025 03:25:05 GMT+0000 (Coordinated Universal Time)","actions":{"getArtsReviews":{},"addArtsReview":{},"getUserArtsReviews":{},"addArtReviewLike":{},"removeArtReviewLike":{},"addArtReviewDislike":{},"removeArtReviewDislike":{},"addReviewReply":{}}}},"take":{"take":{"actions":{"takeBookCSRF":{}},"rating":[]}},"reviews":{"actions":{"addReviewComplain":{}},"activeReply":-1},"searchPage":{"query":""},"zeroSearchPage":{"recommendationBlocks":[],"loading":false,"error":{},"isListInitiated":false,"isInfoInitiated":false,"data":{"art_slider":{"data":[],"pagination":{"next_page":null,"previous_page":null},"loading":false},"person_list":{"data":[],"pagination":{"next_page":null,"previous_page":null},"loading":false},"series_list":{"data":[],"pagination":{"next_page":null,"previous_page":null},"loading":false},"tag_list":{"data":[],"pagination":{"next_page":null,"previous_page":null},"loading":false}}}},"face":{"language":"ru","host":null}}

Книги, похожие на «Podstawy języka T-SQL Microsoft SQL Server 2016 i Azure SQL Database», Itzik Ben-Gan