Duration
2 Days
12 CPD hours
This course is intended for
This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience.
Overview
This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to:
Advanced Query Techniques
Manipulating Table Data Using SQL's Data Manipulation Language (DML)
User-Defined Functions
Stored Procedures
Triggers
A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database.
Advanced Query Techniques
Join inner outer (Left, Right, Full)
Subqueries
Simple
Correlated
Using the Exists Operator
Tips for Developing Complex Queries
Performing Set Operations
Aggregating Results Using Group by
Creating Temporary Tables
Manipulating Table Data Using SQL's Data Manipulation Language (DML)
Inserting Data into Tables
Updating Existing Data
Deleting Records
Truncating Tables
Implementing Data Integrity with Transactions
Beginning Explicit Transactions
Committing Transactions
Rolling Back Transactions
User-Defined Functions
Definition and Benefits of Use
CREATE FUNCTION
Syntax
RETURN Clause and the RETURNS Statement
Scalar vs. Table Functions
Comparison with Stored Procedures
Returning Scalar Values and Tables ALTER and DROP FUNCTION
Stored Procedures
Definition and Benefits of Use
CREATE PROCEDURE
Syntax
Variables and Parameters
Control of Program Flow
ALTER and DROP PROCEDURE
Implementation Differences
Triggers
Definition and Benefits of Use
Alternatives (e.g., Constraints)
CREATE TRIGGER
Syntax
Trigger Types
'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables
Event Handling and Trigger Execution
ALTER and DROP TRIGGER
Additional course details:
Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.
This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.
Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.
While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.
Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.