SQL Entry Package

About this course

This series provides an overview of SQL, introducing the core concepts and features regarding Structured Query Language. An essential apparatus for many fields within the IT sector SQL is a programming language designed for managing data contained within a RDBMS (Relational Database Management Systems). This course will teach you the basics of SQL and give you the relevant base knowledge in this powerful database tool.

WHAT IS SQL?

SQL is a powerful special purpose programming language that works to ensure a number of the modern technologies that we rely on today run consistently and smoothly. This language type is designed to manage data held in a RDBMS (Relational Database Management System). Being a relational database engine was SQL’s original purpose but it has since grown to include a number of new database technologies, such as Relational Data Stream Management System (RDSMS).

In reality more people work with SQL Server in their day to day tasks than anyone probably realises. Many web sites and core business applications are supported by SQL Server. Typically SQL Server based applications are designed, built, maintained and enhanced by DBAs, Developers, Data Modellers, Network Admins, System Admins, Storage Admins, etc.

AUDIENCE

This series is for anyone who wants to learn the basics and familiarise themselves in the uses of SQL.

Training Solution Breakdown:

• Basic concepts and terms relating to table and database design, as well as the basic task of creating a new table in a database.
• Using the INSERT statement.
• Managing and deleting SQL Tables and table data.
• Creating, editing, changing and deleting table views, table spaces, storage groups, indexes, index spaces and databases.
• 18 months unlimited access to course content
• Tutor and technical support available via email and a local US or Canadian phone number
• Completion certificate, which will show employers that you are proficient with basic SQL
• Study from anywhere in the world*

*Internet connection required