SQL Fundamentals for beginners
What you'll learn
- Installing PostgreSQL relational database management system
- Connecting to a database
- Loading a sample database
- Creating database and table
- Using constraints to ensure data intergrity
- Using SQL SELECT Statement to retrieve data
- Using SQL CREATE Statement to create a table
- Using SQL UPDATE Statement to modify data
- Using SQL DELETE to remove data
- Using SQL DISTINCT to filter duplicate data
- Filter data using SQL WHERE Clause
- Sort data using SQL ORDER BY
- Manipulating data with various operators
- Retrieve and combine data from multiple tables
- Manipulating data using Aggregate Functions
Requirements
- Basic knowledge of using a computer
- Basic knowledge of using the internet
Description
Almost all applications you interact with on a daily basis involves data which are stored in databases . Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.
SQL is the language used to interact with the data inside these databases. SQL skills are always in demand due to the ever increasing use and reliance of data.
In this beginners course, you will learn the building blocks of SQL by interacting with a PostgreSQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.
Topics include:
Installing PostgreSQL Relational Database System
Connecting to PostgreSQL Default Database
Load sample database
Creating database and tables
Using constraints
Retrieving data from database table
Updating data inside a table
Deleting data inside a database table
Filtering data returned from a database table
Sorting data returned from a database table
Retrieving data using various operators
Combining data from multiple tables
Using aggregate functions to manipulate data.
Using subqueries
Who this course is for:
- Beginners to SQL
- Beginners to database
Instructor
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.
At Bluelime Learning Solutions, our approach is simple: clear, direct, and engaging. We specialize in 100% video-based courses filled with hands-on examples that provide practical skills applicable in real-world scenarios. Our courses are designed to translate complex concepts into easy-to-understand lessons that anyone, regardless of their background, can grasp and apply.
Our extensive experience includes collaborating on projects with Fortune 500 companies, equipping us with the insights needed to understand the essential skills that today’s employers value most. At Bluelime, we’re not just about teaching; we’re about equipping you with the tools and knowledge to excel in your career and personal growth endeavors.
Join us on this journey to unlock your potential and master new skills in an easy, enjoyable, and efficient way with Bluelime Learning Solutions, where learning is made simple and effective.