Learn SQL in 3 Hours : A tutorial for fast learners

Name: Learn SQL in 3 Hours : A tutorial for fast learners
Rating: 4.4 (951 reviews)

Unlock the Power of Databases and Excel in SQL Mastery: Become a Highly Skilled SQL Developer with Database Knowledge

Created byOCSALY Academy | 570.000+ Students

Last updated 5/2023

English

English [Auto],

What you'll learn

SQL Fundamentals: Gain a solid understanding of the basic concepts, syntax, and structure of SQL queries.
Data Retrieval: Learn how to retrieve specific data from databases using SELECT statements and various filtering techniques.
Sorting and Ordering: Understand how to sort and order query results based on specific criteria using ORDER BY clauses.
Filtering Data: Master the art of filtering data using WHERE clauses to extract relevant information from large datasets.
Joining Tables: Discover different types of table joins, such as inner joins, outer joins, and cross joins, to combine data from multiple tables.
Aggregating Data: Learn powerful aggregation functions like COUNT, SUM, AVG, MIN, and MAX to perform calculations on groups of data.
Working with Functions: Explore SQL functions for manipulating data, performing string operations, and converting data types.
Data Modification: Understand how to insert, update, and delete data within a database using SQL statements.
Data Constraints: Learn about constraints such as primary keys, foreign keys, unique constraints, and check constraints to maintain data integrity.
Subqueries: Dive into the world of subqueries, enabling you to nest queries within queries for more advanced data retrieval and analysis.

Course content

4 sections • 17 lectures • 2h 53m total length

Preparing Environment in 16 Mins16:34
Set up your sql learning environment by installing a text editor, PostgreSQL, pgadmin, and downloading csv data for exercises.
Starting with PostgreSQL10:13
Learn to use pgadmin, a free, full-featured graphical tool for PostgreSQL administration, connect to the default Postgres database, and write, run, and save queries with the SQL tool.
Customizing pgAdmin2:20
Learn to customize pgadmin via preferences, adjusting appearance and themes like dark or high contrast, and adjust the query tool's result grid with a maximum column width of 300 characters.
Creating First Database10:44
Create a new Oxley database in PostgreSQL, connect viaPgAdmin, and build a teachers table with id, first name, last name, school, hire date, and salary, using proper data types.
Creating our First database and Adding Tables Part 25:20
Create a database and a teachers table with id, first_name, last_name, school, hire_date, and salary using bigserial, varchar, date, and numeric; run in Pgadmin and view SQL to recreate table.

Adding Data into Tables18:29
Insert data into tables with insert into statements in PostgreSQL via PgAdmin, specifying columns and values. Learn date formats and how to view inserted records in the teachers table.
Starting with Select Keyword10:20
Learn how the select keyword retrieves rows and columns from tables, inspect data quality, and practice querying subsets using PostgreSQL, PgAdmin, and the asterisk wildcard.
Order by7:57
Learn how the order by clause sorts SQL query results by column or position, with ascending or descending order, and how selecting relevant columns reveals top earners and recent hires.
Magic with WHERE and Operators13:39
Learn to use distinct to reveal unique values, filter data with where and operators, and compare with between, while sorting results with order by for data quality.
Learning Logical Operation in SQL9:07
Learn pattern matching with like, using percent and underscore wildcards to search patterns. Explore and/or with parentheses to combine conditions and understand case sensitivity in ansi sql.

Basic Datatypes in SQL8:38
Learn how data types define column storage in sql databases, covering date, integer, text, char, varchar and text types, with PgAdmin inspection and create table examples.
Char and Text Types in Practice and Exporting TXT Files10:55
Demonstrates char, varchar, and text data types in a PostgreSQL table, inserts sample rows, and exports the data to a text file using copy, with practical path and permission tips.
Integers in SQL5:38
Explore integers in SQL by comparing smallint, int, and bigint, understanding storage sizes and value ranges, and learn how type choice prevents out-of-range errors while enabling math operations.
Other ways to use INCREMENT9:09
Learn how to implement auto incrementing ID columns in PostgreSQL using serial and identity, create tables with generated always as identity, and understand when gaps occur.
Floating Point Numbers and Their Disadvantages17:39
Explore fixed point and floating point SQL data types, understand precision and scale, and learn when to use numeric or decimal for exact calculations versus inexact floating point math.

UTC, Dates and Times in SQL14:06
Explore SQL date and time types such as timestamp, date, time, and interval, learn about time zones, UTC offsets, and how PostgreSQL handles display and storage.
Timestamp with Timezone Interval2:32
Master interval data types to perform date and time calculations, such as adding 90 days to contract dates, using a date-time types table with interval and timestamp columns.

Requirements

No requirements or prerequisties

Description

Are you ready to unlock the power of databases and take your SQL skills to the next level? Look no further than our comprehensive online course, "Mastering SQL: Become a Highly Skilled SQL Developer with Comprehensive Database Management and Querying Techniques."

In today's data-driven world, SQL (Structured Query Language) has become an essential tool for efficiently managing and manipulating data within relational databases. Whether you're a beginner looking to learn SQL from scratch or an experienced programmer seeking to enhance your database management abilities, this course is designed to cater to your learning needs.

Starting with the fundamentals, you'll gain a solid understanding of SQL basics, including the syntax, commands, and key concepts necessary for effective data manipulation. From there, we'll delve into the art of database design, where you'll learn how to create well-structured databases using normalization techniques and entity-relationship modeling.

As you progress, you'll master the intricacies of data manipulation, honing your skills in crafting SQL statements to insert, update, delete, and retrieve data with precision and efficiency. You'll become adept at formulating complex queries, utilizing various clauses, functions, and join operations to filter and extract valuable insights from vast amounts of data.

But we won't stop there. Our course goes beyond the basics, covering advanced SQL concepts that will elevate your expertise. You'll explore topics such as subqueries, views, stored procedures, and triggers, empowering you to optimize your SQL code, improve performance, and streamline database operations.

Additionally, you'll learn crucial database administration tasks, ensuring data integrity and managing user access effectively. We'll guide you through the process of creating tables, implementing security measures, and understanding backup and recovery strategies.

What sets this course apart is its practical approach. Throughout the lessons, you'll apply your SQL knowledge to real-world scenarios, such as data analysis, reporting, and building database-driven applications. By working on hands-on projects and exercises, you'll cement your skills and gain confidence in your ability to tackle SQL challenges head-on.

Our team of experienced instructors is committed to your success, providing clear explanations, step-by-step demonstrations, and valuable insights. With our guidance, you'll become a highly skilled SQL developer, equipped with the tools and knowledge to excel in the fast-paced world of data management.

So, whether you aspire to pursue a career as a data analyst, database administrator, or software developer, this course will pave the way for your SQL mastery. Enroll now and embark on an exciting journey to unlock the full potential of SQL and revolutionize your approach to data manipulation and database management.

Who this course is for:

Beginners: No prior SQL or database experience required.
Non-Technical Professionals: Access and analyze data independently for better decision-making.

Learn SQL in 3 Hours : A tutorial for fast learners

What you'll learn

Explore related topics

Course content

Introduction to pgAdmin and SQL5 lectures • 45min

Creating our first Database and Table5 lectures • 1hr

Datatypes in SQL5 lectures • 52min

Dates and Times in SQL2 lectures • 17min

Requirements

Description

Who this course is for: