Key Concepts Covered by This Free Course:
- Setting up SQL environments and understanding SQL statement basics
- Creating and managing databases and tables
- Grouping and aggregating data with GROUP BY statements
- Understanding JOINS for data consolidation
- Advanced SQL commands and statements for complex data manipulation
- Ensuring data integrity and security in databases and tables
- Using SQL to retrieve, modify and delete data from databases and tables.
Course Overview:
Unlock the power of data management with The Complete SQL from Scratch: Bootcamp. This comprehensive course will provide you with a solid foundation in SQL, from creating databases and tables to advanced data manipulation techniques. Through engaging modules, you'll learn how to efficiently manage data, group and aggregate data, and consolidate data with JOINS. You'll also gain experience in advanced SQL commands for complex data manipulation tasks and how to manage databases and tables for data integrity and security. By the end of the course, you'll have the skills and knowledge needed to manage data confidently and make a valuable contribution to data-driven organisations.Course Benefits:
Invest in your career with The Complete SQL from Scratch: Bootcamp. This course provides a valuable opportunity to develop in-demand skills and open up new career opportunities. By mastering SQL, you'll be able to contribute to the success of data-driven organisations and positively impact your career prospects. In addition to boosting your skills and knowledge, this course also offers flexible learning options, enabling you to study at your own pace and fit your learning around your schedule. With lifetime access to course materials, you can refresh your knowledge and stay up-to-date with the latest SQL trends and practices.Career Path:
- Database Administrator: Responsible for managing and maintaining database systems, ensuring data accuracy, security, and performance.
- Data Analyst: Responsible for collecting, analysing, and interpreting complex data sets to identify patterns, trends, and insights.
- Business Intelligence Developer: Responsible for designing and developing BI solutions, including data warehouses, ETL processes, and reporting tools.
- Software Developer: Responsible for developing software applications that interact with database systems, utilising SQL for data manipulation and retrieval.
- Data Scientist: Responsible for designing and implementing data-driven solutions, including statistical models and machine learning algorithms.
Course content
PostgreSQL Installation
00:13:00
Connecting to PostgreSQL using psql
00:04:00
Connecting to PostgreSQL using PgAdmin
00:07:00
Basic of Database and Tables
00:06:00
Data Types
00:07:00
Primary Keys and Foreign Keys
00:04:00
Create Table in SQL Script
00:17:00
Insert
00:05:00
Update
00:05:00
Delete
00:03:00
Alter Table
00:05:00
Drop Table
00:02:00
Check Constraint
00:12:00
NOT NULL Constraint
00:04:00
UNIQUE Constraint
00:06:00
Overview of Challenges
00:04:00
SQL Statement Basic
00:07:00
SELECT Statement
00:12:00
SELECT DISTINCT
00:10:00
Column AS Statement
00:07:00
COUNT
00:07:00
SELECT WHERE Clause – One
00:06:00
SELECT WHERE Clause – Two
00:11:00
ORDER
00:05:00
LIMIT
00:04:00
BETWEEN keyword usage on real time
00:08:00
IN Operator
00:06:00
LIKE and ILIKE
00:10:00
Overview of GROUP BY
00:03:00
Aggregation Function
00:12:00
GROUP BY – One
00:05:00
GROUP BY – Two
00:06:00
HAVING on SQL Statement
00:04:00
Overview of JOINS
00:07:00
Introduction to JOINS
00:06:00
AS Statement table
00:05:00
INNER Joins
00:14:00
Full Outer Joins
00:04:00
Left Outer join
00:03:00
Right Outer Join
00:05:00
Union
00:05:00
Basic of Advanced SQL Commands
00:04:00
Timestamps
00:17:00
Extract from Timestamp
00:05:00
Mathematical Functions
00:06:00
String Functions
00:16:00
SubQuery
00:08:00
Overview of Databases and Tables
00:02:00
Creating a Database backup
00:03:00
Restoring a Database from backup
00:04:00
Complete This CPD Accredited Course & Get Your Framed Certificate!
Certify Your Skills
A CPD accredited Adams Diploma/Certificate certifies the skills you’ve learned.
Stand Out From The Crowd
Add your Adams Certification to your resume and stay ahead of the competition.
Advance in Your Career
Share your Adams Certification with potential employers to show off your skills and capabilities.
About Course Publisher
Training Express
189 Courses
Training Express is a leading course provider, established by a dedicated team of experts working across the UK. We deliver accredited certification and training to UK businesses looking to improve organisational performance. Our comprehensive courses cover a broad range of sectors and industries, with a focus on promoting high standards of food hygiene, business wellbeing and safety in the workplace.
