88 Database courses in London

Python coding, interactive, instructor-led, hands-on, practical. From basics to working with professionals. Python Part Time. Python Coding. -------------------------------------------------------------------------------- Python Beginners Evenings Course COURSE SUMMARY This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time. It is a Python beginners course and teaches Python coding from scratch to intermediate. Hands-on, practical. We code some real life examples in this course. Duration: 3 Evenings, once per week for 3 weeks 6pm-8pm, of which the first date only shows on the booking. Virtual Classroom: You could attend in our classroom, or attend online via virtual classroom, by select the appropriate ticket. Who Should Attend? This course is intended for beginner programmers who need to code in Python. Fast-paced, Quite intensive. Course Outline: Session 1: Basics * Python Data Types, Variables, * Operators and Expressions: Arithmetic operators; Relational operators; Assignment operator; Logical operators. * Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else; * Using Loops: The while, while-else; do-while and the for loop; Enhanced for loop; Jump statements: break, continue; Nesting loops. Session 2: Lists. Dictionaries, Json * Python Data Structures: Lists. Data Structures: 2-d Lists, Tuples. Dictionary, Nested Disctionary. Session 3: Built-in functions: * Python Date Functions. Random. Math Functions. String Functions. Python Regex. Session 4: Database: * Connect to a database, create Database, create a table, insert, delete, update records, query a database and display results. Drop database, drop table. Session 5: Files * Exception Handling in Python: Fundamentals of exception handling; Exception types; Using try and except. * Files, streams: Create, Open, Traverse and Read Files: Csv, txt and Json Files. * API: Connecting to API’s Session 6: M ethods, Classes and Objects * Creating and using Function, Working with parameters, Calling functions. * Object-Oriented Programming (OOP) principles. Modules and Classes, Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class member.s FAQ Do I need Python on my Laptop? Ideally spoken yes, but if not possible, you could use our online platform. Can I pay by BACS? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Can I pay with PayPal? Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get an invoice? Yes, on request. Can I pay with a PO (Purchase Order Number)? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get a certificate? Yes, a PCWorkshops Certificate Can I attend in classroom? Yes, on request, and it would incur an additional charge, depending on your location. We have offices in London, Manchester, Birmingham, Portmouth, Southend-on-Sea, Milton Keynes. Can beginners follow this course? Yes, this is a Python beginner friendly course. We offer Python courses with max 4 people, so we make sure each delegates fully understand the material covered Can I customise the course? Yes, all our Python courses are customisable. We can customise the dates, times, location. course outline. -------------------------------------------------------------------------------- REFUND POLICY No Refunds

