Will start SQL Server 2012 online live class on Feb 08, 2014.
Class time: 8:00 to 12:00 (USA PST) Saturday, 18:30 to 21:00 (USA PST) Monday
02/08/2014 4hr 02/10/2014 2.5 hr
02/15/2014 4hr 02/17/2014 2.5 hr
02/22/2014 4hr 02/24/2014 2.5 hr
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-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.