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, db, sql, rdbms, oracle, mssql, mysql and programming.
 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 |
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 NobleProg - IT training courses
SQL Language
... 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 and the SQL language
differences between SQL dialects (Oracle, T-SQL, ANSI)
practical skills for writing queries
This course deals with generic ANSI SQL language. It can be used in any database, including
more...
... 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 and the SQL language
differences between SQL dialects (Oracle, T-SQL, ANSI)
practical skills for writing queries
This course deals with generic ANSI SQL language. It can be used in any database, including
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.
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.
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 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 Thinkpath Training LLC
Updating Your Database Administration Skills to Microsoft SQL Server 2005 (Course 2733)
Thank you for your interest in Course 2733.
Introduction
This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
This course is intended for experienced database administrators and database developers who are responsible for
more...
Thank you for your interest in Course 2733.
Introduction
This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
This course is intended for experienced database administrators and database developers who are responsible for
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 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 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...