This Python BootCamp is Instructor-led, Practical. In the12-week Python course, learn start to in-depth, leading to a good Python career. -------------------------------------------------------------------------------- PYTHON BOOTCAMP: This 12-week Python Boot Camp is a practical, instructor-lead program, covering Python from start to in-depth. You will be fully fluent and confident as a Python programmer. If you have more questions goto https://pcworkshopslondon.co.uk/contact.html  [http://pcworkshopslondon.co.uk/contact.html], Or contact us on training@pcworkshopslondon.co.uk [https://pcworkshopslondon.co.uk/] Customise dates, course outline, arrange installments [https://pcworkshopslondon.co.uk/contact.htm] This course will give you enough practical experience and practical projects to code, to give you full confidence to enter into the coding profession.    Duration: 3 months: * 1 Python class per week, * Plus pratical work, * Plus personal trainer-mentor for 1-1 training, * Plus e-learning materials. Final project : Practical to upload to GitHub and show-case Date and times, choose: * Fridays in London or Online , 10am - 5pm, * or Saturdays in London or Online , 12noon-6pm, * or negotiate your date Study level: Start from beginners level to in-depth, ready to work professionally. Virtual attendance:  online instructor-led  Download: Anaconda.com Pre-requisites: General computer literacy. Oracle Qualification: PCWorkshops Python Programmer Certificate Payments:  You may apply to pay in installments for this Python Training course COURSE OUTLINE Week 1 - 4: Essentials 1. Python Coding Basics 2. Object Oriented programming: Python Object Orientated programming (OOP) 3. UX Principles: UX Principles and applying it on Front-ends with TKinter 4. Specialised topics: Dates, Localization, Strings, Maths Operation , Random Number, Lambdas Week 5 - 10 : All about data 1. Python Data Structures: Lists, Tuples, Sets, Exceptions, I/O Fundamentals , Reading and Writing file 2. Database: Database principles and SQL. Database Project: Python database connections and creating a database driven project 3. Data Analytics: Numpy. Pandas for data analytics and data queries. 4. Data Analytics: Pandas data cleaning and restructuring, interacticting with Excel, Csv, Json,etc. 5. Data visualisation: MatPlotLib 6. Prediction: Machine Learning Basics Week 11 and 12: The final touch 1. Python Concurrency and Multi-threading: Threads vs. Processes, Threading Module, Threading Event, Stop a Thread, Daemon Threads, Thread-safe Queue, Thread Pools, Locks 2. Python Unit Testing 3. Optional : Replace Week 11 or 12 with Scraping using Python, ot Tkinter Front-ends INCLUDED: * PCWorkshops Python Course Certificate on completion. * Python Course notes. * Practical Course exercises, Code Examples, Online Materials. * After the course, continuous assistance with practical and preparation for exams * Max group size on this is 4. * Portfolio: Post your Python project online. * Exam preparation and interview questions MORE ABOUT THE ONLINE CLASSROOM *  Attend from your internet connection *  Instructor-led, get instant answers to your questions *  Fully interactive *  Work clearly explained with demonstrations and examples *  Practical exercises to be tried out by delegate WHAT YOU WILL GAIN: * Skills & knowledge: Python coding knowledge and understanding with good practical application   * Certification: Internal PCWorkshops Python certificate * Portfolio: You will have an online portfolio of Python projects  * Experience: Our comprehensive practical makes you job ready -------------------------------------------------------------------------------- REFUND POLICY No Refunds

DATABASE FUNDAMENTALS TRAINING COURSE DESCRIPTION This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. WHAT WILL YOU LEARN * Describe core database concepts. * Create database objects. * Manipulate data. * Describe data storage. * Administer a database. * Create a relational database consisting of 3 related tables. DATABASE FUNDAMENTALS TRAINING COURSE DETAILS * Who will benefit: Those working with databases. * Prerequisites: None. * Duration 3 days DATABASE FUNDAMENTALS TRAINING COURSE CONTENTS * Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. * Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. * Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. * Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. * Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

DATABASE DESIGN TRAINING COURSE DESCRIPTION Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates. WHAT WILL YOU LEARN * Name and give 3 types of database structure. * Explain the difference between standard SQL and different flavours. * Use SQL statements to query databases. * Use SQL statements to query and define databases. * Describe the principles of relational database design and 3 types of relational joins. * Normalise a given flat file table into relational tables. DATABASE DESIGN TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design. * Prerequisites: None. * Duration 3 days DATABASE DESIGN TRAINING COURSE CONTENTS * Database structure and terminology. * Principles of Relational Database Design. * Types of relationship. * Normal Forms. * Practical examples of relational database design. * Hands-on creation of a database. * On paper design a relational database applicable to the delegates work.

ORACLE DATABASE 12C ADMIN TRAINING COURSE DESCRIPTION This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. WHAT WILL YOU LEARN * Administer an Oracle database instance. * Monitor an Oracle database. * Configure the Oracle network environment. * Create and manage database storage structures. * Manage users, profiles, privileges and roles. * Manage undo data and temporary segments. * Monitor and resolve lock conflicts. * Maintain database security. * Implement database auditing. * Monitor the performance of the Database. * Load and unload data. * Use the job scheduler. * Configure a database for backup and recovery. ORACLE DATABASE 12C ADMIN TRAINING COURSE DETAILS * Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. * Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. * Duration 5 days ORACLE DATABASE 12C ADMIN TRAINING COURSE CONTENTS * Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. * Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. * Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. * Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. * Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. * Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. * Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. * Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. * Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. * Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. * Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. * Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ * Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. * SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. * Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. * Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. * Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. * Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. * Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability * Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

