SQL Courses

... creating database objects like tables, indexes and views, and loading data into the database with DB2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference DB2 monitor functions. Students... Learn about: Database training, IT Security...

... data queries; Attribute query with SQL; Simple spatial data analysis; Exporting attribute tables; Producing map layouts; Exporting map images; Updating the play fairway; Assessing potential acreage... Learn about: Writing Skills, Data analysis, Database training...

...MS SQL (Structured Query Language) Introduction to SQL RDBMS Concepts Normalisation Primary Key , Foreign Key DDL – Concepts DML – Concepts Insert... Learn about: Business Intelligence...

...Designed to provide the computing skills that you will need to be a modern professional in the Computing Industry. Our Course covers Software Development (XBOX360, Windows Game Development), Computer Architecture, Operating Systems, IT Applications, working in Teams, E-Commerce, SQL and Desktop... Learn about: Operating Systems, Computing skills, Computer Architecture...

... ❖ Application advanced excel tools for automation and visualisation ❖ Application of SQL commands and become proficient in SQL tools ❖ Analysis of business performance ❖ Python scripting for automation... Learn about: Data analysis, Data Collection, Data Protection...

... Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.The minimally qualified candidate typically:Is an IT professional who plans, implements, and maintains a multi-server... Learn about: Active Directory, Information Architecture, Architecture Design...

.... SQL*Plus • Connectivity • SQL*Plus DBA commands 4. Control Files 5. User and Security Management 6. Parameter Files • Parameter files (tnsnames.ora... Learn about: Schema Management, Database training, Performance Management & Tuning...

... recovery plan file, and using SQL scripts. In addition, the exercises involve multiple servers to simulate an enterprise environment. You participate in group problem determination exercises, perform a variety of backup and restore processes, and optimize data management, such as data deduplication... Learn about: IT Management, Database training...

... 4.4 Restore Part 2 Module 5: Introduction to SQL 5.0 SQL part 1 5.1 SQL part 2 5.2 Parts of SQL Statement 5.3 Select Statement Module 6: Filtering... Learn about: Installing Oracle, Database training, Database Administration...

...MS SQL (Structured Query Language) Introduction to SQL RDBMS Concepts Normalisation Primary Key , Foreign Key DDL – Concepts DML – Concepts Insert... Learn about: Business Intelligence...

... upon which SharePoint depends, including Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 R2 or later, Active Directory Domain Services (AD DS), and networking infrastructure services. Learning Objectives Describe the core SharePoint 2016 architecture... Learn about: Content Management, Database training, Business Intelligence...

... commands and SQL statements Partitioning and Database Partition Groups Identify considerations when choosing a distribution key Describe join strategies... Learn about: Database Administration, Database training...

...-462: Administering SQL Server 2012 Databases Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 After completing these 3 exams, you will earn your MCSA (Microsoft Certified Solutions Associate): Windows SQL Server 2012 Certification. Then you’ll need to pass one of the following... Learn about: Business Intelligence, Data Management, Database training...

... to emerging trends. CompTIA Cybersecurity Project Management Cisco Microsoft Adobe Microsoft SQL Azure Amazon Web Services Cloud Services and more…... Learn about: Adobe Photoshop, IT Security, Project Management...

... network. Introduction to SQL - this module is concerned with the Database Administration track teaching the SQL knowledge's and skills to use... Learn about: Network Training, Network security...

... by a hands-on exercise to create and call SQL procedures using extensive process flows and cursor processing to return result sets to the invoking client or caller. Each exercise builds on the previous exercise to allow the student to use condition handling, dynamic SQL, user-defined types, large objects... Learn about: IT Development, Basic IT, IT Security...

... Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.The minimally qualified candidate typically:Is an IT professional who plans, implements, and maintains a multi-server... Learn about: Architecture Design, Active Directory, Information Architecture...

... and its properties Controls and its events ADO.Net SQL Connection SQL Command SQL Parameter SQL DataReader SQLDataAdapter Fetching the Table data and storing... Learn about: ASP net training, ASP training...

... - Automation and scripting IBM Spectrum Protect SQL interface Macros Server scripts Daily maintenance scripts IBM Spectrum Protect REST API Unit 8 - Tuning... Learn about: IT Management, Database training...

... Exec environment. Students also learn how to configure and work with various Backup Exec Agents, which protect applications like Microsoft Exchange, Microsoft SharePoint, Microsoft SQL, and virtual environments. Hands-On This course includes practical, hands-on lab exercises that enable you to... Learn about: Database training, Microsoft Exchange, Network Training...