An Introduction to SQL Server 2012
Introduction:
SQL Server 2012 offers a cutting edge platform for enterprise data management, sophisticated development and implementation of modern business intelligence solutions. SQL Server 2012 offers better functionality, performance, scalability and security over previous versions. This course provides the foundational knowledge and skills to maximize the benefits of SQL Server 2012.
This course provides a comprehensive introduction to Microsoft SQL Server 2012. You learn how to use the various administrative and development tools included with SQL Server. In addition, you are introduced to the Microsoft BI stack: SQL Server Integration Services, Analysis Services, and Reporting Services. It will provide you with valuable experience leveraging the capabilities of SQL Server and its accompanying components. This course provides the foundation for all other SQL Server courses.
Course Objectives:
By the end of this course, delegates will be able to:
Who Should Attend?
Programmers, application designers, developers and system architects who design and write Microsoft SQL Server applications and who require an introduction to the big picture of what SQL Server can do, Database administrators looking to explore the capabilities of SQL Server, project managers, data processing professionals who may have many years of experience working with other database systems and who are now moving to the SQL Server world, evaluators of database servers who will be making a decision about whether SQL Server 2012 is right for their organization, those who are new to SQL Server, including database administrators and developers who need a solid foundation in creating SQL Server 2012 databases
Course Outline:
Overview of the SQL Server Suite of Products
· Fundamentals of the relational database engine
· Benefits of the Business Intelligence stack
SQL Server Components and Tools
· SQL Server Agent and Management Studio
· Integration Services
· Analysis Services
· Reporting Services
· Data Quality Services
· Master Data Services
Constructing a Relational Database
· Choosing optimal file size and growth parameters
· Working with database schemas
Defining Tables
· Specifying appropriate data types
· Indexing tables with Management Studio
· Adding, modifying or removing columns
Safeguarding Data with Constraints
· Enforcing uniqueness through primary key constraints
· Validating conditions with check constraints
· Protecting relationships with foreign keys
Retrieving Data with Transact-SQL
· Employing Query Designer to construct select statements
· Analyzing data for aggregate functions
· Retrieving data as an XML document
Modifying Data with SQL Commands
· Inserting new rows into tables
· Updating targeted data
· Deleting specific rows
Developing Programming Constructs
· Creating stored procedures for productivity
· Writing user-defined functions to simplify queries
· Deploying triggers to capture change events
Executing the Maintenance Plan Wizard
· Defragmenting data and checking database integrity
· Improving performance by rebuilding indexes
Automating Administrative Tasks
· Scheduling repeating jobs
· Implementing a backup strategy
Monitoring SQL Server Resources
· Displaying current activity and expensive queries
· Running reports with Management Studio
Securing the Database Infrastructure
· Authenticating SQL Server and Windows logins
· Assigning users to database and server roles
· Granting or revoking permissions
Connecting to Microsoft Office
· Pulling data from SQL Server into Excel
· Creating a front-end interface with Access
Transferring Business Information
· Importing and exporting data from text files
· Migrating an Access database to SQL Server
Extracting Data with Integration Services
· Transforming and cleaning data
· Loading data into a data warehouse
Information Delivery with Reporting Services
· Designing reports quickly with the Report Builder
· Deploying reports for centralized access
Aggregating Data with Analysis Services
· Building multidimensional cubes
· Predicting trends with data mining
Developing a Business Intelligence Strategy
· Leveraging SharePoint, Excel and PowerPivot
· Transferring data into knowledge with BI functionality
| Code | From | To | City | Fees | |
|---|---|---|---|---|---|
| IT13 | 12 Jan 2020 | 23 Jan 2020 | Cairo | US$ 6500 | Register |
| IT13 | 09 Mar 2020 | 20 Mar 2020 | Milan | US$ 8500 | Register |
| IT13 | 04 May 2020 | 15 May 2020 | Amsterdam | US$ 9500 | Register |
| IT13 | 27 Jul 2020 | 07 Aug 2020 | New York | US$ 9000 | Register |
| IT13 | 20 Sep 2020 | 01 Oct 2020 | Doha | US$ 7000 | Register |
| IT13 | 16 Nov 2020 | 27 Nov 2020 | Shanghai | US$ 8500 | Register |
|
DUBAI OFFICE
Ittihad Deira Building, |
USA OFFICE 642 E14 Street,10009-13 Manhattan, New York (NY) USA info@petrogas-training.com |
EGYPT OFFICE 52 General Kamal Hejab Street,Suez Bridge, Cairo, Egypt info@petrogas-training.com |
Certificate of Completion will be provided to the candidate(s) who successfully attend and complete the course. Training hours attendance percentage of 75% is required.
Standard course hours: 8:30 A.M. to 3:30 P.M. Informal discussions: 4:30 P.M. to 5:30 P.M.
We use a blend of interactive and hands-on methods, active participation, a variety of instructional techniques, dynamic presentations, individual and group exercises, in depth discussion, DVD’s, role-plays, case studies, examples. All of the information, competencies, knowledge and skills acquired within our training programs, are 100% transferrable to the participants’ workplace.
Pre-Test and Post-Test Assessment are applied on 5-day and 10-day programs. Also, post course evaluation and candidate’s evaluation are applied to add another level of quality measurement. Candidates’ feedback is highly appreciated to elevate the training service quality.
A- Have staff trained in the latest training and development approaches
B- Support nationalization and talent management initiatives
C- Have properly trained and informed people who will be able to add value
D- Gain relevant technical knowledge, skills and competencies
A- Develop job related skills
B- Develop personal skills in subject matter
C- Have a record of your growth and learning results
D- Bring proof of your progress back to your organization
F- Become competent, effective and productive
G- Be more able to make sound decisions
H- Be more effective in day to day work by mastering job-related processes
I- Create and develop competency to perform job well
A- 10% discount after 05 candidates’ registration.
B- 15% discount after 10 candidates’ registration.
C- 20% discount after 20 candidates’ registration.
D- 25% discount after 25 candidates’ registration.
E- 30% discount after 30 candidates’ registration
F- Higher discount rates will be offered based on work volume with different clients.
A- One extra free seat is offered on 4 candidates on the same course and dates.
B- Two extra free seats are offered on 6 candidates on the same course and dates.
C- Three extra free seats are offered on 8 candidates on the same course and dates.
D- Four extra free seats are offered on 10 candidates on the same course and dates.
E- Five extra free seats are offered on 12 candidates on the same course and dates.
Nominations to our public courses are to be processed by the client’s Training and/or HR departments. A refund will be issued back to the client in the event of course cancellation or seat unavailability. A confirmation will be issued to the relevant department official(s).
If a confirmed registration is cancelled less than 5 working days prior to the course start date, a substitute participant may be nominated to attend the same course or a 20% cancellation charge is applied. In case of a no-show, a 100% fee will be charged.
PAYMENT POLICY
Payment is due upon receiving the course confirmation, invoice and/or proforma invoice. However; the fee due can be wire transferred to our bank account directly after course completion. Our bank details are illustrated on the confirmation, invoice and proforma invoice, as well. The above documents can be communicated electronically, i.e., in a soft copy or/and in hard copy based on customer’s request.
COPYRIGHT
© 2017. Material published by PETROGAS shown here is copyrighted. © 2017. All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing in any medium, transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.