We may earn an affiliate commission when you visit our partners.
Code School
The Sequel to SQL
Gregg Pollack
Gregg Pollack
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
Read more
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
Read more
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system.
SQL is used to manage and organize data in all sorts of systems in which various data relationships exist.
In this course, you will learn the most important basics of the SQL language in order to create tables with constraints, relationships, and write other powerful queries.
This course is for anyone who wants to learn the SQL language.
There are no prerequisites for this course.
Register for this course and see more details by visiting:
OpenCourser.com/course/lg8xok/code
What's inside
Syllabus
Aggregate Functions
Table Constraints
Normalization and Relationships
Inner Joins, Aliases, and Outer Joins
Read more
Syllabus
Aggregate Functions
Table Constraints
Normalization and Relationships
Inner Joins, Aliases, and Outer Joins
Read more
Subqueries
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Develops core relational database management skills and deepens database querying knowledge
Teaches valuable table creation and data organization strategies
Builds a strong foundation for SQL language in database management
Taught by Gregg Pollack, an experienced instructor in data management
Suitable for beginners and those seeking to enhance their SQL skills
Save this course
Save Code School: The Sequel to SQL to your list so you can find it easily later:
Save
Save
Activities
Coming soon
We're preparing activities for
Code School: The Sequel to SQL.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete Code School: The Sequel to SQL will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators are responsible for managing and maintaining databases, ensuring that they are up-to-date, secure, and running smoothly. This course can help you develop skills in SQL, which is critical for managing and querying databases, making you a more effective Database Administrator.
Data Architect
Data Architect
Data Architects design and implement data management solutions. They need to be proficient in SQL to design and manage databases. This course can help you develop strong SQL skills, providing you with a foundation for a successful career as a Data Architect.
Database Developer
Database Developer
Database Developers design and develop databases. They need to be proficient in SQL to create and manage databases. This course can help you develop strong SQL skills, providing you with a foundation for a successful career as a Database Developer.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use mathematical and statistical models to analyze financial data and make investment decisions. SQL is commonly used by Quantitative Analysts to query and analyze large datasets. This course can help you develop strong SQL skills, enabling you to contribute to the development and implementation of quantitative models.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts use data to help businesses make better decisions. They need to be proficient in SQL to query, analyze, and visualize data. This course can help you develop strong SQL skills, providing you with a foundation for a successful career as a Business Intelligence Analyst.
Data Scientist
Data Scientist
Data Scientists use advanced statistical and machine learning techniques to build models and analyze trends from large volumes of data. Proficiency in SQL is important to Data Scientists, as they need to work with structured data to uncover valuable insights. This course may help you develop strong SQL skills, providing you with a solid foundation in data analysis.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use mathematical and statistical techniques to improve the efficiency and effectiveness of business operations. SQL is commonly used by Operations Research Analysts to query and analyze operational data. This course can help you develop strong SQL skills, enabling you to contribute to the design and implementation of operations research models.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines to ensure that data is available and reliable for analysis. SQL is widely used by Data Engineers for building data pipelines and performing data transformations. This course can help you develop solid SQL skills, enabling you to contribute to the design and implementation of data-driven solutions.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. SQL is often used by Software Engineers for storing and managing data within applications. This course can help you build a foundation in SQL, enabling you to contribute to the design and implementation of data-driven applications.
Consultant
Consultant
Consultants provide advice and guidance to businesses on a variety of topics, including data management and analytics. SQL is often used by Consultants to query and analyze data to help businesses make better decisions. This course can help you develop SQL skills, enabling you to contribute to consulting projects and provide valuable insights to clients.
Marketing Analyst
Marketing Analyst
Marketing Analysts analyze data to help businesses understand their customers and make better marketing decisions. SQL is often used by Marketing Analysts to query and analyze customer data. This course may help you build a foundation in SQL, enabling you to contribute to marketing campaigns and customer analysis.
Market Researcher
Market Researcher
Market Researchers conduct surveys and analyze data to provide insights about customer preferences and market trends. SQL is often used by Market Researchers to query and analyze survey data. This course may help you build a foundation in SQL, enabling you to contribute to market research studies and provide valuable insights to businesses.
Financial Analyst
Financial Analyst
Financial Analysts analyze financial data to make investment recommendations. SQL is used by Financial Analysts to query and analyze financial data. This course can help you develop SQL skills, enabling you to extract insights from financial data and make better investment decisions.
Product Manager
Product Manager
Product Managers are responsible for defining and managing the roadmap of a product. They need to be able to understand and analyze data to make informed decisions. This course can help you develop SQL skills, enabling you to better understand and analyze product usage data, which can inform your product decisions.
Data Analyst
Data Analyst
Data Analysts study data using sophisticated statistical techniques to provide meaningful insights to help businesses make more informed decisions. This course may help you build a foundation in SQL and prepare you to query, analyze, and visualize datasets, a core skill for Data Analysts.
For more career information including salaries, visit:
OpenCourser.com/course/lg8xok/code
Reading list
We've selected 15 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Code School: The Sequel to SQL.
This comprehensive textbook covers a wide range of database topics, including SQL, database design, and data mining. It valuable resource for students and professionals alike.
Comprehensive guide to SQL injection attacks. It covers everything from the basics of SQL injection to advanced techniques for defending against SQL injection attacks.
An excellent resource for understanding the theory behind SQL and relational databases. is suitable for readers with some prior experience with SQL or database design.
Provides a comprehensive overview of SQL, with a focus on best practices and performance tuning. It valuable resource for experienced SQL developers.
Hands-on guide to SQL data manipulation. It provides clear and concise explanations of the most important SQL concepts, and it includes plenty of examples to help you learn how to use SQL effectively.
Comprehensive guide to PostgreSQL. It covers everything from basic SQL syntax to advanced topics such as replication and performance tuning.
Comprehensive guide to Oracle Database 12c. It covers everything from basic SQL syntax to advanced topics such as data warehousing and business intelligence.
Save
Collection of recipes for solving common SQL problems. It provides clear and concise solutions to a wide range of SQL problems.
Provides a comprehensive overview of the main features and functions of SQL, but it is less suited for deeper technicalities and best practices.
Provides a clear and concise introduction to relational database design. It valuable resource for students and professionals alike.
Covers a wide range of SQL topics, from the basics to more advanced concepts. It is well-written and easy to follow, making it a great choice for beginners.
Provides a collection of SQL practice problems. It valuable resource for students and professionals who want to improve their SQL skills.
Discusses common mistakes that SQL developers make. It valuable resource for helping to avoid these mistakes and write better SQL code.
Save
Offers a concise introduction to the essential principles and concepts of SQL. Thanks to its brevity, it does not provide deep coverage of the most advanced features of SQL.
Save
Provides a concise overview of the SQL language. It valuable resource for quick reference and review.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/lg8xok/code
Share
Similar courses
Here are nine courses similar to
Code School: The Sequel to SQL.
Building a Company’s database using MySQL and SQL
OpenCourser.com/course/1x7xsp/building
Building a Company’s database using MySQL and SQL
Most relevant
CS50's Introduction to Databases with SQL
OpenCourser.com/course/e5uhdn/cs50
CS50's Introduction to Databases with SQL
Most relevant
Manipulating Data with SQL
OpenCourser.com/course/kidyv4/manipulating
Manipulating Data with SQL
Most relevant
Relational Database Basics
OpenCourser.com/course/r7wyip/relational
Relational Database Basics
Most relevant
Databases and SQL for Data Science with Python
OpenCourser.com/course/v5ecv3/databases
Databases and SQL for Data Science with Python
Most relevant
Introduction to SQL
OpenCourser.com/course/weefw6/introduction
Introduction to SQL
Most relevant
Introduction to SQL
OpenCourser.com/course/0t1qcg/introduction
Introduction to SQL
Most relevant
SQL for Data Science with R
OpenCourser.com/course/3wzifm/sql
SQL for Data Science with R
Most relevant
Introduction to Databases and SQL
OpenCourser.com/course/1o26fv/introduction
Introduction to Databases and SQL
Most relevant
Time
46 hours
Level
Intermediate
Via
Pluralsight
Instructor
Gregg Pollack
Language
English
Good to know
Develops core relational database management skills and deepens database querying knowledge
Teaches valuable table creation and data organization strategies
Builds a strong foundation for SQL language in database management
Taught by Gregg Pollack, an experienced instructor in data management
Suitable for beginners and those seeking to enhance their SQL skills
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser