47 SQL courses in London

Database Design and Data Normalization Course Summary Relational Databases & Data Normalisation Overview Training Courses London. Learn how to decide which tables and columns are required for a database, plan relationships, how to decide on data types and how to relate tables. Database Design and Data Normalization Course Description Session 1: Introduction to Relational Databases The Database Approach Database Management Systems The function of a Database Management System The Processing Architecture The Schema Architecture The Storage Architecture An overview of Database System Development An overview of general database principles Session 2: Conceptual Data Models Overview of Entity Models Entities and how to identify them Attributes and how to identify them Relationships and their qualities Building an Entity Relationship Diagram Resolving many-to-many relationships Sub-type and Super-type Relationships Arc Relationships Recursive Relationships Constraints and Assumptions Normalization to the First Normal Form (1NF) Normalization to the Second Normal Form (2NF) Normalization to the Third Normal Form (3NF) Exercises: Analyzing a specification Creating an Entity Relationship Diagram from it Session 3: The Relational Model Relational Structure Relational Terminology Domains A Relational schema Candidate keys and Primary Keys Foreign Keys Key Constraints Attribute Constraints Implementing Sub-type/Super-type Relationships Views Denormalization using Pre-joined Tables Denormalization using Derived Data An Introduction to Structured Query Language (SQL) Simple Queries Simple Updates of the Data Included in the Database Design and Data Normalization Courses: Database Design and Data Normalization Course Certificate on completion Database Design and Data Normalization Course Manual Practical Database Design and Data Normalization Course exercises, Database Course Homework / Database Course Revision work After the course, 1 free session for questions online Database Course via Gotomeeting.com. Max group size, online and in classroom, on this Database Course is 4.

Java Front-ends for desktop and mobile With Java FX Programming Java Front-ends for desktop and mobile With Java FX In this course we create attractive, functional Front-ends using JavaFX. Prerequisites: Delegates already have basic Java Skills. Duration: 2 consecutive days, the first date shows as the booking date Where: Online with Gotomeeting.com Download: Download Java JDK and Eclipse IDE. London classroom: on request locations, bring you own device Location: Online Interactive Instructor-led Webinar. Our Style: This is a very practical course giving you hands-on practice. Included: Course exercises, notes, examples, computers, evaluations Certification: PCWorkshops JavaFX Qualification Java Intermediate and Front-end Course Description Database Concepts Revision: DataBase SQL, database principles and JDBC GUI's with Java FX Building Java FX GUI's Course Contents: GUI's with JavaFX Building Java GUI's. Create a front-end form interface for an application. Working with nodes, labels, inputboxes, prgress bars, etc. Formatting your front-end. Import a Java package to interact with the front-end. Interact with a database via the front-end. Practical Examine the Java SE event model. What is an event. What is event handling. Develop event handlers. Develop Lambda-style event handlers. Practical Create a quotation app. Create a movie booking app. How to create your installer and upload your app Webservices Java Web services What are Web Services? Why Java Web Services? Web Services - Characteristics Web Services - Architecture Web Services - Examples and exercises What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java Intermediate and Front-end Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Learn to code Python, from scratch to job-ready. With this excellent Python Programming course London you will achieve job-ready coding expertees. How does it work? Online, Instructor-led lessons: 1 full day lesson per week, for 12 weeks Plus Self-study Materials and a Structured Self-Study Program Plus 1-1 mentoring Scheduled in addition Plus Live Online Practical Project to showcase your expertees Part Time Part Time 1 full day per week, online instructor-led. Self study, in your own time. 1-1 mentoring, schedule your preferred time. Earn and Learn, stay employed, work, earn your salary until you qualify, then change. 1-1 Mentoring 1-1 Mentoring Additional, between weekly sessions. Work at your pace, 1-1 sessions can cover extra work and/or help you catch up. Gain confidence, because we revise & validate your practicals. Be re-assured, get immediate answers to your questions. Self-Study Self-Study Learn by doing, the best way to re-inforce learning, is by trying on your own. Practical, most of the self-study work is practical exercises. Gain experience, this aspect of the course gives you experience employesr are seeking. Practical Project Practical Project Live online, upload your project. Showcase, your expertees are testified online. Become known, your project will put you in contact with the coding community. Materials Materials Video Tutorials, Short and easy. Python Coding Examples, Plenty thereof. Manuals and Notes Reference materials. Exercises, Practical work with every class. Payments Payments Best deal: → £2100 up front. Installments: Contact us to arrange. Our Style Our Style Personalised, 1-1 Mentoring & Small Groups, Max 4. Practical, Hand-on. Online Instructor-Led. Weekly topics and other details Weekly Python lesson topic descriptions Overview of Python Fundamentals: Python Data Types, Variables: Primitive types; Characters; Boolean; Working with variables and its scope; Type conversion and casting; Strings String Functions, Strings vs numbers vs dates. Getting user input. Python Operators and Expressions: Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. Decision Making: If statement; If - else statement; If- else if - else statement; Nested if - else; Switch Statements Using Loops: The while, do-while and the for loop; Enhanced for loop; Jump statements : break, continue; The return statement; Nesting loops. OOP Principals Using Methods: Learn Python method basics. Defining Methods, Parameters, Returning values, Overloading methods, Calling methods. Encapsulation. Classes and Objects Inheritance, Override, Constructors, Parametised Constructors, the self keyword, Inner classes Lists. Tuples. Sets, Dictionary. Json Files. Using Built-in modules and functions for strings, maths and dates. Exception Handling, Files, Streams. Database concepts, Relational Database Data Types, Columns, Tables Relationships SQL statements DDL SQL Statements: Create and drop a databases Create,aleter and drop alter tables Select queries: where-clauses, wildcards, order by, joins, aggregates, having, DML Queries: Insert, Update and deleting records Connect to a from Python to a SQLite3 database, Data Driven Python Project: DDL Queries: Create a table, alter tables, drop a table Creating a log of transactions, using the above DML Queries: insert, delete, update records Creating a log-in facility to register, delete and maintain users Create a Search facility using select queries Query a database with wildcard parameters and display results Numpy Arrays The Python NumPy Module: Working with arrays, create data using arrays. Array manipulation and array-wise math functions. String functions on arrays. Numpy Built-In Functions : Math, arithmetic and statistical functions. Numpy Calculations Pandas Series Data Cleaning Python Pandas Dataframes and data importing Python Dataframes Data Series. Date/ Time Functionality. Time series. Creating Dataframes, Indexing. Dict to Dataframe, Dataframe to Dict. Csv to Dataframe, Dataframe to csv. Excel to Dataframe, Dataframe to Excel. Data Cleaning and preparation Finding, replacing and filtering missing data. Remove Duplicates. Replacing values. Renaming Axis Indexes. Pandas Data Wrangling Discretization and Binning. Random Sampling. Transforing data using function and mapping, Hierarchical Indexing, Reorder, Sorting, Stastitics, Dataframe Joins, Merging, Concatenation, Overlap. Reshaping and pivoting. Query a Pandas Dataframe Data Analysis: Sorting. Analysing and finding data using filter, slicing and dataframe queries. Finding data by Iteration. Find statistics: Functions, Aggregate functions. Unique values. String objects, Regex. Chart Types: Bar, Column, Line, Scatter, Pie, Area, Histogram, Funnel Charts Formatting: Changing gridlines lines, axes, scales, markers, colours, Chart Elements: legends, titles, plot seizes, exporting. Supervised Machine Learning: Classification Algorithms: Naive Bayes, Decision Tree, Logistic Regression, K-Nearest Neighbors, Support Vector Machine Regression Algorithms: Linear, Polynomial Unsupervised Machine Learning: Clustering Algorithms: K-means clustering, Hierarchical Clustering Dimension Reduction Algorithms: Principal Component Analysis Latent Dirichlet allocation (LDA) Association Algorithms: Apriori, Euclat Ensemble Methods Algorithms: Stacking, bagging, boosting. Random Forest Random Forest, Gradient Boosting Neural Networks and Deep Leaning Algorithms: Convolutional Network (CNN) Data Exploration and Preprocessing: Data cleaning, data transformation and data pre-processing are covered using Python functions to make data exploration and preprocessing relatively easy. Python Tkinter Front-end Basics Getting Started with HTML Getting Started with CSS Getting Started with Php Getting Started with JavaScripts Book the Python Boot Camp About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments