2686 Code courses in Leeds delivered Online

Certified Associate in Project Management (CAPM)® Exam Prep: Virtual In-House Training This course gives you the knowledge you need to pass the exam and covers CAPM®-critical information on project management theory, principles, techniques, and methods Are you planning on taking the CAPM® examination? This course gives you the knowledge you need to pass the exam and covers CAPM®-critical information on project management theory, principles, techniques, and methods. You'll also have an opportunity for practical applications and time to review the kinds of questions you'll find in the CAPM® Exam. What you Will Learn Apply for the CAPM® Examination Develop a personal exam preparation plan Describe the structure, intent, and framework principles of the current edition of the PMBOK® Guide Explain the PMBOK® Guide Knowledge Areas, as well as their inter-relationships with the each other and the Process Groups Getting Started Program orientation The CAPM® certification process Certified Associate in Project Management (CAPM®) Examination Content Outline CAPM® eligibility requirements Code of Ethics and Professional Conduct Application options Foundation Concepts Skills and qualities of a project manager Project management terminology and definitions Relationship of project, program, portfolio, and operations management Project lifecycle approaches Project Integration Management Review Project Integration Management Knowledge Area Develop Project Charter Develop Project Management Plan Direct and Manage Project Work Manage Project Knowledge Monitoring and Controlling Perform Integrated Change Control Close Project or Phase Project Stakeholder Management Review Project Stakeholder Management Knowledge Area Identify Stakeholders Plan Stakeholder Engagement Manage Stakeholder Engagement Monitor Stakeholder Engagement Project Scope Management Review Project Scope Management Knowledge Area Plan Scope Management Collect Requirements Define Scope Create WBS Validate Scope Control Scope Project Schedule Management Review Project Schedule Management Knowledge Area Plan Schedule Management Define Activities Sequence Activities Estimate Activity Durations Develop Schedule Control Schedule Project Cost Management Review Project Cost Management Knowledge Area Plan Cost Management Estimate Costs Determine Budget Control Schedule Project Resource Management Review Project Resource Management Knowledge Area Plan Resource Management Estimate Activity Resources Acquire Resources Develop Team Manage Team Control Resources Project Quality Management Review Project Quality Management Knowledge Area Plan Quality Management Manage Quality Control Quality Project Risk Management Review Project Risk Management Knowledge Area Plan Risk Management Identify Risks Perform Qualitative Risk Analysis Perform Quantitative Risk Analysis Plan Risk Responses Implement Risk Responses Monitor Risks Project Communications Management Review Project Communications Management Knowledge Area Plan Communications Management Manage Communications Monitor Communications Project Procurement Management Review Project Procurement Management Knowledge Area Plan Procurement Management Conduct Procurements Control Procurements Summary and Next Steps Program Review Mock CAPM® Exam Getting Prepared for the CAPM® Exam After the CAPM® Exam

