SQL and PostgreSQL: Introductions Course for Beginners Certification Video Training Course
The complete solution to prepare for for your exam with SQL and PostgreSQL: Introductions Course for Beginners certification video training course. The SQL and PostgreSQL: Introductions Course for Beginners certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Databases Courses SQL and PostgreSQL: Introductions Course for Beginners exam dumps, study guide & practice test questions and answers.
SQL and PostgreSQL: Introductions Course for Beginners Certification Video Training Course Exam Curriculum
Introduction to SQL
-
1. Section Introduction01:14
-
2. Databases and SQL03:25
-
3. Installing PostgreSQL06:01
-
4. Setting Up the Database10:34
Selecting from a Table in SQL
-
1. Section Introduction02:10
-
2. Select05:32
-
3. Select Where06:12
-
4. Multiple Wheres09:36
-
5. Solution 1: Selecting From a Table03:46
-
6. In, Not In07:21
-
7. Between05:31
-
8. CODE: SQL for BETWEEN07:40
-
9. Like05:46
-
10. Solution 2: Selecting From a Table07:31
-
11. Order By06:04
-
12. Limiting Number of Results05:25
-
13. Distinct05:06
-
14. Setting a Column Name Alias04:32
Selecting from Multiple Tables in SQL
-
1. Section Introduction00:54
-
2. Joins in SQL02:24
-
3. Inner Join Part 104:04
-
4. Inner Join Part 203:35
-
5. Solution 1: Selecting from Multiple Tables03:59
-
6. Left Join03:03
-
7. Right Join11:44
-
8. Full Join03:45
-
9. Solution 2: Selecting from Multiple Tables05:59
-
10. Joining More Than Two Tables13:47
-
11. Union11:34
-
12. Solution 3: Selecting from Multiple Tables06:30
Aggregate Functions in SQL
-
1. Section Introduction00:54
-
2. What are Aggregate Functions02:24
-
3. Count04:04
-
4. Min and Max03:35
-
5. Sum03:59
-
6. Average03:03
-
7. Group By11:44
-
8. Having03:45
-
9. Solution: Aggregate Functions05:59
Data Definition Language
-
1. Section Introduction01:00
-
2. What is Data Definition Language?01:23
-
3. Data Types07:54
-
4. Primary Keys03:00
-
5. Foreign Keys02:50
-
6. Creating Tables: Part 110:39
-
7. Creating Tables: Part 208:51
-
8. Solution 1: Data Definition Language03:41
-
9. Modifying Tables: Adding and Removing Columns05:29
-
10. Modifying Tables: Modifying Columns10:12
-
11. Removing Tables01:42
-
12. Deleting All Rows from Tables01:58
-
13. Solution 2: Data Definition Language03:35
Data Manipulation Language
-
1. Section Introduction00:36
-
2. What is Data Manipulation Language?00:56
-
3. Inserting Data into Tables09:16
-
4. Updating Data in Tables07:44
-
5. Deleting Data from Tables04:31
-
6. Solution: Data Manipulation Language06:06
About SQL and PostgreSQL: Introductions Course for Beginners Certification Video Training Course
SQL and PostgreSQL: Introductions Course for Beginners certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Learning SQL is one of the most significant steps you can make to boost your career in IT. And this video course will help you achieve this goal. As the title of this training suggests, it is intended for the newbies, so you don’t need to have any experience in the area.
If you take this course, you will know how to use the PostgreSQL Database with PgAdmin 4, as well as understand the basics of database. You will have enough knowledge to build a database and put in and take out data with the help of PgAdmin. Updating and deleting data from the database is also covered. You will be capable of exploring what’s in the database whenever you need to and making basic reports. You will learn SQL commands: WHERE, SELECT, OR, AND, ORDER BY, INSERT INTO. Foreign and primary keys are also explained in the course lectures. There is some information regarding the ways to backup and restore database and tables. There are 58 lectures included in the course. The sections are dedicated to different topics. For example, selecting from a table in SQL and selecting from multiple tables in SQL are separate parts with 14 and 12 lectures accordingly. Then, you will learn aggregate functions. The data definition language topic is explained in 13 lectures, and data manipulation language is taught in 6 lectures.
The professionally presented information regarding SQL and PostgreSQL is ready for you in this course. Don’t hesitate because it may play a great role in your future career.
Prepaway's SQL and PostgreSQL: Introductions Course for Beginners video training course for passing certification exams is the only solution which you need.
Pass Databases Courses SQL and PostgreSQL: Introductions Course for Beginners Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register