CourseForMe

Database Administration and Development Courses in Denver

13 results - Page 1 of 1

MySQL Database Administration Training Course - Denver

NobleProgUS
MySQL Server Files and Scripts MySQL Programs MySQL Server MySQL Client GUI Tools MySQL Server Configuration mysqld Options The Server SQL Mode Server System Variables Dynamic System Variables Server Status Variables Shutdown Process MySQL Security Issues Securing MySQL Against Attacks Security-Related mysqld Options Security Issues with LOAD DATA LOCAL MySQL Access Privilege Syste
Contact us
Onsite | 14 Hour

Model MapReduce and Apache Hadoop Training Course - Denver

NobleProgUS
Data Mining and Business Intelligence Introduction Area of application Capabilities Basics of data exploration Big data What does Big data stand for? Big data and Data mining MapReduce Model basics Example application Stats Cluster model Hadoop What is Hadoop Installation Configuration Cluster settings Architecture and configuration of Hadoop Distributed File System Console tool
Contact us
Onsite | 14 Hour

SQL in SQL Server Training Course - Denver

NobleProgUS
RDBMS (Relational DataBase Management System) Relational Operators SQL as Declarative Language SQL Syntax SQL Sublanguages DQL, DML, DDL, DCL DQL (Data Query Language) in Detail SELECT clause Column aliases Table aliases Date types and Date functions Group function Table joins JOIN clause UNION operator Nested queries Correlated subqueries DML (DataManipulationLanguage) Overview I
Contact us
Onsite | 14 Hour

AdvancedSQL,Stored Procedures and Triggers for MicrosoftSQLServe - Denver

NobleProgUS
Review of Structured Query Language DQL, DML, DDL The GROUP BY, HAVING Clause Sub-queries and Correlated Sub-queries Advanced Update & Delete Statements Sub-queries Correlated Sub-queries Procedural Programming Variables Control-Of-Flow Statements IF, WHILE, CASE, GOTO, RETURN Managing Errors Responding To Errors RAISERROR PRINT Using Transactions Introduction To Transactions Tran
Contact us
Onsite | 14 Hour

SQL language in MSSQL Training Course - Denver

NobleProgUS
Relational database models The structure of a relational database Relational operators Download the data Rules for writing SQL queries The syntax for the SELECT Selecting all columns Inquiries from arithmetic operations Aliases columns Literals Concatenation Restrict results The WHERE clause The comparison operators. LIKE Condition Prerequisite BETWEEN ... AND IS NULL condition IN
Contact us
Onsite | 14 Hour

Transact SQL Advanced Training Course - Denver

NobleProgUS
Analytical Functions Use of advanced summary functions Use of hierarchical queries Use of analytical summary functions, e.g. moving averages, running totals Use of ranking functions Useful Database Objects Principles of using indexes How to create and maintain an index Use of clustered tables Use of partitioned tables Use of metadata in...
Contact us
Onsite | 7 Hour

PostgreSQL Administration Training Course - Denver

NobleProgUS
What is PostgreSQL? A Brief History of PostgreSQL Conventions Further Information Bug Reporting Guidelines Introduction to PostgreSQL Installation and Creating Database The SQL Language Advanced Features The SQL Language SQL Syntax Data Definition Data Manipulation Queries Data Types Functions and Operators Type Conversion Indexes Full Text Search Concurrency Control Performanc
Contact us
Onsite | 28 Hour

Hadoop Administration on MapR Training Course - Denver

NobleProgUS
Audience: IT professionals who aspire to get into BIG DATA world or want to change their career and move towards open source no sql solutions. This course is for all those who think, big dat/hadoop is all together new technology and...
Contact us
Onsite | 32 Hour

Oracle SQL Intermediate Training Course - Denver

NobleProgUS
Create complex queries to databases Use available operators Queries with multiple conditions Creating tables and references DDL commands (create, alter, and drop) Create referential integrity Normalization of tables (up to 3 normal form) anomalies and ways to avoid them Changes in the structure of existing tables ALTER clause Manipulation of data DML...
Contact us
Onsite | 14 Hour

SQL in MySQL Training Course - Denver

NobleProgUS
Relational database models Relational operators Characteristics of declarative SQL language SQL syntax Division language DQL, DML, DDL, DCL Data Query Language SELECT queries. Aliases columns of tables Service date (DATE types, display functions, formatting) Group Features Combining internal and external tables (JOIN clause) UNION operator Nested Subqueries (the WHERE clause, the table ...
Contact us
Onsite | 14 Hour

Transact SQL Basic Training Course - Denver

NobleProgUS
Basics Selection of all columns/fields Selection of certain columns/fields Use of distinct/unique Selection of certain rows/records Selection of values in a range Selection of values matching a pattern mask Selection of values within a list Treatment of null values How to sort and order data Selection of calculated and derived values How...
Contact us
Onsite | 14 Hour

ORACLE SQL Fundamentals Training Course - Denver

NobleProgUS
Introduction Overview Aims and Objectives Sample Data Schedule Introductions Pre-requisites Responsibilities Relational Databases The Database The Relational Database Tables Rows and Columns Sample Database Selecting Rows Supplier Table Saleord Table Primary Key Index Secondary Indexes Relationships Analogy Foreign Key Foreign Key Joining Tables Referential Integrity Types
Contact us
Onsite | 21 Hour

ORACLE PL/SQL Fundamentals Training Course - Denver

NobleProgUS
Introduction Aims and Objectives Course Schedule Introductions Pre-requisites Responsibilities SQL Tools Objectives SQL Developer SQL Developer - Connection Viewing Table Information Using SQL, SQL Developer - Query SQL*Plus Login Direct Connection Using SQL*Plus Ending the Session SQL*Plus Commands SQL*Plus Environment SQL*Plus Prompt Finding Information about Tables Getting H
Contact us
Onsite | 21 Hour
Page 1 of 1