Introducere curs SQL Server
Acest curs de trei zile, condus de instructor, vizeaza profesionistii sfera bazelor de date care gestioneaza operatiunile Business Intelligence (BI). Acest curs analizeaza diferite optiuni care ofera abilitatatea utilizatorilor de afaceri de a analiza datele si de a-si impartasi constatarile, pornind de la sursele de date BI gestionate si extinderea la sursele de date personale si externe / publice.
La absolvirea cursului SQL Server vei sti:
- Describe the rationale for BI operations.
- Describe roles in BI operations.
- Describe the technologies used in BI operations.
- Describe environments and operational standards.
- Describe the importance of standardized builds.
- Describe the configuration considerations for BI technologies.
- Describe BI architectures.
- Describe the security approach to a BI solution.
- Understand the security components available.
- Apply the security components to BI technologies.
- Manage security in different environments
- Application life cycle management for BI solutions.
- Stand-alone deployments.
- Team-based deployments.
- Describe the need for logging and monitoring.
- Use various logging options.
- Use monitoring tools.
- Set up notifications.
- Failed BI solutions.
- Data Warehouse.
- Analysis Services.
- Reporting Services.
- Understand the need for performance tuning.
- Describe the BI queries required to carry out performance tuning.
- Use the tools for performance tuning.
Agenda cursului SQL Server
Module 1: Introduction to Operational Management in BI Solutions
Module description
Operational management of BI solutions is on the increase. An organization’s need for information, coupled with the timely delivery of this information, means that IT departments are placing as much emphasis on operational frameworks to support BI solutions, as they are on the development outcomes. With the development of BI solutions complete, the right processes and people should be in place to ensure that the solution delivers. You should also use supporting technologies to ensure smooth operations. Furthermore, developing a supporting logging and troubleshooting framework can aid the debugging and resolution of BI issues. The aforementioned are brought together within a single operational management framework that enables a cohesive and proactive approach to managing the BI solution in the production environment. It also ensures the continued operation of the solution, while providing a structured approach to solving BI issues.
Lessons
- Rationale for BI Operations
- Roles in BI Operations
- Technologies Used in BI Operations
- Environment and Operational Standards
Lab:
Introduction to Operational Management in BI Solutions
- Roles in BI Operations
- Using Term Explorer in Visual Studio
Module 2: Configuring BI Components
Module description
The correct configuration of the BI components within the SQL Server product stack will have a big impact on the stability and performance of the overall BI solution. Configuring components by using best practice will enable the BI operations team to rule out the data platform as a root cause of issues that occur within the environment. Defining standards for server builds can help the effectiveness of the team to resolve issues in a known configured environment. Equally, understanding the type of architecture that a BI solution is implemented in will drive the standards for a given architecture.
Lessons
- The Importance of Standardized Builds
- Configuration Considerations for BI Technologies
- BI Architectures
- SharePoint BI Environments
Lab:
Configuring BI Components
- Standardizing the Data Platform
- Configuring the Operating System
- Configuring the Database Engine
- Configuring Reporting Services
Module 3: Managing Business Intelligence Security
Module description
Managing the security of data within an organization should be the first priority for any operational team. Not only could the ramifications of a data leak lead to commercial losses, but there may also be legal and financial penalties that could have wider implications for the business. It is very important that the business intelligence (BI) operations team takes a holistic approach to securing the data. Considerations should include the physical security of the data, in addition to protection at an operating system or SQL Server level. Transfer of data to other sites and data at rest may have to be protected. In these cases, encryption components come into play. Meeting compliance requirements may force a business to track activity on SQL Servers, or provide access to data by using auditing.
Lessons
- Security Approach to BI Solutions
- Security Components
- Security Approach for BI Components
- The Security Approach in Different BI Environments
Lab:
Managing Business Intelligence Security
- Setting up Security in SQL Server
- Setting up Security in SQL Server Analysis Services
- Setting up Security in SQL Server Reporting Services
Module 4: Deploying BI Solutions
Module description
Deploying BI solutions is a discrete part of the BI development life cycle. The BI operations team will be called upon to support the development team during the deployment. The aim is to successfully create the solution within a production environment for operational use. The presence of nonproduction environments provides the opportunity to practice the deployments before they are conducted on a production server, so that the deployments can run smoothly. A variety of tools and practices can be used to aid deployments. Each method has its own benefits and can be used in any environment. Understanding the tools that are available and the benefits they offer will help you to pick the right tool for the job and aid deployment.
Lessons
- Application Life Cycle Management for BI Solution
- Stand-Alone Deployments
- Team-Based Deployments
Lab:
Deploying BI Solutions
- Creating a Standalone DACPAC
- Managing Builds in Team Foundation Server
- Exploring Deployment Methods
Module 5: Logging and Monitoring in BI Operations
Module description
The main aim of any operations team is to ensure the continued service of key applications that are used within the business—more organizations are seeing a BI solution as a critical application for ensuring success. Therefore, the BI operations team should implement a proactive approach to overseeing the general health of the servers and services that are being used. This will involve employing a number of technologies that can log the operations of a service to proactively manage any potential problems that are identified. There will be times when the BI operations team will have to be reactive, using monitoring tools to help identify the root cause of any potential issues.
Lessons
- The Need for Logging and Monitoring
- Logging Options
- Monitoring Options
- Setting Up Alerts
Lab:
Monitoring BI Solutions
- Setting Up General Logging and Monitoring
- Setting Up Targeted Logging and Monitoring
Module 6: Troubleshooting BI Solutions
Module description
The task of trying to troubleshoot failed BI solutions can be complex. It requires an understanding of the environments in which the BI solution is hosted, and an understanding of the workloads that take place during the life cycle of the solution. Troubleshooting can be made easier if the BI operations team has established defined standards for different tiers of servers for the configuration, security, and deployment of the solution. Standards create a baseline environment for the servers and the solution so that the BI operations team have a clear understanding of the environment that they are troubleshooting. With this in place, when an issue is reported to the operations team, they can adopt a structured troubleshooting approach that means they can resolve the issue, and understand the root cause—this leads to a long-term fix. As these issues are occurring within live environments, it is prudent to follow a process that is in line with operational procedures, so that you set the expectations for resolving an issue. This will typically involve applying a fix that follows either standard operating procedures or emergency operating procedures.
Lessons
- Troubleshoot Failed BI Solutions
- Troubleshooting the Data Warehouse
- Troubleshooting SQL Server Analysis Services
- Troubleshooting SQL Server Reporting Services
Lab:
Troubleshooting BI Solutions
- Troubleshooting Data Warehouse Loads
- Troubleshooting SQL Server Analysis Services
Module 7: Performance Tuning BI Queries
Module description
In this course, you have seen many of the operational activities that take place in an organization—they will often lead to the provision of a long-term solution to an issue that has been occurring in a BI environment. Sometimes, however, changes to resolve an issue that are made by the BI operations team, such as optimizing the BI platform, may not have the desired results. When the BI operations team are satisfied that they have exhausted all areas in attempting to resolve an issue, they might need to work with the development team to look at tuning the query aspects of the BI solution to improve performance. Many BI operations make extensive use of queries, and it might be necessary to look at these queries in more depth to improve performance. The BI operations team would also have to discuss taking advantage of BI component features to help in performance. For example, a suggestion might be made that Reporting Services snapshots could be used to help performance. However, the development team would need consulting to understand the impact of using such functionality on the overall solution.
Lessons
- The Need for Performance Tuning
- BI Queries to Performance Tune
- Tools for Performance Tuning
- Remediating Performance Issues
Lab:
Performance Tuning a BI Solution
- Performance Tuning BI Queries
- Exploring SQL Server Query Store
- Remediating Performance Issues
Certificarile oferite
- Interna, tiparita, care atesta absolvirea cu succes a cursului (emitent IT Learning)
- Online, download, care atesta sustinerea cu succes a examenelor online (emitent IT Learning)
- Nationala (calificare “Operator introducere, validare si prelucrare date – cod COR 411301”), in urma examenului sustinut in fata comisiei ANC (emitent Agentia Nationala pentru Calificari, Min. Educatiei si Min. Muncii)
- Europeana, in urma sustinerii examenelor aferente (emitent ECDL)
- Internationala, in urma sustinerii examenului Microsoft Office Specialist – Excel – Core/Expert/Master (emitent Certiport – USA)
Standard de calitate
Conform insusi principiului de baza al Sistemului de management al calitatii, implementat de IT Learning, obiectivul nostru este satisfactia clientului. Pentru atingerea acestui obiectiv, evaluarea calitatii serviciilor livrate este esentiala.
In acest sens va incurajam sa folositi orice cale si metoda de comunicare (feedback la cald si la rece, testimonial scris, telefon, e-mail, blog, forum, retele sociale etc.), pentru a va exprima, nu atat satisfactia pentru calitatea serviciilor noastre, care reprezinta in fapt angajamentul nostru ferm, asumat prin contract, cat mai ales, daca este cazul, insatisfactia de orice fel privind prestatia noastra, care ne va ajuta sa imbunatatim standardul acestor servicii, in beneficiul dvs.
Ce include taxa de participare la curs
Taxa de participare include serviciile de instruire in clasa, cu instructori certificati Microsoft, precum si urmatoarele beneficii, unice in Romania, oferite exclusiv de IT Learning:
- Evaluarea initiala a nivelului dvs. de cunostinte si abilitati, prin completarea online a unui chestionar;
- Suportul de curs in format electronic (manualul “Step by step”, in limba romana, in format text, plus capturile de ecran aferente si prezentarile din timpul cursului in format PowerPoint, precum si workshop-urile de la curs);
- Access pe cel mai mare portal e-learning www.office-learning.ro, dezvoltat de trainerii si consultantii IT Learning, pentru o perioada de 12 luni;
- Evaluarea finala a cunostintelor si abilitatilor practice dobandite in urma absolvirii cursului, prin rezolvarea unui exercitiu complex, in cadrul unui workshop;
- Certificatul de participare, care atesta absolvirea cu succes a cursului;
- Raportul de evaluare, redactat de trainer, in care va fi consemnat progresul dvs., comparand nivelul initial de abilitati, cu cel final;
- Consultanta post-instruire, prin intermediul forumului Comunitatii utilizatorilor MS Office din Romania, in calitatea dvs. de membru.
Inscriere / Facturare / Plata / “Money back guarantee”
- Daca sunteti persoana fizica, sau grup de maxim 5 participanti din partea unei companii, va puteti inscrie doar in clasele noastre deschise, anuntate pe site la pagina “Calendar Cursuri Open“
- Rezervarea locului / locurilor in sala de curs Open se face telefonic (0787.692.238) sau prin e-mail la adresa , in reply urmand sa primiti fisa de inscriere care trebuie completata de dvs. si retrimisa noua impreuna cu datele de facturare
- Urmeaza emiterea facturii, pe care o veti primi tot pe e-mail, in baza careia urmeaza sa efectuati plata (transfer bancar sau depunere numerar in contul IT Learning) si sa ne trimiteti confirmarea aferenta
- Veti primi la randul dvs. confirmarea noastra ferma ca sunteti inscris(a) la cursul respectiv, impreuna cu detaliile organizatorice (orarul cursului, coffee-break, pauza de pranz etc.)
- Urmeaza livrarea cursului, iar la finalul acestuia completarea feedback-ului, conform formularului de evaluare , in baza caruia se poate invoca clauza “Money back guarantee”: “In cazul obtinerii unui nivel de satisfactie mai mic de 75 % , reflectat de formularul de feedback, garantam returnarea taxei de participare sau reluarea cursului fara nici un cost”.
- Daca sunteti persoana juridica si doriti inscrierea unui grup de peste 5 participanti, vom formula o oferta personalizata cu discount de volum, exclusiv pentru compania dvs., conform specificatiilor primite telefonic, prin fax (0371.602.780) sau pe e-mail la adresa
- Dupa acceptarea ofertei (livrabile, costuri, agenda, perioada si locatia organizarii cursului) urmeaza etapa contractuala
- Odata agreata forma finala a contractului de legal-ul partilor, urmeaza semnarea si livrarea efectiva a serviciilor convenite, a caror facturare si plata se va face numai dupa primirea feadback-urilor completate de absolventi la finalul instruirii si numai in virtutea clauzei “Money back guarantee”:”In cazul obtinerii unui nivel de satisfactie mai mic de 75 % , reflectat de formularului atasat , garantam renuntarea la contravaloarea instruirii sau reluarea cursului cu alt trainer, fara nici un cost aditional”)