1032 String courses

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Duration 3.5 Days 21 CPD hours This course is intended for This course is aimed at students new to the language who may or may not have experience with other programming languages. Overview Learn how Python works and what it's good for. Understand Python's place in the world of programming languages Learn to work with and manipulate strings in Python. Learn to perform math operations with Python. Learn to work with Python sequences: lists, arrays, dictionaries, and sets. Learn to collect user input and output results. Learn flow control processing in Python. Learn to write to and read from files using Python. Learn to write functions in Python. Learn to handle exceptions in Python. Learn to work with dates and times in Python. In this Python training course by Webucator, Inc, students learn to program in Python. Python Basics Running Python Hello, World! Literals Python Comments Data Types Variables Writing a Python Module print() Function Named Arguments Collecting User Input Getting Help Functions and Modules Defining Functions Variable Scope Global Variables Function Parameters Returning Values Importing Modules Math Arithmetic Operators Modulus and Floor Division Assignment Operators Built-in Math Functions The math Module The random Module Seeding Python Strings Quotation Marks and Special Characters String Indexing Slicing Strings Concatenation and Repetition Common String Methods String Formatting Built-in String Functions Iterables: Sequences, Dictionaries, and Sets Definitions Sequences Unpacking Sequences Dictionaries The len() Function Sets *args and **kwargs Flow Control Conditional Statements The is and is not Operators Python's Ternary Operator Loops in Python The enumerate() Function Generators List Comprehensions File Processing Opening Files The os and os.path Modules Exception Handling Wildcard except Clauses Getting Information on Exceptions The else Clause The finally Clause Using Exceptions for Flow Control Exception Hierarchy Dates and Times Understanding Time The time Module The datetime Module Running Python Scripts from the Command Line The sys Module sys.argv

This course will take you from the basics of Rust to understanding how to use all its features effectively for writing clear and effective code. With the help of engaging exercises and explanations, you'll learn the basic syntaxes, iterators, generics, borrow checker, code documentation, pointer lifetimes, and much more.

Python is one of the most useful programming languages to learn. You can learn back-end of web applications, games, in-house scripts, and even build a robust test automation framework.

Dive into the world of coiled tubing operations, equipment, well control, safety, and emerging technologies with EnergyEdge's comprehensive classroom training course. Enroll now to stay ahead.

Get up to speed with automating repetitive tasks with Python

