-
admin
SQL DATABASE MANAGEMENT AND DESIGN – Bespoke Training Course
Overview Format of the Course Interactive lecture and discussion. Lots of exercises and practice. Hands-on implementation in a live-lab environment. Requirements SQL: Fundamentals of Querying or equivalent knowledge. Course Outline Module 1: Introduction SQL Definition SQL Capabilities Standards of SQL SQL uses Module 2: SQL Query Commands Table Create [Data Type, Table Format, Key Format] […]
-
admin
Which data storage to choose – from flat files, through SQL, NoSQL to massive distributed systems Training Course
Overview This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches. Requirements Though no technical background is required, understanding the examples requires some level of database theory (e.g. SQL, etc…) Course Outline File Document Storage (Cloud Storage) Features (OCR, Scalaibility, Search, etc…) Open Source […]
-
admin
Data Analysis with SQL, Python and Spotfire Training Course
Overview In this instructor-led, live training, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python […]
-
admin
T-SQL Fundamentals with SQL Server Training Course Training Course
Overview This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn: How to work with SQL Server and SQL Server Management Studio. Meaning of Databases, SQL and RDBMS etc. How to create tables, use DDL, DML and DAL. Which […]
-
admin
SQL Advanced in MySQL Training Course
Overview This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features. Requirements Good SQL knowledge. Course Outline DQL (Data Query Language) Correlation in FROM, WHERE, SELECT and HAVING clauses Correlation and performance Using CASE, […]
-
admin
Oracle SQL Advanced Training Course
Overview Listeners This course is designed for people who want to use the advanced features of SQL in Oracle The course answers the questions How to build advanced queries? How to create advanced reports? Course Outline Control user access User Management System permissions and object Granting Receiving permission Roles Using the links Managing schema objects […]
-
admin
Transact SQL Basic Training Course
Overview Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following: Construct queries to extract and filter data from an SQL Server database Create summarised results Change, derive and format data to suit the required output Change data and maintain database […]
-
admin
SQL Advanced level for Analysts Training Course
Overview The aim of this course is to provide a clear understanding of the use of SQL for different databases (Oracle, SQL Server, MS Access…). Understanding of analytic functions and the way how to join different tables in a database will help delegates to move data analysis operations to the database side, instead of doing […]
-
admin
Transact SQL Advanced Training Course
Overview Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following: Use queries to return complex result sets Manage database objects to aid query performance Tune queries to perform more efficiently This course is for anyone who currently uses […]
-
admin
SQL Advanced Training Course
Overview Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes. Requirements SQL: Fundamentals of Querying or equivalent knowledge. Course Outline Lesson 1: Querying with unions and advanced joins Querying multiple tables with unions Advanced Joins Calculating with COMPUTE Lesson 2: Querying with subqueries Subqueries Lesson 3: Adding […]
