SQL Advanced Course
-
n excellent introduxtion with a lot.of information explained clearly with great examples
← | →
Short course
Online
Description
-
Type
Short course
-
Level
Intermediate
-
Methodology
Online
-
Duration
2 Days
Are you ready to level up in the SQL world? Learn more about it with this course offered by Emagister and imparted by PCWorkshops is for you!
At the beginning you’ll learn about SQL Sub- Queries, in the Where, select from or Having clauses, different clauses in the self- contained sub-queries. Correlated sub-queries and the ones with EXISTS predicate.
Furthermore, you’ll learn about Derived tables and CTEs (Common Table Expressions) using SQL derived tables, creating, altering and dropping views and indexes. Parameters and return values, looping, cursors and many other factors that will boost your skills.
This course includes an assessment-based SQL course certificate, including the notes, practical exercises, revisions of your work and also coffee and tea.
In order to prepare you for the certification, you’ll have one free session via Skype or TeamViewer for questions online. (Maximum groups of 4 students).
So, if you want to learn more, don’t hesitate to contact PCWorkshops through Emagister.
Facilities
Location
Start date
Start date
About this course
In works professionals. University students
SQL Queries, Aggregates, Joins.
Reviews
-
n excellent introduxtion with a lot.of information explained clearly with great examples
← | →
Course rating
Recommended
Centre rating
Antonia Saldana
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Database
- SQL
- Database training
- SQLite
- Primary
- Programming
- SQL Database
- SQL Server
- Data Types
- SQL queries
- Testing conditions
- Committing
- Basic transactions
- Beginning a transaction
- Database Management
- Rolling back
Teachers and trainers (1)
Sarah Barnard
Coder, Instructor
Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.
Course programme
Derived Tables and CTEs ·Using SQL derived tables ·SQL Common Table Expressions (CTEs) ·Recursive CTEs
Views: Create, alter and drop Views, Indexes
SQL Stored Procedure Basics ·Stored Procedure Principles ·Creating stored procedures ·Executing stored procedures ·System stored procedures
Variables ·Declaring variables ·SET versus SELECT
Parameters and Return Values ·Passing parameters ·Default values and WHERE clauses ·Output parameters ·Using RETURN Testing Conditions ·The IF/ELSE statement ·CASE ·CHOOSE
Looping ·Syntax of SQL WHILE ·Breaking out of a loop ·Basic transactions ·Beginning a transaction ·Committing/rolling back ·Deleting and updating ·Using DELETE and UPDATE ·Sys.Objects ·Dropping objects User defined Functions Table Valued Functions ·In-line table-valued functions ·Multi- Statement table-valued functions ·Limitations of user-defined functions Scalar Functions ·What are scalar functions? ·Some examples ·Disadvantages of scalar functions ·Three advantages
Cursors ·Syntax of fetching rows ·When to use (and when not to)
Triggers Create or replace triggers
Creating Tables in SQL ·Create, alter and drop Tables ·Inserting values, single rows and multiple rows using queries
Constraints: Not Null Unique Default Check Primary Key Foreign Key Identity / Auto-increments
Sequencing Indexes
SQL Temporary Tables and Table Variables ·Create and use SQL temporary tables ·Create and use SQL table variables ·SQL Tables vs. Table Variables
Error-Handling ·SQL TRY/CATCH ·SQL System error functions ·Customizing SQL error messages ·@@ error function
Debugging ·The SQL Server debugger, Debugging (breakpoints, etc.)
Readd more:
https://pcworkshopslondon.co.uk/sql-advanced-course.html
Additional information
SQL Advanced Course