USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on November 18, 2013, 05:01:00 PM
-
Coming SQL Server 2012 online live class will add a one time 2 hour special session:
Tuesday 12/17/2013 2hr 18:00 to 20:00 (USA PST Time)
How to write a workable resume with skills you learned in this class.
SQL Server 2012 (Core Package Course) Schedule 6 sessions start on 2013-11-30
Saturday: 11/30/2013 4hr 08:00 to 12:00 (USA PST time)
Tuesday: 12/03/2013 3hr 18:00 to 21:00 (USA PST Time)
Thursday: 12/05/2013 3hr 18:00 to 21:00 (USA PST Time)
Tuesday: 12/10/2013 3hr 18:00 to 21:00 (USA PST Time)
Thursday: 12/12/2013 3hr 18:00 to 21:00 (USA PST Time)
Saturday: 12/14/2013 4hr 08:00 to 12:00 (USA PST time)
This course is a perfect enter point for a new Core Package study. If you want join the class, please do register ASAP, so you can start download the class material and books today, make yourself ready for the class. You will be in a better shape when the class start.
The class is live online, you take the class from your home, we use internet, we can see each other computer screen, we can listen and talk to each other. You do not have to drive to school or fly to California.
In the class, will teach you how to get materials like software, ebooks, sample data, sample SQL code, and Projects. The sample resume, prepare interview consulting, will worth more than the money you pay for the class.
Most important, the Project you learn and DO from this class will add into your resume as the experience.
You do not have to buy any other stuff. No other hiding fee.
This class is part of Core Package 2013.
Cost: $999
Click here: Register course use Credit Card. (http://student.usalaotu.com/make_payment.php)
Click here: Register course use Paypal. (http://student.usalaotu.com/courseschedule.php)
Pre-request: NO.
This is a perfect start class for those who wants to enter IT field as a Database Analyst or Reporting Engineer.
With its nice interface on windows and easily integration with other Windows Applications, Microsoft SQL Server database has been widely used in many companies.
Although this class will focus on how to use SQL Server 2012 for Database Analyst, this class will show you how to use SQL on both Oracle and SQL Server, and teach T-SQL procedure and cursor programming.
In the first part of the class, you'll learn how to install and configure SQL Server 2012, and how to install an OLTP database and sample Account Payable ERP database into your PC. You will learn the concepts and terms you need for working with Oracle or SQL Server. You'll also learn how to use the Microsoft SQL Server 2012 Management Studio to work with queries and databases. At that point, you'll be prepared for rapid progress as you learn SQL.
In second part, you'll learn all the skills for retrieving data from a database and for adding, updating, and deleting that data. These skills move from the simple to the complex so you won't have any trouble if you're a SQL novice. And they present skills like using outer joins, summary queries, and subqueries that will raise your SQL expertise if you do have SQL experience.
In the third part, you'll learn how to design a database and how to implement that design by using either SQL DDL (Data Definition Language) statements or the Management Studio. When you're done, you'll be able to design and implement your own databases. But even if you're never called upon to do that, this section will give you perspective that will make you a better SQL developer.
The fourth part of the class presents the skills for working with database features like views, stored procedures, functions, triggers, cursors, transactions, and security. These are the features that give a database management system much of its power and that give you an extra edge in your SQL skills.
The content of SQL Server 2012 class listed as below:
Chapter 1 An Introduction to Microsoft SQL Server and SQL
Chapter 2 How to Install SQL Server 2012
Chapter 3 How to Install and use the Microsoft Studio
How to Install Databases
Chapter 4 How to retrieve data from a single table
An introduction to the SELECT statement
How to code the SELECT clause
How to code the WHERE clause
How to code the ORDER BY clause
Chapter 5 How to retrieve data from two or more tables
How to work with inner joins
How to work with outer joins
How to work with Unions
Chapter 6 How to code summary queries
How to work with aggregate functions
How to group and summarize data
How to summarize data using SQL Server extensions
Chapter 7 How to code subqueries
An introduction to subqueries
How to code subqueries in search conditions
Other ways to use subqueries
Chapter 8 How to insert, update, and delete data
How to create test table
How to use the SELECT INTO statement
How to use copy of the database
How to insert new rows
How to modify existing rows
How to delete existing rows
Chapter 9 How to work with data types and fuctions
A review of the SQL data types
How to convert data
How to work with String data
How to work with numeric data
How to work with data/time data
CASE, COALESCE and ISNULL function
How to use ranking functions
Chapter 10 How to design a database
How to design a data structure
How to normalize a data structure
Chapter 11 How to create and maintain databases and tables with SQL statements
An Introduction to DDL
How to create database, tables, and indexes
How to use constraints
How to change databases and tables
The script to create the AP database
Chapter 12 How to work with views
An introduction to views
How to create and manage views
How to use views
How to use the view Designer
Chapter 13 How to code scripts
An introduction to scripts
How to work with variables and temporary tables
How to control the execution of a script
Advanced scripting techniques
Chapter 14 How to code stored procedures, functions and triggers
How to code stored procedures
How to code user-defined functions
How to code triggers
Chapter 15 How to work with cursors
How to use cursors in SQL Server
How to use cursors to retrieve data
How to modify data through a cursor
Chapter 16 How to manage database security
How to work with SQL Server login IDs
How to work with permissions
How to work with roles
How to manage security using the Management Studio
-
I am already a core package student, where can I do the registration for it?
-
Will publish class connect info later.
-
Hello everyone,
This is Lily, a newbie who just registered to the Core Package courses yesterday. Where to download the SQL Server 2012 software in order to start the course on 11/30? Also where to download the other 3 software? I appreciate anyone who can give me any hints. Thanks!
-
Please don't do anything before you receive the class material and watch the previous class viceo....you should follow the insturction and demo in the class video, please don't do it by yourself ahead ....
Hello everyone,
This is Lily, a newbie who just registered to the Core Package courses yesterday. Where to download the SQL Server 2012 software in order to start the course on 11/30? Also where to download the other 3 software? I appreciate anyone who can give me any hints. Thanks!
-
如月, could you please give me some instructions where to watch the previous videos of SQL server 2012, Crystal Reports 2011? Thanks.
-
After you register the class, you will receive the class materials download link from laoshi
Read that e-mail carefully, becasue it include all the information and instructions you need to know....to start
如月, could you please give me some instructions where to watch the previous videos of SQL server 2012, Crystal Reports 2011? Thanks.
-
http://student.usalaotu.com/signon.php
Click course web link after sign on.
如月, could you please give me some instructions where to watch the previous videos of SQL server 2012, Crystal Reports 2011? Thanks.
-
Hi, I am a student of core package course, may I attend the new class of SQL2012 at 11/30/13?
Thanks!
-
Should I start to download the SQL2012 course materials from 09/15/2013 to 09/29/2013 session? Or just wait till the next new session starting from 11/30/2013? Thanks.
http://student.usalaotu.com/signon.php
Click course web link after sign on.
-
星期二可以在上午吗?
-
New student can start download class material now, watch previous class video before class start.
To fit into schedule of most students, we schedule class in evening in weekdays. No Tuesday day time class now.
Core Package student who has joined online live class previously are welcome to join this online class again with a fee.
Thanks.
-
All of our courses are recorded.
You will be able to access previous class video immediately after register.
You will get access to new class video after each class.
Therefore, it is not a problem even you miss a class.
-
Coming SQL Server 2012 online live class will add a one time 2 hour special session:
Tuesday 12/17/2013 2hr 18:00 to 20:00 (USA PST Time)
How to write a workable resume with skills you learned in this class.
SQL Server 2012 (Core Package Course) Schedule 6 sessions start on 2013-11-30
Saturday: 11/30/2013 4hr 08:00 to 12:00 (USA PST time)
Tuesday: 12/03/2013 3hr 18:00 to 21:00 (USA PST Time)
Thursday: 12/05/2013 3hr 18:00 to 21:00 (USA PST Time)
Tuesday: 12/10/2013 3hr 18:00 to 21:00 (USA PST Time)
Thursday: 12/12/2013 3hr 18:00 to 21:00 (USA PST Time)
Saturday: 12/14/2013 4hr 08:00 to 12:00 (USA PST time)
-
how to join the class for the pre-students?
-
Question: I did notice that you had old SQL server2012 class offered back to Sep.2013. Is here any major difference between the old class and the new one incoming?
Answer:
After register, student can review September's class video immediately.
And student will have access to new class video too after class start.
New stuff always added into each new class.
Will add a one time two hour session of how to write a workable resume in this SQL Server 2012 class.
Thanks.
-
How to join this 2hr special session (resume workshop) for previous students who have already attended the online sql server course?
Thank you!
-
To join the online live class:
Core Package student who registered after September 25 can join the coming SQL Server 2012 online live class.
Please find course infor from student signon web page.
After sign on, click class name web link.
Class connection information and download material is located in that web page.
After register class, if you have time, please do nothing but review previous class video.
To join the 2 hour special session for prepare resume:
Will send out information on weekend of Dec 14. Please just wait.
-
Thank you, Laoshi!
-
What is Core Package? Read the definition about Core Package from this link:
http://forum.usalaotu.com/index.php?topic=987.0
Core Package student got good deal to take four RECORDED courses.
However, USA LaoTu allow Core Package student take same online class once for FREE after they register the core package.
This is a benefit, but not a must.
Some students chose not join the online class due to their busy schedule, this is totally understandable, they can always review the video of their class later.
-
Password is one of our system security measure. Student can easily generate a password from signon page. Read the instruction please.
Same here, I purchased the core package in Sept. Just before Sept.25 and have not attended any live classes yet, I would have thought that I was allowed to join one of live classes at least. When I tried to join this coming SQL Server 2012 class on 11/30, I was asked about the password used for the class, which means I don't have permission for the class too???
Besides, I have trouble to sign in the recorded course SQL 2012 09/15/2013-09/29/2013, asking me about the password used for the class!
Please help, hopefully we can spend much more time on just studying! Thanks!
-
All of our class will be recorded, student can review video after class.
Therefore, it is not a problem for study if you miss one or more classes.
-
hi, I am a core package student and have never attended the live sql server class before. I clicked the sql server 11/30 link on my student page, but was told my email was not authorized. Could you please check? thanks!
-
Hi you registered Core Package on 2013-07-07.
Core Package student suppose take RECORDED course.
However, chance was given for Core Package student to join online live class for FREE for once.
It is your own choice to decide taking or not taking online class on September.
You can watch class video of September as you prefer.
Thanks.
hi, I am a core package student and have never attended the live sql server class before. I clicked the sql server 11/30 link on my student page, but was told my email was not authorized. Could you please check? thanks!
-
Thanks for the reply. I was in China September. The class begins 11pm or 12am Beijing Time. so I didn't take the that class. as you say, core package student can take one live class for free, not take THE SEP CLASS for free. I wonder if the 11/30 class could be my free class. thanks!
-
Since we have video, you can always review it any time.
More questions? Please email to inquiries@usalaotu.com, some one will answer for you.
Thanks.
Thanks for the reply. I was in China September. The class begins 11pm or 12am Beijing Time. so I didn't take the that class. as you say, core package student can take one live class for free, not take THE SEP CLASS for free. I wonder if the 11/30 class could be my free class. thanks!
-
Dear Laoshi and all,
I couldn't find the connection to the online live class(SQL Server 2012) yesterday(11/30/2013). So I watched the old video which was recorded on May, 2013. My question is do I have a chance to watch the new class recorded video? Where to find it? Due to my busy schedule and time zone difference, I preferred to watch recorded video. Thank you very much.
-
We had excellent class yesterday.
The video is available for review. Message has published on SQl Server Student message board.
Please go to the same student signon page, after login, click class web link, you will find class connection info and video access in that same web page.
Many student learn skills by watching recorded course. Yes, you can do it too!
Dear Laoshi and all,
I couldn't find the connection to the online live class(SQL Server 2012) yesterday(11/30/2013). So I watched the old video which was recorded on May, 2013. My question is do I have a chance to watch the new class recorded video? Where to find it? Due to my busy schedule and time zone difference, I preferred to watch recorded video. Thank you very much.
-
Thanks for your quick response. This is a wonderful school.
-
Just put this class dates in the forum calendar.
Access from the forum menu
or here
http://forum.usalaotu.com/index.php?action=calendar
-
Thanks a lot!
Just put this class dates in the forum calendar.
Access from the forum menu
or here
http://forum.usalaotu.com/index.php?action=calendar
-
正在进行的 SQL Server 2012 课， 广受大家好评。为满足老同学们想再听课的要求:
Core Package Student who registered class within 365 days can join listen current SQL Server 2012 class for FREE.
Please goto http://student.usalaotu.com/signon.php
After sign in, Click link: SQL Server 2012 Old Core Package Student Listen Online Class
After register class, waiting for approval.
Come join SQL Server 2012 class tonight at 6:00pm California time.
-
LaoShi,
Thank you so much!
-
非常非常感謝老師給老同學機會，老師真是越講越好。
請問老師，如果無法參加所有Live class，老同學（old student in 365 days）是否之後可以允許看教學視頻？
-
:)
正在进行的 SQL Server 2012 课， 广受大家好评。为满足老同学们想再听课的要求:
Core Package Student who registered class within 365 days can join listen current SQL Server 2012 class for FREE.
Please goto http://student.usalaotu.com/signon.php
After sign in, Click link: SQL Server 2012 Old Core Package Student Listen Online Class
After register class, waiting for approval.
Come join SQL Server 2012 class tonight at 6:00pm California time.
Did anybody try this way? After sign in ,I was asked to enter email used for course, password used for course , then I was told that my email is not authorized. Can anybody help me figure out the issue?
Thanks a lot.
-
I have the same problem. Maybe this link was only for the class which was over? The link will be given for the next class?
-
No problem at all, you just need to wait to get your registration approved, and then you will receive the meeting link before the class start
-
Have anyone received the confirmation so far? The class will start in one hour and 17 minutes.
如月：When is the "before the class start"?
-
再等等， 因该没有问题
-
哪位老同学可以在线听了吗？
谢谢
-
I can not.
-
After you sign in here: http://student.usalaotu.com/signon.php,
you can see link: SQL Server 2012 Old Core Package Student Listen Online Class. click it, then use your email, your password which you used when you sign in the form above, you can register the class
-
Thanks Lucy
-
Just finished the class. It's as good as always.
By the way, I did the registration yesterday, and got the confirmation email 9 minutes before the class started.
-
Add the 2 hour session for How to write a Workable Resume:
18:00 to 20:00 Tuesday Dec 17.
Student who joined this SQL Server class online will get the connection infor automatically.
-
Add the 2 hour session for How to write a Workable Resume:
18:00 to 20:00 Tuesday Dec 17.
Student who joined this SQL Server class online will get the connection infor automatically.
Thank you, Laoshi!!
-
Hi Sir or Madam,
I just register a SQL Server 2012 course. I would like to register for How to write resume course as well.
Look forward to hear from you,
Best regards,
Y
-
Please send this kind of class related questions to inquiries@usalaotu.com with your registered name and e-mail address
Hi Sir or Madam,
I just register a SQL Server 2012 course. I would like to register for How to write resume course as well.
Look forward to hear from you,
Best regards,
Y
-
Webinar information for How to write a Workable Resume has been emailed to you.
Thanks.
-
SQL Server 2012 class finished this morning.
Students are very happy to gain SQL Server skills by working on many different projects.
In today's class, previous graduated students Rong and Xia shared there real work experience and real project in large USA company and Europe company with class mates. Students asked all sorts of very interesting questions about study, job hunting, and real world work cases.
Class video is available for review.
We will add a two hour FREE for students in this class, discuss about how to prepare a workable resume.
See you on Tuesday evening Dec. 17.
-
This class does very helpful, no matter what kind of background you had and which level you began with, I believe everyone is absorbing useful stuffs by her or his own way.
Therefore, I would like to give a great thanks to LaoShi for his effort of doing all of this for us. Meanwhile, I would like to emphasize one more thing: do your best to think and work on the projects independently, you will gain amazing rewards with no doubt !
Happy Holiday Season to LaoShi, 如月 as well as all former and current classmates !!!
-
just wondering if an old core package student registered within 365 days will be able to ONLY LISTEN TO the special session-RESUME WORKSHOP.
did send the inquiry to Laoshi, unfortunately no definite response has been received yet at the moment.
Dear peers, any advice will be welcome and highly appreciated!
Thanks a lot!
Katie
-
Yes, you can listen the resume webinar.
We will NOT have record for this special session.
-
Thank you so much, Laoshi, for your immediate response. Look forward to the special resume workshop.