Classroom Live, instructor-led training in a standard, professional classroom environment. Virtual Live, instructor-led training conducted over the internet, with hands-on labs. On-site Private training for your entire team, delivered at your location, a training center, or online. Video classroom High-definition video of our most popular courses, streamed to your laptop or personal device. Already purchased this offering?
|Published (Last):||25 April 2019|
|PDF File Size:||13.21 Mb|
|ePub File Size:||14.96 Mb|
|Price:||Free* [*Free Regsitration Required]|
Classroom Live, instructor-led training in a standard, professional classroom environment. Virtual Live, instructor-led training conducted over the internet, with hands-on labs. On-site Private training for your entire team, delivered at your location, a training center, or online. Video classroom High-definition video of our most popular courses, streamed to your laptop or personal device.
Already purchased this offering? Log in. Elements of this syllabus are subject to change. Administrators, implementers, system engineers and developers.
Before attending this course, students must have:. This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise. Upon completion of this program, participants should be able to :. The student will also be introduced to SQL Server database concepts such as relational databases, normalization, and database objects. In addition, the student will learn how to use T-SQL to query databases and generate reports.
After completing this module, students will be able to:. The students will be introduced to the basic Transact-SQL T-SQL statements that are used for writing queries, filtering data, and formatting result sets. Lab : Querying and Filtering Data. Lab : Grouping and Summarizing Data. The students will learn to write joins to query multiple tables, as well as limiting and combining result sets. Lab : Joining Data from Multiple Tables. The students will be introduced to basic and correlated subqueries and how these compare with joins and temporary tables.
The students will also be introduced to using common table expressions in queries. Lab : Working with Subqueries. In addition, students will examine how transactions work in a database, the importance of transaction isolation levels, and how to manage transactions. Lab : Modifying Data in Tables.
The students will learn to query semi-structured and unstructured data. The students will also be introduced to full-text indexing in SQL Server The students will be introduced to user-defined functions and executing various kinds of queries by using user-defined functions.
The students will be introduced to SQL Server views that encapsulate data and present users with limited and relevant information. In addition, the students will be introduced to SQL Server stored procedures and the functionalities of the various programming objects.
The students will learn how to perform distributed queries and how SQL Server works with heterogeneous data such as databases, spreadsheets, and other servers. The students will be introduced to best practices for querying complex data. The students will also examine how to query complex table structures such as data stored in hierarchies and self-referencing tables. The students will analyze the recommended guidelines for executing queries and how to optimize query performance.
Lab : Using Advanced Querying Techniques. Eswaran has been working in the IT industry since He has 12 years of involvement in the IT industry with the past 8 years being in IT training. He continuously seeks to update his knowledge with the latest technology developments. Having worked in various IT and telecommunication companies, has given him a strong foundation in database design, development and applications programming on various platforms. As part of the developers' team in various projects, he was also involved in proposal writing on design solutions to clients.
Besides conducting Microsoft related training, he also trains on the various applications developed by the company. His key specializations lie in database and programming. Having experienced many years in acquiring skills and knowledge in the related fields, the trainer is among a few of extraordinary trainers in the local training arena. The one thing that makes her a prominent trainer is her knowledge and exposure gathered over many years in IT industry. She is well known to have the ability to enlighten participants by not only leading them towards the subject matter but also by allowing them to relate to the subject matter and at the same time make the process of learning a lot more easier.
Over the years, she has developed many training modules and had extended her service to various companies. Read More. Gerald has 19 years of information technology experience and on community service and event experiences, he excels impressively.
He was the only Malaysian presenter among the other presenters from Asia. With his previous vast experiences, he is allowed to provide training for Microsoft Office , , and Microsoft Office , Programming with Microsoft Visual Basic.
Net Applications for Windows VB. Ng Yew Ban has more than 20 years of experience in the software industry involving full software development lifecycle. He has trained many IT professionals from his specialized and practical knowledge including industry best practices and patterns. Many famous and well-reputable IT training centres have invited him to deliver advance courses for their corporate customers. He started his career with programming and gradually took up the responsibilities of architect, analysis, design, QA, team management, project management, on-site software projects and on-site business development in the United States of America, Australia and Taiwan.
NET Server Technologies. He has also been instrumental in devising course curriculum, developing courseware and preparing the faculty for in-house training programmes. His participants find his training sessions to be practical, meaningful, informative and extremely interesting.
Net Framework Visual Basic and C. He is also well verse in ASP. Net using Visual Studio. NET web application with C. When not involved in development, Brian focuses on teaching and evangelizing Microsoft. NET technologies and visions. Net launch in Singapore. He was the speaker for Microsoft technical and partner briefing seminars in Singapore. His areas of expertise include.
Net Framework Development 1. He teaches on. Cheah has more than 23 years of experience in the IT industry and 17 years in computer training.
He has 5 years of experience as an analyst programmer in a Singapore manufacturing company where he gained knowledge and analytical skill to develop and handle different systems. He also gained a reputation of providing high quality of training and of sharing his knowledge and experience. Daryl Soong has been working in the IT industry since As such, he has had ample exposure and experience relating to all manners of businesses and problem scenarios faced by IT personnel of different levels.
He understands the importance of business value, infrastructure efficiency and user productivity. He has successfully managed and implemented several local projects related to his area of expertise.
She has more than 10 years of experience in conducting training, developing course materials and syllabus for IT courses especially Microsoft applications such as Word, Excel, PowerPoint, Access, Outlook and other programming courses for public, in house and individuals.
She is excellent in handling training as she has more than 10 years of hands-on experience as IT support and working in an information technology environment. Her sessions are full of hands-on activities to ensure participation and maximum comprehension. I am programming on the Microsoft platform because I was impressed by the Visual Studio , although I had dabbled in other operating systems.
Net, ASP. Net with Microsoft Visual C. I also recently doing Hadoop Big Data administration and development. Respect Your Dreams. Follow through on your goals with courses. Ways to train Classroom Live, instructor-led training in a standard, professional classroom environment Virtual Live, instructor-led training conducted over the internet, with hands-on labs Online An online, HTML5, self-paced learning experience available for all courses On-site Private training for your entire team, delivered at your location, a training center, or online Video classroom High-definition video of our most popular courses, streamed to your laptop or personal device Learn more about our training formats.
All of our private classes are customized to your organization's needs. Click on the button below to send us your details and you will be contacted shortly. Describe the structure of a SQL Server database.
Explain the basics of the SQL language. Describe the syntax elements of T-SQL. Explain how to manage T-SQL scripts. Module 2: Querying and Filtering Data. Filter data by using different search conditions. Explain how to work with NULL values. Format result sets. Describe the performance considerations that affect data retrieval. Module 3: Grouping and Summarizing Data. Rank grouped data. Module 4: Joining Data from Multiple Tables.
MOC-2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries. When you're learning new skills and meeting new people it's important that you do so in comfortable, modern surroundings. You'll enjoy a rewarding training course here at PFH premises and benefit from our modern training facilities. Please note that the above facilities are available to rent for your specialised training event also.
MOC 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL