好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text

Author Topic: SQL Server 2012 Term VIII Live Class Start on Saturday, May 17,2014  (Read 16676 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4807
  • Karma: +35/-11
SQL Server 2012 Term VIII live class will start on May 17, 2014

Class Time:   8:00AM to 12:00PM (USA PST) Saturday (4hr/class)
Class Dates:  05/17/2014   4hr morning   
                    05/20/2014 2hr     05/27/2014  2hr   18:30  to 20:30
                    05/31/2014 4hr  morning    06/07/2014  4hr morning     06/14/2014    4hr morning     

SQL Server 2012 is one of the Core Package 2013 courses, and it's a perfect enter point for a new Core Package student. If you want join the class, please register ASAP, so you can start download the class materials and watch previous class videos today and prepare yourself for the new class well.

The live class is online. You take the class from home using internet access.  You may interact with teacher and other students during Q&A time or before/after lecture. So, please have your headset and microphone ready.

In the class, you will get information about where/how to get materials, such as related software, ebooks, sample data, sample SQL code, and real life Projects. There will be tips about resume and interview preparation, which worth more than the money you paid for the class.

Most important, the Projects that you will be learning and DOING from this class can be included in your resume as your working experience.

There is no other hidden fee.
Cost: $999
Please pay at the Pricing page: http://www.usalaotu.com/pricing--35838312432021526684.html

Once you have been approved or has access to your student account, please remember to register GO-TO-Meeting for the live class.  Reminder email with the link to each live class will be emailed you before live class starts.

Pre-requisite: None.

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.

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 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.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4807
  • Karma: +35/-11
Dr. LaoTu  will teach this SQL Server 2012 class.
This is a great course for any one to enter Database Analyst field.
A perfect time for a new Core Package student to start.
Will add new databases and new processes for class projects. Will keep students busy.

KEHUA

  • Core Package
  • Newbie
  • *
  • Posts: 11
  • Karma: +0/-0
Hello Laotu,

After registering this course, do i still have chance to switch to core package afterwards if i decide to continue to learn?  For now, I want to register this course for starting. 

Thank you,

Kehua   

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4807
  • Karma: +35/-11
Yes, you can convert to a Core Package students within 30 days.

KEHUA

  • Core Package
  • Newbie
  • *
  • Posts: 11
  • Karma: +0/-0
Hello teacher,

I just made payment and what I should do next?


thanks,

Kehua

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4807
  • Karma: +35/-11
You should have received email, just follow it step by step...

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4807
  • Karma: +35/-11
Schedule change:

SQL Server 2012 Term VIII live class will start on May 17, 2014

Class Time:   8:00AM to 12:00PM (USA PST) Saturday (4hr/class)
Class Dates:  05/17/2014   4hr morning   
                    05/20/2014 2hr  18:30  to 20:30   05/27/2014  2hr   18:30  to 20:30
                    05/31/2014 4hr  morning    06/07/2014  4hr morning     06/14/2014    4hr morning     

yellosand

  • Core Package
  • Sr. Member
  • *
  • Posts: 306
  • Karma: +7/-1
I'm an old student, I can help you if you post your questions

KEHUA

  • Core Package
  • Newbie
  • *
  • Posts: 11
  • Karma: +0/-0
Hello Laotu,

This is my first class, i missed first hours of the class  due to time difference ( I am in the east of Canada ).  I am wondering where I can find today's video so i can watch it again.

Thanks,

Kehua

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4807
  • Karma: +35/-11
Today's class video wil be ready this evening.  There is nothing to worry about.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4807
  • Karma: +35/-11
Re: SQL Server 2012 Term VIII Live Class Start on Saturday, May 17,2014
« Reply #10 on: May 17, 2014, 04:08:57 PM »
SQL2012 ch1_5_20140517 class video is ready for review, located in same class webpage of signon.php.
Enjoy study!

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4807
  • Karma: +35/-11
Re: SQL Server 2012 Term VIII Live Class Start on Saturday, May 17,2014
« Reply #11 on: May 28, 2014, 06:59:28 AM »
SQL2012 ch7_20140527 class video is ready for review, located in same class webpage of signon.php.
In last night's class, we all enjoyed watch Mili, Yi, and Liang shown their excellent projects.
It is really amazing to see different classmates used different ways to get the projects done.
新同学们看到这几位同学的作品,很感慨的赞道: USA LaoTu 的学生们都太厉害了!
其实 米粒同学是在本期课开课前五天才报的名参加的,易同学是今年三月才开始的,亮同学也才学了一年,最近一直有面试。
同学们在课堂上讲自己做的项目,既极大的锻炼了讲课的学生,也让听课的同学快速提高,收益很多。这是 USA Laotu 课堂的独有特质,别的任何地方都没有。
Thanks everybody!
Enjoy study!