284 Other courses

ORACLE SQL TRAINING COURSE DESCRIPTION The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create SQL statements to query database tables. * Use standard aggregate functions and related SELECT statement clauses. * Join Tables. * Use basic subqueries and the set operators. * Use numeric, character and date functions. * Use conversion and other miscellaneous functions. * Use SQL parameters. * Use complex subqueries. * Create and alter tables and views. * Insert, update and delete rows in database tables. * Manage sequences and synonyms. ORACLE SQL TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. * Prerequisites: None. * Duration 3 days ORACLE SQL TRAINING COURSE CONTENTS * Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. * Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. * Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. * Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. * Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. * Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. * SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. * Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. * Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. * Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. * Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. * Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

MYSQL FOUNDATION TRAINING COURSE DESCRIPTION The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create, alter and drop a MySQL database. * Write SQL statements. * Use SQL expressions and functions. * Create and alter tables, indexes and views. * Use transactions. * Grant and revoke access privileges. * Export and import data. MYSQL FOUNDATION TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to access and work with a MySQL Database. * Prerequisites: An understanding of databases and exposure to information technology in general would be useful. * Duration 3 days MYSQL FOUNDATION TRAINING COURSE CONTENTS * Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. * Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. * Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. * LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. * Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. * Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. * Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. * Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. * Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. * Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. * Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. * Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Learn advanced concepts in DAX, Data Modeling, Power BI architectural design, and more.

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

The innovative Primavera P6 Beginner & Intermediate Training has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector. This popular Primavera P6 Beginner & Intermediate Training has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Primavera P6 Beginner & Intermediate Training course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Primavera P6 Beginner & Intermediate Training is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Primavera P6 Beginner & Intermediate Training consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Primavera P6 Beginner & Intermediate Training has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Primavera P6 Beginner & Intermediate Training course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Primavera P6 Beginner & Intermediate Training has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at.   Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

Level 3, 5 & 7 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

The innovative Excel spreadsheet Level 3 has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector. This popular Excel spreadsheet Level 3 has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Excel spreadsheet Level 3 course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Excel spreadsheet Level 3 is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Excel spreadsheet Level 3 consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Excel spreadsheet Level 3 has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Excel spreadsheet Level 3 course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Excel spreadsheet Level 3 has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at.   Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

  The innovative Excel Data Analysis for Beginner has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.  This popular Excel Data Analysis for Beginner has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Excel Data Analysis for Beginner course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Excel Data Analysis for Beginner is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Excel Data Analysis for Beginner consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Excel Data Analysis for Beginner has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Excel Data Analysis for Beginner course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Excel Data Analysis for Beginner has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at.   Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.