536 Writing courses in Bristol delivered Live Online

Duration 4 Days 24 CPD hours This course is intended for This course is geared for experienced skilled Java developers, software developers, data scientists, machine learning experts or others who wish to transtion their coding skills to Scala, learning how to code in Scala and apply it in a practical way. This is not a basic class. Overview Working in a hands-on learning environment led by our expert instructor you'll: Get comfortable with Scala's core principles and unique features, helping you navigate the language confidently and boosting your programming skills. Discover the power of functional programming and learn techniques that will make your code more efficient, maintainable, and enjoyable to write. Become proficient in creating dynamic web applications using the Play Framework, and easily connect to databases with the user-friendly Slick library. Master concurrency programming with Akka, empowering you to build scalable and fault-tolerant applications that excel in performance. Enhance your testing skills using ScalaTest and ScalaCheck, ensuring the reliability and quality of your Scala applications, while having fun in the process. Explore the fascinating world of generative AI and GPT technologies, and learn how to integrate them into your projects, adding a touch of innovation and intelligence to your Scala solutions. If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals. Discover the power of Scala programming in our comprehensive, hands-on technical training course designed specifically for experienced object-oriented (OO) developers. Scala is a versatile programming language that combines the best of both OO and functional programming paradigms, making it ideal for a wide range of projects, from web applications to big data processing and machine learning. By mastering Scala, you'll be able to develop more efficient, scalable, and maintainable applications. Fast Track to Scala Programming for OO / Java Developers is a four day hands-on course covers the core principles of Scala, functional programming, web application development, database connectivity, concurrency programming, testing, and interoperability between Scala and Java. Additionally, you'll explore cutting-edge generative AI and GPT technologies, learning how to integrate them into your Scala applications for intelligent suggestions or automation. Throughout the course you?ll explore the latest tools and best practices in the Scala ecosystem, gaining valuable knowledge and experience that can be directly applied to your day-to-day work. With 50% of the course content dedicated to hands-on labs, you'll gain practical experience applying the concepts you've learned across various projects, such as building functional web applications, connecting to databases, designing modular components, and implementing concurrency. Upon completing the course, you'll have a solid understanding of the language and its features, empowering you to confidently apply your new skills in data science and machine learning projects. You'll exit well-prepared to create efficient, scalable, and maintainable Scala applications, regardless of the complexity of your projects. Introduction to Scala Scala features and benefits Comparing Scala with Java and other OO languages Installing Scala and setting up the development environment Object-Oriented Programming in Scala Classes and objects Traits, mixins, and inheritance Companion objects and factories Encapsulation and polymorphism Functional Programming Basics Pure functions and referential transparency Higher-order functions and currying Immutability and persistent data structures Pattern matching and recursion Having Fun with Functional Data Structures Lists, sets, and maps in Scala Folding and reducing operations Stream processing and lazy evaluation For-comprehensions Building Web Applications in Functional Style Introduction to Play Framework Functional web routing and request handling JSON handling with Play-JSON Middleware and functional composition Connecting to a Database Introduction to Slick library Database configuration and setup Querying and updating with Slick Transactions and error handling Building Scalable and Extensible Components Modular architecture and design patterns Dependency injection with MacWire Type classes and type-level programming Implicit parameters and conversions Concurrency Programming & Akka Introduction to Akka framework and Actor model Actor systems and message passing Futures and Promises Supervision and fault tolerance Building Confidence with Testing Introduction to ScalaTest and ScalaCheck Unit testing and property-based testing Test-driven development in Scala Mocking and integration testing Interoperability between Scala and Java Calling Java code from Scala Using Java libraries in Scala projects Converting Java collections to Scala collections Writing Scala code that can be called from Java Using Generative AI and GPT Technologies in Scala Programming Overview of GPT and generative AI Integrating GPT with Scala applications Use cases and practical examples Additional course details: Nexus Humans Fast Track to Scala Programming Essentials for OO / Java Developers (TTSCL2104) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Fast Track to Scala Programming Essentials for OO / Java Developers (TTSCL2104) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Course Overview The French Course for Beginners offers a comprehensive introduction to one of the world’s most widely spoken languages. Designed for learners with little to no prior experience, this course covers essential vocabulary, common phrases, pronunciation, and basic grammar structures. By the end of the programme, learners will be able to engage in simple conversations, understand everyday expressions, and build a strong foundation for further study or travel. The practical value of the course lies in its ability to enhance communication skills, promote cultural understanding, and boost confidence in using French in various real-world contexts. Whether pursuing personal enrichment, preparing for travel, or seeking to expand language skills for future professional opportunities, this beginner-level course equips learners with the essential tools needed to start their journey towards fluency. Structured lessons, engaging exercises, and supportive materials ensure a rewarding and motivating learning experience throughout. Course Description The French Course for Beginners takes learners on a structured journey through the fundamentals of the French language. The course covers topics such as greetings, introducing oneself, numbers, telling the time, ordering food, asking for directions, and discussing daily activities. Each lesson builds progressively to reinforce understanding and confidence. Through interactive exercises, audio support, and clear explanations, learners develop listening, speaking, reading, and writing skills in a supportive environment. Attention is given to pronunciation, cultural nuances, and practical conversation techniques that will serve learners in everyday situations. Designed with absolute beginners in mind, this course enables participants to develop a strong linguistic foundation without feeling overwhelmed. Upon completion, learners will have acquired essential communication abilities, basic grammatical knowledge, and the confidence to continue advancing their French language studies, making it an ideal starting point for both personal and professional growth. Course Modules Module 01: Lesson 1 Module 02: Lesson 2 Module 03: Lesson 3 Module 04: Lesson 4 Module 05: Lesson 5 Module 06: Lesson 6 Module 07: Lesson 7 Module 08: Lesson 8 Module 09: Lesson 9 (See full curriculum) Who is this course for? Individuals seeking to learn French for travel, communication, or personal growth. Professionals aiming to expand their language skills for international career opportunities. Beginners with an interest in exploring new languages and cultures. Students preparing for future academic studies in French-speaking environments. Anyone looking to add a valuable language skill to their portfolio. Career Path Language Assistant International Customer Service Representative Hospitality and Tourism Staff Administrative Support Roles in International Companies Language Tutor for Beginners Travel Coordinator or Tour Guide Retail and Sales Associate in French-speaking regions

