SQL Courses

...Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational... Learn about: Database Design, Database training...

...Oracle Forms, a component of Oracle Apps Middleware, is used for creating screens that interact with an Oracle database. Oracle Forms has an IDE including an object navigator, property sheet and code editor that uses PL/SQL. Oracle Forms is a long-established technology to design and build... Learn about: Monitoring Application Data, Icons in Form Builder, Default Deployment...

.... Along with that, you will get an introduction to the BigInsights value-add including Big SQL, BigSheets, and Big R. The second module is IBM Open Platform with Apache Hadoop. IBM Open Platform (IOP) with Apache Hadoop is the first premiere collaborative platform to enable Big Data solutions...

...An introduction to sabermetrics, baseball analytics, data science, the R Language, and SQL. With an apprenticeship you earn while you learn, you gain recognized qualifications, job specific skills and knowledge and this helps you stand out in the job market.With this course you earn while you learn... Learn about: R Language, Data science...

... EMR clusterLaunch and configure an Amazon EMR clusterLeverage common programming frameworks available for Amazon EMR including Hive, Pig, and StreamingLeverage Hue to improve the ease-of-use of Amazon EMRUse in-memory analytics with Spark and Spark SQL on Amazon EMRChoose appropriate AWS data storage...

... Accessing Data Using ADO.NET­ - Part 1 1.4 Accessing Data Using ADO.NET­ - Part 2 1.5 Accessing Data From Web Service 1.6 SQL Server Database In Azure 1... Learn about: Database training, SQL Database...

... specialized modules with value-add that sits on top of the IOP. Along with that, you will get an introduction to the BigInsights value-add including Big SQL, BigSheets, and Big R.The second module is IBM Open Platform with Apache Hadoop. IBM Open Platform (IOP) with Apache Hadoop is the first premiere...

...Relational databases are a powerful tool used throughout the industry. Learn the basics of SQL and how to connect your Python code to a relational database... Learn about: Database training...

... ways to change the performance. This will include the use of statistics, outlines, and profiles to influence the optimizer, adding and rebuilding indexes, and using the SQL Advisors. A major task of DBA's is to maintain SQL performance across changes. This course introduces the DB Replay, and... Learn about: Database training, Monitoring Tools...

...-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs... Learn about: Oracle Architecture, Sorting Data, Database training...

... and Manage Blobs Module 2: Microsoft Azure Databases Understand Relational Database Deployment Options Create and Connect to SQL Databases Lab : Create a... Learn about: Active Directory, SQL Database, Database training...

... to:Install 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: Database training, Web Development...

...This offering teaches IBM Cognos Framework Manager data modelers how to use some of the advanced capabilities in the product. Participants will learn how to make use of advanced generated SQL and complex queries. They will also learn about advanced parameterization techniques, such as prompt macros...

... EMR clusterLaunch and configure an Amazon EMR clusterLeverage common programming frameworks available for Amazon EMR including Hive, Pig, and StreamingLeverage Hue to improve the ease-of-use of Amazon EMRUse in-memory analytics with Spark and Spark SQL on Amazon EMRChoose appropriate AWS data storage...

...This course teaches developers, database administrators, and system programmers various features of SQL, including object creation and alteration, views, advanced queries, and analytic constructs. Note: Guided eLearning is a self-paced offering which includes web-based content for self-study...

...Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational... Learn about: Database Design, Database training...

... on a MySQL database. The delegates will practise: Using advanced features of the MySQL ClientUsing advanced data typesManaging the structure of databases and tablesManaging and using indexesWriting complex SQL query statementsUsing advanced SQL expressionsUsing advanced SQL functionsPerforming advanced... Learn about: Database training...

... to:Install 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: Database training, Web Development...

... of Database Replay Managing Performance by SQL Tuning SQL Tuning and SQL Advisors Using SQL Tuning Advisor SQL Access Advisor SQL Performance Analyzer Overview... Learn about: Database training...

... applications for the Web, in using Application Express to manage database objects and in administering the Oracle Application Express environment. Learning Objectives Skills GainedThe delegate will practice:Developing an Apex Web ApplicationUsing the Apex SQL WorkshopCreating ReportsCreating FormsManaging... Learn about: Database training...