3772 Courses

Overview of Office Admin & Receptionist Becoming an office administrator or receptionist is an excellent entry point into the professional workforce. With over 1.5 million administrative and secretarial jobs in the UK, the demand for organised and personable admins to manage office tasks and assist staff continues rising. This comprehensive Office Admin & Receptionist course prepares you to thrive in these in-demand roles through industry-relevant training in key areas like communication etiquette, scheduling, customer service, business writing, and time management. Gain the skills and knowledge to become a confident, reliable, and exceptional administrative professional equipped to excel in any office environment. Ready to compose your career symphony? Enrol today and unlock the rewarding world of Office Administration & Receptionism! This Office Admin & Receptionist Course will help you to learn: Demonstrate effective communication and customer service skills required of a receptionist. Manage schedules and bookings and arrange travel and events. Follow best practices for phone, mail, filing, and other administrative duties. Represent the company and assist management professionally. Implement time management and organisational strategies effectively. Implement time management and organisational strategies effectively. Apply business writing principles through correspondence and other documents. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Office Admin & Receptionist. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Office Admin & Receptionist course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Career Changers: Seeking a fresh start in a dynamic field? This course equips you with the skills to excel in diverse office environments. School Leavers: Eager to kickstart your professional journey? Build a strong foundation with industry-relevant skills and knowledge. Upskillers: Looking to add polish and efficiency to your existing skillset? This course empowers you to take your career to the next level. Ambitious Individuals: Whether you dream of climbing the corporate ladder or setting up your office, this course provides the tools to succeed. Requirements You don’t need any educational qualification or experience to enrol in the Office Admin & Receptionist course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path Receptionist - £18K to £22K per year. Administrative Assistant - £20K to £28K per year. Executive Assistant - £25K to £40K per year. Office Manager - £28K to £45K per year. Personal Assistant - £30K to £50K per year.

***Premium Version*** Autumn Flash Sale Is Live Now! Get Free (PDF +Hard Copy) Certificates as a Gift. Teaching is a hugely rewarding profession, and to become a qualified teacher, one must have excellent communication, social and time management skills, in addition to postgraduate teacher training. If you're thinking about becoming a teacher, and want to contribute to the lives of young people, then this online teaching diploma will give you the practical knowledge and training you need to accelerate your career. This Advanced Diploma in Teaching course has no entry requirements and is designed to introduce teaching broadly, focusing on primary school and early years teaching. There will also be a section on SEN teaching to help you gain an understanding of teaching children with special educational needs such as dyslexia. You'll learn how to create lesson plans, familiarise yourself with different teaching methodologies, learn about teachers' pay and much more. Furthermore, to help you showcase your expertise in Teaching: Teacher Training, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Teaching : Teacher Training Bundle Consists of the following Premium courses: Course 01: Teach the Teachers Level 3 Course 02: School Administrator Training Course 03: Child Psychology Course 04: Child Neglect Awareness Certificate Course Course 05: Phonics Teaching Assistant Course 06: Education and Pedagogy Course 07: Lesson Planning for Teaching Course 08: Counselling Children & Supporting Their Wellbeing Course 09: Functional Skills English Practice Level 2 Course 10: Functional Skills Maths Level 2 Course 11: Learning Disability Awareness Course 12: Remote Teaching Online Course 13: Effective Communication Skills Course 14: Time Management Teaching : Teacher Training Curriculum of Teaching : Teacher Training Bundle Course 01: Teach the Teachers Level 3 Working with the School and Its Policies High-Quality Teaching for Pupils with SEN SEN Teaching Methodologies Communication and Interaction Cognition and Learning Social, Emotional and Mental Health Difficulties Sensory or Physical Needs Introduction to EYFS Importance of Early Years in Development EYFS Teaching Techniques Working as an EYFS Teacher Promoting Learning and Development Course 02: School Administrator Training Introduction to School Administration Types of Schools In The UK Workplace Development Creating and Maintaining a School Culture Educational Administration and Management Safeguarding Students Child Development Serious Behavioural Issues and Problems of Students Managing School Premises Safety and Maintenance As an Administrator Self-Management and Dealing with Stress Course 03: Child Psychology Introduction to Child Psychology Attachment and Relationship Building in Childhood Impacts of Separation and Loss on Attachment Factors That Influence Development Cognitive Development Social and Emotional Development Personality and Intellectual Development of Children Stages of Language Development Understanding Moral Development And Many More... Course 04: Child Neglect Awareness Certificate Course Introduction to Child Neglect Signs of Child Neglect Risk Factors for Neglect The impact of Child Neglect Child Neglect Cases Legislation Surrounding Child Neglect Responding to and Reporting Child Neglect Prevent Child Negligence Course 05: Phonics Teaching Assistant Introduction to Phonics Education Teaching Phonics Jolly Phonics Dyslexia and Learning Difficulties Cognitive Approaches in Dyslexia Involving Parents and Carers Speaking and Phonological Awareness Systematic Assessment and Record Keeping Meeting Individual Needs And Many More... ------------- Other Courses Are ------------- Course 06: Education and Pedagogy Course 07: Lesson Planning for Teaching Course 08: Counselling Children & Supporting Their Wellbeing Course 09: Functional Skills English Practice Level 2 Course 10: Functional Skills Maths Level 2 Course 11: Learning Disability Awareness Course 12: Remote Teaching Online Course 13: Effective Communication Skills Course 14: Time Management How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Teaching : Teacher Training Anyone from any background can enrol in this Teaching : Teacher Training bundle. Requirements Teaching : Teacher Training Our Teaching : Teacher Training course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Teaching : Teacher Training The Advanced Diploma in Teaching is beneficial for the following careers: Educator Guidance Counsellor Instructor Mentor School Administrator Special Education Teacher Tutor. Certificates Certificate of completion Digital certificate - Included