Course Overview Master the skills of medical coding with the Medical Coding: IP DRG 3M ICD Workshop course. Through this course, you will learn the essentials of 3M coding and get the opportunity to prepare yourself to face the challenges of medical coding. From this Medical Coding: IP DRG 3M ICD Workshop, you will receive a detailed introduction to the 3M coding system. The course will help you understand the process of assigning ICD codes using 3M. You will become skilled in setting combination codes. The easy to digest modules will teach you the ins and outs of obesity and malnutrition coding. You will acquire the knowledge required to code COPD Bronchitis Pneumonia, and Cystic fibrosis This Medical Coding: IP DRG 3M ICD Workshop course is a great place to build medical coding skills. Enrol in the course and kickstart your career in the relevant industry. Learning Outcomes Get a detailed understanding of the fundamentals of 3M Learn the process of assigning ICD codes using 3M Understand the strategies of assigning combination codes Know the Code Otitis Conditions, obesity and malnutrition Familiarize with the coding process for COPD Bronchitis Pneumonia and Cystic fibrosis Who is this course for?  The Medical Coding: IP DRG 3M ICD Workshop course is for those interested in enriching their knowledge of medical coding.  Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Medical Coding: IP DRG 3M ICD Workshop course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Medical Coder 3M Introduction 3M Introduction 00:07:00 Basic 3M Usage Tabs File View and Option 00:11:00 Reference Tab in 3M Software 00:14:00 Reference usage with Addition Tips and shortcut 00:03:00 How to Assign ICD Codes using 3M How to Assign ICD Codes using 3M 00:08:00 How to assign Combination codes How to assign Combination codes Using 3M HTN, CKD, CHF 00:06:00 Digestive System Gastritis Duodenitis 00:13:00 How to Code Otitis Conditions 00:05:00 Obesity and Malnutrition with Tip BMI usage 00:12:00 Combinations with Sleep Apnea 00:05:00 DM Complications 00:11:00 CAD and related combinations using 3M 00:18:00 How to code COPD Bronchitis Pneumonia and Cystic fibrosis 00:18:00 How DRG changes while we change Diagnosis or Procedure using 3M How DRG changes while we change Diagnosis or Procedure using 3M 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Immerse yourself in a literary voyage with our home-study English Literature IGCSE course. 📚 From poetry to prose, heighten your analytical and critique abilities while exploring your literary passions. Understand author intent with clarity, and enrich your reading experience through a comprehensive understanding of literary techniques, form, vocabulary and imagery. Secure a solid foundation for A-Level study and improve your analytical skills across various subjects with our IGCSE English Literature course.  An IGCSE qualification is a prized educational standard in the UK, making it a commonly pursued credential for learners aged 16. English language serves as an inspiration and motivation tool, challenging us in numerous ways. This IGCSE Qualification course empowers you to read, understand and analyse various text forms, and write with clarity and precision.  Designed according to the latest specifications, our IGCSE English Literature course maximises your chances of success. Starting with a clear induction and well-structured assignments, we ensure you develop the skills and knowledge necessary to excel in your exam. With our course, IGCSEs truly are Qualifications that count. Your benefits include: A newly developed course that aligns with the latest specifications, packed with dynamic and engaging content 📖 Access to our partnership exam centres ensuring a guaranteed exam venue 🏢 Fast track option available for 2022 exams 🚀 Unlimited tutor support, helping you devise a study plan and providing continuous support 🎓 Exam pass guarantee (If you don’t pass the first time, we’ll support you to the next exam) 🎯 Delve into your love for poetry and prose while honing your analytical and critique skills! About the awarding body Awarding body: Edexcel Our course code: X802 Qualification code: 1ET0 As the UK's largest awarding body, Edexcel has been nurturing success through learning in academic and vocational qualifications for nearly two decades, both domestically and abroad.  Study Hours ⏱️ Allocate between 120 to 150 hours for study time, and additional time for completing assignments. Study Method 👩‍🏫 Our course is delivered via our interactive online learning platform. Fear not if you prefer print, as the learning materials are available for printing. Learning resources span various media including videos, quizzes, and interactive activities. Course Duration 📆 You can enrol today, with the course officially starting on 01/09/21. Prior to this date, you will receive your MyOxbridge login credentials, but access to learning materials is restricted until the official start date. Enjoy unlimited tutor support for two years from your course start date. Assessment 📋 Enrol now for Summer 2022 examinations.  Complete two standard IGCSE written exams, with: Paper 1 – 1 hour 45 minutes – 50% of marks Paper 2 – 2 hours 15 minutes – 50% of marks We offer a guaranteed exam space in one of our nationwide exam centres. During your course, complete one introductory assignment and nine assignments. Although these do not contribute to your final grade, they give you an opportunity to submit work to your tutor for marking and feedback, helping gauge your progress. Course Outcomes 👩‍🎓 Upon successful course completion, earn an IGCSE in English Literature, issued by Edexcel. We've chosen this syllabus (1ET0) for its suitability to distance learning. Additional Information ℹ️ Difficulty - Level 2 Entry requirements - No formal entry requirements, but an intermediate ability to read and write English is recommended. Course Content 📘 Explore literary masterpieces such as J.B Priestley's "An Inspector Calls", Shakespeare's "Romeo and Juliet", and John Steinbeck's "Of Mice and Men". Engage with a rich anthology of poetry from renowned poets like Rudyard Kipling, D.H Lawrence, Shakespeare, and more. This course promises a comprehensive literary journey, sharpening your analytical skills and enhancing your understanding of English literature.

