SQL Fundamentals for beginners

Focused View

Bluelime Learning Solutions

6:10:47

12 View

1. Introduction.mp4

02:00

2. What is SQL.mp4

02:29

3. Basic Database Concepts.mp4

09:00

4. What is PostgreSQL.mp4

01:41

5. Download and install PostgreSQL for Windows.mp4

10:46

6. Download and install PostgreSQL for Mac.mp4

03:15

7. Connecting to a PostgreSQL Database.mp4

09:35

8. Load sample database.mp4

11:49

9. Exploring some database objects.mp4

10:53

10. Using Constraints for data integrity.mp4

06:09

11. Create database.mp4

05:40

12. Create a table with PgAdmin.mp4

07:48

13. Schema.mp4

02:50

14. Introduction.mp4

00:56

15. Create a table with SQL.mp4

08:40

16. Retrieve all data from Table with SQL SELECT.mp4

06:33

17. Retrieve specific data from Table with SQL SELECT.mp4

07:41

18. Modify data in table using SQL UPDATE.mp4

07:48

19. Remove data from table using SQL DELETE.mp4

05:26

20. Filtering Data using SQL WHERE Clause.mp4

06:58

21. Ordering data using SQL ORDER BY Clause.mp4

08:16

22. Subqueries.mp4

08:13

23. Removing Duplicate Records.mp4

05:00

24. Truncating a Table.mp4

03:52

25. Adding new data to table using SQL INSERT.mp4

09:37

26. Comparison Operators.mp4

09:49

27. BETWEEN Operators.mp4

09:06

28. NOT BETWEEN Operators.mp4

05:49

29. LIKE Operators.mp4

11:37

30. NOT Operators.mp4

05:49

31. OR Operators.mp4

06:35

32. AND Operators.mp4

07:07

33. Combining OR AND Operators.mp4

08:33

34. IN Operators.mp4

10:57

35. UNION OPerators.mp4

04:43

36. UNION ALL Operators.mp4

03:30

37. INTERSECT Operators.mp4

06:21

38. Introduction to Table Joins.mp4

01:06

39. SQL INNER Joins.mp4

10:36

40. SQL LEFT JOIN.mp4

11:17

41. SQL OUTER JOIN.mp4

10:21

42. SQL CROSS JOIN.mp4

06:50

43. SQL NATURAL JOIN.mp4

10:27

44. Introduction to aggregate functions.mp4

02:03

45. SQL AVG Aggregate Function.mp4

11:56

46. SQL COUNT Aggregate Function.mp4

11:09

47. SQL MAX Aggregate Function.mp4

10:59

48. SQL MIN Aggregate Function.mp4

08:58

49. SQL SUM Aggregate Function.mp4

06:48

50. Grouping Data using SQL GROUP BY Clause.mp4

11:15

51. Splitting Groups using HAVING Clause.mp4

04:11

Description

Learn to interact with databases using SQL

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

Who is this for?

Beginners to SQL

Beginners to database

What You Need to Know?

Basic knowledge of using a computer

Basic knowledge of using the internet

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Bluelime Learning Solutions

Instructor's Courses

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.