Enable Technology

SQL 

SQL Training Courses Midlands

SQL Training Courses West Midlands Birmingham Telford Wolverhampton

Enable Technology is a West Midlands (e-Innovation Centre) based IT training provider which runs scheduled and bespoke training courses across the midlands.

Please find a list of all of our our scheduled training courses. If you you require a bespoke syllabus or onsite provision please contact us by email or telephone on 01902 837404.

Classes are small and training is Tutor led. All delegates receive detailed training and reference materials and we offer a post training support service.



SQL Midlands Course

  • 2 day course
  • £650 plus VAT
  • Course Outline
  • SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating  data,  joins,  subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.



Transact SQL Midlands Course

  • 2 day course
  • £675 plus VAT
  • Course Outline
  • In this two day intensive course you will learn how to create queries to retrieve, add, update, and report from your SQL Server database.  You will sort and aggregate data, use built-in functions, create stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and explore SQL Server 2012 error handling features.

    The course is particularly suitable for Data Analysts or candidates involved in retrieving and reporting business and management information. No prior SQL knowledge is assumed.

    The course uses a SQL Server 2012 database but is suitable for users of earlier SQL Server versions. For those interested in external accreditation the course materials are mapped against the Microsoft SQL Server 2012 Database Querying (70-461) exam syllabus.



Oracle SQL Midlands Course

  • 2 day course
  • £720 plus VAT
  • Course Outline
  • A two day intensive course familiasing participants with the use of SQL in an Oracle context. SQL statements will be written and executed using a number of Oracle environments including SQL* Plus and Oracle SQL Developer.



Oracle PL/SQL Midlands Course

  • 3 day course
  • £950 plus VAT
  • Course Outline
  • This three day course gives participants a sound understanding of working with Oracle PL/SQL. The courses assumes no prior programming knowledge and is hands on in character.



SQL Server 2012 Data Warehouse Implementation Midlands Course

  • 3 day course
  • £975 plus VAT
  • Course Outline
  • Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.

    The course requires a working knowledge of SQL.



Microsoft SQL Server 2012-2014 Analysis Services SSAS Midlands Course

  • 2 day course
  • £710 plus VAT
  • Course Outline
  • This intensive instructor-led course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. This course also discusses how to use the Analysis Services development tools to create both multidimensional and tabular projects, and follows with explanations on how to use the management and administrative tools to manage both Analysis Services solutions.



Microsoft SQL Server 2008 Analysis Services SSAS Midlands Course

  • 2 day course
  • £710 plus VAT
  • Course Outline
  • In this two day course participants learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services.



Microsoft SQL Server 2005 Analysis Services SSAS Midlands Course

  • 2 day course
  • £710 plus VAT
  • Course Outline
  • In this course participants learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services.



Microsoft SQL Server 2012 -2014 Integration Services SSIS Midlands Course

  • 2 day course
  • £710 plus VAT
  • Course Outline
  • This two day intensive course introduces SQL Server Integration Services using the SQL Server 2012 or 2014 versions. No prior knowledge of Integration Services is assumed.



Microsoft SQL Server 2008 Integration Services SSIS Midlands Course

  • 2 day course
  • £710 plus VAT
  • Course Outline
  • This two day course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.



Microsoft SQL Server 2005 Integration Services SSIS Midlands Course

  • 2 day course
  • £710 plus VAT
  • Course Outline
  • This two day course will familiarise participants with SQL Server Integration Services 2005 (SSIS) tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.



Microsoft SQL Server 2012 Database Administration Midlands Course

  • 3 day course
  • £975 plus VAT
  • Course Outline
  • This course is is aimed at those who administer and maintain SQL Server databases. It is matched against the Microsoft Exam 70-462 syllabus.



SQL Server Reporting Services SSRS 2012/2014 Midlands Course

  • 2 day course
  • £740 plus VAT
  • Course Outline
  • Aimed at Report Writers using SQL Server Reporting Services (SSRS) 2012 and 2014 this intensive two day course demonstrates how to create and deploy parameterised reports using Report Builder and Report Designer. No prior Reporting Services experience is assumed but a reasonable grasp of SQL is essential.



SQL Server 2005 Reporting Services SSRS Midlands Course

  • 2 day course
  • £740 plus VAT
  • Course Outline
  • This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.



SQL Server 2008 Reporting Services SSRS Midlands Course

  • 2 day course
  • £740 plus VAT
  • Course Outline
  • A two day intensive course introducing the comprehensive range of SQL Server Reporting Services 2008 report writing and deployment features.


 

