Introduction to Databases and SQL Querying
A step by step introduction to the concept of Databases and Introduction to SQL Querying.
Created by Rakesh Gopalakrishnan - Over 260,000 Students
Students: 379414, Price: Free
This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.
Advanced Databases and SQL Querying
Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.
Created by Rakesh Gopalakrishnan - Over 260,000 Students
Students: 198265, Price: Free
This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.
If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.
Oracle SQL – A Complete Introduction
Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.
Created by Ben Brumm - IT Software Consultant
Students: 68457, Price: Free
Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.
This course will teach you the basics of the SQL language on an Oracle database.
It uses video lectures to teach you Oracle SQL, covering database topics such as:
- Setting up your Oracle environment
- Basic terminology
- Reading data using a SELECT statement
- What can be done using a SELECT statement
- Data types
- Joins, set operators, subqueries
- Inserting, updating and deleting data
- Creating tables
The course materials run for approximately 4 hours and are split into multiple sessions.
It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn.
Why should you take this course?
There are many benefits of taking my Oracle SQL course:
- You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
- Avoid paying thousands of dollars for training.
- You can also study in your own time!
- Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!
If you want to learn Oracle SQL from someone who has experience, then take this course.
Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC
Gentle Introduction to Non Programmers on SQL for Analytics. 1 day Bootcamp Course Begineers Hands-on. Project: New York
Created by Shivgan Joshi - Free Python Class Bootcamp Big Data Science NYC 312 285 6886
Students: 29045, Price: Free
SQL 101 Bootcamp is build up based on the SQL classes for Analytics taken in NYC, New York by Shivgan Joshi. Having taught at various bootcamps in NYC and gathering feedback from students this course addresses all the major topics you need to get started for Analytics in SQL if you have never programmed.
This course will help you answer and critically think and implement:
Create a DB design for your day to day work data that you use in Excel
Understand what you can do and what you cannot do. Or rather how hard or simple it is to do some analytical steps in SQL.
Understand Data Wrangling using Group, Joins and UNION to get data in the format you need
For any data that comes to you new tools get new insights
Get Excel equivalent functions for SQL commands
Understand the data wrangling terms often used in Data Analytics that remain common to all languages (Python / R / SQL)
Other areas that will be introduced to are:
Understand why SQL is needed as a solution to limitation of excel
Connect to the SQL Server database and execute a simple query.
Include a search condition in a simple query.
Use various functions to perform calculations on data.
Organize data obtained from a query before it is displayed on-screen.
Use New York City data for running on SQL
A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.
Created by Sagar Uppuluri - Software Architect and a passionate trainer
Students: 28323, Price: Free
SQL is an integral part of majority of software projects and is important for you to gain familiarity with the language if you are an IT aspirant.
This course covers the topics related to database design and query design, and helps you assimilate the topics in a way that you should be able to understand and design the schema.
It covers the most essential features of the language and explains them through simplified and easy to understand examples. Includes DDL, DML and Query commands along with hints about the other essential features. Core focus will be on table design and explaining the features such as query and joins with their mathematical approach so that you can effectively design complex queries.
It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.
AWS RDS Databases – Fast Track
Fast-track training to work with relational databases on AWS Cloud using AWS Relational Database Service.
Created by Siddharth Mehta - Enterprise Cloud Architect, Published Author, Cloud Geek
Students: 16849, Price: Free
Hi! Welcome to the AWS RDS Databases - Fast Track Training, the only comprehensive and most impactful course on AWS RDS that is available FREE of Cost. This is the only course you would need to get started with AWS RDS.
This course is taught by an Enterprise Cloud Architect, who leads large teams of junior architects in the real world, who has an industry experience of close to two decades in the IT industry, who is a published author, and leads technology architecture of XXX million dollar projects on cloud for multi-national clients.
This course teaches to work with the following AWS RDS Databases along with its related client tools like HeidiSQL, PgAdmin and Oracle SQL Developer. So if you are new to AWS RDS or are preparing for a quick technical discussion on AWS RDS with very limited time at hand, this is the perfect course for you.
MariaDB is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Organizations like Wikipedia, WordPress and Google uses MariaDB. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data.
PostgreSQL is the one of the world’s most advanced open source and popular database. PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, macOS, Solaris), and Windows. It is abbreviated as Postgres because of ubiquitous support for the SQL standard among relational databases.
Oracle is a proprietary multi-model database management system from Oracle Corporation. It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads.
This course is composed of almost 90% labs and also covers the fundamental theory of important AWS RDS Concepts with some basic FAQs as well. After pursuing this course, if you have any questions related to the subject or need suggestions about pursuing the next course related to AWS data services, please do not hesitate to contact me.
I hope to see you soon in the class !
Oracle SQL: An Introduction to the most popular database
A quick tour of the six principal clauses of the SELECT statement.
Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far
Students: 11359, Price: Free
This course is a brief presentation of Oracle SQL.
We will install a version of Oracle Express Edition and Oracle SQL Developer for free.
We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).
Following this, we'll look at what else you need to know, and resources (which range from FREE to very expensive) which will help you to learn it..
No prior knowledge is required - just a willingness to learn.
See you on the course.
Step by Step Practical Oracle SQL with real life exercises
Explains both the what and why of an Oracle SQL concept. Deals with real-life situations.
Created by Ramesh R - Senior Architect at an IT Major
Students: 10268, Price: Free
Relational databases have spread across the software world. Learning SQL means you know how to access them. This skill enables you to stay competitive.
The course teaches you Oracle SQL. But, SQL is a standard that is used for other relational databases also. So, you can re-use the SQL learning (not 100% though) for other DBs as well with some tweaks specific to those DBs.
The course tries to impart knowledge using two methods.
1. Video lectures. The lectures introduce you to the basics of Oracle SQL and also the important nuances. For e.g. apart from learning what a NULL value means, you will also learn the situations the NULL values can be problematic.
2. Exercises - PDFs -> The exercises deal with the concepts introduced in the videos and their nuances.
- The answer for a question and the explanation will be provided in the next page. Occasionally, some questions can also ask you to do some self-exploration (recommended) on a topic related to the lecture. If you do not have time to do that, you can look at the answer with the explanation in the next page.
- The exercises vary in complexity. Some of them can seem quite complex for a beginner. Some questions have been made intentionally confusing. A confusion/complexity now is better than the one at an examination hall or work. Isn't it?.
- Several questions deal with real-life situations and their handling. Please attempt them using logical and practical reasoning, and if needed, take the help of the answer and the explanation in the next page. You can always contact me for any doubts.
I believe, the course will help in preparing you for the complexity and ambiguity in the real-life database world.
Good luck. Enjoy the course.
PS: Exercises are attached as PDF resources in the videos. And not all videos will have a PDF. Questions across lectures could be clubbed together and uploaded against a single video lecture.
Oracle SQL Starting Point
Learn how to use Oracle SQL
Created by Kal Younes - Instructor at Udemy
Students: 9157, Price: Free
You will learn how to use the industry standard tool for working with a Relational Database. You will also learn many other things, from constructing simple queries to creating your own tables.
After the course you should have a good understanding of SQL*Plus, from starting it, to creating simple reports on it.
·Oracle SQL Developer.
We will go over the SQL Developer components and see how it hangs together
Microsoft SQL Crash Course for Absolute Beginners
This Crash course uses Microsoft SQL Server. The SQLs used here can also used in Oracle, MySQL, PostgreSQL, SQLite,etc.
Created by Sandeep Kumar - Founder of a Training company. IT Consultant, Coach, Mentor
Students: 7238, Price: Free
'This Course covers SQL using Microsft SQL Server but you can apply these SQL queries in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2'.
"Welcome to the most popular Quality crash Course on Microsoft SQL Server(MS SQL Server)"
Covers different forms of SELECT Statements
Explains how to filter the Records
All the Arithmetic operators are explained
NULL Values are explained
Beautiful examples of all the operators
ORDER BY, GROUP BY, HAVING clauses has examples in detail
The course covers all the Aggregate Functions and other Functions
UNION and JOINs are explained with real-life examples
I have explained all types of Joins
Data types used in Microsoft SQL
Join this course which is the best "Microsoft SQL" course. I will share all the syntax of SQL with multiple examples along the way!!!
Want to start learning SQL from scratch with no previous coding experience?
You have come to the right place. Please have a look at the Course content carefully and ask a few questions yourself?
I have shared all the codes which are used in this course
Is the Course taught by a real-time expert? I have more than 15 years of experience as an Instructor and more than 10 years of experience in SQL. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.
Is the Course content clear and Precise? The content is short, crisp, and clear.
The course assumes no prior knowledge of MS SQL(Microsoft SQL Server) and teaches you from scratch to an advanced level
Once you Enroll in this Course, you get lifetime access to this course and you will get all the future updates.
The course does not cover T-SQL directly but it will help you to learn T-SQL also.
This will also help you to get Microsoft certification.
This Course is not for DBA(Database Administration) but certainly, helps you to become better.
If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.
If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.
Do you want to start on SQL but have no experience with SQL?
If you have some prior knowledge of SQL or if you are a complete fresher, you are at the right place. The Course teaches you to SQL right from Scratch. It will be the best course for absolute beginners.
There’s no risk involved in taking this Course!
I am sure that this is the best crash course on SQL and it is the perfect starting point to learn the basics of SQL.
What if you are stuck?
I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.
Are you getting updated content?
Yes, I keep updating the content always to make sure, I provide all the information to my students.
Once you enroll for this course-
1) Selecting Records from Table - SELECT statement in SQL
2) Filtering the Records - Using WHERE clause in SQL
3) Sorting Records - Using ORDER BY clause
5) Grouping data - using GROUP BY clause
6) complete guide with examples of all the Functions - All aggregate functions covered
7) Creating simple and advanced Tables - with constraints and without constraints
8) Keys, Index - PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX
9) Inserting records(loading) - with INSERT Statement
10) Updating the records of a Table - Using UPDATE statement
11) Combining multiple tables - Using UNIONS
12) Joining multiple columns of different tables - Using JOINs
13) Modify table properties - ALTER statement
14) Deleting records from the table - DELETE statement
15) Removing tables from the database permanently - DROP statement
Note: This course helps to learn SQL using Microsoft SQL Server but it will also help to master SQL if you want to learn Oracle SQL, MySql, PostgreSQL, SQLite, DB2, etc.