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.
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.
| Filter By Training Type: |
From Wise Owl Business Solutions Ltd
Writing SQL
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...
Writing SQL
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...
SSRS 2005
...into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will also learn how to create ad hoc reports using the Report Builder and Report Model
more...
...into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will also learn how to create ad hoc reports using the Report Builder and Report Model
more...
From Hands On Technology Transfer, Inc.
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...
...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 Serebra Learning Corporation
SQL Data Management
Gives students a practical grasp of SQL commands for manipulating data, and teaches commands to define tables, views, and indexes.
more...
Gives students a practical grasp of SQL commands for manipulating data, and teaches commands to define tables, views, and indexes.
more...
SQL Queries
Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.
more...
Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.
more...
SQL/DS Essentials
This course Introduces the student to the SQL/DS environment, SQL and QMF, as well as teaches structure, commands and security features.
more...
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
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...
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
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...
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
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...
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
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...
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
...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...
...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 Hands On Technology Transfer, Inc.
Microsoft Transact-SQL Programming
...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 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...
Microsoft SQL Server 2008 Administration
...ining that focus on the fundamentals of administering the SQL Server 2008 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2008. 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...
...ining that focus on the fundamentals of administering the SQL Server 2008 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2008. 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 2008 Reporting Services
...s three-day hands-on course thoroughly covers Microsoft's SQL Server Reporting Services utility, including the generation and distribution of parameter reports, drill-through reports, matrix reports (pivot tables) and linked reports. It begins with an overview of the Reporting Services architecture, and then presents the procedures for creating reports of all types. The course also covers how
more...
...s three-day hands-on course thoroughly covers Microsoft's SQL Server Reporting Services utility, including the generation and distribution of parameter reports, drill-through reports, matrix reports (pivot tables) and linked reports. It begins with an overview of the Reporting Services architecture, and then presents the procedures for creating reports of all types. The course also covers how
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
...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 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
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...
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...
Introduction to Firebird
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...
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 MUX Data Systems, Inc
CE120 SQL Workshop June 20 2011
This course provides an introduction to the SQL language and applies to the entire DB2 Family, and Informix. This course is appropriate for customers working in all DB2 environments, that is, z/ OS, VM/ VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.
more...
This course provides an introduction to the SQL language and applies to the entire DB2 Family, and Informix. This course is appropriate for customers working in all DB2 environments, that is, z/ OS, VM/ VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.
more...
From Modulus
SQL Server 2008 Integration Services
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...
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
...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...
...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
..., 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...
..., 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
...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...
...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 Aspect Training
SQL Introduction for SQL Server
...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...
...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
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...
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 Goldstar Software Inc.
Implementing Pervasive Data Exchange
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...
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 Community Business College
Introduction to SQL
Gain a solid working knowledge of the most powerful and widely used database programming language.
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
...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...
...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 Microsys Technologies and Solutions Pvt. Ltd.,
SQL Server 2008 Database Administration
...SQL Server 2008 with SQL Server Management Studio and Transact-
SQL
Build databases and upgrade from prior versions
Secure the server through logins and database permissions management
Implement backup and recovery strategies and manage transaction logs
Automate administrative activities with SQL Server Agent multistep jobs
Perform routine maintenance to correct fragmentation
more...
From New Horizons Albany - Tech Valley
Databases
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...
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
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...
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
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...
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
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...
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...
online course |
instructor-led class |
learn at home |
group study |
self-directed study |
cd-based training |
 DVD video training |
printed book |
e-book digital book |
workshop seminar |
 train the trainer |
computer-based learning |
 discount pricing |
 online tutorial |