***Limited Time Deal*** The medical field of pharmacology is concerned with the applications, side effects, and mechanisms of action of medications. Millions of people throughout the world are impacted by pharmaceuticals and medicines, and research is ongoing to develop new or better therapies. To help you kickstart in pursuing a rewarding career in healthcare, we offer you this Pharmacist 12-in-1 complete bundle. Our Pharmacist bundle comprises 12 courses. Initially, the course covers pharmacology and pharmacy assistance. Then, this Pharmacist bundle continues covering medical terminology, vaccine management and medical transcription. In addition, you will get a grasp of medical coding with DRG-PCS, 3M Software and SAS Programming. If you enjoy helping people, problem-solving, science, and medicine, a pharmacist assistant job might be ideal. And we are here to help. So, enrol now to march toward success! Courses are included in this Pharmacist - CPD Accredited bundle: Course 01: Pharmacology Course 02: Pharmacy Assistant & Pharmacy Technician Course 03: Medication Administration Level 4 Course 04: Medical Transcription Course 05: Control and Administration of Medicines Online Training Course Course 06: Vaccine Management Course 07: Medical Terminology Training Course 08: Clinical Data Analysis with SAS Course 09: Medical Coding Inpatient Training: DRG-PCS Course 10: Medical Law Course 11: GDPR in Healthcare Course 12: Infection Prevention Training Learning Outcome of Pharmacist Bundle: Upon completion of this Pharmacist bundle, you will be able to - Learn all the terminology needed to understand pharmacology Know about the essential characteristics and features of the central nervous system Recognise the fundamentals of chemotherapy Discover more about the function of pharmacy technicians Correctly fill a prescription and distribute medication in pharmacies Prepare a medical report and other standard reports Understand the commonly used medical terminologies Learn Medical Coding Using DRG-PCS, 3M Software and SAS So, enrol now in this Pharmacist - CPD Accredited Training to advance your career! Pharmacist - CPD Accredited Curriculum of Pharmacist Bundle Course 1: Pharmacology Module 1: Fundamental Principles of Pharmacology Module 2: Drug Development and Regulation Module 3: Neuropharmacology Module 4: Cardiovascular Pharmacology Module 5: Endocrine Pharmacology Module 6: Chemotherapy Module 7: Inflammation and Immune Pharmacology Module 8: Toxicology How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously, it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) P.S. The delivery charge inside the U.K. is £3.99 and international students have to pay £9.99. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Pharmacist - CPD Accredited Training Individuals who want to work as pharmacists. Anyone seeking employment in the pharmaceutical sector. Professionals who want to advance their pharmaceutical knowledge. ** Completing this course does not imply that you are qualified to work as a Pharmacy Technician or Pharmacist. If you are seeking a course that fits The General Pharmaceutical Council's standards, please get in touch with The General Pharmaceutical Council. ** Requirements Pharmacist - CPD Accredited Training Career path Pharmacist - CPD Accredited Training This Pharmacist bundle course is comprehensively designed and will help explore the following careers, Pharmacist Pharmacy Technician Pharmacy Assistant Relief Pharmacy Assistant Pharmacy Dispenser In the United Kingdom, a pharmacist typically earns between £40,000 - £60,000 per annum. Certificates Certificate of completion Digital certificate - Included

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + QLS Endorsement | Assessment & Tutor Support Included

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that the NHS sees over 1 million patients every 33 hours in the UK? Effective medical receptionists are vital in keeping this complex system running smoothly. Are you interested in a career that allows you to play a key role in patient care? This comprehensive Medical Receptionist Bundle equips you with the necessary skills and knowledge to excel in this rewarding field. This Medical Receptionist & Medical Terminology bundle combines ten targeted courses designed to transform you into a confident medical receptionist. Master medical terminology and navigate healthcare acronyms. Learn to schedule appointments, manage patient records securely following GDPR guidelines, and effectively communicate with patients and medical staff. Deepen your understanding of medication administration, infection control protocols, and essential clinical observations. This Medical Receptionist Bundle Package includes: Main Course : Certificate in Medical Transcription at QLS Level 3 10 Additional CPDQS Accredited Premium Courses - Course 01: Medical Receptionist Course Course 02: Introduction to Medical Terminology Course 03: Online Clinical Coding Course Course 04: Medication Administration Course 05: Healthcare GDPR Course 06: Medical Laboratory Assistant Course 07: Infection Control Course 08: Clinical Observations Skills Course 09: Workplace First Aid Course 10: Personal Hygiene Whether you're new to the healthcare field or seeking to upskill, this Medical Receptionist Bundle provides the perfect platform to launch a successful career. Invest in your future and enroll today! Learning Outcomes of Medical Receptionist & Medical Terminology Confidently navigate medical terms and abbreviations used in a healthcare setting. Learn best practices for scheduling appointments, handling cancellations, and ensuring smooth clinic workflow. Become familiar with GDPR regulations and handle patient information with the utmost care. Develop strong communication skills to effectively interact with patients and medical staff. Gain expertise in managing patient records, insurance claims, and other essential administrative duties. Understand infection control protocols and perform basic first-aid procedures. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Medical Receptionist & Medical Terminology Get a free student ID card with Medical Receptionist & Medical Terminology Training program (£10 postal charge will be applicable for international delivery) The Medical Receptionist & Medical Terminology is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Medical Receptionist & Medical Terminology course materials The Medical Receptionist & Medical Terminology comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course : Certificate in Medical Transcription at QLS Level 3 Module 01: Introduction To Medical Transcription Module 02: The What, How, Who And Why Of Medical Transcription Module 03: Understanding Medical Reports Module 04: Medical Language Boot Camp Module 05: Formatting: The Basics Module 06: Data Protection Course 01: Medical Receptionist Course Introduction to Healthcare and Receptionists National Health Services Responsibilities and Skills Personal Grooming and Hygiene Work in a Socially Diverse Environment Reception Service Patterns The Hospital Services Health and Safety in Clinical Environment Security Concerns Regulatory Organisations in the United Kingdom Healthcare Laws and Regulations Medical Terminologies Course 02: Introduction to Medical Terminology Module 01: Human Body Vocabulary With Pictures Module 02: Equipment, Instruments And Lab Tests Module 03: Acronyms And Abbreviation Module 04: Digestive System Module 05: Cardiovascular System Module 06: Blood And Immunity System Module 07: Respiratory System Module 08: Musculoskeletal System Module 09: Central Nervous System =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £89) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Career changers School leavers Medical enthusiasts Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Medical receptionist Patient services Practice manager Certificates Certificate in Medical Transcription at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

