Instructor Led Sql Fundamentals Training - Training Resources

SQL Fundamentals of Querying Upon successful completion of this course, students will be able to: * Define what a relational database is and identify some uses for the SQL language. * Recognize proper syntax for an SQL statement. * Use aggregate functions, column aliases, and mathematical expressions in a query statement. * Use the WHERE clause to select specific rows of information from a database. * Search for  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 Language  more...

Adobe and Quark Training Classes for Designers, Illustrators & Publishers: Chicago Dear Chicago Graphic Designers, Illustrators and Publishers: If you're ready to upgrade your skills in Adobe, Quark or Avid, Ascend Training is your first stop. We offer hands on classroom training in our Chicago or Deerfield Illinois facilities. We also offer onsite training in a one-on-one or group setting at your facility. While other training companies are located elsewhere and rent out  more...

SQL Programming This 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 This Transact-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...

Perl Programming and CGI Scripting This hands on Perl programming course provides a thorough introduction to the Perl programming language, teaching attendees how to develop and maintain portable scripts useful for system management, data manipulation, and Web CGI programming. Emphasis is placed on built-in subroutines that can be used to help conveniently build fast, portable and efficient scripts. Extensive hands on exercises  more...

Microsoft SQL Server 2008 Administration This class consists of five days of hands-on training 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  more...

Macromedia Dreamweaver Fundamentals -- Introduction & Intermediate Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML, CSS, XML, Access VBA, Excel VBA), MS Office (Excel, Access, PowerPoint, Word, Outlook, Project) instructor-led, classroom training at our location or your company location.  more...

Macromedia Flash / Actionscript -- Introduction & Intermediate What's in Flash MX: Basic + CBT: This ILT series course teaches students the fundamentals of using Flash MX to design animations for the Web. This course introduces students to creating and editing shapes, applying colors and line styles, combining shapes, importing bitmaps, and converting bitmaps to vector shapes. Course activities also cover adding and formatting text, using layers to arrange  more...

HTML & CSS - Fundamentals -- Introduction & Intermediate Course Description Overview: Students will learn about how to create Web documents using HMTL 4.01. Performance-based objectives Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to: Understand what HTML is, how it is used, and how it came to be. Use a text  more...

Oracle Database 11g PL SQL Fundamentals - Complete Coverage The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle  more...

Oracle Database 11g PL SQL Fundamentals I The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups  more...

Oracle Database 11g PL SQL Fundamentals II The objective of this course is to equip students to develop database server-side PL/SQL program units within an Oracle database. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are Application designers and developers and Database administrators.  more...

Oracle Database 11g SQL Fundamentals - Complete Coverage The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in  more...

Oracle Database 11g SQL Fundamentals I This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups  more...

Oracle Database 11g SQL Fundamentals II The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. This enhanced and  more...

Oracle 9i PL SQL Programming Students will learn the fundamentals of the PL/SQL programming language. Stored procedures, functions, packages and triggers implement complex business rules in Oracle. Students will learn programming, management and security issues of working with PL/SQL program units. Numerous exercises and labs will introduce students to the new PL/SQL features in Oracle9. Audience:Database administrators,  more...