NYU Stern | Course Schedule

Spring 2026 Course Listing (Intensives)

PRELIMINARY

Click on course number to view the course description.

Click on course section to view the course syllabus.

Sample syllabi are posted to provide you with additional information for the course registration process and may not reflect the final versions of the courses. Content, schedule, requirements, assignments, etc. may change. Please do not use these samples as a basis for buying textbooks, scheduling, preparing assignments, etc.

For Online classes, Click here.

Core Courses
Economics
Finance
Management and Organizational Behavior
Marketing
Professional Responsibility
Technology

= Cancelled
= New Class Added
= Professor Change
= Rescheduled (day/time change)

Core Courses

COR1-GB.2103Strategy I (1.5)

Course Description:

This course provides students with the concepts and tools required to devise business strategies to gain competitive advantage at the product market level. It also shows how to apply the rules of competitive advantage to a range of economic markets in the United States and globally where the business environment is increasingly turbulent. The course explains how to formulate a business strategy, how to analyze competitive markets and how to define each firm's strategic situation. It focuses on how to create superior value for customers and capture enough value to create increasing profit for your firm. Students learn how successful firms develop superior resources products operations human competencies, organizational teams, procurement technology finances and business alliances to gain and sustain competitive advantage in a dynamic economic environment.

Schedule for COR1-GB.2103
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	In-Person	--Alternate Schedule-- TR 6:00 pm - 9:00 pm Su 9:00 am - 4:00 pm	01/06-01/15 01/11-01/11	Miller,A		1913
W2	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/06-01/15 01/11-01/11	Min,W	Online; This class will have additional asynchronous work each week.	1914
W3	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O)	01/05-01/14 01/10-01/10	Porac,J	Online; This class will have additional asynchronous work each week.	1917
W4	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O)	01/05-01/14 01/10-01/10		Online; This class will have additional asynchronous work each week.	1919
W5	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/06-01/15 01/11-01/11		Online; This class will have additional asynchronous work each week.	1936

Equivalencies:

COR1-GB.1101 Business Strategy

COR1-GB.2104Strategy II (1.5)

Course Description:

In this course students learn how to develop skills needed to manage the multibusiness enterprise for the creation of corporate advantage To create value through corporate strategy managers must command a number of critical competencies They must be able to create a vision that targets multiple businesses objectives including achieving sustainable corporate growth in profits This course requires integrating skills at developing and deploying corporate resources and capabilities to apply analytical tools and perspectives to changing industries and multibusiness markets and to design organizational structures systems and process that achieve shortterm and longterm corporate strength and profit growth Students learn how to manage the interpersonal dynamics of strategy decision making and how to communicate effectively their visions ands strategies to internal and external stakeholders of the corporation A considerable part of corporate strategy today focuses on managing merger integration Alliances internal growth and global networks which involves increasing cooption and creating various combinations of both multiple business collaborations to expand new markets and also pursuing simultaneous competitive goals to ensure the survival and growth of the firm

Schedule for COR1-GB.2104
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	In-Person	--Alternate Schedule-- TR 6:00 pm - 9:00 pm Su 9:00 am - 4:00 pm	01/20-01/29 01/25-01/25	Hegde,D		1915
W2	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/20-01/29 01/25-01/25	Miller,A	Online; This class will have additional asynchronous work each week.	1916
W3	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O) Sa 11:00 am - 1:00 pm (O)	01/21-01/31 01/24-01/24 01/31-01/31	Miller,A	Online; This class will have additional asynchronous work each week.	1918
W4	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O) Sa 11:00 am - 1:00 pm (O)	01/21-01/31 01/24-01/24 01/31-01/31	Porac,J	Online; This class will have additional asynchronous work each week.	1920
W5	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/20-01/29 01/25-01/25	Min,W	Online; This class will have additional asynchronous work each week.	1937

Pre/Corequisite:

Full-time MBA & Part-time MBA Prerequisite: COR1-GB 2103.

