GitHub
github.com › ShantanilBagchi › DataCamp › blob › master › SQL Courses › Intermediate SQL Server › Readme.md
DataCamp/SQL Courses/Intermediate SQL Server/Readme.md at master · ShantanilBagchi/DataCamp
You can use derived tables when you want to break down a complex query into smaller steps. A derived table is a query which is used in the place of a table. Derived tables are a great solution if you want to create intermediate calculations ...
Author ShantanilBagchi
GitHub
github.com › Novartus › Datacamp_SQL
GitHub - Novartus/Datacamp_SQL: Datacamp solutions in SQL with DATASET
It contains the SQL solution of the following tracks with DataSet.
Starred by 27 users
Forked by 18 users
Languages TSQL 90.6% | PLpgSQL 9.4% | TSQL 90.6% | PLpgSQL 9.4%
SQL Associate Practical Exam help
I have reviewed your code. Your problem is the aliasing in TASK 3. The column name should be description instead of service_description. SELECT s.description , b.id AS branch_id, b.location, r.id AS request_id, r.rating FROM request r JOIN branch b ON b.id = r.branch_id JOIN service s ON r.service_id = s.id WHERE s.description IN ('Meal', 'Laundry') AND b.location IN ('EMEA', 'LATAM'); Thanks by the way yyour code helped me to succeed More on reddit.com
11
9
February 21, 2024DataCamp and beyond basic SQL
It is pretty difficult to find SQL content that goes beyond simple queries with perfectly normalized data. I found this course to be very good, it is paid though. He gets into correlated subqueries, window functions and has lots of exercises where you need to solve complex business problems with questionable data like you would need to do in real life. https://www.masterywithsql.com/ More on reddit.com
31
29
December 2, 2023DataCamp has 25 courses that will take you from a SQL beginner to expert, and they’re all free RIGHT NOW through 5/22, no credit card required. You'll learn using real tools and datasets all within your browser. Come check us out! No risk, all reward.
Not gonna lie, datacamp for SQL was very very helpful. SQL is a good tool to do a lot of tasks in almost any job nowadays. Just important note: It will teach you to write SQL queries, and basic concepts about databases, but it will NOT teach you any "expert" database design concepts. More on reddit.com
31
142
May 19, 2020Datacamp Learning Path
I enjoy it.
I'm switching between python and SQL with hopes of using them both when I learn enough.
I've learned more about sql than I ever would've and used my knowledge to solve some what I would call advanced queries.
More on reddit.com 4
13
September 15, 2020Videos
GitHub
github.com › datacamp-content-public › Intermediate-SQL
GitHub - datacamp-content-public/Intermediate-SQL
Which DataCamp courses cover topics that a student should be familiar with before attempting this course?
Author datacamp-content-public
GitHub
github.com › ShantanilBagchi › DataCamp › blob › master › README.md
DataCamp/README.md at master · ShantanilBagchi/DataCamp
Intermediate Importing Data in Python · - - - - Cleaning Data in Python · - - - - Exploratory Data Analysis in Python · - - - - Analyzing Police Activity with pandas · - - - - Introduction to SQL · - - - - Streamlined Data Ingestion with pandas · - - - - Introduction to Relational Databases in SQL ·
Author ShantanilBagchi
GitHub
github.com › raquelcolares › SQL-Fundamentals_Datacamp
GitHub - raquelcolares/SQL-Fundamentals_Datacamp: My repository of SQL Fundamentals course by Datacamp · GitHub
This repository shows my projects during the SQL Fundamentals course by Datacamp. In this course, I've learned the skills needed to level up my data skills through hands-on exercises.
Starred by 7 users
Forked by 2 users
GitHub
gist.github.com › case-eee › 5affe7fd452336cef2c88121e8d49f5d
Intermediate SQL · GitHub
On line 136 we're instructed to rename a column to 'class', but we can't since 'class' is a reserved word in SQL. Maybe change it to 'class_name'? I'm guessing you're still waiting for an answer on this?
GitHub
github.com › sayakpaul › Reporting-in-SQL-DataCamp-Course-Exercises
GitHub - sayakpaul/Reporting-in-SQL-DataCamp-Course-Exercises: Contains my solutions to the exercises of the course "Reporting in SQL"
Contains my solutions to the exercises of the course "Reporting in SQL" - sayakpaul/Reporting-in-SQL-DataCamp-Course-Exercises
Starred by 4 users
Forked by 2 users
GitHub
github.com › SaiSharanyaY › Datacamp--Data-Analyst-with-SQL-Server
GitHub - SaiSharanyaY/Datacamp--Data-Analyst-with-SQL-Server: View complete Datacamp SQL server track course contents with solutions
View complete Datacamp SQL server track course contents with solutions - SaiSharanyaY/Datacamp--Data-Analyst-with-SQL-Server
Author SaiSharanyaY
GitHub
github.com › Novartus › Datacamp_SQL › blob › master › README.md
Datacamp_SQL/README.md at master · Novartus/Datacamp_SQL
It contains the SQL solution of the following tracks with DataSet.
Author Novartus
GitHub
github.com › topics › datacamp-exercises
datacamp-exercises · GitHub Topics · GitHub
This repo includes all exercises for courses and projects that I have finished on datacamp. python machine-learning sql power-bi data-analytics datacamp-exercises datacamp-projects
GitHub
github.com › Hakulani › Intermediate-SQL
GitHub - Hakulani/Intermediate-SQL: Intermediate SQL Datacamp
Intermediate SQL Datacamp Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
Author Hakulani
GitHub
github.com › ShantanilBagchi › DataCamp › blob › master › SQL Courses › Introduction to SQL Server › Readme.md
DataCamp/SQL Courses/Introduction to SQL Server/Readme.md at master · ShantanilBagchi/DataCamp
Hit 'Submit Answer' to run the query and view the existing data.
Author ShantanilBagchi
GitHub
github.com › ishtiakrongon › Datacamp-Intermediate_SQL
GitHub - ishtiakrongon/Datacamp-Intermediate_SQL: SQL is the most popular language for turnng raw data stored in a database into actionabale insights. I have completed Intermediate SQL course in DataCamp.
SQL is the most popular language for turnng raw data stored in a database into actionabale insights. I have completed Intermediate SQL course in DataCamp. - GitHub - ishtiakrongon/Datacamp-Intermediate_SQL: SQL is the most popular language for ...
Author ishtiakrongon
GitHub
github.com › ashleyj2 › DA102-SQL-queries › blob › ashleyj2-patch-1 › intermediate_sql_notes.sql
DA102-SQL-queries/intermediate_sql_notes.sql at ashleyj2-patch-1 · ashleyj2/DA102-SQL-queries
Datacamp - Intermediate SQL · Notes & Exercises · Uses several different datasets · 12/2/22 · Ashley Joyner · */ · --COUNT · -- Count the number of records in the people table · SELECT COUNT(*) AS count_records · FROM people; · -- Count the number of birthdates in the people table ·
Author ashleyj2
GitHub
github.com › datacamp-content-public › Intermediate-SQL › releases
Releases · datacamp-content-public/Intermediate-SQL
datacamp-content-public / Intermediate-SQL Public · Notifications · You must be signed in to change notification settings · Fork 1 · Star 0 · Releases · datacamp-content-public/Intermediate-SQL · You can create a release to package software, along with release notes and links to binary files, for other people to use.
Author datacamp-content-public
GitHub
github.com › parulrathore › DataCamp_Intermediate_SQL
GitHub - parulrathore/DataCamp_Intermediate_SQL
Contains solutions for Data Camp Intermediate SQL Course
Author parulrathore
GitHub
github.com › viktor-taraba › DataCamp
GitHub - viktor-taraba/DataCamp: This repo includes all exercises for courses and projects that I have finished on datacamp. · GitHub
Intermediate DAX in Power BI · Done · 15 · Reports in Power BI · Done · 16 · Exploratory Data Analysis in Power BI · Done · 17 · Report Design in Power BI · Done · 18 · User-Oriented Design in Power BI · Done · 19 · Machine Learning with Tree-Based Models in Python · Done · 20 · Case Study: Analyzing Job Market Data in Power BI · Done · 21 · Hierarchical and Recursive Queries in SQL Server ·
Starred by 20 users
Forked by 4 users
Languages Jupyter Notebook 66.6% | HTML 33.1%
Reddit
reddit.com › r/datacamp › sql associate practical exam help
r/DataCamp on Reddit: SQL Associate Practical Exam help
February 21, 2024 -
I've just tried my first attempt and just can't see what is wrong even with the hints, made some changes but I think something might be still off.
I don't mind failing the exam to take it again but I just want to learn from my mistakes here since I spent quite a while doing this.
UPDATE: the guy in the comments helped me out and i passed, do take a look if you're struggling to complete it
ps.!! i couldn't update it on git so just take note of my error in TASK 3 where the column description should not be renamed to service_description
https://github.com/christyleeyx/sql-associate-cert/blob/main/notebook%20(3).ipynb
Top answer 1 of 4
2
I have reviewed your code. Your problem is the aliasing in TASK 3. The column name should be description instead of service_description. SELECT s.description , b.id AS branch_id, b.location, r.id AS request_id, r.rating FROM request r JOIN branch b ON b.id = r.branch_id JOIN service s ON r.service_id = s.id WHERE s.description IN ('Meal', 'Laundry') AND b.location IN ('EMEA', 'LATAM'); Thanks by the way yyour code helped me to succeed
2 of 4
1
I keep getting the error "clean categorical and text data by manipulating strings" on task 1, did you pass task one? if so can you please help
GitHub
github.com › vskabelkin › datacamp › blob › master › Course - Joining Data in PostgreSQL › Datacamp - Joining Data in PostgreSQL.sql
datacamp/Course - Joining Data in PostgreSQL/Datacamp - Joining Data in PostgreSQL.sql at master · vskabelkin/datacamp
My solutions for projects and courses on Datacamp.com - datacamp/Course - Joining Data in PostgreSQL/Datacamp - Joining Data in PostgreSQL.sql at master · vskabelkin/datacamp
Author vskabelkin
GitHub
github.com › topics › datacamp
datacamp · GitHub Topics · GitHub
python data-science machine-learning pandas data-analysis datacamp-course datacamp datacamp-exercises datacamp-solutions-python datacamp-python datacamp-machine-learning datacamp-track data-analyst-with-sql-server data-scientist-with-python data-analyst-with-python data-science-for-everyone datacamp-data-science