Shulou(Shulou.com)06/01 Report--

On April 18, 2014, when "Tip of the tongue 2" began to air (exactly three months before this online course), foodies prepared early, and even a certain Bing Bing posted this Weibo: "it is said that you cannot turn on the TV until you have enough to eat tonight. China on the tip of the tongue, a major killer, is haunting. Hey, hey, I've prepared enough snacks to sit in front of the TV. How about you?" This class is mainly about topics related to eating.

This lesson mainly talks about how to add, delete, modify and check more than a million rows of data by reviewing two films and documentaries-"God of Food" and "China 2 on the Tip of the tongue". These operations are the same as the title of this lesson-Egg fried rice, the simplest and most difficult, is one of the operations that often perplex DBA in the production environment, which may lead to big mistakes if not done properly.

In the course of DBA's work, if you inadvertently operate a small amount of dml statements on a large table, it may kill a database, which is by no means alarmist. Mr. Zhai has personal experience.

The online open course was lectured by Mr. Zhai, the gold medal OCM lecturer of CUUG. Teacher Zhai Xiaoyu, with a master's degree in computer application from Beijing Jiaotong University, has many years of experience as an Oracle project manager, as well as experience in large-scale database engineering projects, such as the short message platform of the Traffic Administration of Beijing Public Security Bureau, the urban service level evaluation system, the individual soldier positioning system, and the emergency command and transfer system of high-speed railway. Three ministries (Ministry of Communications, Ministry of Public Security, Ministry of Science and Technology) emergency traffic accident command and processing system, equipment monitoring project, large mobile phone software mall, etc.

Can't you get into the online open course? Click the novice guide illustration → http://www.51CTO to remind you, do not spam ads! / jishushalong/gongkaike/201204/zhinan-1218.html

Course content:

1. Update the real-time table with 1 million rows (two methods)

2. Delete conditional records in 1 million rows (two methods)

3. How to insert a large amount of data correctly in the production database

4. Cursor optimization when querying large amounts of data.

See group sharing for courseware download: 314447206

Speaker: Mr. Zhai Xiaoyu, lecturer of CUUG oracle

Speaker qualification: Oracle 10g OCP, OCM

Course time: 20:00 on Friday, July 18, deadline for registration: 18:00 on July 18

Course website and password: please sign up for free and attend for free

Venue: Cisco online meeting system is used to teach online. If you have a network, you can listen to the class.

Registration method: send your name and phone number to signup@51CTO to remind you, do not spam ads! Can

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.