Course Overview The Italian Language Course for Beginners offers an exciting introduction to the Italian language, designed to build a strong foundation in communication skills for everyday use. This course covers essential vocabulary, pronunciation, grammar, and conversational phrases, allowing learners to engage confidently in basic Italian dialogues. Through a structured and accessible approach, it provides valuable linguistic and cultural knowledge that can enhance travel experiences, support personal enrichment, or broaden career opportunities. Learners will benefit from step-by-step lessons that gradually develop listening, speaking, reading, and writing abilities. By the end of the course, participants will have gained the competence to hold simple conversations, understand common expressions, and navigate everyday situations with ease. Whether pursuing a personal passion or preparing for future opportunities, this course equips learners with essential Italian language skills that can be applied in various social, educational, and professional contexts. Course Description This comprehensive Italian Language Course for Beginners guides learners through the foundational elements of Italian in an engaging and supportive environment. Covering a range of topics from everyday greetings and basic sentence structure to practical vocabulary and common expressions, the course ensures a balanced development of communication skills. Participants will explore pronunciation techniques, grammatical rules, and essential conversational scenarios relevant to travel, dining, shopping, and social interactions. Lessons are carefully designed to foster gradual progression, enabling learners to build confidence as they advance. Interactive activities and real-world examples enhance understanding and retention, while cultural insights provide additional depth to the learning experience. By the conclusion of the course, learners will possess a strong entry-level proficiency in Italian, capable of managing simple conversations and understanding key aspects of the language. This course is ideal for those seeking to expand their linguistic abilities and cultural knowledge within a structured, beginner-friendly framework. Course Modules Module 01: Lesson 1 Module 02: Lesson 2 Module 03: Lesson 3 Module 04: Lesson 4 Module 05: Lesson 5 Module 06: Lesson 6 Module 07: Lesson 7 Module 08: Lesson 8 Module 09: Lesson 9 (See full curriculum) Who is this course for? Individuals seeking to learn Italian for travel, relocation, or cultural interest. Professionals aiming to add basic Italian language skills to enhance career prospects. Beginners with an interest in European languages and cultures. Students preparing for further language study or international education opportunities. Language enthusiasts wishing to expand their multilingual abilities. Career Path Customer Service Representative in international companies Hospitality and Tourism Sector Roles Administrative Support in multinational organisations Language Teaching Assistant (Entry-level) Cultural Exchange Programme Coordinator

