Harry Potter
SQL for Newcomers - The Full Mastery Course
Hi!
I'm Sameh Sharaf. I am a data engineer. I have worked on data since 2010 so I guess I can say I'm experienced enough.
This course will teach you how to use SQL (Structured Query Language), a language so prominent for relational databases, databases such as MySQL, PostgreSQL, SQLlite and more.
SQL now is a great skill to have if you want to work as a data analyst, data scientist, BI developer, data engineer, database administrator or even a software developer/engineer, since all these jobs need to use databases and data in a daily basis.
I'm a beginner, is this course for me?
Sure! This course was done for beginners. Even students with experience in SQL may find it useful too to memorize some keywords and functions, as well as learning more about the bits they may miss.
Is there any prerequisites to attend this course?
The only thing you need is a PC or laptop with average performance and any operating system installed on. We'll be using Windows 10 for this course but the OS does not matter since the tech we'll be using is cross-platform and can work on Linux and Mac.
Who this course is for:
- Students aspiring to become data analysts, scientists or engineers
- Junior data analysts and scientists.
- Junior developers who need to work on relational databases.
- Undergraduate students who study relational databases in their curriculum.
- Anyone who's interested to learn SQL and add it to their resume.
What you'll learn
- Able to select & filter data using SQL, fetch data for useful reports based on different requirements.
- Create & modify tables with setting constraints to columns.
- Join tables using different join types SQL provides.
- Manipulate data by adding new records & modifying or deleting existing ones.
- Learn some of the most useful built-in functions in SQL, as well as data type conversion.
- Brag about how cool they are knowing how to use SQL with their friends.
Course content
- Introduction
- Setting Up Course Tools
- Browsing & Filtering Data
- Filter Data with AND, OR, NOT Operators
- Math Operations
- String Concatenation
- Tidy Up Your Results: Sorting, Alias Names, Limit Records
- NULL, DISTINCT & CASE Statements
- Functions in SQL: Multiple-Row Functions
- Functions in SQL: Single-Row Functions
- Nested Queries
- Casting & Data Conversion
- Combination Relationships
- Joins in SQL
- Data Manipulation (DML)
- SQL Data Definition Language (DDL)
- Access Control
Requirements
-
Have a PC or laptop to work on. Your old clunky notebook will do.
-
Can work on any operating system (Windows, Linux & MacOS).
Free Download 😀
Zip/rar files password can be one of these :- FreeCourseUniverse / CheapUniverse
Harry Potter
Hey Guys We are Tech Enthusiasts and we know knowledge is key to success ! We are here to open path to your success by providing what you want. Today education == business. Our moto is education should be accessible by any person who is not able to purchase overpriced content.
Leave a comment
0 Comment
All TakenDown courses are available here
How to download ??
This site is hosted on Digital Ocean
Get $200 credit Instantly
Offer available for limited time
( Take advantage of free credits 👇 )
Related Posts
Tags
© 2022 FreeCourseUniverse. All Rights Reserved