React Fullstack with node/express, PostgreSQL and AWS
Learn how to setup a React Fullstack app on AWS with a PostgreSQL database
Created by Mohammad Iqbal - Full Stack Developer at Coding Spectrum
Students: 42794, Price: Free
Learn the Most used technologies currently in web development
AWS is the most used Cloud computing platform by far, with over 30% market share.
PostgreSQL is the one of the most popular SQL based database engine in the world.
I dont think I need to say anything about React.
We will begin with the basics, then move onto setting up the database. We will setup the Express routes which will allow us to communicate with our database. Then we will build out the client side blog using React components. We will animate the posts and comments, then move onto something more difficult. We will begin AWS. I will give you a detailed explanation of how AWS works then we will go into a complex deployment with AWS.
SQL Crash Course : PostgreSQL for Beginners
SQL course covering important topics of Business Intelligence for SQL Database ( PostgreSQL ) for Beginners
Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries
Students: 20462, Price: Free
Why learn SQL?
SQL is the most universal and common used database language.It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put,If you want to access databases then yes, you need to know SQL.
It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people get interested data from database. It is also an English like language so anyone who can use English at a basic level can write SQL query easily.
SQL is one of the most sought-after skills by hiring employers.
You can earn good money
How much time does it take to learn SQL?
SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.
What are the steps I should follow to learn SQL?
Start learning from the basics of SQL. The first 10 sections of the course cover the basics.
Once done with the basic try your hands on advanced SQL. Next 10 sections cover Advanced topics
Next few sections will cover help you with interviews and Vivas.
Practice your learning on the exercise provided in every section.
What's the difference between SQL and PostgreSQL?
SQL is a language. Specifically, the "Structured Query Language"
PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.
All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.
Which is better, PostgreSQL or MySQL?
Both are excellent products with unique strengths, and the choice is often a matter of personal preference.
PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.
Open source development will bring more features to subsequent releases of both databases.
Who uses these databases?
Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.
What's special about this course?
The course is created on the basis of three pillars of learning:
Review (Self feedback)
We have created a set of concise and comprehensive videos to teach you all the SQL related skills you will need in your professional career.
We also provide Exercises to complement the learning from the lecture video. These exercises are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.
Check if you have learnt the concepts by executing your code and analyzing the result set. Ask questions in the discussion board if you face any difficulty.
Apart from this, their is a bonus section which covers important topics from the view of job interviews and Vivas.
The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of SQL in today's corporate world.
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 !
SQL Crash Course for Aspiring Data Scientist
Learn SQL and Data Science FAST with hands on labs!
Created by Bob Wakefield - Data Management Expert
Students: 7727, Price: Free
The problem with online learning and self-guided learning, especially in programming, is that you are often not certain exactly where to get started on your journey. But you do know that having to run to the IT department whenever you need data pulled, or need a dataset to be created, can sometimes leave you stranded.
SQL, as an easy programming language designed for interacting with relational databases, is your starting point when it comes to anything data related. The user base of SQL is so deep that many big data technologies utilize some kind of port of SQL.
The problem with other SQL for data science classes is that, by only covering SQL itself, they leave you hanging on your journey to data science mastery, much like when you have to rely on IT to meet your data needs.
With Mass Street University, that journey does not end with bare bones knowledge of SQL. DSCI100: SQL Crash Course for Data Science is designed to quickly get you up to speed on the basics of using SQL. But this course does more than give you the SQL foundation you need to work with data.
In DSCI100, we extend your journey by teaching you some real data science. By demonstrating how Python and Apache Spark interact with SQL in hands-on labs, we teach you how SQL is actually used in a data science workflow once you have mastered the basics.
At the end of the course, you will be able to work with relational databases to pull the necessary data you need to perform complex analyses…without the assistance of IT. You will also have a good understanding of how to use SQL with common data science languages.
No other course will grant you the tools and fuel that allow you to take control of your journey. Enroll today for a real, self-sufficient path to data science excellence.
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.
Ethical Hacking with Nmap and Metasploit Framework Part-2
Learn to conduct vulnerability assessment with Nmap and penetration testing Metasploit
Created by Rajneesh Gupta - Cyber Security Practitioner and Instructor
Students: 4700, Price: Free
Learn to conduct vulnerability assessment with Nmap and penetration testing Metasploit framework.
Nmap ("Network Mapper") is a free and open source (license) utility for network discovery and security auditing. Many systems and network administrators also find it useful for tasks such as network inventory, managing service upgrade schedules, and monitoring host or service uptime.
The Metasploit Project was undertaken in 2003 by H.D. Moore for use as a Perl-based portable network tool, with assistance from core developer Matt Miller. It was fully converted to Ruby by 2007, and the license was acquired by Rapid7 in 2009, where it remains as part of the Boston-based company’s repertoire of IDS signature development and targeted remote exploit, fuzzing, anti-forensic, and evasion tools.
Distributed SQL and YugabyteDB Fundamentals
Learn the core concepts of distributed SQL, put them into practice using YugabyteDB and take the certification exam
Created by Jimmy Guerrero - VP Developer Relations
Students: 1508, Price: Free
This course will teach you the core concepts of distributed SQL and what makes it different from monolithic databases like Oracle, SQL Server PostgreSQL and MySQL. Through lectures and hands-on exercises you'll develop the knowledge and skills to configure and get started with YugabyteDB. Over the span of 90 minutes we'll covered the following topics in-depth:
Distributed SQL terms, definitions, and comparisons
YugabyteDB architecture and design principles
YSQL API development
Course review and exam prep
We also worked through a variety of hands-on exercises including:
Single and multi-node cluster installs on Mac, Linux, and Kubernetes
User management and basic security
Working with databases and schemas
Creating objects and loading data from external files
Creating and exploring a sample database
Creating functions and triggers
Setting up admin tools like pgAdmin, TablePlus, and DBeaver
Using a Java load generator
Testing fault tolerance (remove node, add node, rebalancing)
Learn MS SQL Server from Scratch
SQL Server Basics to Advanced Concepts
Created by VenkatM M - Technical Architect at MNC
Students: 1169, Price: Free
SQL (Structured Query Language)
SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”.SQL (Structured Query Language) is used to modify and access data or information from a storage area called database.
SQL commands are instructions used to communicate with the database to perform specific task that work with data.
Data Definition Language (DDL) - These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.
Data Manipulation Language (DML) - These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.
Transaction Control Language (TCL) - These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.
Data Control Language (DCL) - These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.
CREATE TABLE table name
column name datatype
table name - is the name of the table.
column_name1, column_name2.... - is the name of the columns
datatype - is the datatype for the column like char, date, number etc.
Many more examples on SQL Server 2016 and SQL Server 2019
Will try to cover sql performance tuning and trouble shooting concepts as well.
how to create jobs in sql agents and trouble shooting concepts