Course Overview The German Language Course for Beginners is designed to provide a comprehensive introduction to one of the world’s most widely spoken languages. Whether for travel, work, or personal enrichment, this course offers a solid foundation in speaking, reading, writing, and understanding German. Learners will gain essential communication skills, from everyday greetings to basic conversations, allowing them to navigate a variety of real-world situations confidently. The course focuses on developing vocabulary, pronunciation, sentence construction, and listening comprehension through engaging and accessible lessons. By the end of the course, learners will be able to understand and communicate basic ideas in German, laying the groundwork for further study or everyday interactions. This course is ideal for those seeking a structured and supportive environment to start their German language journey and aims to deliver practical outcomes that can be applied across travel, education, and professional settings. Course Description The German Language Course for Beginners offers an engaging exploration into the fundamentals of German communication. Through a series of structured lessons, learners will cover key topics such as introductions, numbers, days of the week, everyday vocabulary, basic grammar rules, verb conjugations, and common expressions. The course presents material in a logical progression to ensure that learners build confidence step-by-step, with an emphasis on pronunciation and conversational fluency. Interactive exercises, cultural insights, and simple dialogues enhance the learning experience, fostering both comprehension and retention. By participating in this course, learners will acquire the foundational skills necessary to engage in basic conversations, understand simple written texts, and grasp the structure of the German language. Designed for complete beginners, this programme offers a supportive and stimulating learning environment, making it a valuable stepping stone for further language study, career development, or international travel. Course Modules Module 01: Introduction to the German Language Module 02: German Alphabet and Pronunciation Module 03: Basic Greetings and Introductions Module 04: Numbers, Dates, and Time Module 05: Essential Vocabulary for Everyday Situations Module 06: Basic Grammar: Articles, Nouns, and Verbs Module 07: Forming Simple Sentences and Questions Module 08: Common Phrases and Daily Expressions Module 09: Introduction to German Culture and Customs (See full curriculum) Who is this course for? Individuals seeking to learn German for personal, educational, or travel purposes. Professionals aiming to enhance their career prospects through multilingual skills. Beginners with an interest in European languages and cultures. Students preparing for further German language studies or international opportunities. Career Path Tourism and Hospitality Sector Roles International Customer Support Positions Language Tutoring or Educational Support Translation and Interpretation Assistance Administrative and Office Roles in International Companies

Course Overview The Trainee Train Driver Course offers a comprehensive and engaging journey into the world of train operations, ideal for individuals aspiring to build a career in the railway industry. Covering essential aspects such as licensing, required skills, application success strategies, psychometric preparation, and medical assessments, this course is designed to equip learners with the knowledge and confidence needed to pursue trainee train driver opportunities. Throughout the course, learners will gain a thorough understanding of the recruitment process, assessment methods, and professional expectations associated with this respected role. By the end, participants will be well-prepared to approach train driver applications, interviews, and training stages with a competitive edge. The course’s structured approach ensures learners develop key theoretical insights and align with industry standards, helping them to take their first significant steps towards a rewarding future in rail transport. Course Description The Trainee Train Driver Course delves into each crucial phase of becoming a qualified train driver, from understanding the basic responsibilities to mastering the complex selection processes. Learners will explore topics such as licensing requirements, application writing techniques, psychometric testing frameworks, and preparation for the rigorous interview stages. Detailed guidance on medical assessments, reference checks, and formal training procedures is also provided. The course maintains a professional focus, offering a clear roadmap for candidates aiming to meet the high standards expected within the railway sector. Participants will develop a strong foundation in the attitudes, behaviours, and knowledge required for success. With expertly crafted modules and a learner-centred approach, the course provides invaluable support for those committed to starting their journey towards a stable and respected career in train driving, ensuring they are fully aware of what the profession entails and how best to achieve their goals. Course Modules Module 01: Introduction to Trainee Train Driving Module 02: Train Driver Licences and Certificates: Key Facts Module 03: Train Driver Required Skills and Attitudes Module 04: Train Driver Application Form Success Module 05: Train Driver Psychometric Test Module 06: Find Success in the Train Driver Interview Module 07: References, Medical Assessment and Training (See full curriculum) Who is this course for? Individuals seeking to start a career as a trainee train driver. Professionals aiming to transition into the railway industry. Beginners with an interest in transport and rail operations. Anyone preparing for a train driver application or assessment process. Career Path Trainee Train Driver Passenger Train Driver Freight Train Driver Rail Operations Officer Train Driver Assessor Railway Safety Inspector Rail Traffic Controller