24-Hour Flash Sale! Prices Reduced Like Never Before!! Over 5 million businesses regularly navigate the complexities of PAYE, tax, and payroll management, and clearly the demand for skilled payroll administrators has never been any higher. The "UK Payroll Administrator - CPD Certified" course bundle stands as a comprehensive gateway for those eager to master the art and science of payroll management, offering in-depth training on the latest software, tax laws, and financial strategies essential for successful payroll administration. This thoroughly designed course bundle equips learners with critical skills across key areas of Payroll Management, including Sage 50 Payroll, QuickBooks Online Bookkeeping, and Xero Accounting. It delves into HR, Payroll, PAYE, and tax intricacies, ensuring a robust understanding of UK tax Accounting. Advanced training in Microsoft Excel and Financial Modelling enhances analytical skills, while courses on Financial Analysis and improving financial intelligence provide the insights needed to navigate financial challenges effectively. Courses Are Included in this UK Payroll Administrator - CPD Certified Bundle: Course 01: UK Payroll Administrator Course 02: Sage 50 Payroll Complete Course Course 03: QuickBooks Online Bookkeeping Diploma Course 04: HR, Payroll, PAYE, TAX Course 05: UK Tax Accounting Course 06: Xero Accounting - Complete Training Course 07: Microsoft Excel - Beginner, Intermediate & Advanced Course 08: Financial Modelling Using Excel Course 09: Financial Analysis Course Course 10: Improve your Financial Intelligence Course 11: Making Budget & Forecast The "UK Payroll Administrator - CPD Certified" course journey offers an invaluable opportunity for career advancement in the field of payroll administration. Elevate your professional ranks or join the ranks of genius payroll administrators and contribute to the financial health of businesses across the UK. Enrol now and live the dream! Learning Outcomes of this Bundle: Master payroll management using Sage 50, QuickBooks, and Xero. Navigate UK payroll, PAYE, and tax regulations confidently. Utilise advanced Microsoft Excel for financial modelling and analysis. Develop comprehensive financial analysis and intelligence skills. Implement effective budgeting and forecasting techniques. Ensure compliance and accuracy in payroll administration processes. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Take a step toward a brighter future! Course Curriculum Course 01: UK Payroll Administrator Module 01: Payroll System in the UK Module 02: Payroll Basics Module 03: Company Settings Module 04: Legislation Settings Module 05: Pension Scheme Basics Module 06: Pay Elements Module 07: The Processing Date Module 08: Adding Existing Employees Module 09: Adding New Employees Module 10: Payroll Processing Basics Module 11: Entering Payments Module 12: Pre-Update Reports Module 13: Updating Records Module 14: e-Submissions Basics Module 15: Process Payroll (November) Module 16: Employee Records and Reports Module 17: Editing Employee Records Module 18: Process Payroll (December) Module 19: Resetting Payments Module 20: Quick SSP Module 21: An Employee Leaves Module 22: Final Payroll Run Module 23: Reports and Historical Data Module 24: Year-End Procedures Course 02: Sage 50 Payroll Complete Course Module 01: Introduction Module 02: First Transactions Module 03: T Accounts introduction Module 04: TASK 4 Fixed Assets Module 05: TASK 5 a and b Bank Payment and Transfer Module 06: TASK 5 c and d Supplier and Customer Payments and DD STO Module 07: TASK 6 Petty Cash Module 08: TASK 7 a Bank Reconnciliation Current Account Module 09: TASK 7 b Bank Reconciliation Petty Cash Module 10: TASK 7 c Reconciliation of Credit Card Account Module 11: TASK 8 Aged Reports Module 12: TASK 9 a Payroll Module 13: TASK 9 b Payroll Module 14: TASK 10 Value Added Tax &#8211; Vat Return Module 15: Task 11 Entering opening balances on Sage 50 Module 16: TASK 12 a Year end journals &#8211; Depre journal Module 17: TASK 12 b Prepayment and Deferred Income Journals Module 18: TASK 13 a Budget Module 19: TASK 13 b Intro to Cash flow and Sage Report Design Module 20: The Conclusion To The Course Course 03: QuickBooks Online Bookkeeping Diplom Module 01: Introduction Module 02: Introduction to Bookkeeping Module 03: Manual System Module 04: Computerised Systems Module 05: How it Fits Together Module 06: Bookkeeping Basics Module 07: Ledgers Module 08: Trial Balance and Coding Module 09: PNL Account and Balance Sheet Module 10: AILE Personal Module 11: The Conclusion To The Course =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring payroll administrators Finance professionals HR managers Accountants Small business owners Career changers Requirements You will not need any prior background or expertise to enrol in this HR and Payroll Management for the UK course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Payroll Administrator - £22,000 to £30,000 Payroll Manager - £28,000 to £40,000 HR and Payroll Officer - £24,000 to £32,000 Financial Analyst - £30,000 to £45,000 Accountant with Payroll Expertise - £25,000 to £35,000 Bookkeeper - £18,000 to £25,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

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.

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.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

Supporting Microsoft SQL server course description A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. What will you learn Install SQL server. Backup SQL server databases. Recover SQL server databases. Secure SQL server databases. Perform routine maintenance. Automate tasks. Supporting Microsoft SQL server course details Who will benefit: Anyone working with Microsoft SQL server Prerequisites: Supporting Windows server. Duration 3 days Supporting Microsoft SQL server course contents SQL server introduction Platform, Tools, services. Installation. Creating databases. Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. Security Users, server roles, database roles. Permissions. Monitoring Routine database maintenance. Performance data. Jobs and alerts The SQL server agent, database mail, alerts, jobs.