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

Author Topic: SQL Server 2012 (Core Package Course) start on 2013-11-30  (Read 60514 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
SQL Server 2012 (Core Package Course) start on 2013-11-30
« 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.

Click here: Register course use Paypal.

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

xz3

  • Core Package
  • Newbie
  • *
  • Posts: 19
  • Karma: +0/-0
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #1 on: November 18, 2013, 05:22:33 PM »
I am already a core package student, where can I do the registration for it?

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #2 on: November 18, 2013, 06:02:43 PM »
Will publish class connect info later.

LilyHou

  • Core Package
  • Newbie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #3 on: November 21, 2013, 08:18:42 AM »
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!

如月

  • Core Package
  • Hero Member
  • *
  • Posts: 1742
  • Karma: +17/-2
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #4 on: November 21, 2013, 08:45:43 AM »
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!

LilyHou

  • Core Package
  • Newbie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #5 on: November 21, 2013, 09:02:44 AM »
如月, could you please give me some instructions where to watch the previous videos of SQL server 2012, Crystal Reports 2011? Thanks.

如月

  • Core Package
  • Hero Member
  • *
  • Posts: 1742
  • Karma: +17/-2
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #6 on: November 21, 2013, 10:23:58 AM »
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.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #7 on: November 21, 2013, 10:41:55 AM »
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.

dreamoon

  • Core Package
  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #8 on: November 22, 2013, 08:50:25 AM »
Hi, I am a student of core package course, may I attend the new class of SQL2012 at 11/30/13?

Thanks!

LilyHou

  • Core Package
  • Newbie
  • *
  • Posts: 10
  • Karma: +0/-0
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #9 on: November 22, 2013, 09:11:28 AM »
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.

 

hanna

  • Core Package
  • Jr. Member
  • *
  • Posts: 96
  • Karma: +0/-1
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #10 on: November 25, 2013, 09:50:32 AM »
星期二可以在上午吗?

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #11 on: November 25, 2013, 09:59:29 AM »
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.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第6期 (Core Package Course) start on 2013-11-30
« Reply #12 on: November 25, 2013, 09:44:13 PM »
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.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
SQL Server 2012 Extra session: How to write a workable resume with SQL Skills
« Reply #13 on: November 26, 2013, 07:13:01 AM »
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)

yellosand

  • Core Package
  • Sr. Member
  • *
  • Posts: 306
  • Karma: +7/-1
Re: SQL Server 2012 (Core Package Course) start on 2013-11-30
« Reply #14 on: November 26, 2013, 09:08:43 AM »
how to join the class for the pre-students?