Instructor Led Database Objects Training in Canada

SQL Server 2005 Transact SQL T-SQL with Additional Topics ... now use .NET languages like C# and Visual Basic to build database objects. You'll also learn about enhancements made to SQL Server 2005 for handling complex data structures, using partitioning, and working with XML. LEARNING OBJECTIVES Understand basic database design principles and how to implement them in SQL Server. Learn the fundamentals of writing Transact-SQL queries that  more...

SQL Server 2008 Transact SQL (T-SQL) ...o execute Transact-SQL code to access and update data and database objects. Discover how transactions can protect the integrity of your data and ways to handle errors that occur when code executes. Understand the complex data types in SQL Server, such as for spatial and hierarchical data, and how they support complex data operations. How to partition data to store data in ways that  more...

SQL Server 2008 for developers ...e .NET languages like Visual C# and Visual Basic to build database objects. SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You will learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You will learn how to take advantage of SQL Server's tools for analyzing and  more...

Oracle 10g Administration ...urity, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data Dictionary and Oracle 10g architecture; Administrative Users; Instances; Initialization Parameter Files; creating and managing Users; Password  more...

Oracle 10g 11g Introduction to SQL ...tilize SQL*Plus and iSQL*Plus to query, update and create database objects Create simple database tables with all the major datatypes such as NUMBER, VARCHAR2, DATE, TIMESTAMP and LOBs Query Oracle data dictionary tables such as USER_TABLES and USER_OBJECTS Utilize transaction control statements such as Commit, Rollback and Savepoint Create database objects such as  more...

Microsoft Access 2007 Level 1 Objectives * Opening and Modifying Database Objects * Working with Multiple Windows * Adding, Editing, and Deleting Records * Tour of a Form, Query, or a Report * Planning and Creating a Database * Create a Table Using the Table Wizard * Create a Report Using the Report Wizard * Create a Form Using the Form Wizard * Database Object Management *  more...

Microsoft Access 2003 Level 1 (1 Day) ...Seats Available: 2 Objectives Opening and Modifying Database Objects Working with Multiple Windows Adding, Editing, and Deleting Records Tour of a Form, Query, or a Report Planning and Creating a Database Create a Table Using the Table Wizard Create a Report Using the Report Wizard Create a Form Using the Form Wizard Database Object Management Finding, Filtering, and  more...

Microsoft Access XP 2003 Level 1 ...Database Objects * Working with Multiple Windows * Adding, Editing, and Deleting Records * Tour of a Form, Query, or a Report * Planning and Creating a Database * Create a Table Using the Table Wizard * Create a Report Using the Report Wizard * Create a Form Using the Form Wizard * Database Object Management * Finding, Filtering, and Formatting Data  more...

Plsql Programming for Oracle Professionals This course runs for five full days; from 8:30 am to 4:30 pm. PL/SQL is quickly becoming the most widely used programming language for Oracle. In this instructor-led course, we will explore topics such as: * The Oracle Development Environment * Creating the Database * Creating Tables * Structured Query Language Basics * Advanced Structure Query Language * PL/SQL  more...

Microsoft Office Access 2007 Foundation ... a Template Creating a Blank Database Using Database Objects Setting Navigation Options Step-By-Step Skill Sharpener About Records What is a Record? Navigation Tips Adding Records Editing Records Deleting Records E-Mailing Records Printing Records Step-By-Step Skill Sharpener  more...

Microsoft Access 2000 - 2003 Level 1 Data Entry and Reports Upon completion, participants will be able to : Identify & work with the components of a database, work with tables, create several query types, create several report types, preview & print database objects & change the page setup options.  more...

Microsoft Access 2000 - 2003 Level 1 Database Design nexient Who should attend? This course is intended for new users of Access 2000/ 2002/ 2003. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Identify the components of a database, and work with those components Open a table, find information stored there, and enter data Create a table design from a template, and customize it  more...

Microsoft Access 2000 - 2003 Level 1 Database Design - nexient Who should attend? This course is intended for new users of Access 2000/ 2002/ 2003. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Identify the components of a database, and work with those components Open a table, find information stored there, and enter data Create a table design from a template, and customize it  more...

Microsoft Access 2000 - 2003 Level 1 Data Entry Reports-Nexient Upon completion, participants will be able to : Identify & work with the components of a database, work with tables, create several query types, create several report types, preview & print database objects & change the page setup options.  more...

Microsoft Access 2000 - 2003 Level 1 Data Entry Reports 1 day course - nexient Upon completion, participants will be able to : Identify & work with the components of a database, work with tables, create several query types, create several report types, preview & print database objects & change the page setup options.  more...