2382 Courses delivered Online

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

Python Unittest Course Summary. Testing plays a major role in software development. This course will explain Python Unit Testing using the unittest built-in module. We'll cover issues before going to the production itself and the basics of testing in Python. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Unittest Certification Duration: 1-Day, 10am-5pm Unittest topics UnitTest Framework - Home UnitTest Framework - Overview UnitTest - Framework UnitTest - API UnitTest - Assertion UnitTest - Test Discovery UnitTest - Skip Test UnitTest - Exceptions Test UnitTest - Time Test UnitTest - Unittest2 UnitTest - Signal Handling UnitTest - Doctest UnitTest - Doctest API UnitTest - Py.test Module Nose Testing - Framework Nose Testing - Tools Included with Python Unittest Course Python Unittest Certificate on completion Python Unittest Videos Python Unittest Notes Python Unittest Examples Practical Python Unittest exercises

Python Data Analytics with Python using Numpy, Pandas, Dataframes. Most attendees are in-work Data Professional. Private individuals are very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

The comprehensive Complete SAS Programming has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Complete SAS Programming today, and learn from the very best the industry has to offer! This best selling Complete SAS Programming has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Complete SAS Programming is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Complete SAS Programming is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Complete SAS Programming is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Complete SAS Programming, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Complete SAS Programming will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Complete SAS Programming to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview The comprehensive Neuro-Linguistic Programming (NPL) has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Neuro-Linguistic Programming (NPL) today, and learn from the very best the industry has to offer! This best selling Neuro-Linguistic Programming (NPL) has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Neuro-Linguistic Programming (NPL) is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Neuro-Linguistic Programming (NPL) is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Neuro-Linguistic Programming (NPL) is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Neuro-Linguistic Programming (NPL), you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Neuro-Linguistic Programming (NPL) will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Neuro-Linguistic Programming (NPL) to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Package Details: Number of Courses: 30 Courses Accreditation: CPD Quality Standards Free Certificates:PDF: 30Hardcopy: 30 (Delivery Charge Applicable) Courses Access: Lifetime Instalment Payment Available Basic Programming (C, Java, Python, SQL) Course 01: Diploma in Computer Programming Course 02: C# Programming - Beginner to Advanced Course 03: Master JavaScript with Data Visualization Course 04: SQL Programming Masterclass Course 05: Python Programming for Everybody Course 06: Javascript Programming for Beginners Course 07: jQuery: JavaScript and AJAX Coding Bible Structural Programming Course 01: Kotlin Programming : Android Coding Course 02: Sensors Course 03: Remote Sensing in ArcGIS Course 04: Linux Shell Scripting Course 05: Bash Scripting, Linux and Shell Programming Course 06: Coding with Scratch Course 07: CSS Coding Data Driven Programming Course 01: Quick Data Science Approach from Scratch Course 02: Secure Programming of Web Applications Course 03: A-Frame Web VR Programming Course 04: Complete AutoLISP Programming AutoCAD Programming Course 01: AutoCAD Programming using C# with Windows Forms Course 02: AutoCAD Programming using VB.NET with Windows Forms Programming for Computer Building Course 01: Building Your Own Computer Course 02: Neuro-linguistic Programming (NLP) Diploma Programming for Security Course 01: Cyber Security Incident Handling and Incident Response Course 02: Computer Networks Security Course 03: IT Asset Department IT Soft Skills Course 01: Functional Skills IT Course 02: CompTIA Healthcare IT Technician Course 03: Basic Google Data Studio Course 04: Data Analytics with Tableau Course 05: Recovering from a Job Loss in Technology Computer Programming Fundamental Course This Computer Programming Fundamental bundles' curriculum has been designed by Computer Programming Fundamental experts with years of Computer Programming Fundamental experience behind them. The Computer Programming Fundamental course is extremely dynamic and well-paced to help you understand Computer Programming Fundamental with ease. You'll discover how to master Computer Programming Fundamental skills while exploring relevant and essential topics. CPD 310 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Computer Programming Fundamental Course Requirements Computer Programming Fundamental Course Career path Computer Programming Fundamental Course