Equivalencies:

COR1-GB.2101 Strategy

COR1-GB.2301 Strategy

COR1-GB.2111 Corporate Strategy

Economics

ECON-GB.2148Public Policy and Business Strategy (1.5)

Course Description:

In most industries firms are either subject to direct regulation or under the eye of a competition policy watchdog Agreements with competitors mergers and acquisitions pricing distribution practices these and many other dimensions of firm strategy are potentially subject to the scrutiny of government authorities In addition to competition policy the governments role is also apparent in state aid eg subsidies to firms direct intervention inational champions eg golden shares and industrial policy eg government favoritism for a particular technology standard This course provides an introduction to the role and impact of public policy on market competition It takes the perspective of a firms manager and asks the twin questions a to what extent does government intervention limit a firms strategy and b how can firm strategy take advantage of government intervention The course will be based on case studies Several of these case studies correspond to actual litigation cases in the US and Europe After each case there will also be a brief lecture pointing to some general concepts One peculiar characteristic of most of the cases discussed in class is that there are two clearly distinguished and to some extent opposed approaches this is obviously true for litigation cases but not exclusively Grading will consists exclusively of class participation Specifically you will be asked to argue in favor or against a particular position in each of the cases discussed in class

Schedule for ECON-GB.2148
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O)	01/05-01/14 01/10-01/10	Cabral,L	Online; This class will have additional asynchronous work each week.	2023

Pre/Corequisite:

Prerequisite: MBA student and COR1-GB 1303.
Prerequisite: Focused MBA student and COR1-GB 1103.
Not open to students with more than 24 ECON-GB units.

Equivalencies:

ECON-GB.2348 Public Policy and Business Str

Specializations:

Economics

Healthcare

Law & Business

Strategy

ECON-GB.2190Emerging Economies (1.5)

Course Description:

This course covers the economic development and market structure of various emerging economies. The course is designed to cover many of the most important emerging markets in the world. Asia, especially China and India, receives a strong focus given its size and pivotal role in the world economy. However, the markets of Latin America, Africa, Eastern Europe and the Middle East all receive coverage. Emerging markets are now responsible for the lion's share of world GDP growth. Success in them is critical for the strategies of multinational firms. Similarly, they are an important part of most investment portfolios. The course attempts to answer a number of important questions about these markets: What are the key challenges facing emerging markets today? What are the key drivers for economic growth in different countries? What is their future potential and how are they likely to evolve over the next few decades? How will demographic trends impact the attractiveness and growth prospects of these markets? What role does the government, especially the state-owned sector, play in their economies? More generally, how does politics impact markets, especially for foreign firms operating there? How do financial markets and corporate governance vary by country and what impact do they have on firm strategies? Why are conglomerates more common in emerging markets and what role do they play? How do consumer behavior and product markets vary by income and region?

Schedule for ECON-GB.2190
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/20-01/29 01/25-01/25	Foudy,J	Online; This class will have additional asynchronous work each week.	2022

Pre/Corequisite:

ECON-GB Departmental Max and Non-Stern

Equivalencies:

ECON-GB.2195 Advanced Global Perspectives O

ECON-GB.2338 Emerging Markets & Global Chal

ECON-GB.2290 Emerging Economies

Specializations:

Economics

Global Business

Law & Business

Finance

FINC-GB.3173Venture Capital Financing (1.5)

Course Description:

This course provides institutional background and details necessary to deal with the venture capital and new issues markets Examines basic valuation issues appropriate capital structure the value of liquidity and the value of control Also considers the intangible aspects of entrepreneurship and venture capital forms of financing.

Schedule for FINC-GB.3173
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O)	01/05-01/14 01/10-01/10	Okun,G	Online; This class will have additional asynchronous work each week.	2212

Pre/Corequisite:

