SQL Training and Seminars

Databases and SQL

SQL Training Classes SQL - Structured Query Lanaguage
The language used to get information into and out of Relational Database tables in RDBMSs such as MS SQL Server and Oracle. Learn about tables, views, indexes, SELECTs, UPDATEs, DELETEs and INSERTs.
Some important terms: sql, select, rdbms, dbms, database, select, query, reporting, structured query lanaguage, data, tables, views, indexes database, mssql, mysql, oracle, programming, rdbms and sql.
SQL Training Seminars and Classes
From Hands On Technology Transfer, Inc.
SQL Programming instructor led trainingcomputer labClassroom-based, instructor-led training with 50% hands-on labs ...SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand  more...
Microsoft Transact-SQL Programming instructor led trainingcomputer labClassroom-based, instructor-led training with 50% hands-on labs ...SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course covers T-SQL programming constructs, predefined data types including XML, deployment of stored procedures and triggers, use of  more...
SQL Server 2016 Business Intelligence Integration Services and Analysis Services instructor led trainingcoursewarecomputer lab ...SQL Server 2016 provides a rich environment for business intelligence development. The focus of this five day course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data  more...
SQL Server 2016 Business Intelligence Application Development SSRS SSIS SSAS instructor led trainingcoursewarecomputer lab ...SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting new report design enhancements. Three of the five days are reserved for SSRS, with the remaining two days providing an introduction to SSIS and SSAS  more...
SQL Server 2016 Reporting Services instructor led trainingcoursewarecomputer lab ...SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting new report design enhancements. The three day course includes an overview of the SQL Server business intelligence architecture focusing the role  more...
Microsoft SQL Server 2014 Administration ...ining that focus on the fundamentals of administering the SQL Server 2014 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2014. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data  more...
SQL Server 2014 Business Intelligence Integration Services and Analysis Services ... (SSAS) business intelligence tools that are bundled with SQL Server 2014. Students will install and configure SQL Server 2014 servers that are enabled for SSIS and SSAS, which are then used for comprehensive hands on exercises demonstrating key features of SSIS/ SSAS. Students work with complex SSIS data migration projects that import/ export data between multiple formats including: Access,  more...
SQL Server 2014 Reporting Services ...SQL Server Reporting Services 2014 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports,  more...
SQL Server 2014 Business Intelligence Application Development SSRS SSIS SSAS ...SQL Server 2014 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students start by installing and configuring SQL Server 2014 servers that support SSRS, SSIS and SSAS. Hands-on exercises will be performed where they create various types of reports, including basic table-based reports, parameterized reports, drilldown  more...
From Wise Owl Business Solutions Ltd
Writing SQL instructor led traininggroup study and discussioncoursewareworkshop / seminarcomputer lab You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the  more...
From Sql Server Online Training
COMPLETE PRACTICAL TRAINING ON T-SQL AND SQL SERVER BASICS on-line e-learning cbt (computer based)coursewareworkshop / seminarcomputer lab SQL School is one of the best training institutes for SQL Server Dev, SQL DBA and MSBI Trainings. We have been providing Online and Corporate Trainings for the last SIX years. All our training sessions are COMPLETELY PRACTICAL on LIVE environment with Realtime examples and Case Studies. We assure you quality of training. Study Material and Practice Material included in the course.  more...
SQL SERVER INTEGRATION SERVICES SSIS REALTIME ONLINE TRAINING on-line e-learning cbt (computer based)workshop / seminarcomputer lab ...SQL School provides Interactive and Practical LIVE Online Trainings on T-SQL, SQL DBA and MSBI (SSIS, SSAS, SSRS). All sessions are completely PRACTICAL. Course Highlights for SQL Server Integration Services (SSIS) Online Training: a Database Engine Limitations and Need for MSBI Process a Introduction to SSIS Workflow Environment a Control Flow and Data Flow Operations a  more...
PROJECT ORIENTED WEEKEND REGULAR TRAINING ON SQL Server 2008 DBA ONLINE ...SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 2012 DBA Training. We have been providing Online Training, Classroom Training and Corporate Training for the last SIX years. All our sessions are completely Practical and Real-time. SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING SQL Server Basics a SQL Server Design Architecture a 2008 R2 & 2012 a  more...
SSIS WEEKEND ONLINE TRAINING SQL SCHOOL COMPLETELY PRACTICAL ...SQL School provides Interactive & Practical Online Trainings and Classroom Trainings on SQL Server Integration Services (SSIS). All the sessions are completely PRACTICAL. One Realtime Case Study included in the course. Daily and Weekend Batches available. Course Fee: INR 6000 (fixed course fee) Free detailed course curriculum, schedule, timings and free demo registration, please visit:  more...
Realtime Classroom Training on MSBI SQL School ...SQL School provides Interactive & Practical Trainings on Microsoft Business Intelligence (MS BI 2012). Real Time Case Studies are also included in the course. No PPTs nor Screenshots during live sessions. All the sessions are completely PRACTICAL. Modules Discussed: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).  more...
Complete Practical Training on MSBI SQL School ...SQL School provides Interactive & Practical Trainings on Microsoft Business Intelligence (MS BI 2012). Real Time Case Studies are also included in the course. No PPTs nor Screenshots during live sessions. All the sessions are completely PRACTICAL. Modules Discussed: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).  more...
Practical Weekend Online Training on Microsoft Integration Services SSIS at SQL School ...SQL School provides Interactive and Practical LIVE Online Trainings on T-SQL, SQL DBA and MSBI (SSIS, SSAS, SSRS). All sessions are completely PRACTICAL. Course Highlights for SQL Server Integration Services (SSIS) Online Training: Database Engine Limitations and Need for MSBI Process Configuring SSIS Catalog Database Introduction to SSIS Workflow Environment Control Flow and Data  more...
From Serebra Learning Corporation
SQL Data Management on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd Gives students a practical grasp of SQL commands for manipulating data, and teaches commands to define tables, views, and indexes.  more...
SQL Queries on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.  more...
SQL/DS Essentials on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course Introduces the student to the SQL/DS environment, SQL and QMF, as well as teaches structure, commands and security features.  more...
Basic SQL Programming on-line e-learning cbt (computer based) This course introduces the student to the basics of T-SQL. It also covers the skills required to retrieve and modify data using T-SQL. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.  more...
Advanced SQL Programming on-line e-learning cbt (computer based) This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.  more...
SQL Basic Skills on-line e-learning cbt (computer based) This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students willl be able to query and update tables using SQL statements.  more...
SQL Advanced Skills on-line e-learning cbt (computer based) This course is the second course in the SQL Programming curriculum that consists of two courses. The course describes the statements used to manipulate data and to work with tables, indexes, and views. The students will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions.  more...
Database Technologies Part 2: Introduction to SQL on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd ...dge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course this course teaches students the essential SQL statements and associated variations needed to perform fundamental data access and manipulation on a relational database. After taking this course students will have a solid foundation in two  more...
From Open Source Training
SQL Programming ...SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand  more...
From NobleProg - IT training courses
SQL Programming Training Course instructor led trainingon-line e-learning cbt (computer based)group study and discussioncoursewareself directede-bookbookworkshop / seminarcomputer lab ...SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: * how to write SQL queries * what relational databases are and how we can use them * what are relations and how to create them * the structure of data * differences between SQL dialects (Oracle, T-SQL,  more...
SQL Advanced in MySQL instructor led trainingon-line e-learning cbt (computer based)group study and discussioncoursewareworkshop / seminarcomputer lab This course has been created for people already acquainted with SQL. The course introduces you into secretes common to all SQL databases as well as MySQL specific syntax, functions and features. Requirements Good SQL knowledge.  more...
Administering SQL Server 2008 instructor led trainingon-line e-learning cbt (computer based)group study and discussioncoursewareworkshop / seminarcomputer lab This course will enable delegates to administer a SQL Server 2008 database. The course will cover the SQL Server 2008 components and tools. Improving database and server performance will be introduced. The course will also include the new features in SQL Server 2008.  more...
Introduction to Firebird instructor led trainingon-line e-learning cbt (computer based)group study and discussioncoursewareworkshop / seminarcomputer lab Classic, SuperClassic or Superserver? What is in the kit? Default disk locations Installing Firebird Server configuration and management Working with databases Protecting your data  more...
From Accord info Matrix Pvt. Ltd
PHP MySQL Rich Internet applications (RIA) are web applications that have the features and functionality of traditional desktop applications. RIAs typically transfer the processing necessary for the user interface to the web client but keep the bulk of the data (i. e., maintaining the state of the program, the data, etc.) back on the application server. This is a web application program capturing  more...
From Learn Well Professional classes
SQL PL-SQL training in Pune by corporate professionals ... Since we deal with all Datawarehousing tools, for which SQL is basic requirement, all our trainer specialize in SQL. Our experts from the industry having real time experience will definitely give you the best of knowledge. Our trainers come to you with the huge experience of giving corporate training also. SQL/ PL-SQL training package: 1. Basics of RDBMS 2. Basics/ Advanced concepts of  more...
From Modulus
SQL Server 2008 Integration Services group study and discussioncoursewarebookworkshop / seminar In this three day course, you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, destinations, SSIS package management and deployment, error handling and logging techniques. The instructor kit for this course is appropriate for  more...
SQL SERVER 2008 REPORTING SERVICES from Modulus Training instructor led trainingcoursewareworkshop / seminarcomputer lab ...SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You'll then explore tabular and list reports that employ datasets and data regions. As you progress you'll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports  more...
T-SQL 2008 instructor led traininggroup study and discussioncoursewarebookworkshop / seminar ..., you will learn about the features that are available in SQL Server such as how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for error  more...
SQL Server 2008 for Developers instructor led traininggroup study and discussioncoursewareworkshop / seminarcomputer lab ...SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management Studio and how to build effective views,  more...
From Goldstar Software Inc.
Implementing Pervasive Data Exchange instructor led trainingcomputer lab This is a new class developed by Goldstar Software for 2005! This course covers all of the aspects of installing, implementing, and monitoring the Pervasive DataExchange product in your application environment. It is also includes extensive labwork to implement DataExchange and troubleshoot replication problems.  more...
From Aspect Training
SQL Introduction for SQL Server courseware ...et and Intranet Web site. Aspecta ™s Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals. This course is designed for people with no relational database experience. The database that we use for the class is MySQL, an open source product that is gaining in popularity in the industry.  more...
SQL Advanced for SQL Server courseware Building upon the skills mastered in Aspect Traininga ™s Introduction to SQL and Database Design course, Advanced SQL and Database Programming teaches the development techniques needed to take full advantage of powerful and flexible data-driven applications. We'll turn from the prior course's concern with data modelling and database design to how to use data in extensive, enterprise-class  more...
From CAL Business Solutions
GP Essentials for IT - Beyond the Basics Topics of this class include: Basic SQL Management, SQL 2005 & 2008 Overview, Configuration of reporting Services a How to Make SQL reports visible in GP, Overview of SQL Report Builder, Disaster recovery, SQL Maintenance Plans, Recommended File maintenance for GP SQL Databases.  more...
From Open Technology Group, Inc.
PostgreSQL Administration instructor led trainingcomputer lab ...SQL Administration (5 days) As the most advanced PostgreSQL course in the industry, this course covers a broad range of diverse topics of importance to administrators. Students attending this course will learn how to administer and performance tune a database, and learn how to leverage other useful modules, such as connection pooling, full text searching, and replication. Our PostgreSQL  more...
From New Horizons Albany - Tech Valley
Databases instructor led training The following list is of all the courses and classes we provide. Learn how to create and manage databases using both Access and FileMaker. You will also learn how to manage information efficiently with Crystal reports and SQL You will learn all of the code that you will need to use these databases everyday.  more...
From New Horizons Charlotte
Databases instructor led training The following list is of all the courses and classes we provide. Learn how to create and manage databases using both Access and FileMaker. You will also learn how to manage information efficiently with Crystal reports and SQL You will learn all of the code that you will need to use these databases everyday.  more...
From Makau Corporation
SQL Server 7.0 on-line e-learning cbt (computer based)cd rom Learn to manage data retrieval and exportation, create advanced queries, control security, configure, replicate, and monitor all information contained within your SQL 7.0 database. Then move on to data warehouse managment, cubes, MDX statements, and much more in the tutorial series for SQL Server 7.0. 12 levels - 224 training modules  more...
SQL 2005 - Querying Microsoft SQL Server 2005 Database with Transact-SQL on-line e-learning cbt (computer based)cd rom Learn about the Transact-SQL programming language, what it is and how to query Microsoft SQL Server 2005. Then move on to how to use Transact-SQL query tools to retrieve data, format results, grouping and summarizing data. And then learn how to join multiple tables, work with subqueries, modify data in existing tables, and use programming objects. 3 levels - 49 training modules  more...
From Impart IT Training
Introduction to SQL ...SQL (Structured Query Language) - the language used to create, modify, manage and query relational databases (RDBMSs). Using real world examples you will create a database, add schemas and tables, set permissions, insert, update and delete data, and retrieve your data using standard SQL. You will also learn about the most common features of the proprietary extensions to the standard language  more...
Custom Search
tcw11-v473M-03/27/17-00:59:19-()[B]-[B]-[B]