USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on May 17, 2014, 04:55:32 PM
-
Oracle PL/SQL Programming
Teacher Chris is an Oracle expert with more than 15 years Database developer experience in USA companies. He taught SQL server T-SQL programming course in USA LaoTu school, students learned a lot.
Five 4 hour sessions, total 20 hours.
Registration: http://student.usalaotu.com/make_payment.php
Price:
$1098 for general public
$798 for students paid $2999
$748 for students paid $3999
$698 for students paid $4999 and up
8:00am to 12:00pm Sunday, 06/15/14 to 7/13/14
Class 1
Introctuction
PL/SQL Variable
PL/SQL Dataype and their Functions
date
number
varchar2
%type
Clob
PL/SQL table
Analytic functions
Regular Expressions: avoiding hard coding
Project: Data cleansing
Sending catch up file: by date , or by cust_id?
Class 2
Oracle PL/SQL control structure and keyword
begin end
when
if
exit
exist
loop
session
commit
rollback
Cursor
explicit
implicit
ref cursor
Bulk collect
Project: Prevent and remove duplicate
Class 3
Oracle objects
Funtion
parameter order and named
return
cursor as parameter
return cursor
pl/sql table as parameter
return pl/sql table
table function
Procedure
return values?
Package spec and body
global variable
Views
Trigger
Autonomous
Mutating table
in line procedure, in line function
with
Project: table_to_file
Class 4
performance
index
function based index
active distinc values
dup_val_on_index
hint to silently remove dupe value
compress
partition
hint
parallel processing
materilized view
global temprorary table
dblink and clob
truncate vs delete
Dynamic SQL
Project: supporting a QA project
Class 5
error handling
common errors
when others
error log table
continue on error
space estimate and management
connecy by
pivote and unpivot table
v$session etc
Project On line Application support
password repeating characters
returning object to front end
-
Is the registration information going to be posted later?
-
Yes, will publish later soon.
-
Thanks, Laotu and Chris.
-
Thank you John for your interest in this class.
I recently started a new job. I joined at a time of crisis. Our team of 20+ had a project this was over due for several weeks.
I helped them resolve a performance issue in a pretty easy way, and helped them remove a a major road blocker. Now the project
is almost completed, and they are asking me to sit in every major meeting, with top management. How good can that be!
I am surprised at myself can 打开局面in such a short time at a new company.
I would like to share my story in more detail in my class.
-
学习PL/SQL是不是像学Oracle对SQL一样对T-SQL有帮助？
-
Yes, exactly. Learn Big Data will help Oracle too, on Unix/Linux system.
-
我是core package 的新学员, just started SQL class，want to know what's the pre-request for this class? Should I finish SQL and oracle from core package first.
-
Oracle 11g SQL class is the pre-request for Oracle PL/SQL class.
(Sorry for the confusing, previous old reply was talking about Hadoop Big Data class. It was deleted.)
我是core package 的新学员, just started SQL class，want to know what's the pre-request for this class? Should I finish SQL and oracle from core package first.
-
Thanks for your reply, Chris. I do remember you are a such expert of SQL, we need learn from you a lot.
I recently cross join another group to build Oracle Apecs application, I need us a lot of Pl/sql, are you familiar with this tool?
I also sometimes use "Postgres SQL",what I can say, Sql be in every place.
I expect your class.
-
John,
Unfortunately, I have not used Oracle Apecs, although I have used so many different application/tools when worked in Oracle environment, such as SAS, Informatica, Business Object, Tibco, Arbor, Maestro, Composite... It is almost an endless list. but guess what, as long you are strong in PL/SQL, you can easily work well in those area.
One recommendation for those who want to take my PL/SQL class: prepare ahead, bring you questions and problems to class, I will address your questions, and solve your problems. It will be much more fun, and you will learn much more.
See you.
Chris
-
It's ok, pl/sql is the key for that tool so far as I know. It use sql to build web app.
-
老师，我还挺喜欢你简单直接的讲课方式，当然更看重你十几年的工作经验。但是我想知道想听懂这么课的基础高么，因为我只是看过core package oracle 的 video。 我这种基础现在上你的课是不是就象听天书还是能基本能听懂呢？谢谢
-
With Oracle 11g SQL is enough to study PL/SQL course.
-
老师，我还挺喜欢你简单直接的讲课方式，当然更看重你十几年的工作经验。但是我想知道想听懂这么课的基础高么，因为我只是看过core package oracle 的 video。 我这种基础现在上你的课是不是就象听天书还是能基本能听懂呢？谢谢
身为Chris 老师 T-SQL的学生，我认为不管目前是否能听懂，直接来上课就对了，因为Chris老师的课有太多宝贝可以借用到未来您的实际工作中。这是十几年经验的累积。是我们所有学生的宝藏。
-
这个课可以注册了吗？找不到注册的地方。
-
Once the course tuition is finalized and announced here, you can register from the Pricing page the same way as you register other course: http://www.usalaotu.com/pricing--35838312432021526684.html
-
Five 4 hour sessions, total 20 hours.
Registration: http://student.usalaotu.com/make_payment.php
Price:
$1098 for general public
$798 for students paid $2999
$748 for students paid $3999
$698 for students paid $4999 and up
-
Hi Chriss,
Could you pls talk one topic about choping the sql statement into different batches to get the result in the class?thank you!
-
John,
Absolutely. I will make sure you understand everything about it.
Way to go, John! You ask for it, and you will get it!
I hope more students will do this.
Chris
-
你们好！我是新学生，对这里还不熟悉。我已经付钱报名了这个课程了，怎么还没有收到以前的video呢？希望能尽快收到，可以安排时间看一下。我是三个孩子的妈妈，平时挺忙的。谢谢！
-
Oracle PL/SQL is NOT a Core Package course.
This is the first time we open Oracle PL/SQL class, there was no previous video available for this class at this moment.
First class video will be ready for class students to review in the night of the class day.
Thanks.
-
老土老师，
我看了一下PL/SQL的内容介绍，觉得对写SQL很有帮助，决定报名了。现在同时学SQL，SSIS，HADOOP，PL/SQL和CRYSTAL REPORTS，时间实在分不过来，一些作业要看样子来不及做了，到时候还希望您和Chris老师多多包涵。
在此先谢过了
-
不苦不累求职无味，不拼不搏低薪白活.
-
不苦不累求职无味，不拼不搏低薪白活.
谢谢老师，又一句老土语录，收藏了！
-
Chris,
I will be your PL/SQL student. Do I need any pre-class preparation? I took Oracle live class at month, do I need go over Oracle class video before PL/SQL?
Thanks,
Yi
-
Liyi0522,
My class will be very hands on and work related. It would certainly help if you come to class well prepared.
Go over your class material, or your projects at work. Think about issues or problems or puzzles you had. Bring them to class. The better prepared, the more you will learn from this class. I will make sure you get your questions answered.
Welcome to my class!
Chris
-
易同学，
你太厉害了，同时学五门课，你是老土学校的学霸，无人能及了
老土老师，
我看了一下PL/SQL的内容介绍，觉得对写SQL很有帮助，决定报名了。现在同时学SQL，SSIS，HADOOP，PL/SQL和CRYSTAL REPORTS，时间实在分不过来，一些作业要看样子来不及做了，到时候还希望您和Chris老师多多包涵。
在此先谢过了
-
易同学，
你太厉害了，同时学五门课，你是老土学校的学霸，无人能及了
老土老师，
我看了一下PL/SQL的内容介绍，觉得对写SQL很有帮助，决定报名了。现在同时学SQL，SSIS，HADOOP，PL/SQL和CRYSTAL REPORTS，时间实在分不过来，一些作业要看样子来不及做了，到时候还希望您和Chris老师多多包涵。
在此先谢过了
没办法，我眼睛里只有高薪，哈哈。
-
说的是西部时间，东部时间是从11点开始？
-
Could be
-
Fabulous 1st class, Thank you, Chris.all info are very useful in the real work. Can you talk some how to use auto trace...in your next class when you have time.
John
-
This is definitely an outstanding class full of useful knowledge. The amazing part is the way Chris teacher's hands-on practice. By looking how he jump around to compose a query, you can see and understand his logical thinking as a Sr. professional
-
请问什么时候开 PL/SQL 的专区? 还有好像上课的资料好像不可以下载 :-(
-
请问什么时候开 PL/SQL 的专区? 还有好像上课的资料好像不可以下载 :-(
The download is OK, I just tried and got the materials.
If you are PL/SQL student,send your forum ID to Inquiries@usalaotu.com to activate your access to the corresponding message board.
-
同问:pl/sql sub_category in the students forum?
John