Scheduled courses are delivered at the following locations. Birmingham, Bridgnorth, Bromsgrove, Burton-on-Trent, Cannock, Coventry, Derby Derbyshire, Dudley, Cheltenham, Cannock, Coventry, Derby Derbyshire, Dudley, Cheltenham, Gloucester, Hailsowen, Kenilworth, Kingswinford, Lichfield, Nottingham, Nuneaton, Rugby, Rugely, Sandwell, Shrewsbury, Solihull, Stoke-on-Trent, Stafford, Stourbridge, Tamworth, Telford Shropshire, Walsall and Wolverhampton.West Midlands.

Please contact Enable Technology if you would like to discuss any of our SQL training courses or would like to discuss the possibility of either bespoke or onsite training.



Scheduled Courses: Midlands Excel VBA; Midlands MS Project, Midlands SSRS; Midlands SQL; Midlands Crystal Reports; HTML; Midlands Adobe Illustrator; Midlands ASP.NET; Midlands Dreamweaver; Midlands Flash; Midlands Photoshop; Midlands InDesign; Midlands Google Scripting; Midlands Visio; Midlands PHP; Midlands Microsoft Access; Web Development Midlands ;

Birmingham Telford Wolverhampton Midlands Database Onsite Courses: Birmingham Telford Wolverhampton Midlands Microsoft SQL Server 2012 Database Administration Training Courses; Birmingham Telford Wolverhampton Midlands SQL Training Courses; Birmingham Telford Wolverhampton Midlands Transact SQL Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft SQL Server 2005 Analysis Services SSAS Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft SQL Server 2005 Integration Services SSIS Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft SQL Server 2008 Integration Services SSIS Training Courses;

Birmingham Telford Wolverhampton Midlands Excel Onsite Courses: Birmingham Telford Wolverhampton Midlands Excel 2007 Advanced Training Courses; Birmingham Telford Wolverhampton Midlands Excel MOS 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Excel 2007 Intermediate Training Courses; Birmingham Telford Wolverhampton Midlands Excel MCAS 2007 Training Courses; Birmingham Telford Wolverhampton Midlands Excel 2010 Intermediate Training Courses; Birmingham Telford Wolverhampton Midlands Excel 2007 Basic Training Courses;

Birmingham Telford Wolverhampton Midlands Crystal Reports Onsite Courses: Birmingham Telford Wolverhampton Midlands Crystal Reports 2008 Training Courses; Birmingham Telford Wolverhampton Midlands Crystal Reports 2011 Training Courses; Birmingham Telford Wolverhampton Midlands Crystal Reports 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Crystal Reports XI Training Courses; Birmingham Telford Wolverhampton Midlands Training Courses;

Birmingham Telford Wolverhampton Midlands Adobe Onsite Courses: Birmingham Telford Wolverhampton Midlands Flash CS5 Training Courses; Birmingham Telford Wolverhampton Midlands Photoshop CS6 Training Courses; Birmingham Telford Wolverhampton Midlands InDesign CS5 Training Courses; Birmingham Telford Wolverhampton Midlands Dreamweaver CS6 Training Courses; Birmingham Telford Wolverhampton Midlands InDesign CS6 Training Courses; Birmingham Telford Wolverhampton Midlands Dreamweaver CS5 Training Courses;

Birmingham Telford Wolverhampton Midlands Office Onsite Courses: Birmingham Telford Wolverhampton Midlands Publisher 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Publisher 2013 Training Courses; Birmingham Telford Wolverhampton Midlands PowerPoint 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Word 2013 Basic Training Courses; Birmingham Telford Wolverhampton Midlands Word 2010 Advanced Training Courses; Birmingham Telford Wolverhampton Midlands PowerPoint 2013 Training Courses;

Birmingham Telford Wolverhampton Midlands Project Onsite Courses: Birmingham Telford Wolverhampton Midlands Project 2007 Training Courses; Birmingham Telford Wolverhampton Midlands Project 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Project 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Training Courses;

Birmingham Telford Wolverhampton Midlands Web Development Onsite Courses: Birmingham Telford Wolverhampton Midlands ASP.NET using C# Training Courses; Birmingham Telford Wolverhampton Midlands JQuery Mobile Training Courses; Birmingham Telford Wolverhampton Midlands ASP.NET using VB.NET Training Courses; Birmingham Telford Wolverhampton Midlands PHP Training Courses; Birmingham Telford Wolverhampton Midlands HTML Training Courses; Birmingham Telford Wolverhampton Midlands HTML 5 Training Courses;

Birmingham Telford Wolverhampton Midlands Visio Onsite Courses: Birmingham Telford Wolverhampton Midlands Visio 2007 Training Courses; Birmingham Telford Wolverhampton Midlands Visio 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Visio 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Training Courses;

Birmingham Telford Wolverhampton Midlands Access Onsite Courses: Birmingham Telford Wolverhampton Midlands Access Programming Using VBA Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft MOS Access 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft MCAS Access 2007 Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft MOS Access 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Training Courses;