Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 3.27 GB | Duration: 9h 49m
Just a computer.
What you'll learn
Get set-up with MySQL
Discover what SQL is and what it is used for
Learn and practice SQL queries
Understand how to solve real world problems with SQL
Avoid common SQL mistakes
Create and modify your own databases
We'll , install and set up the required software together.
Do you want to learn SQL by starting at the very start?
Do you want to be able to confidently write SQL queries to analyse and make sense of data?
Do you want to get started but don't even know what software you need?
Have you tried to learn SQL but got lost along the way?
Or are you a developer who needs to add SQL to their skillset?
This course is for you.
With a student-centred approach, this course will give you the skills and confidence in SQL and MySQL that you need.
I am a qualified and experienced IT educator with over a decade of teaching experience.
I understand students, so when creating this course I focused on two things:
clear and logical explanations
plenty of opportunities for you to practice what we are learning.
You will not just be watching videos of me typing in SQL queries. After every technique is explained, you will learn by doing.
This course includes over 130 practice exercises with full solutions.
Why learn SQL?
SQL is one of the most in-demand IT skills worldwide. SQL is necessary for web development, app development, writing applications or games, database administration, ecommerce and more. It's a great way to improve your employability, advance your career and boost your earnings potential.
Does the course cover SQL or MySQL?
MySQL is the most popular variant of SQL and it is what we will use in this course. However, the majority of everything that we learn will be directly transferrable to other SQL products such as Oracle, SQLite, Postgres or SQL Server.
Do I need to have SQL set up on my computer to take this course?
No! I will step you through ing MySQL, MySQL Workbench and the required sample databases. It's all free and easy to use.
What if I need help?
I am highly responsive to any questions you may have along the way. In addition to this, you can join the Code Lift Off course group on Facebook to discuss what you are learning.
After completing this course, you will be able to confidently write SQL queries on any database as well as create databases from scratch.
You will have a solid understanding of how the different SQL commands work, and how to approach various real world problems.
Enough talk, let's go! Sign up and we'll get started!
Who this course is for:
Bners interested in learning SQL
Students needing a better understanding of the SQL class they are taking
Developers looking to add SQL database knowledge to their skills