Unleash the power of English Language to inspire, motivate, and challenge your world view. Embark on our IGCSE English Language course, devised to boost your capability to read, engage with and critically analyse a spectrum of texts. Dive deep into the 20th and 21st-century textual influences and understand how writers impact their readers. Gain proficiency in crafting clear, concise and compelling narratives across diverse styles and text formats, including letters, reports, and interviews. Aiming for accessibility, our course offers a stimulating learning experience suitable for all learners. An English Language IGCSE qualification is a valuable asset across various career paths, given the essential role of written and verbal communication in human connections and comprehension. IGCSEs are a revered qualification in the UK and globally, serving as a significant educational stepping stone for school-leavers. This self-paced, online course adheres to the latest CAIE IGCSE English Language syllabus, allowing you to learn at your leisure and convenience. With unlimited tutor support, a clear induction, and meticulously structured assignments, you'll acquire the knowledge and skills required to excel in the exam. For those undertaking final exams in the UK, we guarantee access to one of our exam centres. Your enrolment includes: Dynamic content based on the latest course specification Fast track option for 2022 exams Access to our partnered exam centres (guaranteed exam venue) Unlimited tutor support, including study plan assistance Exam pass assurance (support until you pass) English Language is a vital skill for careers requiring comprehensive English proficiency and effective written and verbal communication.  About the awarding body Awarding body: CAIE Our course code: X803 Qualification code: 0990 Cambridge Assessment International Education is the world's leading provider of international education programmes and assessments, reaching over 8 million learners in more than 170 countries. ⏱ Study Hours Anticipate between 120 and 150 hours of study time, plus additional time for assignment completion. 👩‍🏫 Study Method Our interactive online learning platform offers diverse media resources, including videos, quizzes, and activities. Materials can be printed for those who prefer physical copies. 📆 Course Duration Enrolment is open, with the course commencing on 01/09/21. You'll receive logins to MyOxbridge before the start date, with access to learning materials and two years of unlimited tutor support from the official start. 📋 Assessment Enrolment for Summer 2022 examinations is now open. Two GCSE standard written exams are required: Paper 1: Reading: 2 hours, 80 marks, 50% of IGCSE. This exam includes structured and extended writing questions based on three reading texts. Paper 2: Writing: 2 hours, 80 marks, 50% of IGCSE. This exam involves extended writing questions and a composition task. Guaranteed exam space in one of our UK exam centres is provided. Assignments throughout the course aid your progress, with tutor feedback provided, though these do not contribute towards your final grade. There is no coursework required. 👩‍🎓 Course Outcomes Successful completion results in a GCSE in English Language, issued by CAIE. We've selected syllabus (0990) as it is best suited to distance learning. ℹ️ Additional Information Difficulty - Level 2 Entry requirements - A strong command of both spoken and written English is assumed. The course includes reading and analysing texts from the 19th, 20th and 21st centuries. Therefore, this course may not be suitable for non-native English speakers. If in doubt, reach out for guidance. Course Content Explore persuasive and descriptive texts, delve into discursive and narrative texts, and unravel argumentative texts. Strengthen your comprehension and summary skills while examining classic works, such as Mary Shelley's 'Frankenstein', Leo Tolstoy's 'Anna Karenina' and George Orwell's '1984'. Develop your critical reading, evidence-based answering, note-taking, and paraphrasing skills. Deconstruct news articles, identify author bias, recognise linguistic devices, and express your thoughts and ideas fluently.

