{"product_id":"microsoft-sql-server-training-course","title":"Microsoft SQL Server Training Course","description":"\u003cdiv\u003e\n\u003cp\u003eIn this intro to \u003cstrong\u003eMicrosoft SQL Server® training\u003c\/strong\u003e, you gain the introductory skills to maximize SQL Server's benefits. Learn how to use the various administrative and development tools within SQL Server, including the Microsoft BI (Business Intelligence) stack of Integration Services, Analysis Services, and Reporting Services. \u003c\/p\u003e\r\n\u003cp\u003eSQL Server offers a platform for enterprise data management, robust development, and implementation of modern Business Intelligence solutions. Attend this hands-on course and learn to leverage these features.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eMicrosoft SQL Server Training Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Microsoft SQL Server training, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreate and administer SQL Server databases.\u003c\/li\u003e\n\u003cli\u003eWrite Transact-SQL queries to retrieve and manipulate data.\u003c\/li\u003e\n\u003cli\u003eSecure, back up, and monitor databases with Management Studio.\u003c\/li\u003e\n\u003cli\u003eIntegrate SQL Server with Microsoft Office.\u003c\/li\u003e\n\u003cli\u003eTransform data into strategic information using Business Intelligence components.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eMicrosoft SQL Server Training Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis is SQL Server training for beginners, so no prior experience is needed to take this course. You will learn the basics of SQL Server and gain the introductory skills needed to maximize SQL Server’s benefits.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eMicrosoft SQL Server Introduction Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introducing SQL Server\u003c\/h4\u003e\n\u003cdiv\u003e\n\u003cp\u003eOverview of the SQL Server suite of products\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFundamentals of the relational database engine\u003c\/li\u003e\n\u003cli\u003eBenefits of the Business Intelligence stack\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSQL Server components and tools\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSQL Server Agent and Management Studio\u003c\/li\u003e\n\u003cli\u003eIntegration Services\u003c\/li\u003e\n\u003cli\u003eAnalysis Services\u003c\/li\u003e\n\u003cli\u003eReporting Services\u003c\/li\u003e\n\u003cli\u003eData Quality Services\u003c\/li\u003e\n\u003cli\u003eMaster Data Services\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Building the Database\u003c\/h4\u003e\n\u003cp\u003eConstructing a relational database\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eChoosing optimal file size and growth parameters\u003c\/li\u003e\n\u003cli\u003eWorking with database schemas\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDefining tables\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSpecifying appropriate data types\u003c\/li\u003e\n\u003cli\u003eIndexing tables with Management Studio\u003c\/li\u003e\n\u003cli\u003eAdding, modifying, or removing columns\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSafeguarding data with constraints\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEnforcing uniqueness through primary key constraints\u003c\/li\u003e\n\u003cli\u003eValidating conditions with check constraints\u003c\/li\u003e\n\u003cli\u003eProtecting relationships with foreign keys\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Leveraging Server Programmability\u003c\/h4\u003e\n\u003cp\u003eRetrieving data with Transact-SQL \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying Query Designer to construct select statements \u003c\/li\u003e\n\u003cli\u003eRetrieving subsets of data from multiple tables using joins and the WHERE clause criteria \u003c\/li\u003e\n\u003cli\u003eAnalyzing data for aggregate functions \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eModifying data with SQL commands \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInserting new rows into tables \u003c\/li\u003e\n\u003cli\u003eUpdating targeted data \u003c\/li\u003e\n\u003cli\u003eDeleting specific rows \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIntroduction to developing programming constructs \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating stored procedures for productivity \u003c\/li\u003e\n\u003cli\u003eWriting user-defined functions to simplify queries \u003c\/li\u003e\n\u003cli\u003eDeploying triggers to capture change events \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Administering SQL Server Databases\u003c\/h4\u003e\n\u003cp\u003eExecuting the Maintenance Plan Wizard\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefragmenting data and checking database integrity\u003c\/li\u003e\n\u003cli\u003eImproving performance by rebuilding indexes\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAutomating administrative tasks\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eScheduling repeating jobs\u003c\/li\u003e\n\u003cli\u003eImplementing a backup strategy\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eMonitoring SQL Server resources\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDisplaying current activity and expensive queries\u003c\/li\u003e\n\u003cli\u003eRunning reports with Management Studio\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSecuring the database infrastructure\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAuthenticating SQL Server and Windows logins\u003c\/li\u003e\n\u003cli\u003eAssigning users to database and server roles\u003c\/li\u003e\n\u003cli\u003eGranting or revoking permissions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Integrating External Applications\u003c\/h4\u003e\n\u003cp\u003eConnecting to Microsoft Office\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePulling data from SQL Server into Excel\u003c\/li\u003e\n\u003cli\u003eCreating a front-end interface with Access\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTransferring business information\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImporting and exporting data from text files\u003c\/li\u003e\n\u003cli\u003eMigrating an Access database to SQL Server\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Implementing Business Intelligence Solutions\u003c\/h4\u003e\n\u003cp\u003eExtracting data with Integration Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTransforming and cleaning data\u003c\/li\u003e\n\u003cli\u003eLoading data into a data warehouse\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eInformation delivery with Reporting Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDesign reports quickly with the Report Builder\u003c\/li\u003e\n\u003cli\u003eDeploying reports for centralized access\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAggregating data with Analysis Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding multidimensional cubes\u003c\/li\u003e\n\u003cli\u003ePredicting trends with data mining\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDeveloping a Business Intelligence strategy\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLeveraging Excel and Power Pivot\u003c\/li\u003e\n\u003cli\u003eTransferring data into knowledge with BI functionality\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B58US \/ 2026-07-14T09:00:00 \/ Herndon, VA","offer_id":47534212219099,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269B02US \/ 2026-09-15T09:00:00 \/ Herndon, VA","offer_id":47595015635163,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"268A86CN \/ 2026-08-18T09:00:00 \/ Ottawa","offer_id":48216552669403,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BC78US \/ 2026-11-17T09:00:00 \/ Herndon, VA","offer_id":48216552702171,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26CA30CN \/ 2026-12-15T09:00:00 \/ Ottawa","offer_id":48216552734939,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"272B82US \/ 2027-02-16T09:00:00 \/ Herndon, VA","offer_id":48266084843739,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273A34CN \/ 2027-03-16T09:00:00 \/ Ottawa","offer_id":48377302155483,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275C56US \/ 2027-05-18T09:00:00 \/ Herndon, VA","offer_id":48780665159899,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/microsoft-sql-server-training-course","provider":"Learning Tree International","version":"1.0","type":"link"}