Pre-req: Full-time MBA, COR1-GB 2311. Co-requisite: FINC-GB 2302.
Pre-req: Focused MBA and COR1-GB 2222.
Pre-req: Part-time MBA, (COR1-GB 2311). Co-requisite: (FINC-GB 2302).
Not open to students with 24 or more FINC-GB units.

Equivalencies:

FINC-GB.3361 Entrepreneurial Finance

FINC-GB.3373 New Venture Financing

Specializations:

Banking

Corporate Finance

Entrepreneurship and Innovation

Finance

Financial Instruments & Markets

Quantitative Finance

FINC-GB.3196Mergers and Acquisitions (1.5)

Course Description:

This course examines selected topics in mergers and acquisitions from the viewpoint of finance Basic theory and empirical findings form the base for discussing such issues as merger strategy defensive measures in merger the valuation of firms as a whole under differing management strategies and the impact of financing considerations on various stakeholders.

Schedule for FINC-GB.3196
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	In-Person	--Alternate Schedule-- TR 6:00 pm - 9:00 pm Su 9:00 am - 4:00 pm	01/20-01/29 01/25-01/25	Amihud,Y		2237

Specializations:

Banking

Corporate Finance

Finance

Law & Business

Quantitative Finance

Strategy

Management and Organizational Behavior

MGMT-GB.2159Collaboration, Conflict, and Negotiation (1.5)

Course Description:

Successful managers know how to collaborate with other people effectively and how to resolve conflicts constructively. The goal of this course is to teach students the fundamentals of managing collaboration and conflict in one-on-one and small group settings. Our objective is to enhance students' interpersonal skills at their jobs. Drawing from the latest findings in managerial psychology, we cover the fundamentals of effective negotiation, communication, and persuasion. Special topics include getting buy-in, coping with resistance, and building coalitions.

Schedule for MGMT-GB.2159
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/06-01/15 01/11-01/11	Corfman,K	Online; This class will have additional asynchronous work each week.	2037
W2	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/06-01/15 01/11-01/11	Hur,J	Online; This class will have additional asynchronous work each week.	2038
W3	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O)	01/05-01/14 01/10-01/10	Hewlin,J	Online; This class will have additional asynchronous work each week.	2039
W4	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/06-01/15 01/11-01/11	Hewlin,J	Online; This class will have additional asynchronous work each week.	2040
W5	In-Person	--Alternate Schedule-- TR 6:00 pm - 9:00 pm Su 9:00 am - 4:00 pm	01/20-01/29 01/25-01/25	Blader,S		2042
W6	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/20-01/29 01/25-01/25	Corfman,K	Online; This class will have additional asynchronous work each week.	2043
W7	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O)	01/05-01/14 01/10-01/10	Hur,J	Online; This class will have additional asynchronous work each week.	2079

Pre/Corequisite:

MGMT-GB Departmental Max and Non-Stern

Equivalencies:

MGMT-GB.2259 Collaboratn, Conflct & Negtn

Specializations:

Leadership and Change Management

Management

MGMT-GB.2327Managing the Growing Company (3)

Course Description:

This course exposes students to the unique challenges of managing the growth of small businesses. It concentrates on building the company issues rather than start-up issues, although some cases and lectures explore start-up as well. Included are studies of family businesses that have acute growth issues because of succession and family dynamics. It is designed for students interested in understanding the opportunities and problems involved in the management or operation of their own business; and it is also aimed at students considering employment in a small or midsized firm. The differences between small firms and large organizations, management needs, practices, and financial resources are examined.

Schedule for MGMT-GB.2327
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/06-01/22 01/11-01/24	Okun,G	Online; This class will have additional asynchronous work each week.	2050

Pre/Corequisite:

Prereq:Full-time MBA &(COR1-GB.1302 or COR1-GB.1102) or Co-req:Full-time MBA & COR1-GB.2104
Prereq: Focused MBA & (COR1-GB 1102 or COR1-GB 2101)
Prereq: Part-time MBA & (COR1-GB 1302 or CORE-GP 1020).
Not open to students with more than 24 MGMT-GB units.

