Database Design & Programming with SQL: Part 2 Learning Objectives This is the second portion of the Database Design and Programming with SQL course. In this portion, students implement their database design by creating a physical database using SQL, the industry-standard database programming language. Upon completion of this course, students have the opportunity to sit for the first of two exams required to earn the Oracle Certified Associate. The course outline below includes section titles and descriptions, lesson titles, anddetailed objectives for each lesson. Section 1 SQL has many functions used to manipulate data. This section continues the discussion of functions and focuses on those that are the most common. Functions are a very powerful feature of SQL and can be used to do the following: perform calculations on data, modify individual data items, manipulate output for groups of rows, format dates and numbers for display, and convert column data types. This section also introduces substitution variables, and how these are used in Oracle Application Express. Finally, the section offers students the opportunity to examine the IT job market and identify careers that they may be interested in pursuing. Lesson 1: Case and Character Manipulation • Select and apply single-row functions that perform case conversion and/or character manipulation. • Select and apply character case-manipulation functions LOWER, UPPER, and INITCAP in a SQL query. • Select and apply character-manipulation functions CONCAT, SUBSTR, LENGTH, INSTR, LPAD, RPAD, TRIM, and REPLACE in a SQL query. • Write flexible queries using substitution variables. Lesson 2: Number Functions • Select and apply the single-row number functions ROUND, TRUNC, and MOD in a SQL query. • Distinguish between the results obtained when TRUNC is applied...
Website: academy.oracle.com | Filesize: 92kb
No of Page(s): 10
Download 2009-2010 Database Programming with SQL - Introduction to Computer.pdf
No comments:
Post a Comment