SQL Courses

... And Services • Automatic Workload Repository (AWR) • The Benefits of Automatic Database Replay Session 20: DATABASE PERFORMANCE BY SQL TUNING • Application... Learn about: Database training...

... processing Internal working of above utilities Using utilities TPT FastLoad, and MultiLoad. TERADATA SQL Primary keys, Foreign keys in a Teradata system...

... your teeth into. It ranges from Oracle to Microsoft's SQL (Structured Query Language) to .NET. Designed for people already working the field of programming or database design, this package allows you to pick which modules you want to practice on and complete. It's also ideal for programmers... Learn about: Windows Server, Database training...

...Syllabus: Section 1: Introduction Unit 1.1 - Introduction Unit 1.2 - Datasheet View Section 2: Databases and SQL Unit 2.1 - Linking to Other Access... Learn about: Splitting a Database, Web Apps, Microsoft Access...

... Express to manage database objects and in administering the Oracle Application Express environment. The delegate will practice: Developing an Apex Web ApplicationUsing the Apex SQL WorkshopCreating ReportsCreating FormsUsing Page Designer to manage Web Pages and Regions in the Apex ApplicationUsing... Learn about: Javascript training, Database training...

... Types Configure web apps Deploying web apps from visual studio Debugging Monitoring and Diagnosis SQL Database Introduction SQL Servers Creating... Learn about: Database training, Network Training...

... system views for improved system managementIn addition, you will get a brief overview of Unicode support, SQL changes and upgrade paths... Learn about: IT Management...

... in Database Administration. The courses in this bundle cover a variety of technologies, ranging from SQL to Oracle. The data explosion is happening across almost every business, to include applications, and individual roles. Certification, especially in Microsoft, has risen swiftly in importance over the... Learn about: Core Solutions, Database Administration, Server 2013...

... also explains how to manage Microsoft Azure by using the Azure portal, Visual Studio, and SQL Server Management Studio. In addition, the module describes... Learn about: Active Directory, Database training...

... subject types • Identify the effects of modifying query subjects on generated SQL • Specify two types of stored procedure query subjects • Use prompt values... Learn about: IT Security...

... This course is intended for IT Professionals already experienced in general Windows Server and Windows Client administration or already experienced in administering and supporting Application servers and services including applications such as Exchange, SharePoint, and SQL. System, Infrastructure and Application... Learn about: Windows Server, XML training...

...Oracle Essbase terminology Overview of steps required to use Cognos Integration Server The Connection Manager Sources and targets Create a connection Connection... Learn about: Financial Training...

... Tools Introducing Oracle Database Management Tools Using SQL*Plus Using SQL Developer Logging in to Oracle Enterprise Manager Database Express Using... Learn about: Database training, Network Training...

... query subjects Identify the effects on generated SQL when modifying query subjects, SQL settings and relationships Set Security in Framework Manager... Learn about: IT Security...

... CodeInstall and Test MySQLBasic SQL SyntaxConnect to a MySQL Database with Error CheckingUse PHP to Interact with a MySQL DatabaseUtilise PHP with the HTML EnvironmentWork with Email and CookiesConsider Security Implications when using PHP and MySQL... Learn about: Web Development, Database training...

... accelerator backups, and security. This course also covers using NetBackup to manage Oracle, Microsoft Exchange, Microsoft SQL, and Microsoft SharePoint database backups... Learn about: Database training, Microsoft Exchange...

..., and diagnosis and tuning of SQL-related performance issues.Learn To:Use the Oracle tuning methodology.Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.Use database advisors to proactively correct performance problems.Identify and tune problem SQL statements.Monitor... Learn about: Database training, Performance Management...

... 11g Release or Oracle Database 12c. The delegate will practice: Tuning database applications for optimal performanceIdentifying and resolving common tuning problemsUsing diagnostic sourcesManaging database statisticsIdentifying and correcting problem SQL statementsExamining the execution plan of a... Learn about: Database training...

... of three months programming experience and have basic Windows navigation skills.This course is intended for anyone responsible for analyzing data with Excel. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data. Learning Objectives... Learn about: MS Excel, Database training, Data analysis...

... will have had exposure to: TFS editions and componentsSupported topologies and environmentsMust-have TFS administration toolsHardware and software requirementsRequired service accounts and permissionsInstalling Team Foundation ServerConfiguring Team Foundation ServerManaging relevant SQL Server componentsManaging... Learn about: MS Excel, Team Training...