Equivalencies:

MGMT-GB.2127 Managing Growing Companie

MGMT-GB.2227 Managing Growing Companies

Specializations:

Entrepreneurship and Innovation

Leadership and Change Management

Management

Strategy

MGMT-GB.3155Technology Innovation Strategy (1.5)

Course Description:

The purpose of this course is to expose you to the dynamics of industries driven by technological innovation and to train you to think strategically about technological innovation. In this course we will tackle such questions as: How and why are dominant standards chosen in winner-take-all industries. How do firms choose among multiple attractive innovation projects? How do firms decide whether to go it alone or collaborate and how do firms develop an effective collaboration strategy? How do firms make the difficult choice between protecting their technologies with patents or copyrights versus rapidly disseminating them to build installed base and complementary goods? The course will be lecture, case, and discussion based. Like the industries we will study, the course will be fast-paced challenging and exciting.

Schedule for MGMT-GB.3155
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O) Sa 11:00 am - 1:00 pm (O)	01/21-01/28 01/24-01/24 01/31-01/31	Schilling,M	Online; This class will have additional asynchronous work each week.	2056
W2	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/06-01/15 01/11-01/11	Prescott,B	Online; This class will have additional asynchronous work each week.	2531

Pre/Corequisite:

MGMT-GB Departmental Max and Non-Stern

Equivalencies:

MGMT-GB.3255 Tech Innovation Strategy

Specializations:

Brand Management

Entertainment, Media & Technology

Entrepreneurship and Innovation

Management

Management of Technology & Operations

Strategy

Tech Product Management

MGMT-GB.3366Power and Politics in Organizations (3)

Course Description:

This course considers the way political processes and power structures influence decisions and choices made within and by organizations. It analyzes the sources, distribution, and use of influence in relation to resource allocation, organizational change and performance management succession, procedural justice, policy formulation, and social movements within organizations. It develops skills in diagnosing and using power and politics in organizational settings. A basic assumption underlying the course is that managers need well-developed skills in acquiring and exercising power to be effective. The course is designed to (1) improve students' capacity to diagnose organizational issues in terms of their political dimensions and (2) enhance their effectiveness in their jobs and careers as a result of that improved capacity.

Schedule for MGMT-GB.3366
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- TWR 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O) Su 11:00 am - 1:00 pm (O)	01/20-01/29 01/24-01/31 01/25-02/01	Magee,J	Online; This class will have additional asynchronous work each week.	2847

Pre/Corequisite:

Co-requisites: Full-time MBA & COR1-GB 1302 or COR1-GB.1102.
Co-requisites: Focused MBA & COR1-GB 1102.
Co-requisites: Part-time MBA & COR1-GB 1302 or CORE-GP 1020.
Not open to students with more than 24 MGMT-GB units.

Equivalencies:

MGMT-GB.3165 Power and Professional Influen

Specializations:

Leadership and Change Management

Management

Tech Product Management

Marketing

MKTG-GB.2128Consultative Selling (1.5)

Course Description:

The goal of Consultative Selling is to provide students with the knowledge and skills that entrepreneurs - and nearly all other business executives - need to win customers and grow their business. We will use the consultative selling model to understand the process of selling discovery of and alignment with customer's needs, presentations of solutions, overcoming objections, and gaining agreement. Rather than pigeonholing selling as "something done by those sales types," we look at it as providing solutions to customer's problems. Selling is unique in that everyone does it. In business, we sell our products, proposals, IPOs, projects, budgets, and anything else that someone else has to approve. In life we buy cars and houses (buying and selling are two sides of the same coin), interview for jobs, propose marriage, and many other things that someone else has to say OK to. In short, selling is a fundamental life skill. The course is primarily an interactive discussion including debates, case discussions, and many small group "skills drills" to apply the concepts and methods. In addition to learning the aspects of contemporary selling as it applies to their chosen careers, students will also gain a better appreciation of this important - and often misunderstood - aspect of an organization. The course is focused on professional business-to-business (B2B) sales issues and sales management. We frequently draw on our own experiences as consumers (B2C) as a basis for developing perspectives, insights, and understanding of B2B sales themes.

