Where to learn SQL in Great Britain

Displaying courses for Great Britain [Change]

ENQUIRE THROUGH GOOROO TO QUALIFY FOR SPECIAL DISCOUNTS

DDLS logo
New Horizons logo
QA logo
Pluralsight logo
  • Filtered by:

Duration:

Delivery method:

Location:


	

Pluralsight courses

  • SQL Azure is Microsoft's RDBMS for the cloud. Because it is based on SQL Server, developers can apply what they know about SQL Server to SQL Azure immediately. SQL Azure is its own product and, over time, developers will discover that they need to know some extra items in order to be fully productive on this platform. This module covers much of what developers need to know: basic development, security models, integration with existing platforms, and pricing. It covers new features like the SQL Azure OData service as well.

  • SQL | PHP | MySQL

    In this course you will learn how to create dynamic, data driven websites using the LAMP stack. The course focuses on the integration of the LAMP components (especially MySQL and PHP) to create a complete working site. Throughout the course, a lending library that needs a web application to track its books and borrowers provides a scenario for discussion and demonstration. Attention is also paid to best practices for keeping the site secure. Students should have a basic prior knowledge of relational databases and SQL and of the PHP language (variables, operators, loops, branches, and simple string handling). Basic competence at the Linux command line (including the ability to edit text files) is also assumed. Students can follow along with all demos by pre-installing Centos 6 (or similar) into a virtual machine.

  • Redgate SQL Prompt by Dan Sullivan
    SQL

    Using Redgate SQL Prompt to complete SQL code as you type, define your own SQL code snippets, and refactor the metadata defining your database.

  • This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster, such as transforming your data to normal form, using more efficient SQL code, and using indexes, as well as how to work with partitions.

  • This course provides an overview of the recent additions to the SQL language that have been added over the last few years, but that may have slipped under your radar. We will describe Analytic Functions, extensions to GROUP BY, the WITH Clause (Oracle's Subquery Factoring Clause/SQL Server's Common Table Expressions), the PIVOT and UNPIVOT Features, the MERGE Statement and, finally, the PARTITION BY/RIGHT OUTER JOIN syntax.

  • Introduction to SQL by Jon Flanders

    Structured Query Language (SQL) is a special purpose language for interacting with relational databases. This course is a gentle introduction to SQL and will lead you through the basics you need for querying, updating, and creating items in a database.

  • This course explains what Big Data, Hadoop and Massively Parallel Processing (MPP) data warehouse technologies are, and how the latter two are converging technologically. Products from Hadapt, Teradata, ParAccel, Microsoft and Cloudera -- all of which integrate with Apache Hadoop -- are investigated

  • This course describes Oracle functionality useful to the SQL-savvy data analyst, and features topics such as ordering your data with NULLs appearing first or last, using FETCH to subset your data, using SAMPLE to randomly sample from a table, using CROSS APPLY and OUTER APPLY, how to use the MODEL feature to access the rows and columns of a database table like a spreadsheet, generating random numbers, computing occurrences, using nested tables, and much, more.

  • From developer to analyst, this course tackles a few big questions about big data: Why does this technology exist and why do I need it? How can I get the best out of it utilizing something familiar like SQL and how does this all fit together in an ever-evolving eco-system? This course will introduce the concepts of distributed computing, Hadoop and MapReduce and then goes into great detail into Apache Hive which is an SQL-like query language that can be used with Hadoop and NoSQL databases like HBase and Cassandra. The course presents some challenges you might experience solving real production problems and how Hive makes that task easier to accomplish.

  • If you need to modify data in a SQL Server database, then you need to know how to use the INSERT, UPDATE and DELETE statements. This course starts by explaining how to find information about the tables and columns you want to modify. It then explains the INSERT, UPDATE, and DELETE statements in detail along with various methods for limiting the data being modified. Finally it moves beyond the basic modification statements to more advanced topics like the MERGE statement, error handling and more. More then thirty five demos help to give you a thorough understanding of how to perform these essential operations, all using a freely-available demo environment that you're shown how to set up and configure. This course is perfect for developers who need to modify data in SQL Server databases, from complete beginners through to more experienced developers who can use some of the modules as reference material. The information in the course applies to all versions from SQL Server 2005 onwards.

  • If you need to retrieve data from a SQL Server database then you need to know how to use the SELECT statement. This course starts with the basics of a SELECT statement and its various sub-clauses, and progresses to how to select from multiple data sources in the same statement and a comprehensive section on the functions available to manipulate, aggregate, and convert data during the select operation. More then fifty demos help to give you a thorough understanding of how to perform these essential operations, all using a freely-available demo environment that you're shown how to set up and configure. This course is perfect for developers who need to query SQL Server databases to retrieve data, from complete beginners through to more experienced developers who can use some of the modules as reference material. The information in the course applies to all versions from SQL Server 2005 onwards.

  • Robust Transact-SQL coding practices dictate proactive planning for anticipated and unanticipated errors that might occur during code module execution. SQL Server’s flavor of Transact-SQL provides several commands that can be used to properly handle errors in your code and this course will cover the fundamental commands you’ll need to know, as well as effective error handling techniques that will help you properly handle issues for high throughput, mission-critical data tiers. This course is perfect for developers, DBAs, and anyone responsible for writing Transact-SQL code, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward, with some emphasis on new SQL Server 2012 commands.

  • Query plan analysis is both a science and an art, and the best tool for the job is SQL Sentry Plan Explorer. In this demo-heavy course, you'll learn how to make the most of the Free and Pro Editions of the tool to make query plan analysis and performance tuning much easier and more intuitive than using SQL Server Management Studio. The course starts by comparing the Management Studio with Plan Explorer, demonstrating how Plan Explorer solves the problems and shortcomings that Management Studio has. The course then describes and demonstrates all the features of both Editions of Plan Explorer, showing how to use them to best effect using practical examples. This course is perfect for anyone who is responsible for query tuning and query plan analysis, from SQL Server 2005 onward.

  • Every single database has its own integrated development environment (IDE) to facilitate database developers to perform various database tasks like writing code, automating processes, and debugging. SQuirreL SQL Client is a universal SQL client supporting over 60 different popular databases. It allows users to view the structure of a database, browse the data in tables, issue SQL commands, and more.

  • The Introduction to Dates and Times in SQL Server course details how to use the date, time, smalldatetime, datetime and datetime2 data types as well as the many date- and time-related functions available to the SQL programmer such as DATEPART(), DATEFROMPARTS(), DATEADD(), as well as many others.

  • This course focuses on SQL Server 2014 and two of the latest additions to the database engine. We first look at how the shift in technology trends established the need for a different breed of technologies. Columnar, or Column-Oriented, databases have become increasingly popular in data warehousing applications because they allow for better compression and multi-fold performance improvements, and we'll see how SQL Server 2014 implements this with clustered columnstore indexes. In addition, as technology makes a bigger shift in hardware to multi-core CPU architectures and large amounts of memory are even cheaper and more attainable, it's important for software to adjust and utilize these changes. We'll see how In-Memory OLTP addresses these trends and more, letting you create tables in memory, eliminating locks and implementing optimistic multi-version concurrency. This course discusses in depth In-Memory OLTP (memory optimized tables), previously known as Hekaton. We'll cover creating memory-optimized tables, loading data, durability and the affect that has on the transaction log. We'll also look at indexing in detail, explaining the new index types created specifically to support In-Memory OLTP and how and when to apply each type based on your use case and we'll discuss how In-Memory OLTP and Clustered Columnstore indexes can fit a variety of applications while comparing them with each other and traditional disk-based tables and indexes.

  • In this course, we will talk in detail about how transaction management occurs in Oracle. We will talk about transaction management commands like commits, rollbacks, and savepoints, as well as talk about naming transactions and initiating read-only transactions. Dynamic SQL helps us write extremely flexible SQL. We will talk extensively about native dynamic SQL and the DBMS_SQL package, along with the two ways to execute dynamic SQL in PL/SQL. Finally, we will dive deep into debugging methods for PL/SQL with an extensive look at the SQL Developer debugger. All of these are important concepts and skills which enable you to write efficient, accurate, and high-performing PL/SQL code.

  • Introduction to SQL Server by Dan Sullivan

    This course starts with a high level introduction to relational databases. It follows up with the use of the Data Modification and Data Definition Languages that are part of SQL Server.

  • SQL Server performance tuning is an in-depth topic, and an art to master. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. The basics revolve around the details of how SQL Server carries out query execution, so the optimizations explored in this course follow along the same lines.

  • This course explores the new developer-centric SQL Server Data Tools introduced with SQL Server 2012, including advanced SSDT topics such as snapshots, schema compares, and database deployment to both on-premise and cloud-based servers. In addition to a deep exploration of SSDT, several enhancements to the T-SQL language in SQL Server 2008 and SQL Server 2012 are explored, including table-valued parameters (TVPs), MERGE, windowing, sequence objects, error handling and host of new built-in functions.

  • Part 3 of 3 in the SQL Server 2012 Database Administration (70-462) series. This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, basic high availability principles, and proper management of data and log files. If you're new to SQL Server administration, you'll benefit from this introduction as it introduces you to a broad range of topics.

  • Part 2 of 3 in the SQL Server 2012 Database Administration (70-462) series. This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, basic high availability principles, and proper management of data and log files. If you're new to SQL Server administration, you'll benefit from this introduction as it introduces you to a broad range of topics.

  • Part 1 of 3 in the SQL Server 2012 Database Administration (70-462) series. This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, basic high availability principles, and proper management of data and log files. If you're new to SQL Server administration, you'll benefit from this introduction as it introduces you to a broad range of topics.

  • Part 1 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, replication, and optimized use of SQL server FileGroups. Whether you're a beginner or experienced in SQL Server administration, you will benefit from this in-depth course.

  • Part 2 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, replication, and optimized use of SQL server FileGroups. Whether you're a beginner or experienced in SQL Server administration, you will benefit from this in-depth course.

  • Part 1 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.

  • Part 2 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.

  • Part 3 of 3 in the SQL Server 2008 Advanced Database Administration series will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.

  • Part 1 of 2 in the SQL Server 2008 Database Development (70-433) series. This SQL Server 2008 Database Development course is designed to teach you how to design databases and applications, and build the functionality. In this course you'll learn, T-SQL, .NET/CLR development, data partitioning, and advanced query techniques. If you have done any type of distributed application development, taken our SQL Server 2008 Administration Training course, or have experience installing SQL Server and setting up user accounts, you'll benefit from this in-depth course.

  • Part 2 of 2 in the SQL Server 2008 Database Development (70-433) series. This SQL Server 2008 Database Development course is designed to teach you how to design databases and applications, and build the functionality. In this course you'll learn, T-SQL, .NET/CLR development, data partitioning, and advanced query techniques. If you have done any type of distributed application development, taken our SQL Server 2008 Administration Training course, or have experience installing SQL Server and setting up user accounts, you'll benefit from this in-depth course.