Understanding property investment cash flows in all its complexity by type of investment and by purpose -------------------------------------------------------------------------------- ABOUT WHO COULD BENEFIT? This senior practitioner-led on-line course is aimed at c-suite/senior managers but is also suitable for junior staff keen to understand how cash flows get used higher up within the company or the various forms that cash flows can take, or service / database / software providers. Only £875+VAT pp on a public course. In this face-to-face course we drill down to all types of cash flows across the real estate spectrum and within the different levels within companies and by asset type. We help you get to grips with reality, and help you focus on the most important cash flow aspects across the property industry. Do you work as: * Board and Investment Committee Members, Managers and Team Leaders dealing in multi-asset classes as investor or manager to obtain a sound, comprehensive overview of the relevance and importance of understanding cash flow uses * Analysts and Associates in particular working in multi-disciplinary real estate teams engaged in investment, lending, asset management and development * Data, system and service providers keen to understand the various forms and uses of cash flows and its inputs across the property industry -------------------------------------------------------------------------------- MODULES DEEPER UNDERSTANDING OF RE CASH FLOWS Property investment is driven by the promise of quality cash flow over time. It is essential to gain a better understanding of the various forms cash flow can take, as each asset type and asset structure is unique. Financial modelling courses only provide you the tools how to model, but fail to provide a deeper understanding why or what you model in real-life in all its complexities. This course provides you with insight, detailed knowledge and experience on the assumptions. Cash Flows in reality vary wildly in construction and complexity. There are many types of cash flows, suited to its specific circumstance and use, and get used in different ways in decision making. Only £875+VAT pp for this 1-day course! This senior-practitioner-led course is aimed at c-suite/senior managers but is also suitable for junior staff keen to understand how cash flows get used higher up within the company or the various forms that cash flows can take. This course, in brief, provides: – a comprehensive overview of how cash flows differ across property –  applicable to a range of real estate investment deal types and asset classes such as office, shopping centres, residential (PRS), warehouse-logistics and industrial. – context in which information derived from cash flows is used – the contribution of cash-flow outputs in decision-making – high-level detail of the inputs, assumptions and outputs – sound understanding of how cash flow models enable analysis of financial statements, appraisals & risk sensitivities – highlights good practice for cash flow model structure set-up and controls, – highlights key metrics, terminology, etc Detailed course manual provided on the day. This course is taught by dedicated, friendly and seasoned practitioner Kaushik Shah Press ‘see content’ below to see detailed content. Next Date Available: Thursday 20 June 2024 | Location: On-line or C. London as desired IN-HOUSE COURSE “DEEPER UNDERSTANDING OF RE CASH FLOWS” In-house tailor-made course written and presented by senior property practitioners. In one engaging they will be providing you with a deeper understanding of the inputs, drivers and outputs of real estate cash flows – how do they differ, why, and how are they used? In the end it is (the promise of future) cash flows that drive real estate value. Only £3,850/day + VAT for this is an essential knowledge course to help you understand property in all its complexity. Next Date Available: in-house dates available upon request -------------------------------------------------------------------------------- PRICING FIND THE BEST PRICE.   Property Overview offers competitively priced training courses with unique practitioner-led content. Applied, relevant content in this retail property course leads to greater impact and value-for-money. Pricing below is shown for public courses for individual bookings, and for in-house courses. To book one or several individual places please fill in the booking form, or email kaushik@propertyoverview.co.uk For bookings of 4 or more staff an on-line in-house course is recommended, also as the content can be tailored around your needs and your products or services. -------------------------------------------------------------------------------- DEEPER UNDERSTANDING OF RE CASH FLOWS -------------------------------------------------------------------------------- £875PP +20% VAT Single place on a public course IN-HOUSE COURSE “DEEPER UNDERSTANDING OF RE CASH FLOWS” -------------------------------------------------------------------------------- £3,850/DAY + VAT @ 20% Detailed manual included. Includes up to 6 attendees. £60+VAT pp surcharge thereafter

