USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team 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. (http://usalaotu.com/make_payment.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 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
-
是老土老师讲吗？
-
Yes.
是老土老师讲吗？
-
Class start date changed to May 25.
-
刚注意到课程推迟了，不会再继续推迟吧 ：-）
-
Teacher of Advanced MSBI ETL & SSIS gets sick today, so have to postpone the schedule for one week.
刚注意到课程推迟了，不会再继续推迟吧 ：-）
-
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.
刚注意到课程推迟了，不会再继续推迟吧 ：-）
-
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.
-
Sorry, the class have to postpone to May 25.
Wish there will be no more delay.
Thanks for understanding.
-
您好！
这个系列课程共５个周六讲授，如果我因有急事误了一次课，请问怎样可以补上这节课呢？
多谢！
-
You can watch the recorded class video after the class, you won't miss the class, it is the same.
您好！
这个系列课程共５个周六讲授，如果我因有急事误了一次课，请问怎样可以补上这节课呢？
多谢！
-
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
-
发现一位新来的小蜜蜂Newbee同学
你好牛B！
-
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.
-
土老师，您的网站今天一整天都不能登陆。今天的课您计划重播吗？
-
2012-05-25 SQL Server class video link has been emailed out to students.
Please check your email, include your junk email folder.
Enter your email address to watch class video.
Your current IP will be tight with your email and save into database.
If your IP changed, you will get error.
Email to keiko if you get error.
-
看老师的SQL课程编排的越来越简洁明析！赞！越后来的同学越有福气啊！加油！