SQL Courses

...This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps... Learn about: Create SQL Server Backups, Restore SQL Server databases, Describes the system databases...

...This course is intended for Developers, Database Administrators, and System Programmers who require further insight into the SQL language. Note: Guided eLearning is a self-paced offering which includes web-based content for self-study and videos (including audio) that demonstrate activities. If...

.... Benefits to You: Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Advanced Features of SQL: By enrolling in this course, you'll also gain exposure to using... Learn about: Database training...

...This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding...

...Develop the skills needed to become a fully qualified SQL Server 2012 database administrator with the official Microsoft Certified Systems Architect qualification. Upon completion of this intensive hands-on course, students will be ready to sit the... Learn about: MCSA training...

... Exam 70-764. By the end of this course, you will be able to administer a Microsoft SQL 2016 server. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment... Learn about: Database training, SQL Database...

... consolidation onto database clouds.Learn Advanced Features of SQL:This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects... Learn about: Database training...

...This Oracle 12C SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning. It is designed to give delegates practical experience in analysing and tuning the performance of SQL. This course is suitable for users of Oracle Database 11g and Oracle... Learn about: Database training...

...Develop the skills needed to become a fully qualified SQL Server 2012 database administrator with the official Microsoft Certified Systems Architect qualification. Upon completion of this intensive hands-on course, students will be ready to sit the... Learn about: Database training, MCSA training...

...Microsoft SQL 2012 - Administering (Exam 70-462) This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system... Learn about: Database training...

... for this course is: Database Administrators, Database Developers and BI professionals. Learning Objectives After completing this course, students will be able to: Describe key capabilities and components of SQL Server 2016. Describe T-SQL, sets, and predicate logic. Write a single table SELECT statement. Write a multi-table... Learn about: Database training...

... and SQL Server Master Data Services...

...Oracle 12c SQL Fundamentals is the first step towards the Oracle Certified Professional (OCP) certification and provides you with the Oracle Certificate Associate (OCA) status upon completion... Learn about: Database training, Data warehousing, Data Collection...

...This course teaches developers, database administrators, and system programmers various features of SQL, including column functions, grouping, unions, subqueries, and maintaining data. Note: Guided eLearning is a self-paced offering which includes web-based content for self-study and videos...

... by enabling consolidation onto database clouds.Gain Experience through Hands-On PracticeIn this course, you'll learn from expert Oracle instructors, then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. You'll use Oracle SQL Developer to develop these program units... Learn about: Database training...

...The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Windows Azure cloud-based...

.... • Combine datasets. • Create and alter DML triggers. • Create and alter indexes. • Create and alter stored procedures. • Create and alter tables. • Create and alter user-defined functions (UDFs). • Create and alter views. • Create and modify constraints. • Design T-SQL stored procedures. • Design views...

...Supporting database analysts and designers to go beyond simply understanding the mechanics of SQL Server 2012, this course shows how to create and deploy database solutions for an enterprise-class environment... Learn about: MCSE training, Database training, XML training...

... to be able to design and create PL/SQL packages and program units that execute efficiently. Students will also learn how to write and tune PL/SQL code and learn to create Oracle PL/SQL applications that use collections. On this Oracle 11g Advanced PL/SQL course you will implement a virtual private database... Learn about: Access Control...

...The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint...