SQL for Beginners : learn SQL from scratch step by step

Focused View

Islam Elgaeidy

3:08:26

8 View

01 - SQL Introduction

001 SQL Histroy.mp4

03:20

002 Setting Up My SQL On MAC.mp4

05:41

003 Setting Up My SQL On Windows.mp4

05:45

004 Course-Databases.zip

004 This Course Databases.mp4

08:35

005 How this Course is Organized.mp4

02:29

02 - SELECT Data From a Single Table

001 Retrieve Data using Select Statement.mp4

05:52

002 Closer look at Select Clause.mp4

08:45

003 Closer look at Where Clause.mp4

05:08

004 Logical Operators in SQL.mp4

06:40

005 How to use IN Operator.mp4

02:52

006 How to use the Between Operator.mp4

01:53

007 Matches pattern using Like Operator.mp4

05:01

008 How to use REGEXP Operator in SQL.mp4

09:20

009 Is Null operator in SQL.mp4

02:29

010 Order By Clause.mp4

07:15

011 The Limit Clause.mp4

03:29

03 - SELECT Data From Many Tables

001 Select Data from Multiple Tables.mp4

08:29

002 Select Data from Multiple Databases.mp4

02:49

003 Joining table with itself.mp4

04:16

004 Joining table with many Tables.mp4

06:49

005 Compound Join Conditions.mp4

03:43

006 Implicit Join Syntax.mp4

02:23

007 Why we use Outer Joins.mp4

06:29

008 Outer Join Between Multiple Tables.mp4

06:21

009 How to use Self Outer Joins.mp4

02:15

010 The USING Clause.mp4

05:25

011 Natural Joins.mp4

01:23

012 Cross Joins.mp4

03:17

013 Unions.mp4

08:31

04 - Data Manipulation in SQL

001 Column Attributes.mp4

03:27

002 Adding Rows to a table.mp4

05:49

003 Adding Many Rows to a table.mp4

03:21

004 Adding Hierarchical Rows.mp4

05:55

005 Creating a Copy of a Table.mp4

08:50

006 Updating a Single Row.mp4

03:57

007 Updating Multiple Rows.mp4

03:17

008 Using Subqueries in Updates.mp4

05:39

009 Deleting Rows.mp4

01:27

Description

Learn SQL statements that every software developer or data analyst needs for designing and developing databases

What You'll Learn?

Understand the core SQL syntax and concepts
Write complex SQL queries across multiple tables
Create your own database or interact with existing databases
Query and filter (simple and complex) data
You will know how to write SQL statements to CREATE, Retrieve, Update, and Delete data.

Who is this for?

Beginner SQL developers or data scientists

(Web) developers who want to incorporate SQL into their applications

Data analysts and scientists

What You Need to Know?

No previous programming language experience required, but it won't hurt :)

All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.

No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome.

More details

Description
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.
Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. SQL for Beginners introduces you to a solid foundation in databases in a way thatâ€™s both informative and engaging. Yes, thatâ€™s right, itâ€™s possible to make an engaging course on databases.
This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what youâ€™re learning. Apply what youâ€™re learning to real-world challenges .

SQL is THE most important query language you can learn!
It's used by many popular relational database management systems like MySQL. But it's also used by data analysis and big data frameworks and tools like Apache Spark.
Hence knowing SQL opens up an endless amount of opportunities and jobs - no matter if you're going to work with relational databases or if you're becoming a data scientist, knowing SQL will be key!
This course teaches you SQL from the ground up and in extremely high detail!

SQL is a standardized language and therefore learning SQL will help you apply it in all kinds of contexts. Nonetheless, different database systems also support different aspects of SQL or bring their own variations of the SQL language. Therefore, this course dives into SQL by exploring all key features at the example of one of the most popular database systems: MySQL. All query and command examples are shown for this database system, ensuring that you feel comfortable working with SQL in this environment!
This course will enable you to write your own (simple or complex) SQL queries, create basic or advanced databases and table structures and work with data of different shape and complexity!
In detail, you will learn:
What exactly SQL is and how the core syntax looks like
How to write SQL commands
How to install MySQL
How to create and structure database tables
Which data types you may use and when to use which data type
How to perform CRUD operations: Create, Read, Update & Delete Data
How to insert data into tables
How to query and filter data
Why you should split data across multiple tables (and how to do that)
How to join (merge) data into combined result sets
How to write basic and more complex queries
How to aggregate and group data
How to use built-in database functions to work with numbers, text or dates
How to optimize databases with indexes
And much, much more!
Explore the full course curriculum to get a thorough overview of the course content and watch the free preview section to learn how this course will help you!
This course also comes with a 30 day refund period, so that you can try it risk-free :)
We'd love to welcome you on board of this course and explore SQL together with you!
So letâ€™s do this! Enroll today and start learning SQL!
Who this course is for:
Beginner SQL developers or data scientists
(Web) developers who want to incorporate SQL into their applications
Data analysts and scientists

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Islam Elgaeidy

Instructor's Courses

Hi! My name is Islam Elgaeidy! I'm a passionate software engineer and a full-stack web developer with more than 10 Years of experience in Programming and Web Developing. I've also years of experience as a professional instructor and trainer for Data Science, programming and web developing .I've never stopped learning new programming skills and languages.I started by Learning Oracle 10g, SQL Server Development and administration then I developed a lot of desktop applications using C# and SQL. After that I started my career as a freelancer developer so I've developed dozens of successful web applications using front end technologies such as (HTML5,CSS3,Bootstrap,Javascript) and Front-end frameworks like Angular4+ and for back-end technologies I've used ASP.NET and Node.js .I've Excellent knowledge in web development in both : Client-end and Back-end . I started creating websites for fun only and to help others, after that I've created very big applications to international companies and still developing and supporting these applications till the moment.In my courses I will provide you with all experience you need so you can start a new successful career or to develop your current skills.Any course will be up to date so don't worry it will never get outdated.

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.