Proofreading & Copyediting Level 5 Course Overview This Proofreading & Copyediting Level 5 course offers an in-depth understanding of the essential skills required for proofreading and copyediting. Learners will explore key techniques for enhancing text accuracy, consistency, and clarity. Through detailed lessons, this course covers proofreading basics, the application of style guides, grammatical rules, and the intricacies of copyediting. Learners will also gain knowledge in legal checks and how to develop a successful career in this field. By the end of the course, participants will have a solid foundation in proofreading and editing, enabling them to produce high-quality written content that meets industry standards. Course Description This comprehensive course dives into the world of proofreading and copyediting, focusing on fundamental skills and advanced techniques. Learners will examine key concepts like applying style guides, understanding grammar rules, and maintaining text accuracy. Modules cover proofreading both on paper and on-screen, copyediting for language use, accuracy, and legal checks. A significant part of the course involves developing an understanding of professional editing practices, which will enable learners to work in various industries such as publishing, marketing, and legal sectors. The course structure is designed to offer a gradual progression, helping learners to refine their skills and gain confidence in producing error-free and well-polished content. Proofreading & Copyediting Level 5 Curriculum Module 01: Proofreading Basics Module 02: Applying the Style Guide Module 03: Spelling and Grammar Module 04: Proofreading on Paper Module 05: Proofreading On-Screen Module 06: Copy-Editing Basics Module 07: Copy-Editing – The Use of Language Module 08: Copy-Editing – Checking Accuracy and Facts Module 09: Copy-Editing – The Beginning and The End Module 10: Copy-Editing – Legal Checks Module 11: Finding Work and Developing Your Career (See full curriculum) Who is this course for? Individuals seeking to improve their proofreading and editing skills. Professionals aiming to advance in editing and publishing careers. Beginners with an interest in editing and writing industries. Anyone seeking to refine their written communication. Career Path Proofreader Copyeditor Content Editor Publishing Assistant Editorial Assistant Freelance Proofreader/Copyeditor Legal Proofreader Publishing Manager

Course Overview The 120 Hours TEFL (TESOL) Masterclass is a comprehensive programme designed for individuals aspiring to teach English as a foreign or second language. This course provides a robust foundation in teaching methodologies, linguistics, grammar, pronunciation, and classroom management. Learners will develop the confidence and competence needed to deliver engaging and effective English lessons across diverse cultural and educational settings. By the end of the course, participants will be equipped with the theoretical knowledge and instructional strategies to teach English successfully to learners of all ages and proficiency levels. This qualification opens the door to teaching opportunities worldwide, enhancing employability in an ever-expanding global market. Whether seeking to start a new career, travel while teaching, or advance existing skills, this course offers valuable expertise and an internationally recognised credential. Course Description This professionally structured TEFL (TESOL) Masterclass covers all the essential aspects of English language teaching. Modules explore topics such as second language acquisition, teaching receptive and productive skills, lesson planning, classroom management, and the integration of technology into teaching. Learners will gain a solid grounding in linguistics, master techniques for teaching grammar, vocabulary, pronunciation, and discover innovative ways to motivate students through games and activities. Throughout the course, participants will build essential skills for creating dynamic learning environments and adapting teaching methods to different learner needs. With a focus on academic excellence and professional development, this course prepares learners for a rewarding career in English language teaching across schools, private institutions, and online platforms. Upon completion, learners will possess a deep understanding of English teaching practices, ready to inspire students and contribute meaningfully to educational communities around the world. Course Modules Module 01: Introduction to English Language Teaching and Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment (See full curriculum) Who is this course for? Individuals seeking to teach English to speakers of other languages. Professionals aiming to transition into the education sector or broaden their teaching credentials. Beginners with an interest in English language teaching and global communication. Travellers and expatriates looking to pursue international teaching opportunities. Recent graduates considering a career in education and language instruction. Career Path English as a Foreign Language (EFL) Teacher English as a Second Language (ESL) Instructor Online English Tutor Academic English Teacher English Language Programme Coordinator English Curriculum Developer Private Language Institute Teacher International School English Teacher