Special Education Needs: Special Education Needs Training A career in the Special Education Needs: Special Education Needs Training course field may be ideal for people who appreciate working with and assisting children with learning disabilities. It is crucial to identify children with learning problems as soon as possible to meet their special education needs. Teaching strategies and tactics for Special Needs SEN students will differ from those used with other students. As a result, learning the required knowledge and skills before beginning a career in Special Needs SEN is important. Our Course Cave diploma in Special Education Needs: Special Education Needs Training course is designed to provide you with the necessary knowledge and skills for a career in Special Needs SEN. This Special Education Needs: Special Education Needs Training course is highly recommended for special education professionals who desire to develop their professions. If you finish this Special Education Needs: Special Education Needs Training course, your chances of finding a relevant job will improve. Experts have designed this Special Needs SEN course to help you learn fast and efficiently, at your own speed and convenience. Enrol in our diploma in Special Education Needs: Special Education Needs Training course to start a great career in the field of Special Needs SEN. Courses are included in this Special Education Needs: Special Education Needs Training Bundle Course Course 01: Diploma in Special Education Needs (SEN) Course 02: Level 3 Certificate in Understanding Autism Course 03: Speech & Language Therapy Course 04: Level 2 Safeguarding Children Training [ Note: Free PDF certificate as soon as completing the Special Education Needs SEN Training Course] Special Education Needs: Special Education Needs Training Course Curriculum of Special Education Needs: Special Education Needs Training Industry Experts Designed this Special Education Needs: Special Education Needs Training course into 09 detailed modules. Module 1: Introduction What is Special Education Needs (SEN) Some Essential Terminology Related to SEN What Can You Do if You are Worried that Your Child May Have Difficulties? What is the Graduated Approach? What is a Statutory Assessment? Module 2: A Quick Overview of the New SEND Code of Practice What is the SEND Code of Practice? Different Sections of This Code of Practice Changes from the SEN Code of Practice (2001) Module 3: Legislation Related to SEN The Children and Families Act and associated Code of Practice 2014 Module 4: SEN Assessments and Descriptors SEN Information Form to Inform Assessment Initial Screening Test SEN Descriptors Module 5: Education for Children with Disabilities Why is Disability Such an Essential Issue for Education? What are the Barriers to Educating Children with Disabilities? Segregation, Integration or Inclusion? Action Required Making Interventions Effective for Children with Disabilities How to Improve the Quality of Education for Children with Disabilities? How to Get Children with Disabilities in Schools? Module 6: Common SEN Conditions Found Within Mainstream Schools Specific Learning Difficulties (SpLD) Cerebral Palsy Learning about Autism Spectrum Disorders (ASD) Module 7: Assessment and Planning for Children with Special Educational Needs The Place of Assessment in Supporting Learning and Behaviour Needs Formal, Norm-referenced (standardised) Tests Criterion-referencing Assessment of Behaviour Assessment of Visual Impairment Auditory Impairment Taking Students' Views into Account Engaging with Parents' or Carers' Perspectives Planning to Meet Pupils' Special Educational Needs and Disabilities Planning for Differentiation Module 8: The Wider Children's Workforce Associated with Special Education Needs Provisions In-class Support Arrangements Effective Use of Support Staffs in Classroom Issues Inter-agency Collaboration Module 9: Working with Other Professionals and Other Sources of Support and Information Involving Specialists The Local Offer Professionals Who Maybe in Your Support and Advice Network Other Professionals Assessment Method of Special Needs SEN Training After completing each module of the Special Education Needs: Special Education Needs Training, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Special Needs SEN Training After completing the MCQ/Assignment assessment for this Special Education Needs: Special Education Needs Training course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. Who is this course for? Special Education Needs: Special Education Needs Training This Special Education Needs: Special Education Needs Training course is ideal for those already working in a SEN role as part of their Early Years Practitioner role or interested in doing so. This Special Education Needs: Special Education Needs Training course is applicable for: SEN counsellors Teachers Parents with special needs children Behavioural Analysts Requirements Special Education Needs: Special Education Needs Training Students who intend to enrol in this Special Education Needs: Special Education Needs Training course must meet the following requirements: Special Education Needs: Good command of the English language Special Education Needs: Must be vivacious and self-driven Special Education Needs: Basic computer knowledge Special Education Needs: A minimum of 16 years of age is required Career path Special Education Needs: Special Education Needs Training This Special Education Needs: Special Education Needs Training course is appropriate for those who want to work in the following fields: Health and social care Childhood studies Community, youth and families Social work Early years Primary teaching Nursing Certificates Certificate of completion Digital certificate - Included

