6128 Courses

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

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.

Enrol TODAY to CLAIM a BIGGER SAVINGS < 5 CPD Courses Ahead > Up to 94% Off for the GDPR Training course package! Enrol before the offer ends! Are you looking to enhance your GDPR Training skills? If yes, then you have come to the right place. Our comprehensive courses on GDPR Training will assist you in producing the best possible outcome by learning the GDPR Training skills. This GDPR Training Bundle Includes Course 01: GDPR Compliance Course 02: Employment Law Course 03: Security Management Course 04: AML Compliance Manager Course 05: Human Rights Consultant GDPR Course Learning Outcomes: Upon successful completion of this highly appreciated this GDPR training Course, you'll be a skilled professional, besides- You can provide services related to cleaning with complete knowledge and confidence. You'll be competent and proficient enough to explore GDPR related job fields on your own. Furthermore, you can train up others and grow an efficient peer community in your locality and serve people. It will enhance your portfolio, you can use the certificate as proof of your efficiency to the employer. It will boost up your productivity, you can use the skill and credentials, and become more competent in your vocation with increased earning! So, stand out in the job market by completing the course. Get an accredited certificate and add it to your resume to impress your employers. Other Benefits Lifetime Access to All Learning Resources An Interactive, Online Course A Product Created By Experts In The Field Self-Paced Instruction And Laptop, Tablet, And Smartphone Compatibility 24/7 Learning Support Free Certificate After Completion Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny, bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. GDPR Training Course Curriculum topic: Module 1: Basics Of GDPR Module 2: Principles of GDPR Module 3: Legal Foundation for Processing Module 4: Rights of Individuals Module 5: Accountability and Governance Module 6: Data Protection Officer Module 7: Security Of Data Module 8: Personal Data Breaches Module 9: International Data Transfers After the Brexit Module 10: Exemptions - Part One Module 11: Exemptions - Part Two Module 12: National Security and Defence Module 13: Understanding Data Protection Act 2018 CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this GDPR Training bundle. Requirements To enrol in this GDPR Training, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to GDPR Training. Certificates Certificate of completion Digital certificate - Included Get 5 CPD accredited PDF certificate for Free. Certificate of completion Hard copy certificate - £9.99 Get 5 CPD accredited Hardcopy certificate for £9.99 each. The delivery charge for the hardcopy certificate inside the UK is £3.99 each and international students need to pay £9.99 each to get their hardcopy certificate.

This video course will help you learn all the basic and advanced concepts of Microsoft Excel 2019. You'll start with Excel basics and slowly move to the advanced concepts in Excel. Each section is accompanied by an exercise at the end to practice what you have learned.

Discover Excel 2019 and become confident in using spreadsheets

Explore the intricacies of timber harvesting with our comprehensive course on Logger Training: Techniques in Timber Harvesting. From sustainable practices to advanced technology, delve into key topics including environmental conservation, legal considerations, and supply chain management. Master logging techniques, prioritize safety, and gain insights into the ethical dimensions of the industry. Elevate your skills and contribute to sustainable forestry management. Enroll now!

Course Overview Organisational skills refer to the ability to effectively plan, organize, and manage one's time, tasks, and resources in order to achieve specific goals. We introduce a post-agile approach that leverages the benefits of the agile methodology whilst addressing its limitations. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Analyse current habits and routines -Prioritise time schedule and daily tasks -Optimise communications to increase focus and productivity -Use effective planning tools to regularly plan and prioritise tasks and projects Format F2F or Virtual Delivery Mode Closed Cohort or Occasional Limited Public Schedule Duration 4 Hrs Target Audience Business professionals, leaders & executives aiming to enhance their personal effectiveness by developing their self organisational skills

The main outcome of this training course is to provide you with the knowledge to carry out the functions of a fire marshal. Please note, this course also contains all of the content in the Basic Fire Awareness and Fire Extinguisher.

Description  Would You Like To Achieve Anything 10x Faster? Learn How The Worlds Top Achievers Think And Behave So They Can Accomplish Massive Goals In the Fastest Amount Of Time. Welcome to the science of Goal Setting &amp; Goal Achievement! I had the privilege of learning and talking to the worlds top achievers and I was fortunate to learn from them. In this course, you'll learn these goal setting and goal achievement secrets. This is what you'll learn: How to Achieve Your Goals 10x Faster The 7 Secrets Of the Worlds Top Achievers How To Master your Time To Achieve More With Less Effort - Time Management Secrets How To Find Purpose &amp; Motivation In Your Goals &amp; Life How To Learn Anything 10x Faster How To Create Momentum So You Achieve Your Goals In the Fastest Amount Of Time How To Solve Any Problems That Prevent You From Achieving Your Goals How To Deal With Obstacles That May Come Up Go ahead, enroll in this course now. The science of goal setting and goal achievement will transform your life. If you want to achieve all of your goals faster than ever and learn the secrets of goal setting and goal achievement, then you can try this course risk free with the 30-day money back guarantee! What you'll learn How to Achieve Anything 10x Faster The 7 Secrets Of the Worlds Top Achievers How To Master your Time To Achieve More With Less Effort How To Find Purpose &amp; Motivation In Your Goals & amp; Life How To Learn Anything 10x Faster How To Create Momentum So You Achieve Anything In the Fastest Amount Of Time How To Solve Any Problems That Prevent You From Achieving How To Deal With Obstacles That May Come Up Requirements A willingness to set goals and apply the world's best achievement techniques Who is the target audience ? People who would like to achieve 10x more in less time People who would like to learn the mindset and techniques of the worlds top achievers People who would like to set goals and achieve them faster than ever People who want to become a top achiever People who want to have more time to do what they love Goal Setting & Achievement: Achieve Your Goals 10x Faster Welcome + What You Will Learn 00:04:00 The 7 Secrets Of Top Achievers Discover Uncover Their Secrets 00:13:00 How To Achieve Anything 10x Faster: Save Time, Money & Energy 00:18:00 How To Master Your Time: 10x Productivity & Have More Time To Do What You Love 00:17:00 How To Find Purpose In Your Goals & In Life 00:12:00 How To Learn Anything 10x Faster 00:13:00 How To Create Momentum To Achieve Anything In The Shortest Amount Of Time 00:11:00 How To Solve Any Problems That May Prevent You From Achieving What You 00:07:00 How To Deal With Obstacles When They Appear 00:08:00