Introduction to SQL
This course is for you if you are new to SQL, you want to quickly learn how to get the most out of SQL and you want to learn how to use SQL in your own application development.Course
Gain insight into a topic and learn the fundamentals4.8
(1566)
- Understand how to extract individual, multiple and all columns from databases.
- Understand the process of sorting and filtering retrieved data to extract meaningful insights.
- Develop abilities in advanced data filtering, using operators and functions to refine queries.
- Become skilled in applying aggregate functions like COUNT, AVG, MAX, MIN, and SUM to analyze data sets.
Equip your business with cutting-edge Data and AI expertise.
Share it on social media and in your performance review
There are 6 modules in this course
This course is for you if you are new to SQL, you want to quickly learn how to get the most out of SQL and you want to learn how to use SQL in your own application development.- Retrieving Individual ColumnsPreview
- Retrieving Multiple ColumnsPreview
- Retrieving All ColumnsPreview
- Retrieving Distinct RowsPreview
- Limiting ResultsPreview
- Challenge: Find the Population of the CountriesPreview
- Challenge: Find All CountriesPreview
- Challenge: Find All Countries With Their IDsPreview
- Challenge: Find Country CapitalsPreview
- Challenge: Find the Regions in Which All Countries Are LocatedPreview
- Sorting DataPreview
- Challenge: Population SortPreview
- Sorting by Multiple ColumnsPreview
- Challenge: Dual-Sort QueryPreview
- Specifying Sort DirectionPreview
- Challenge: Sort the Countries by Region and CapitalPreview
- Challenge: Sort Capitals in Descending OrderPreview
- Challenge: Sort Countries in Ascending OrderPreview
- Challenge: Find Countries, Their IDs, and Their PopulationsPreview
- Challenge: Find Countries, IDs, Populations, Regions, and Sort ThemPreview
- Challenge: Find All Continents and Sort Them in Ascending OrderPreview
Chosen by students of top schools
Why people choose Codefinity for their career
Kwizera Mugisha
The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.
Sherry Barnes-Fox
My first course was 4 hours, I did it in a few days, "nugget-style. The instructions are very clear and easy to understand. There is even a hint to help you get the answer, and if you still cannot get the answer, then you can display the answer. I love the learning style that is used, it engages me.
Bill Wagner
I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.
Stephanie Chan
As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.
Daniel Chinea
I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming.
Steve Bruening
The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.
Learner reviews
4.9
50 reviews
5
90%
4
6%
3
4%
2
0%
1
0%
Showing 3 of 50 reviews
Rudy Beugels
5
Reviewed on Nov 15, 2024
Kriss SPOTT
5
Reviewed on Nov 13, 2024
GREAT!!!! I feel like every day I'm closer to saying "wooow, I know SQL"
Molly McCreight
5
Reviewed on Nov 11, 2024
Recommended if you're interested in learning SQL
Codefinity advantages
Embrace the fascination of Tech Skills! Our AI-assistant provides real-time feedback, personalized hints, and error explanations, empowering you to learn with confidence.
With Workspaces, you can create and share projects directly on our platform. We've prepared templates for your convenience
Take control of your career development and commence your path into mastering the latest technologies
Real-world projects elevate your portfolio, showcasing practical skills to impress potential employers
Embrace the fascination of Tech Skills! Our AI-assistant provides real-time feedback, personalized hints, and error explanations, empowering you to learn with confidence.
With Workspaces, you can create and share projects directly on our platform. We've prepared templates for your convenience
Take control of your career development and commence your path into mastering the latest technologies
Real-world projects elevate your portfolio, showcasing practical skills to impress potential employers
Full catalog access
One subscription opens up this course and our entire catalog of projects and skills.
Top-rated, curated contentNew courses added weeklyAl assistant to answer any questionsPassionate community of learners
100+ Top-Rated coursesCompletion certificatesEarly access to new courses
20+ hands-on Real-world projectsPersonalized study tracksUnlimited workspaces100+ Top-Rated coursesCompletion certificatesEarly access to new courses20+ hands-on Real-world projectsPersonalized study tracksUnlimited workspacesYour subscription also includes:
Frequently asked questions
Is Codefinity worth the investment?
Why do I need Codefinity?
Is Codefinity good for beginners?
Are the skills taught on Codefinity up-to-date with industry standards?
Are Codefinity certificates recognized by employers?
How much time do I need to commit to Codefinity courses?
Is there a satisfaction guarantee?
How do I cancel my subscription?
Still have questions?
Write your question here
