Curs SQL Avansat

Durata curs: 40 ore
Format: Online - Live cu instructor sau la sediul clientului
Pretul include: diploma de participare si suportul de curs, in format electronic
Pretul nu include TVA.

De ce sa alegeti cursurile noastre?
Experienta de peste 28 de ani in domeniul instruirii profesionale.
Traineri certificati national si international.
Flexibilitate: cursuri online sau la sediul clientului, oriunde in tara.
Discount-uri negociabile pentru volume mari.
Cursurile pot fi personalizate in functie de nevoile companiei si pot fi desfasurate online sau la sediul beneficiarului.

Solicitati o oferta personalizata, pentru angajatii companiei dumneavoastra! EMAIL  office@promanagement.ro

Plan De Curs
Introduction to Oracle Database
o List the features of Oracle Database
o Discuss the basic design, theoretical, and physical aspects of a relational database
o Categorize the different types of SQL statements
o Describe the data set used by the course
o Log on to the database using SQL Developer environment
o Save queries to files and use script files in SQL Developer
Join Operators
o Describe the SQL operators for joins
o List the possible access paths
o Join Methods
o Nested Loops Join
o Nested Loops Join: Prefetching
o Nested Loops Join: 11g Implementation
o Sort-Merge Join
o Hash Join
o Cartesian Join
o Join Types
o Equijoins and Nonequijoins
o Outer Joins
Retrieve Data Using Sub-queries
o Multiple-Column Subqueries
o Pairwise and Nonpairwise Comparison
o Scalar Subquery Expressions
o Solve problems with Correlated Subqueries
o Update and Delete Rows Using Correlated Subqueries
o The EXISTS and NOT EXISTS operators
o Invoke the WITH clause
o The Recursive WITH clause
Manipulate Large Data Sets
o Use Subqueries to Manipulate Data
o Retrieve Data Using a Subquery as Source
o Insert Using a Subquery as a Target
o Usage of the WITH CHECK OPTION Keyword on DML Statements
o List the types of Multitable INSERT Statements
o Use Multitable INSERT Statements
o Merge rows in a table
o Track Changes in Data over a period of time
Regular Expression Support
o Use the Regular Expressions Functions and Conditions
o Use Meta Characters with Regular Expressions
o Perform a Basic Search using the REGEXP_LIKE function
o Find patterns using the REGEXP_INSTR function
o Extract Substrings using the REGEXP_SUBSTR function
o Replace Patterns Using the REGEXP_REPLACE function
o Usage of Sub-Expressions with Regular Expression Support
o Implement the REGEXP_COUNT function
Management of Schema Objects
o Add, Modify, and Drop a Column
o Add, Drop, and Defer a Constraint
o How to enable and Disable a Constraint
o Create and Remove Indexes
o Create a Function-Based Index
o Perform Flashback Operations
o Query External Tables
Schema Objects
o Create a simple and complex view
o Retrieve data from views
o Create, maintain, and use sequences
o Create and maintain indexes
o Create private and public synonyms
Manage Objects with Data Dictionary Views
o Explain the data dictionary
o Use the Dictionary Views
o USER_OBJECTS and ALL_OBJECTS Views
o Table and Column Information
o Query the dictionary views for constraint information
o Query the dictionary views for view, sequence, index and synonym information
o Add a comment to a table
o Query the dictionary views for comment information
Control User Access
o Differentiate system privileges from object privileges
o Create Users
o Grant System Privileges
o Create and Grant Privileges to a Role
o Change Your Password
o Grant Object Privileges
o How to pass on privileges?
o Revoke Object Privileges
Introduction to SQL Tuning
Identify a cause of the problems:
o Recognize a SQL tuning issue
o Clarify the details of the issue
o Verify that the issue is the problem
o Check the basics (after the SQL problem is verified)
o Choose an appropriate tuning strategy
o What Is Bad SQL?
Using the SQL Trace Facility and TKPROF
o Configure the SQL Trace facility to collect session statistics
o Discuss steps needed before tracing
o Enable appl