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

Author Topic: SQL Server 2012 第四期 Start Saturday May 25  (Read 27360 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
SQL Server 2012 第四期 Start Saturday May 25
« on: April 14, 2013, 08:45:53 AM »
SQL Server 2012 第四期 Schedule 5 sessions:

Saturday Morning 9:00 to 13:00 California time
05/25/2013             06/01/2013           06/08/2013                 
06/15/2013             06/22/2013

This class is the beginning of a new Core Package process. 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 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.

All the class materials, software, books, sample data, sample SQL code, and Project will be supplied to you. 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.
This class is part of Core Package.

Cost: $999

Make payment: Click here pay by Credit Card.

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 2008 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 2008, 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

Ding Ding

  • MSBI 2008
  • Newbie
  • *
  • Posts: 17
  • Karma: +0/-0
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #1 on: April 25, 2013, 07:56:49 PM »
是老土老师讲吗?

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #2 on: April 25, 2013, 08:58:21 PM »

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #3 on: May 03, 2013, 10:21:14 PM »
Class start date changed to May 25.

lmaalm

  • Core Package
  • Newbie
  • *
  • Posts: 22
  • Karma: +0/-0
Re: SQL Server 2012 第四期 Start Saturday May 18 to Jun 15
« Reply #4 on: May 04, 2013, 09:32:53 AM »
刚注意到课程推迟了,不会再继续推迟吧 :-)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第四期 Start Saturday May 18 to Jun 15
« Reply #5 on: May 04, 2013, 09:40:14 AM »
Teacher of Advanced MSBI ETL & SSIS gets sick today, so have to postpone the schedule for one week.


刚注意到课程推迟了,不会再继续推迟吧 :-)

lmaalm

  • Core Package
  • Newbie
  • *
  • Posts: 22
  • Karma: +0/-0
Re: SQL Server 2012 第四期 Start Saturday May 18 to Jun 15
« Reply #6 on: May 04, 2013, 04:52:47 PM »
Admin,

我早上给您单独发的email 不知是否成功,主要是想问我的 windows vista 是不是太旧了,computer 连接互动需要什么软件吗?我要发言是用mic 吗?多谢。
The class is 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.

Teacher of Advanced MSBI ETL & SSIS gets sick today, so have to postpone the schedule for one week.


刚注意到课程推迟了,不会再继续推迟吧 :-)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第四期 Start Saturday May 18 to Jun 15
« Reply #7 on: May 04, 2013, 05:17:47 PM »
Didn't receive your email/message.
Widow Vista is too old.
Better use Windows 7 or 8.
Better get a headset, with ear phone and mic.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #8 on: May 09, 2013, 03:08:33 PM »
Sorry, the class have to postpone to May 25.

Wish there will be no more delay.
Thanks for understanding.

newbee

  • SQL Server SQL
  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #9 on: May 13, 2013, 01:34:56 PM »
您好!

这个系列课程共5个周六讲授,如果我因有急事误了一次课,请问怎样可以补上这节课呢?


多谢!

如月

  • Core Package
  • Hero Member
  • *
  • Posts: 1742
  • Karma: +17/-2
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #10 on: May 13, 2013, 02:35:02 PM »
You can watch the recorded class video after the class, you won't miss the class, it is the same.

您好!

这个系列课程共5个周六讲授,如果我因有急事误了一次课,请问怎样可以补上这节课呢?


多谢!

Gracie

  • Core Package
  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #11 on: May 21, 2013, 08:53:26 AM »
I just registered. Could someone please let me know what is the next step after paying online. I will need the access to the class or links. Who should I contact with?
thank you in advance
Gracie

lao9

  • Core Package
  • Hero Member
  • *
  • Posts: 581
  • Karma: +20/-0
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #12 on: May 22, 2013, 01:28:06 PM »
发现一位新来的小蜜蜂Newbee同学
你好牛B!
Google before asking | Change what you can | 学好Excel 增加一只吃饭的手 http://t.cn/8FaGKwz | 微信号 datatrix

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #13 on: May 23, 2013, 06:25:27 PM »
Class connection infor has been emailed to registered students.
After register, waiting for approval.
Better register before Friday night.
Don't wait till Saturday morning please.

ronee

  • SQL Server SQL
  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
Re: SQL Server 2012 第四期 Start Saturday May 25
« Reply #14 on: May 25, 2013, 09:20:17 PM »
土老师,您的网站今天一整天都不能登陆。今天的课您计划重播吗?