go backarticles

Articles of SQLschool.gr Team

Instructor-Led Training Now Available for SQL Server 2012 Are you ready?

Antonios Chatzipavlis

Αν ψάχνετε να εκπαιδευτείτε στον SQL Server 2012 τότε μην περιμένετε άλλο πλέον έχουν ήδη βγει τα σεμινάρια για αυτόν και είμαι όλος χαρά να τα διδάξω και να σας πω τι έχω δει στο SQL Server 2012 τα τελευταία 2 χρόνια που από beta ασχολούμαι μαζί του

Ποια είναι όμως αυτά τα σεμινάρια και ποίες εξετάσεις αντιστοιχούν σε αυτά:


Course 10774: Querying Microsoft SQL Server 2012 

This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. It is also appropriate entry for business analysts who may write SQL queries in other tools such as Excel, and those embarking on the jobs in the data steward career path. In short anyone who may read data from a database and can write ad-hoc queries against it. Later students will encapsulate the queries in database objects but at this stage in their knowledge would most likely not have those permissions in production environments. This course helps people prepare for exam 70-461  .

Course 10775: Administering Microsoft SQL Server 2012 Databases 

This course is designed to be the second in the series of basic skills. At this point student can retrieve (SELECT) data and has basic relational database concepts and tools experience. The next step is to understand the system more such understanding of the security model, working with the database maintenance such as backup and maintenance of indexes are covered. Students who will primarily maintain the database will find key knowledge here, but those learning the platform will benefit. Those with ANSI SQL knowledge wanting to understand the Microsoft SQL Server database management system will want to start here. This course helps you prepare for the Exam 70-462  .

Course 10776: Developing Microsoft SQL Server 2012 Databases 

Students embark on implementing the database objects in this course. They now have the rights on the server to implement the objects using data definition language statements for optimal server code performance with stored procedures. Students are also taught key topics such as geospatial data and XML storage and retrieval common in Web databases. This course helps you prepare for the Exam 70-464  .

Course 10777: Implementing a Data Warehouse with Microsoft SQL Server 2012

This course is about the movement of data. Professionals identified a key task was to move data into and out of their servers. This course covers ETL and Microsoft SQL Server 2012 Integration Services. It is the final course now that data may be retrieved, data objects such as views created, and now to move into other locations such as a data warehouse snowflake or star schema. It is still using the SQL Server relational engine so is everything up to the data warehouse before moving to analysis services. This course helps people prepare for the exam 70-463  . It is the basis for feeding the data warehouse solution created in course 10778.

Course 10778: Implementing Data Models and Reports with Microsoft SQL Server 2012

Students are now ready to implement multi-dimensional models and use SQL Server Analysis service. They will support end user reporting solutions and SQL Server Reporting Service. Business analysts may be interested in portions of this course if their primary interest is reporting piece and do not intent to create the data warehouse. Excel Power Pivot is covered in this course. This course helps people prepare for exam 70-466  .

Relative Articles

Leave your comment

Login with your SQLschool.gr account if you want to comment on this article.