In this course, you'll learn the Ruby programming language from absolute beginner to advanced - in no time at all!

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create complex Web Intelligence documents using advanced query and reporting techniques, including:Combined queries and sub-queriesCharacter and date string functionsVariables and calculation contextsLink documents using hyperlinks In this course, students will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. Web Intelligence Core Report Design Reviewing Core Report Design Concepts Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC) Multiple Data Sources Synchronizing Data from Multiple Data Sources Creating Multiple Queries in a Document Synchronizing Data with Merged Dimensions Interacting with Other Data Providers Advanced Query Techniques Implementing Combined Queries Implementing Subqueries Creating a Query Based on Another Query Changing Data Sources Calculation Contexts Describing Calculation Contexts Redefining Calculation Contexts Implementing Extended Syntax Operators Implementing Extended Syntax Keywords Defining Calculation Context Formulas with Character and Date String Functions Creating Formulas with Character and Date String Functions Implementing the Right() Function Implementing the Replace() Function Implementing the SubStr() Function Implementing the Pos() Function Concatenating Character Strings Implementing Date Functions If Logic Executing If() to Group Data Executing the If() Function to Modify Calculation Behavior Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel Managing Hyperlinks in the Web Intelligence Interactive Panel Additional Reporting Techniques Implementing Data Tracking Implementing Additional Report Functions

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Week 1: Getting Started Quiz 1 00:02:00 Quiz 1 Solution 00:01:00 What is Programming 00:03:00 Quiz 2 00:01:00 Quiz 2 Solution 00:01:00 Meeting the Interpreter and Problem Quiz 3 00:01:00 Quiz 3 solution 00:01:00 Why Programming and Quiz 4 00:02:00 Gammar and Python Rules 00:04:00 Backus Naur Form 00:03:00 Quiz 4 part 2 00:01:00 Quiz 4 Part 2 Solution 00:01:00 Python Grammar and Quiz 5 00:05:00 Quiz 5 Solution 00:03:00 Quiz 6 00:01:00 Quiz 6 Solution 00:02:00 Processors 00:02:00 Introducing Variables 00:05:00 Variables Quiz 8 00:01:00 Quiz 8 Solution 00:01:00 Variables Quiz 9 00:01:00 Quiz 9 Solution 00:01:00 Variables Quiz 10 00:01:00 Quiz 10 Solution 00:03:00 Introducing Strings 00:04:00 Using Strings Quiz 11 00:01:00 String indexing 00:02:00 Quiz 13 00:01:00 Quiz 13 Solution 00:03:00 String Subsequences 00:04:00 String Subsequences Quiz 14 00:01:00 Quiz 14 Solution 00:02:00 Understanding Selection Quiz 15 00:01:00 Quiz 15 Solution 00:04:00 Finding String in String Quiz 16 00:04:00 Quiz 16 Solution 00:02:00 Testing and Quiz 17 00:02:00 Quiz 17 Solution 00:03:00 Find With Parameter Quiz 18 00:02:00 Quiz 18 Solution 00:01:00 Congratulations 00:01:00 Week 2: Procedures and Loops Unit Overview 00:03:00 Procedural Abstraction 00:03:00 Introducing Procedures 00:04:00 Procedure Code Quiz 1 00:03:00 Quiz 1 Solution 00:01:00 Output and Quiz 2 00:01:00 Quiz 2 Solution 00:02:00 Return Statement and Quiz 3 00:03:00 Quiz 3 Solution 00:02:00 Inc Procedure Quiz 4 00:01:00 Quiz 4 Solution 00:01:00 Sum Procedure and Quiz 5 00:01:00 Quiz 5 Solution 00:02:00 Sum Procedure With a Return Statement3 00:02:00 Square Procedure Quiz 6 00:01:00 Quiz 6 Solution 00:02:00 Sum 3 Quiz 7 00:01:00 Quiz 7 Solution 00:02:00 Double String Procedure Quiz 8 00:01:00 Quiz 8 Solution 00:01:00 Find Second Quiz 9 00:02:00 Quiz 9 Solution 00:02:00 Equality Comparison Quiz 10 00:04:00 Quiz 10 Solution 00:01:00 If Statement Quiz 11 00:03:00 Quiz 11 Solution 00:03:00 Is Friend Quiz 12 00:02:00 Quiz 12 Solution3 00:02:00 Is Friend Quiz 13 00:02:00 Quiz 13 Solution 00:02:00 The Or Construct 00:03:00 Quiz 14 Solution 00:06:00 While Loop Quiz 15 00:05:00 Quiz 15 Solution 00:02:00 While Loop Quiz 16 00:01:00 Quiz 16 Solution 00:01:00 Print Numbers Quiz 17 00:01:00 Quiz 17 Solution 00:02:00 Factorial Quiz 18 00:02:00 Quiz 18 Solution 00:02:00 Break Quiz 19 00:04:00 Quiz 20 00:05:00 Quiz 20 Solution 00:01:00 No Links Quiz 21 00:01:00 Print All Links Quiz 21 Solution 00:02:00 Final Quiz Solution 00:02:00 Week 3: How To Manage Data Unit Overview 00:03:00 Stooges And Quiz 1 00:01:00 Quiz 1 Solution 00:01:00 Days in Month Quiz 00:01:00 Countries Quiz 00:01:00 Quiz 3 Solution 00:01:00 Relative Size Quiz 00:01:00 Quiz 4 Solution 00:01:00 Lists Mutation 00:01:00 Different Stooges Quiz 00:01:00 Quiz 5 Solution 00:01:00 Secret Agent Man Quiz 00:01:00 Replace Spy Quiz 00:01:00 Quiz 7 Solution 00:03:00 Python List Addition and Lenght 00:02:00 List Operations In Python 00:02:00 Python Lists Length Quiz 00:01:00 Quiz 8 Solution 00:01:00 Append Quiz 00:01:00 Hard Drive Quiz 00:01:00 Quiz 11 Solution 00:01:00 Python Loops on Lists Quiz 00:02:00 Quiz 12 Solution 00:02:00 Python For Loops 00:03:00 Sum List Quiz 00:02:00 Measure a String Quiz 00:01:00 Find Element Quiz 00:02:00 Quiz 15 Solution 00:04:00 Quiz 16 Solution 00:01:00 Python Union Procedure Quiz 00:01:00 Quiz 17 solution 00:01:00 Pop in Python Quiz 18 00:02:00 Quiz 18 Solution 00:03:00 Collecting Links 00:01:00 Get All Links 00:02:00 Starting Get All Links Quiz 00:01:00 Quiz 19 Solution 00:01:00 Updating Links Quiz 00:01:00 Quiz 20 Solution 00:01:00 55. Finishing Get All Links Quiz 00:01:00 Quiz 21 Solution 00:01:00 Finishing the Python Web Crawler 00:03:00 Crawling Process Quiz 00:01:00 Quiz 22 Solution 00:01:00 Crawl Web Quiz 00:01:00 Quiz 23 Solution 00:01:00 62. Crawl Web Loop Quiz 00:01:00 Quiz 24 Solution 00:02:00 Crawl If Quiz 00:01:00 Quiz 25 Solution 00:01:00 Finishing Crawl Web and Final Quiz 00:02:00 Final Quiz Solution & Conclusion 00:03:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

This course offers an immersive experience in data analysis, guiding you from initial setup with Python and Pandas, through series and DataFrame manipulation, to advanced data visualization techniques. Perfect for enhancing your data handling and analysis skills.