Schedule for MKTG-GB.2128
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	In-Person	--Alternate Schedule-- MW 6:00 pm - 9:00 pm Sa 9:00 am - 4:00 pm	01/05-01/14 01/10-01/10	Krawitz,J		2125

Pre/Corequisite:

Prerequisites: Full-time MBA. Co-requisite: COR1-GB 2310.
Prerequisites: Focused MBA. Co-requisite: COR1-GB 2110.
Prerequisites: Part-time MBA and COR1-GB 2310.
Not open to students with more than 24 MKTG-GB units.

Equivalencies:

MKTG-GB.2329 Entrep Selling

Specializations:

Brand Management

Luxury Marketing

Marketing

MKTG-GB.2175Omni-Channel Marketing (1.5)

Course Description:

In today's digital-centric world, it is crucial that brands learn how to adapt and adjust quickly while staying true to their core DNA. With new channels for reaching and engaging consumers shifting as rapidly as consumer expectations, brands have the ability to launch products, reach new audiences, and build awareness with unprecedented speed and efficiency. This has resulted in a shift in the retail landscape. This course will expose you to real- world examples, strategies, and behind the scenes on how retailers are creating a meaningful path to executing the right experience, at the right time, for the right customer. In particular, the course will help you define and understand what omni channel means for today's retailers and the challenges they face in developing a winning strategy.

Schedule for MKTG-GB.2175
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- TR 7:00 pm - 9:00 pm (O) Su 11:00 am - 4:00 pm (O)	01/20-01/29 01/25-01/25	Shanley,L	Online; This class will have additional asynchronous work each week.	2126

Equivalencies:

MKTG-GB.2375 Omni-Channel Marketing

INTA-GB.3311 NYC Immersion: L&R

Specializations:

Marketing

MKTG-GB.3150Marketing Planning & Strategy (1.5)

Course Description:

Approximately 95 percent of a brand manager's responsibilities involve the development execution, evaluation, and refinement of marketing plans. In this tremendously practical semester-long course, developed based on best practices at top marketing companies, students are guided through the entire marketing plan process. Teams then apply the learning to create comprehensive plans for "real" brands at "real" companies in the industry of their choice. The course covers the ins and outs of brand positioning, marketing plan, budget setting, pricing strategy development, and volume forecasting. Media plans and ads are created as well as consumer promotion, trade promotion, direct marketing, Internet marketing and viral/buzz marketing plans.

Schedule for MKTG-GB.3150
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- MW 7:00 pm - 9:00 pm (O) Sa 11:00 am - 4:00 pm (O) Sa 11:00 am - 1:00 pm (O)	01/21-01/28 01/24-01/24 01/31-01/31	Krentzman,S	Online; This class will have additional asynchronous work each week.	2118

Equivalencies:

MKTG-GB.2350 Marketing Planning & Strategy

MKTG-GB.3250 Marketing, Planning & Strategy

Specializations:

Brand Management

Luxury Marketing

Marketing

Professional Responsibility

COR2-GB.3101Professional Responsibility (1.5)

Course Description:

This course is designed to inspire you with a positive vision of what business can be, a realistic vision of what it often is, and a roadmap for how to navigate through the hazards and opportunities you will face in your career. Specifically: 1) You will learn about the types of traps that lure business professionals into ethical lapses and criminal behaviors. 2) You will learn enough moral psychology to understand how well-intentioned professionals can get lured into such traps. 3) You will learn conceptual frameworks that help you to navigate ethical gray zones with more confidence and better results. 4) You will learn what characterizes companies with positive ethical values, and why you are better off working for them, or creating them. 5) You may, if you choose, commit yourself to a standard of professional conduct that will help to make your work more fulfilling and honorable.

