Why Learn with Us?
- We have taught and certified more than 50,000+ students and organisations worldwide
- We are committed to helping students start new careers or advance in their chosen career paths
- We have Award-winning Customer Support, and we’re proud of it
- We believe in you. Your success is our success
The SQL Developer is one of our most popular training courses and is perfect for those individuals who want to start a new career path as a SQL developer, as well as established professionals who want to test their existing abilities and learn the latest techniques.
Course Curriculum
This comprehensive SQL Developer course has been divided into 85 interactive lessons. This makes for a more stimulating and comprehensive study of all the essential areas of SQL development, which also means that learners will be able to absorb the knowledge in manageable and intuitive segments and retain the vital information without even realising it.
This fully inclusive SQL Developer course includes the following modules:
Learn how to increase your expertise in SQL development by taking the following modules of this popular SQL Developer course.
Introduction
- Case Study Part 1
- CREATE
- Exercise 1: Create DB and Table
Installation and getting started
- INSERT
- Import data from File
- Exercise 2: Inserting and Importing
Case Study : Demo
- SELECT statement
- SELECT DISTINCT
- WHERE
- Logical Operators
- Exercise 3: SELECT & WHERE
- UPDATE
- DELETE
- ALTER
- Exercise 4: Updating Table
Fundamental SQL statements
- Exercise 5: Restore and Back-up
Restore and Back-up
- IN
- BETWEEN
- LIKE
- Exercise 6: In, Like & Between
Selection commands: Filtering
- Side Lecture: Commenting in SQL
- ORDER BY
- LIMIT
- Exercise 7: Sorting
Selection commands: Ordering
Aggregate Commands
- COUNT
- SUM
- AVERAGE
- MIN & MAX
- Exercise 8: Aggregate functions
Group By Commands
- GROUP BY
- HAVING
- Exercise 9: Group By
Conditional Statement
JOINS
- Introduction to Joins
- Inner Join
- Left Join
- Right Join
- Full Outer Join
- Cross Join
- Except
- Union
- Exercise 10: Joins
Subqueries
- Subqueries
- Exercise 11: Subqueries
Views and Indexes
String Functions
- LENGTH
- UPPER LOWER
- REPLACE
- TRIM, LTRIM, RTRIM
- CONCATENATION
- SUBSTRING
- LIST AGGREGATION
- Exercise 13: String Functions
Mathematical Functions
- CEIL & FLOOR
- RANDOM
- SETSEED
- ROUND
- POWER
- Exercise 14: Mathematical Functions
Date-Time Functions
- CURRENT DATE & TIME
- AGE
- EXTRACT
- Exercise 15: Date-time functions
PATTERN (STRING) MATCHING
- PATTERN MATCHING BASICS
- Exercise 16: Pattern Matching
Data Type conversion functions
- Converting Numbers/ Date to String
- Converting String to Numbers/ Date
User Access Control Functions
Bonus Section: Nail that Interview!
- Tablespace
- PRIMARY KEY & FOREIGN KEY
- ACID compliance
- Truncate
Performance tuning tips
- TIP 2
- TIP 3
- TIP 4 (VACCUM)
- TIP 5
- TIP 6 (STRING FUNCTIONS)
- TIP 7 (JOINS)
- TIP 8 (SCHEMAS)
Bonus Section : Database Basics
- What is SQL
- Tables and DBMS
- Types of SQL commands
- PostgreSQL
Supplementary Resources
- Supplementary Resources – SQL For Data Analytics
Certificate of Completion
On completion of the SQL Developer course, you will be eligible to order your free PDF & Hardcopy certificate of course completion. There is a minimum postal charge applicable to obtain the hardcopy course completion certificate which is:
- Inside the UK = £6.49
- International Students = £17.49
CPD UK and IPHM Accredited Certificate of Achievement
On completion of the SQL Developer course, you will be eligible to obtain the CPD UK and IPHM accredited certificate of achievement (dual certificate) to evidence your new skill and accomplishment, as well as your knowledge and skill set. You can also share this certificate with prospective employers and your professional network. The CPD UK and IPHM accredited certificate of achievement (dual certificate) is available in PDF format, at the cost of £12, or a hardcopy can be sent via post at the cost of £35.
Compatibility
All the lessons in this SQL Developer course will only take a few minutes to complete, which means that it caters to every type of lifestyle and study method. Study breaks can be quickly scheduled, as can long and intensive periods of learning. You can make the most of your personal time, even if you only have 10 to 15 minutes free at any one time. Make this course work for you.
We don’t believe in placing time limits on learning, so you will never have to rush and complete a course before a strict deadline. Just concentrate on your goals and study in your own time and at your own pace with no unnecessary pressure.
