Introduction to SQL
Duration: 2h 7m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 642 MB
Genre: eLearning | Language: English
Learn the basics of SQL, how to use this powerful language, and improve your skillset with this course!
You'll learn how to read and write various queries to a database using one of the most popular database management systems in the world - MySQL.
These skills are also applicable to any other major SQL database, such as Oracle, Microsoft SQL Server, and much more. There are only syntax differences between various vendors but the concept is the same.
SQL is one of the most in-demand skills for business analysts, data scientists, and anyone who finds themselves working with data.
Learning SQL is one of the fastest ways to improve your career as well!
So, to be a successful developer or data scientist, or business analyst you need to know SQL.
SQL isn't complicated - or at least it doesn't need to be, as long as you follow the right route to learn.
This is a course that puts you in control, having you set up and import databases right at the start of the course.
Almost every lesson comes with an exercise part which is described under the Resources section. Exercises are based on real-world examples when you need to write queries that produce the useful and correct result set.
Inside the course, you will find lessons organized properly and we will work with a sample database with some sample data but we will have more than the single database and multiple tables which is also based on real-world database design.
Also, the archived file will be available for download from the course resources section, so you will be able to import the database inside your MySQL Workbench.
What You'll Learn.
- Get started with MySQL Workbench, installing it on Windows machine and all required setup- Intro to databases- MySQL Workbench introduction, UI, various options and shortcuts, importing database- Learn the basics of SQL syntax- Write complex SQL queries- Learn to use logical operators to add logic flow to your SQL queries- How to retrieve data from single and multiple tables- Joins (inner, outer, natural, cross)- and more!
Who is this course for
- Anyone who wants to learn and use SQL to query relational databases- People interested in SQL development, Database administrator, Business Analyst, and Business Intelligence job opportunities- Developers who have some experience in SQL but want to brush up on their SQL skills
By the end of this course, you'll be able to.
- Write SQL queries with confidence- Have a solid understanding of MySQL DBMS
No Prior Knowledge Needed!
The course covers everything that you need to know in detail and to get into SQL and relational databases,so don't worry if you're a complete novice.
I'll see you inside the course!