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 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.
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...
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, CLR
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, CLR
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...
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 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 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 Aspect Training
SQL Introduction for SQL Server
Aspecta ™s Introduction to T-SQL for SQL Server training class teaches attendees the T-SQL and SQL Server skills they need to develop queries and data reports using SQL..
Aspect Traininga ™s course will enable delegates to:
Understand how SQL Server works
Learn to select the required records
Learn to use SQL to output reports with SQL Server
more...
SQL Advanced for SQL Server
...oduct knowledge and skills needed to implement advanced T-SQL strategies on Microsoft SQL Server 2005/ 2008. The course focuses on teaching individuals how to use additional Transact SQL Server features and tools related to developing and querying a database.
After completing this course, students will be able to:
a Write and execute Transact-SQL scripts utilizing procedural language
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 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...
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 |