Schedule for COR2-GB.3101
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	--Alternate Schedule-- TR 6:00 pm - 9:00 pm (O) Su 9:00 am - 4:00 pm (O)	01/20-01/29 01/25-01/25	Patterson,M	Online; This class will have additional asynchronous work each week.	1964
W2	In-Person	FSaSu 9:00 am - 4:00 pm	01/09-01/11	Patterson,M		1965
W3	Online	--Alternate Schedule-- MW 6:00 pm - 9:00 pm (O) Sa 9:00 am - 4:00 pm (O)	01/05-01/14 01/10-01/10	Buchanan,B	Online; This class will have additional asynchronous work each week.	1969
W4	Online	--Alternate Schedule-- TR 6:00 pm - 9:00 pm (O) Su 9:00 am - 4:00 pm (O)	01/06-01/15 01/11-01/11	Mullins,V	Online; This class will have additional asynchronous work each week.	1970
W5	Online	--Alternate Schedule-- TR 6:00 pm - 9:00 pm (O) Su 9:00 am - 4:00 pm (O)	01/20-01/29 01/25-01/25	Taylor,A	Online; This class will have additional asynchronous work each week.	1966
W6	Online	--Alternate Schedule-- TR 6:00 pm - 9:00 pm (O) Su 9:00 am - 4:00 pm (O)	01/20-01/29 01/25-01/25		Online; This class will have additional asynchronous work each week.	1973
W7	In-Person	FSaSu 9:00 am - 4:00 pm	01/30-02/01	Michaelson,C	Online; This class will have additional asynchronous work each week.	1967
W8	Online	--Alternate Schedule-- MW 6:00 pm - 9:00 pm (O) Sa 9:00 am - 4:00 pm (O)	01/05-01/14 01/10-01/10	Fraser,G	Online; This class will have additional asynchronous work each week.	1968

Equivalencies:

BSPA-GB.3301 Ethical and Legal Challenges o

COR2-GB.3111 Prof & Corp Social Resp

COR2-GB.3151 Professional Responsibility

Technology

TECH-GB.2147Databases for Business Analytics (1.5)

Course Description:

Databases are ubiquitous in all businesses and hold significant information about the business. Every data analysis and report typically starts with an SQL query, as SQL is the lingua franca of all database systems. Therefore, SQL is necessary for anyone who needs to analyze data as part of their job. Many tech companies consider the knowledge of SQL a prerequisite for all their analysts and managers. This database class is designed for absolute beginners and teaches students how databases are structured and how to write SQL queries that retrieve data from a database. The class is heavily hands-on, focusing on developing the necessary skills for writing SQL queries. We will cover the following topics: Basics of Entity-Relationship model, and the connection to databases USE, DESCRIBE queries, to understand the structure of a database Selection queries: *, column, column AS, DISTINCT, ORDER BY, LIMIT Filtering data using "where": Boolean conditions, IN, BETWEEN, LIKE Join queries: Inner and Outer joins, self-joins Aggregation queries: GROUP BY, SUM, AVG, MAX, MIN, etc Subqueries Window queries (if time allows) After this course, students will be able to navigate relational databases, issue queries against databases in an organization, and generate data that can be used for analyses and reports. This course is the first half of the traditional 3cr. version of Dealing with Data (TECH-GB 2346). Students who took TECH-GB 2346 should not take this course.

Schedule for TECH-GB.2147
Section	Instr Mode	Meeting Times	Dates	Instructor	Notes	Class Nbr
W1	Online	MWF 7:00 pm - 9:00 pm	01/05-01/16	Ipeirotis,P	Online; This class will have additional asynchronous work each week.	2154

Pre/Corequisite:

TECH-GB Departmental Max and Non-Stern

Equivalencies:

TECH-GB.2346 Dealing With Data

TECH-GB.2146 Databases for Business Analy

Specializations:

Business Analytics

FinTech

Financial Systems & Analytics

Management of Technology & Operations

Tech Product Management