Course Overview This comprehensive course offers a deep dive into three essential technologies for data science: Python, JavaScript, and Microsoft SQL. Learners will gain foundational knowledge and practical skills in each of these key areas, which are crucial for handling data, creating interactive websites, and working with databases. By the end of the course, students will be proficient in writing Python code for data analysis, creating dynamic web content with JavaScript, and managing data with Microsoft SQL. The course is designed to equip learners with the technical skills needed to succeed in data science, making it a valuable investment for anyone looking to excel in this growing field. Course Description In this course, learners will explore the core principles of Python, JavaScript, and Microsoft SQL, all tailored to the needs of data science professionals. The curriculum covers Python’s data structures, functions, and libraries essential for data analysis, while JavaScript introduces students to web development skills, including client-side validation and data visualisation. The Microsoft SQL section focuses on data management, including filtering, joining, and structuring queries. Learners will develop a solid understanding of these technologies, which will enable them to manipulate data, automate processes, and design interactive applications. The course also includes real-world applications, ensuring learners are well-prepared for future opportunities in data science and web development. Course Modules: Module 01: JavaScript Getting Started Module 02: JavaScript Fundamentals Module 03: JavaScript Strings Module 04: JavaScript Operators Module 05: JavaScript Conditional Statements Module 06: JavaScript Control Flow Statements Module 07: JavaScript Functions Module 08: Data Visualization (Google Charts) Module 09: JavaScript Error Handling Module 10: JavaScript Client-Side Validations Module 11: Python Introduction Module 12: Python Basic Module 13: Python Strings Module 14: Python Operators Module 15: Python Data Structures Module 16: Python Conditional Statements Module 17: Python Control Flow Statements Module 18: Python Core Games Module 19: Python Functions Module 20: Python Args, KW Args for Data Science Module 21: Python Project Module 22: Publish Your Website for Live Module 23: MS SQL Statements Module 24: MS SQL Filtering Data Module 25: MS SQL Functions Module 26: MS SQL Joins Module 27: MS SQL Advanced Commands Module 28: MS SQL Structure and Keys Module 29: MS SQL Queries Module 30: MS SQL Structure Queries Module 31: MS SQL Constraints Module 32: MS SQL Backup and Restore (See full curriculum) Who is this course for? Individuals seeking to enhance their skills in data science. Professionals aiming to expand their knowledge in programming and database management. Beginners with an interest in Python, JavaScript, and SQL. Anyone looking to enter the field of data science or web development. Career Path Data Scientist Web Developer Database Administrator Data Analyst Front-End Developer Full Stack Developer Data Engineer

Diploma in Python Programming Course Overview The Diploma in Python Programming offers an in-depth exploration of Python, one of the most versatile and in-demand programming languages. This course is designed to provide learners with a strong foundation in Python, covering essential concepts such as data structures, functions, libraries, and file handling. Learners will gain the skills necessary to write Python code to solve real-world problems, enabling them to create applications, automate tasks, and perform data analysis. By the end of the course, learners will have the practical knowledge to use Python effectively for various programming tasks in both professional and personal settings. Course Description This comprehensive course begins with the basics of Python programming, guiding learners through essential concepts such as syntax, data types, and conditional statements. Learners will progress to more advanced topics, including file handling, data storage structures, and error handling. Key modules like the creation of user functions, working with external libraries, and implementing Python in database management provide valuable skills that can be directly applied in the workplace. This course also covers essential tools such as command prompt usage, Jupyter notebooks, and package management in Python. By the end of the course, learners will have developed the confidence and competence to apply Python across various domains, including software development, data analysis, and system automation. Diploma in Python Programming Curriculum Module 01: Introduction to Python Programming Module 02: Getting Started with Python Module 03: Conditional Branching with Python Module 04: Importing External/Internal Library in Python Module 05: Project Rock Paper and Scissors Module 06: Strings Operation in Python Module 07: Date and Time in Python Module 08: File Handling, Read and Write Using Python Module 09: Data Storage Structures: Tuple, List, and Dictionary Module 10: Writing User Functions in Python Module 11: Sending Mail Module 12: Import Tricks in Python Module 13: Import Operating System and Platform Module 14: Exceptions Handling in Python Module 15: Installing Packages and Scheduling in Python Module 16: Database in Python Using SQLite Module 17: Running Programs from Command Prompt and Jupyter Notebook Module 18: Conclusion (See full curriculum) Who is this course for? Individuals seeking to develop a foundational understanding of Python programming. Professionals aiming to enhance their programming skills for career advancement. Beginners with an interest in software development, data analysis, or automation. Anyone looking to pursue a career in programming or technology. Career Path Software Developer Data Analyst Automation Engineer Python Programmer Database Administrator IT Specialist

Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data