ORACLE & SQL: High-Performance Training & Implementation Solutions
SUCCESSFULLY DEVELOP & MANAGE YOUR ORACLE OR SQL DATABASES By Creating Alignment Between People, Organisational Processes & Technology
PEOPLE
PROCESS/ POLICY
TECHNOLOGY
A Holistic Approach to Optimise Your Workforce
Comprehensive Oracle & SQL Learning Paths
High-Performance Training & Implementation Solutions
Learn more
Learn more
Learn more
Presenting Learning Tree and Microsoft Official Content
BUILD ROBUSTLY. AND SCALE INTELLIGENTLY. 46%
10%
32%
Of IT decision makers report their BI structures rarely or never incorporate a formal, data quality program that includes data quality scorecards.
The increase in usability of and accessibility to data that translates to significant boosts in productivity and sales for the median Fortune 1000 company.
Of Web Applications are affected by SQL injection. – Barricade
– Sybase
– IDO Research
ORACLE
SQL SERVER
Oracle and SQL Server are both relational databases management systems that will provide a robust and reliable data platform for your business-critical applications and decision support systems. They have many similar features, but they have a few differing features and functionality:
SQL LANGUAGE
TRANSACTION CONTROL
INSTANCE DATABASE SCHEMA
DIFFERENT TOOLS
SQL SERVER DOES RUN ON LINUX
Oracle and SQL Server have similar, but not identical, implementations of ANSI/ISO Structured Query Language (SQL).
By default, SQL Server has implicit transactions. In Oracle, nothing is committed until someone explicitly commits them.
These have different meanings in Oracle and SQL Server.
SSMS vs SQL*Plus Until the latest version of and SQL Developer. SQL Server (SQL Server 2016) SQL Server only runs on Windows. Going forward into 2017, SQL Server will run on different flavors of Linux.
READ MORE: BLOG.LEARNINGTREE.COM/UK/ORACLEvsSQL
Optimise Your Oracle or SQL Workforce by Creating Alignment Between People, Processes & Technology PEOPLE
PROCESS/POLICY
TECHNOLOGY
Your database is only as good as the people (and training) behind it. Our Oracle and SQL learning solutions empower your staff and management with best practices and practical skills to build and maintain a robust and reliable data platform for your business-critical applications and decision support systems.
Change doesn’t work in a vacuum. Evolving your database approach has enterprise-wide impact, so our training curriculum includes helping you assess, prepare, and implement process and policy updates for your organization. We help supply your team with readily understood, clearly defined processes to ensure a seamless solution, better data management, and more relevant insight.
While Oracle and SQL Server have many similar features, each technology has its own differing features and functionality. With Learning Tree, you’ll learn the subtle differences in SQL language, transaction control, instance database schema, tools, and OS requirements – and help determine the best approach for your organization.
A HOLISTIC APPROACH TO OPTIMISE YOUR WORKFORCE
DEFINE
Organisational Structure, Processes & Job Roles
ENHANCE
ASSESS/MAP
Knowledge, Skills & Abilities (KSAs)
Knowledge, Skills & Abilities (KSAs)
IMPLEMENT
Process & Organisational Improvements
› Based on your specific
Oracle/SQL needs, our experts will ensure your workforce is equipped with a clear objective for the capability you intend to achieve
› Create a clear business plan that establishes the goal and vision of your Oracle/SQL adoption fit for your specific context
› Establish the necessary
ORACLE & SQL ACCELERATION WORKSHOPS
cultural, mindset and behavior changes for successful Oracle/SQL transformations
› Develop a customised
Oracle/SQL curriculum with individual learning plans to meet the needs of your staff and organization
› Align the Knowledge,
Skills and Abilities (KSAs) of your workforce to your immediate, short-term, and long-term business goals
› Provide program
› Determine the KSAs
of your existing staff and identify skill gaps using automated skills assessments
management of the Oracle/SQL training, coaching and mentoring of your staff
•C reate basic query select statements for improved performance • Protect sensitive data through encryption • Integrate data between Oracle and SQL Server •E nable analytics across the enterprise to deliver insights •E valuate and deploy big data solutions to extract value from your data
› Rapidly increase
the process maturity of your staff with customised Oracle/ SQL Acceleration Workshops
› Embed our expert
instructors to help your staff apply newly acquired Oracle/SQL skills on the job
Learning Tree’s Comprehensive Oracle & SQL Lea
To help you advance your Oracle/SQL knowledge and skills related to your job roles, Learning Tree has structured learning paths us Microsoft Official Content. Additionally, these paths also recommend related courses that help you implement, manage and enhanc
KNOWLEDGE AREA
FOUNDATION }R elational Database Design, Tools and Techniques Course 382 • 4 Days
IT Managers and Business Analysts
} I ntroduction to SQL Programming Training Course 925 • 3 Days }R elational Database Design, Tools and Techniques Course 382 • 4 Days }S QL Programming Language Introduction Course 925 • 3 Days
Database and System Administrators
}W riting SQL Queries Course 4551 • 1 Day }O racle Database 12c Introduction Course 2226 • 5 Days
}R elational Database Design, Tools and Techniques Course 382 • 4 Days
Developers, Programmers, and Data Processing Professionals
}S QL Programming Language Introduction Course 925 • 3 Days
}O racle Database 12c Introduction Course 2226 • 5 Days
}O racle Database 12c Administration Course 2227 • 5 Days
} Administering Microsoft SQL Server 2014 Databases (20462) Course 8464 • 5 Days
}P owerful SQL Queries for SQL Server Course 4559 • 1 Day
} I ntroduction to SQL Databases (10985) Course 8426 • 3 Days
}W riting Stored Procedures Course 4563 • 1 Day } Transact-SQL Querying Training (20761) Course 8420 • 5 Days
}O racle Database 12c Introduction Course 2226 • 5 Days
}O racle PL/SQL Programming Course 493 • 5 Days
}P erformance Tuning and Optimizing SQL Server 2016 Databases (10987) Course 8428 • 4 Days
} Powerful SQL Queries for SQL Server Course 4559 • 1 Day
} I ntroduction to SQL Server 2016 Databases (10985) Course 8426 • 3 Days
}R elational Database Design, Tools and Techniques Course 382 • 4 Days
} Introduction to SQL Server 2016 Databases (10985) Course 8426 • 3 Days
}W riting SQL Queries Course 4551 • 1 Day
} Report Development with SQL Server Reporting Services Course 4556 • 1 Day
} Updating Your Skills to SQL Server 2016 (10986) Course 8427 • 3 Days
}W riting SQL Queries Course 4551 • 1 Day
}S QL Programming Language Introduction Course 925 • 3 Days
Business Intelligence (BI) Analysts
} Writing SQL Queries Course 4551 • 1 Day
INTERMEDIATE
} SQL Server Reporting Services: Analyzing Data with SSRS (10990) Course 8431 • 3 Days } Managing SQL Server 2016 Business Intelligence Operations (10988) Course 8429 • 3 Days
}W riting Stored Procedures Course 4563 • 1 Day
}R eport Development with SQL Server Reporting Services Course 4556 • 1 Day }A nalyzing Data with Power BI (20778) Course 8430 • 3 Days } Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (20467) Course 8469 • 5 Days
TO LEARN MORE, VISIT LEARNINGTREE.CO.UK/ORACLE, LEARNINGTREE.CO.UK/SQL OR CALL 0800 282 353
} Introduction to SQL Server 2016 Databases (10985) Course 8426 • 3 Days
} Administering a SQL Server 2016 Database Infrastructure (20764) Course 8422 • 5 Days } I mplementing a SQL Server 2016 Data Warehouse (20767) Course 8424 • 5 Days }D esigning Solutions for Microsoft SQL Server 2014 (20465) Course 8467 • 3 Days }D esigning and Implementing Cloud Data Platform Solutions (40441) Course 8486 • 3 Days }Q uerying SQL Server 2016 Data with Transact-SQL (20761) Course 8420 • 5 Days }Q uerying Microsoft SQL Server 2014 (20461) Course 8463 • 5 Days } Developing Microsoft SQL Server 2014 Databases (20464) Course 8466 • 5 Days } Implementing Data Models and Reports with Microsoft SQL Server 2014 (20466) Course 8468 • 5 Days } Querying SQL Server 2016 Data with Transact-SQL (20761) Course 8420 • 5 Days } Implementing a SQL Server 2016 Data Warehouse (20767) Course 8424 • 5 Days
arning Paths
sing both Learning Tree and ce your organisations Oracle/SQL Environment.
LOOKING TO EARN YOUR DATA MANAGEMENT & ANALYTICS MCSA OR MCSE CERTIFICATION? If you are currently working towards your data management & analytics MCSA or MCSE, Learning Tree can help with these courses below.
TO PREPARE FOR:
ADVANCED }M DX Query Fundamentals Course 4567 • 1 Day
}D eveloping SQL Queries for Oracle Databases Course 234 • 4 Days
}S QL Server High Availability Training Course 141 • 3 Days
}S QL Server Database Development (20762) Course 8421 • 5 Days
}O racle Database 12c Backup, Recovery and Server Tuning Course 2228 • 5 Days
} Provisioning SQL Server 2016 Databases (20765) Course 8423 • 3 Days
MCSA SQL SERVER 2012/2014
MCSA SQL 2016 DATABASE DEVELOPMENT
} Developing SQL Server 2016 Databases (20762) Course 8421 • 5 Days
} Developing SQL Queries for Oracle Databases Course 234 • 4 Days
}A dministering Microsoft SQL Server 2014 Databases (20462) Crs 8464
} Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463) Crs 8465
} T ransact-SQL Querying Training (20761) Crs 8420
}S QL Server Database Development (20762) Crs 8421
MCSA SQL 2016 DATABASE ADMIN
}A dministering a SQL Server 2016 Database Infrastructure Training (20764) Crs 8422
}P rovisioning SQL Databases (20765) Crs 8423
MCSA SQL 2016 BI DEVELOPMENT
} I mplementing a SQL Server 2016 Data Warehouse (20767) Crs 8424
}D eveloping SQL Server 2016 Data Models (20768) Crs 8425
}D eveloping Microsoft SQL Server 2014 Databases (20464) Crs 8466
}D esigning Business Intelligence Solutions with Microsoft SQL Server 2014 (20467) Crs 8469
MCSE ELECTIVES
} Developing High-Performance SQL Server Databases Course 535 • 5 Days
}M icrosoft SQL Fundamentals Training (20461) Crs 8463
} I mplementing Data Models and Reports with Microsoft SQL Server 2014 (20466) Crs 8468
See the full list of Microsoft Courses that you can redeem using your Microsoft Software Assurance Training Vouchers. Learn more at:
info.LearningTree.co.uk/Microsoft-SATVs
FEATURED EXPERT INSTRUCTORS: Real-World Oracle/SQL Practitioners } MDX Query Fundamentals Course 4567 • 1 Day }D eveloping SQL Server 2016 Databases (20762) Course 8421 • 5 Days
} Developing SQL Server 2016 Data Models (20768) Course 8425 • 3 Days } I mplementing a Data Warehouse with Microsoft SQL Server 2014 (20463) Course 8465 • 5 Days
JASON ARCHAMBEAU
Founder and Principal Consultant for Jthomas Enterprises and Learning Tree Technical Instructor Jason has 26 years of database experience with an emphasis on Oracle — going back to Oracle 6 — running on a wide range of operating systems, including UNIX, Linux, Mac OS X, Windows, and Novell. He worked for the United States Air Force as an Applied Sciences Technician from 1990 to 1999 with a focus on materials technology integration with information systems.
SHARON DOOLEY
SQL Principal Consultant and Learning Tree Instructor and Author Sharon has specialized in designing high-performance Microsoft SQL Server databases for more than 25 years. She is a Microsoft Certified Professional and graduated from the University of Pennsylvania with a bachelor’s degree in Computer and Information Science magna cum laude. She is the author of two books on Database Administration, one from WordPress and the other from New Riders.
TRANSFORMING ORGANISATIONS’ PEOPLE • PROCESSES • TECHNOLOGY TECHNOLOGY BRANDS Adobe
IBM
Oracle
Salesforce
AWS
Lean Six Sigma
Red Hat
VMware
Cisco
Microsoft
IT & MANAGEMENT TRAINING TOPICS Agile & Scrum
Cyber Security
Linux & UNIX
SharePoint
Apple Programming
DevOps
Microsoft Office
Software Development
Azure
FAC P/PM
Mobile App Development
SQL Server
Big Data & Data Science
ITIL®, COBIT® & TOGAF®
.NET / Visual Studio
Web Development
Business Analysis
ITSM Certification Training
Networking & Virtualisation
Windows Training
Business Intelligence
Java Programming
Project Management
Cloud Computing
Leadership & Professional Development
Python, Perl & C++
Communication Skills
Trusted Partner for 60,000+ Organisations
600+ Expert Advisors
Demonstrated Past Performance
serving national and multinational corporations, government agencies, education and non-profits
serving our global customer footprint and averaging 20+ years of diverse real-world experience
in offering end-to-end proven capabilities to provide all facets of Workforce Optimisation resulting in improved organisational alignment
UK1903 Oracle/SQL
LEARN MORE AT: LEARNINGTREE.CO.UK
ITIL®, PRINCE2®, and PRINCE2 Agile® are registered trade marks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved. COBIT® is a registered trademark of Information Systems Audit and Control Association® (ISACA®). IIBA® is a registered trademark owned by International Institute of Business Analysis. CBAP® and CCBA® are registered certification marks owned by International Institute of Business Analysis. PMI, PMP, CAPM, PMI-ACP, and PMI-PgMP are marks of the Project Management Institute, Inc.