Your Cart Is Empty
Home > Technical Courses > SQL Server > Intermediate to Advanced SQL Programming
This course explores how to identify and use advanced querying techniques to manipulate and index tables.
The Intermediate to Advanced SQL Programming course explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work is ANSI SQL compliant and should work with SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Join us and learn the skills you need to develop, analyze, and maintain data in structured, modern, and secure databases.A company's success hinges on responsible and accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers, to setting financial goals. Data professionals like analysts, developers, and architects are tasked with creating, optimizing, managing, and analyzing data from databases, with little room for error. When databases aren't built or maintained correctly, it's easy to mishandle or lose valuable data.
Category
ID
Duration
Level
Price
Oracle Database
12984
2 Day(s)
Advanced
$1,495.00
Objectives
Successful completion of this course will increase your knowledge and ability to understand:• Advanced Query Techniques• Manipulating Table Data Using SQL's Data Manipulation Language (DML)• User-Defined Functions• Stored Procedures• Triggers
1. Understanding SQL Advanced• Understanding the Difference Between SQL, SQL*Plus, and PL/SQL• Understanding the SQL Developer Environment and Commands2. SQL MODEL Statements• Symbolic cell addressing• Symbolic array computation• Wildcard dimension specification• Iterative rule evaluation• Partition wise computation3. Analytical Functions• Single Row Analytic Functions• Aggregating Analytic Functions• PIVOT / UNPIVOT• The MODEL clause4. SQL*Plus Reporting• SQL*Plus Report Writing Commands• COLUMN Command / Titles, System Variables• Master-Detail Report with TITLE and COLUMN Commands• Control Breaks, Computing Aggregate Amounts• Using SET Variables in SQL*Plus, SQL to Generate SQL• Creating, Deferrable, Dropping, Disabling/Enabling Constraints / Displaying Constraint Information• Handling Exceptions• Views, Synonyms, Sequences, Indexes, Virtual Columns• Temporary Tables, External Tables5. Data Manipulation Language (DML) Commands• MERGE Command• Use of Subqueries• Transaction Control Commands / Read Consistency / Locking• Flashback Queries6. Data Definition Language (DDL) Commands• TRUNCATE, COMMENT, RENAME Command• Views, Synonyms, Sequences, Indexes, Virtual Columns• Temporary Tables, External Tables
7. Security• Users• Privileges• Roles• Authentication Methods8. Multiple Table Inserts• Unconditional Insert ALL• Conditional Insert All• Conditional Insert First• Pivoting Insert• With StatementLabsLab 1: Creating Tables and ConstraintsLab 2: Creating ViewsLab 3: Data ManipulationLab 4: Single Row FunctionsLab 5: Advanced JoinsLab 6: SubqueriesLab 7: Group FunctionsLab 8: Analytic FunctionsLab 9: SQL*Plus ReportingLab 10: Advanced DDLLab 11: Advanced DML
Questions?
Oracle Database SQL Certified Associate
An understanding of relational database design concepts and general knowledge of SQL.
Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.
Productivity Point Headquarters 1580 Sawgrass Corporate Parkway Suite 205 Sunrise, Florida 33323 United States
Contact T 1-844-238-8607 P 1-954-425-6141 F 1-954-928-9057 E info@productivitypointls.com