TechPledge Certified Data Scientist (SQL)

• Lectures (PDF)
•  Lab Manual (PDF)
• Recorded Video
• Xtream Lab / LOD Access
• Cloud Pass

 

- Designing, developing and maintaining databases and data pipelines using SQL and other tools
- Performing data analysis and reporting using SQL queries, functions and procedures
- Developing and testing data models and algorithms using SQL and other languages such as Python or R
- Collaborating with other data scientists, engineers and stakeholders to understand business requirements and deliver data-driven solutions
- Ensuring data quality, security and compliance using SQL and best practices
- Troubleshooting and optimizing SQL performance issues and providing recommendations for improvement
 

- Introduction to SQL and relational databases

•   - What is SQL and why is it important for data science?
•   - How to create, query, and manipulate tables and views
•   - How to use joins, subqueries, and set operations

- Data analysis and visualization with SQL

•   - How to perform descriptive and inferential statistics with SQL
•   - How to use aggregate functions, window functions, and common table expressions
•   - How to create and customize charts and dashboards with SQL

- Data wrangling and preprocessing with SQL

•   - How to handle missing values, outliers, and duplicates with SQL
•   - How to apply data transformations and normalization with SQL
•   - How to use SQL for feature engineering and selection

- Machine learning and predictive modeling with SQL

•   - How to use SQL for supervised and unsupervised learning
•   - How to implement linear regression, logistic regression, and k-means clustering with SQL
•   - How to evaluate and optimize model performance with SQL

- Advanced topics and applications of SQL for data science

•   - How to use SQL for text analysis and natural language processing
•   - How to use SQL for spatial analysis and geospatial data
•   - How to use SQL for big data and cloud computing

The course duration is 40 hours and the prerequisites are basic computer skills and familiarity with relational database concepts.
 

Note: For detailed syllabus and lab , please book a demo or email us at info@techpledges.com.