ADMINISTERING MICROSOFT SQL SERVER COURSE DESCRIPTION This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. WHAT WILL YOU LEARN * Describe core database administration tasks and tools. * Configure SQL Server databases and storage. * Import and export data. * Monitor SQL Server. * Trace SQL Server activity. * Manage SQL Server security. * Audit data access and encrypt data. ADMINISTERING MICROSOFT SQL SERVER COURSE DETAILS * Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. * Prerequisites: Introduction to data communications & networking. * Duration 3 days ADMINISTERING MICROSOFT SQL SERVER COURSE CONTENTS * Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. * Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. * Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. * Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. * Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. * Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

MYSQL FOUNDATION TRAINING COURSE DESCRIPTION The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create, alter and drop a MySQL database. * Write SQL statements. * Use SQL expressions and functions. * Create and alter tables, indexes and views. * Use transactions. * Grant and revoke access privileges. * Export and import data. MYSQL FOUNDATION TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to access and work with a MySQL Database. * Prerequisites: An understanding of databases and exposure to information technology in general would be useful. * Duration 3 days MYSQL FOUNDATION TRAINING COURSE CONTENTS * Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. * Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. * Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. * LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. * Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. * Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. * Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. * Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. * Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. * Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. * Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. * Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

MYSQL FOR DEVELOPERS TRAINING COURSE DESCRIPTION This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. WHAT WILL YOU LEARN * Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. * Use advanced features of the MySQL Client. * Use advanced data types. * Manage the structure of databases and tables. * Manage and using indexes. * Write complex SQL query statements. * Use advanced SQL expressions. * Use advanced SQL functions. * Perform advanced Insert, Update, Delete, Replace and Truncate Operations. * Use user variable syntax and properties. * Import and export data from within MySQL. * Import and export data from the command line. * Perform complex joins to access multiple tables. * Perform complex subqueries. * Create, manage and us views. * Use prepared statements. * Create and use stored routines. * Create and use triggers. * Obtain database metadata. * Optimize queries. * Work with the main storage engines. * Debug MySQL applications. MYSQL FOR DEVELOPERS TRAINING COURSE DETAILS * Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. * Prerequisites: MySQL foundation * Duration 5 days MYSQL FOR DEVELOPERS TRAINING COURSE CONTENTS * Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. * Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server * The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program * Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types * Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers * Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases * Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes * Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data * SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions * Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data * Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. * Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata * Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging * Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins * Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries * Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views * Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting * User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements * Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines * Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic * Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic * Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters * Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions * Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers * Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations * More about indexes Indexes and joins Hands on Investigating indexes and joins

SUPPORTING MICROSOFT SQL SERVER COURSE DESCRIPTION A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. WHAT WILL YOU LEARN * Install SQL server. * Backup SQL server databases. * Recover SQL server databases. * Secure SQL server databases. * Perform routine maintenance. * Automate tasks. SUPPORTING MICROSOFT SQL SERVER COURSE DETAILS * Who will benefit: Anyone working with Microsoft SQL server * Prerequisites: Supporting Windows server. * Duration 3 days SUPPORTING MICROSOFT SQL SERVER COURSE CONTENTS * SQL server introduction Platform, Tools, services. Installation. Creating databases. * Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. * Security Users, server roles, database roles. Permissions. * Monitoring Routine database maintenance. Performance data. * Jobs and alerts The SQL server agent, database mail, alerts, jobs.