Do you want to build a simple, reliable, and error-free chatbot for your business? If yes, then this is the course for you! Learn to build a chatbot with Amazon Lex, a fully-controlled AI service with sophisticated natural language models to create, develop, test, and deploy chatbots (conversational interfaces) in applications.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Flutter & Dart Development Course Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Flutter & Dart Development Course Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Flutter & Dart Development Course Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Flutter & Dart Development Course Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Flutter & Dart Development Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Flutter & Dart Development Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Flutter & Dart Development Course course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Flutter & Dart Development Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Flutter & Dart Development Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Flutter & Dart Development Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:02:00 Setup On Windows 00:16:00 Setup On Linux 00:14:00 Setup On Mac iOS 00:14:00 Setup On Mac Android 00:12:00 App Base Code 00:03:00 Section 02: Widgets Text 00:04:00 Container 00:04:00 Row 00:05:00 Column 00:02:00 Stack 00:02:00 Image 00:06:00 Center 00:02:00 Padding 00:03:00 Align 00:02:00 Constrained Box 00:03:00 Baseline Class 00:03:00 Aspect Ratio 00:03:00 Sized Box 00:02:00 Transform 00:03:00 Section 03: Gestures Pointers 00:06:00 Tap 00:02:00 Double Tap 00:02:00 Long Press 00:03:00 Vertical Drag 00:04:00 Horizontal Drag 00:04:00 Pan 00:04:00 Section 04: Navigation Components Scaffold 00:06:00 App bar 00:05:00 Bottom Navigation Bar 00:08:00 TabBar View 00:07:00 Drawer 00:05:00 SliverApp Bar 00:07:00 Section 05: Input/Selection Components FlatButton 00:04:00 RaisedButton 00:03:00 DropdownButton 00:09:00 TextField 00:04:00 CheckBox 00:06:00 Radio Button 00:04:00 PopupMenuButton 00:07:00 IconButton 00:04:00 ButtonBar 00:03:00 Floating Action Button 00:04:00 Switch 00:04:00 Slider 00:05:00 Date Picker 00:05:00 Time Picker 00:07:00 SimpleDialog 00:08:00 AlertDialog 00:06:00 BottomSheet 00:06:00 Expansion Panel List and Expansion Panel 00:07:00 SnackBar 00:07:00 Cupertino Setup 00:02:00 Cupertino Action Sheet 00:06:00 Cupertino Activity Indicator 00:01:00 Cupertino Alert Dialog 00:04:00 Cupertino Button 00:03:00 CupertinoPageScaffold 00:04:00 CupertinoPicker 00:04:00 CupertinoPopupSurface 00:04:00 CupertinoSegmentedControl 00:04:00 CupertinoSlider 00:04:00 CupertinoSwitch 00:03:00 CupertinoNavigationBar 00:04:00 CupertinoTabBar 00:05:00 CupertinoTabScaffold 00:04:00 CupertinoTextField 00:04:00 Section 06: Information Displays Icons 00:04:00 Chip 00:03:00 Tooltip 00:02:00 DataTable 00:09:00 Card 00:06:00 Linear Progress Indicator 00:03:00 Circular Progress Indicator 00:04:00 Section 07: Layout GridView 00:03:00 ListView & ListTile 00:04:00 Stepper & Step 00:07:00 Divider & divideTiles 00:05:00 Aligning Widgets 00:03:00 Sizing Widgets 00:03:00 Sizing Widgets 00:03:00 Add, Update and Delete Widgets 00:06:00 Section 08: Navigation & Routing Navigate To A New Screen and Back 00:06:00 Multiple Files For Each Screen 00:03:00 Send Data To A New Screen 00:05:00 Return Data From A Screen 00:05:00 Navigate With Named Routes 00:03:00 Animating A Widget Across Screens 00:02:00 Stateless vs Stateful Widgets 00:08:00 Section 09: Animation Tween Animation 00:07:00 Staggered Animation 00:04:00 Reverse and Stop Animations 00:02:00 Section 10: Platform Specific Code Call Android Java Code 00:08:00 Send Parameters To Android Java Code 00:07:00 Call Android Kotlin Code 00:08:00 Send Parameters To Android Kotlin Code 00:05:00 Call iOS Objective-C Code 00:10:00 Send Parameters To iOS Objective-C Code 00:05:00 Call iOS Swift Code 00:08:00 Send Parameters To iOS Swift Code 00:05:00 Section 11: Building & Releasing Remove Debug Badge 00:01:00 Build & Release For Android 00:04:00 Build & Release For iOS 00:06:00 Section 12: Networking Fetch Data From The Internet 00:13:00 Making authenticated requests using HTTP Headers 00:03:00 Parsing JSON In The Background 00:17:00 Working With WebSockets 00:10:00 Section 13: Data Persistence Reading & Writing Files On The Server Using SQL Injection Vulnerability 00:06:00 Storing Key-Value Data On Disk 00:03:00 Data Persistence Using SQLite 00:04:00 Section 14: Creating An App Calculator Part 1 - TabBar Creation 00:12:00 Calculator Part 2 - Implementing The Tabs 00:05:00 Calculator Part 3 - Tab Persistence 00:03:00 Changing Android App Icon 00:05:00 Changing iOS App Icon 00:01:00 Change App Display Name 00:05:00 Assignment Assignment - Flutter & Dart Development Course 00:00:00

This is a comprehensive course for learning Bootstrap 4 in no time. It starts with a basic introduction to Bootstrap 4 and then moves on to explain the concepts that play a crucial role in building responsive websites. The course will help you to encapsulate your learning by working on interesting projects.

Discover the fascinating world of decentralized trading with Python and DYDX. Build a sophisticated trading bot, harness statistical arbitrage techniques, and automate your trading strategies on the AWS cloud. Gain the skills to navigate the cryptocurrency market and achieve consistent profitability in this comprehensive and hands-on course.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.